RE: get the SQL to be executed

2012-01-19 Thread Thomas Fox
Perhaps you can use the log output (with some tweaks to the log4j configuration). However I'm not sure how and if Torque 3.3 logs the update statements. But then again I've heard of drivers which at as a bridge between the application and the real driver (e.g http://www.squirrelsql.org/) and which

Re: get the SQL to be executed

2012-01-19 Thread Joe Carter
You can use a logging driver such as p6spy to see your SQL statements. http://sourceforge.net/projects/p6spy/ On 19 January 2012 08:25, Thomas Fox thomas@seitenbau.net wrote: Perhaps you can use the log output (with some tweaks to the log4j configuration). However I'm not sure how and if

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
If you are trying to generate an initial data scripts rather than a audit log, you might look at the dumpdata and datasql tasks that Torque supplies. I have used these to create initial data sets that applications need (e.g. initial user entry, rights entry, etc.) If you need to do this inside

Re: get the SQL to be executed

2012-01-19 Thread Ivano Luberti
Thanks all for your responses. Just to clarify, I need to generate sql commands inside my code to generate a file that can be used by another software (not written by me) to import data. I would like not to execute commands but only write them (because this is what I need). If I cannot find

Re: get the SQL to be executed

2012-01-19 Thread Thomas Vandahl
On 19.01.12 18:38, Ivano Luberti wrote: Thanks all for your responses. Just to clarify, I need to generate sql commands inside my code to generate a file that can be used by another software (not written by me) to import data. I would like not to execute commands but only write them

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
Or, if the info you're exporting maps to your Torque app's tables, you could probably just add toSQL() methods to the record stubs that creates the INSERT statements. E.g. if you have a User record object, modify the User.java Torque created with something like: Public String toSQL() {