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