Store Database Queries

[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.