I was able to get the functionality I wanted :)
I "traced" the DAL (import pdb - pdb.set_trace()) and realized that "debug"
was set to False - Default value.
I updated models/db.py as follows :
db = DAL('mysql://user:pass@host/db', debug=True)
Now all the queries get logged nicely.
I understand this might be "overkill" since there are a LOTS of "select"s
(as expected) but at least I have the data now. Now to optimize the
solution.
BTW, I'm using 2.0.9, if it matters
-Mandar
On Thursday, September 27, 2012 6:33:35 PM UTC+5:30, Niphlod wrote:
>
> There is no facility to log all the queries ATM, but the functionality to
> have all things "traced" for all tables (or only for the tables you want
> to) is embedded in DAL: there are no logs, just "a way" to version records
> on the tables.
>
> http://web2py.com/books/default/chapter/29/06#Record-versioning
>
> On Thursday, September 27, 2012 2:07:38 PM UTC+2, Mandar Vaze wrote:
>>
>> Hi,
>>
>> I'm interested in capturing all the inserts/updates and deletes -
>> Especially I want the auth_user performing these operations and the
>> timestamp(s) for the operations.
>> This will be useful in production setup to figure out who
>> modified/deleted specific record in case things go wrong.
>> (When I was using pylons+sqlalchemy in one of my earlier projects, I
>> found this functionality useful, and all I had to do was modify
>> logging.conf)
>>
>> I played around with logging - copied logging.example.conf to
>> logging.conf, then added following lines :
>>
>> [loggers]
>>
>> keys=root,rocket,markdown,web2py,*dal*,rewrite,cron,app,welcome
>>
>> [logger_dal]
>>
>> level=DEBUG
>>
>> handlers=consoleHandler,rotatingFileHandler
>>
>> qualname=web2py.dal
>>
>> propagate=0
>>
>> Then I restarted web2py. But I still don't see any DB transactions in the
>> log.
>>
>> Further looking into gluon/dal.py - I realized that
>> insert/update/delete() do NOT have logger.debug statements - It is likely
>> that is why I don't see anything in the log/web2py.log
>>
>> Any sugestions how I get the functionality ?
>>
>> Thanks,
>> -Mandar
>>
>>
>>
>>
>>
>>
>>
--
