Store Database Queries

[hubert]

Hello,

I'm in the process of upgrading and modifying my site and just discovered this setting.
As I want to reduce to the max the downtime of the site I was planning to make a bunch of modifications by using SQL queries directly on the database.

I found the syntaxe of some of the queries I need (by myself) but I would like to see what's happening behind the curtain, to be sure to not make any mistake and to take some queries as examples.

Unfortunately, by setting Store Database Queries to true I only get SELECTs.

That would be wonderful if I could get UPDATEs and INSERTs.

Is there a setting that I'm missing ?
Any modification to do on query_factory.php to get this ?


Thanks for your help.

Regards

Hubert

[kobra]

As I want to reduce to the max the downtime of the site I was planning to make a bunch of modifications by using SQL queries directly on the database

If you are following the recommended method for upgrading - there should be no need for what you are describing - which is dangerous at best

PLEASE Back up your database before doing any of this

[hubert]

You're right Kobra, it is dangerous and I know that.
That's why I want to see Insert and Upgrade queries made by ZC so that I'm sure the ones I build are not wrong.

More, my modifications are, for example, mass moving products from one category to another, or mass changing price to zero (because the product is becoming priced by attributes).

Making that from admin takes a long time, making it using a query is very fast.

I'm planning to queue all these modificcations using queries.
That's why I need to see, not only SELECTs but also UPDATEs and INSERTs.

Hubert

[dbltoe]

Why are you insisting on such a radical process? What is it you expect to gain from avoiding the tried and true method of upgrade?

Have you looked at http://www.zen-cart.com/entry.php?3-...-of-upgrading?

[hubert]

I've already done that guys, but while upgrading I'm also updating, changing look and feel, adding some new modules, two of theme are custom modules. This simplify the structure of my categories and products.

My only question was how to get sql INSERT and UPDATE queries in the logs.

[DrByte]

you will have to rewrite the query-factory code

[hubert]

So sad, seems too complicated for me.
I took a look into query_factory but I don't see where it is said to only log SELECTs.

I also was wondering if all and every queries are going thru query_factory.
Perhaps it's the case for everything done from admin ?
If not, this is not my solution.

That's really sad, it would have been a good debugging tool.

[DrByte]

I don't mean to sound uncooperative. However it's important to note that there's a lot more business logic going on in the PHP code beyond just mere SQL queries, including safeties and keeping relational records intact and ensuring related dependencies exist. This logic will not be evident in mere SQL queries alone. The logic is all there in the PHP files for you to review.

And, yes, query_factory is used for all queries executed by original Zen Cart files.
That said, addons/contributions may have taken shortcuts and thus there are no guarantees that they've embraced the ZC framework methods for doing db queries, and therefore can't be certain that they're using query_factory as it was intended.

[hubert]

Thanks for your reply DrByte.

Are you meaning that there's No safe SQL queries if they are made directly on the database ?
Even if it's only a simple price update, or a category id change ?

[DrByte]

Thanks for your reply DrByte.

Are you meaning that there's No safe SQL queries if they are made directly on the database ?
Even if it's only a simple price update, or a category id change ?

I didn't say that. I was responding to your post where your question implied that reverse-reviewing logged queries would be suitable for relying upon for general updates.
My post was intended to convey the fact that taking information out of context can result in problems. That includes looking at queries independent of business logic.