sql debug

Hello,

In openerp you can use following option related to logging configuration when you start the server in terminal:

  Logging Configuration:
    --logfile=LOGFILE file where the server log will be stored
    --syslog Send the log to the syslog server
    --log-level=LOG_LEVEL
                        specify the level of the logging. Accepted values:
                        ['info', 'debug_rpc', 'warn', 'critical', 'error',
                        'debug', 'notset']

Like following example:
./openerp-server --addons-path=<path> --loglevel=debug_rpc

Thanks for the answer but OpenERP is still not show the sql sentences to the postgresql DB, only show messages about modules or conection.

You know the specific log level which I can try?

I have tried with debug, debug-rpc, info but nothing happens.

Thanks.

Hello,

There is not any option available in tiny for that. So you need to manually trace the code by print statement.

Thanks.

Hello fmarcks,

There is one option in cursor to start logging sql queries,turn it on for the code where you feel problem exists.
I hope following peace of code can help you to log sql expression..

def create(self,cr,uid,vals,context={}):
 cr.sql_log = True
""" Your code : you will be able to see sql query related to this code server side """
 cr.sql_log = False
 return super(res_partner,self).create(cr,uid,vals,context)

and start server with --log-level=debug option

I hope ,this will solve your problem .
Thanks,
Regards,
Dhara Shah