By using web2py's default sqlite db, I was able to solve the threading issues(Thanks Iceberg)- however, for whatever reason the only record being inserted into the db is the initial one from log.py when logging gets initiated. Any subsequent attempts to log from controllers don't show up in the db- no error, just nothing, even though the same code pointing to a file works fine. I'm really at a loss here- I've linked to the application archive, if anyone would be willing to take a look:
https://sites.google.com/site/ykessler/main/logging_sqlite_test.tar The relevant files are models/log.py: https://sites.google.com/site/ykessler/main/log_sqlite.py models/sqlhandler.py: https://sites.google.com/site/ykessler/main/sqlitehandler.py I'm running this with mod_wsgi/apache. Any ideas would be welcome. On Jul 21, 10:37 pm, Iceberg <[email protected]> wrote: > Just a quick thought. Since web2py itself already handles SQLite db well > under multi-thread situation, so a quick tweak to your sqlitehandler.py may > be putting the web2py db instance, rather than a filename, to initialize your > SQLiteHandler() class. > > Best regards, > Iceberg, 2010-Jul-22, 10:28(AM), Thu > > > > ----------------------- Original Message ----------------------- > From: Yarin <[email protected]> > To: web2py-users <[email protected]> > > Cc: [email protected], [email protected], > [email protected] > Date: Wed, 21 Jul 2010 19:15:55 -0700 (PDT) > Subject: SQLite Logging > ------------------- > > > I'd like to elicit some help in putting together a SQLite-based > > logging solution for web2py. > > > Logging to a file was covered earlier in this forum (See "Global > > logging to file"): > >http://groups.google.com/group/web2py/browse_thread/thread/e20d0bd2e5... > > log.py: > >https://sites.google.com/site/ykessler/main/log.py > > > I've written a SQLite logging handler: > >https://sites.google.com/site/ykessler/main/sqlitehandler.py > > > However, although the SQLite handler works great in normal Python > > environments, it errors out with the global logging solution because > > the logger emits on multiple threads, and SQLite objects are > > restricted to the thread they're created on. > > > Any ideas on how to sync these two solutions?
