[Tutor] logging to a database
kent37 at tds.net
Fri Nov 11 12:26:05 CET 2005
> Hello all,
> I would like to log messages to a database (mysql)
> I found the example log_test14.py that comes with python logging
> module http://www.red-dove.com/python_logging.html
> but that example is a bit greek for me ... :) and it doesnt work with
Have you used mysql from Python before? I looked at that example and it is not that complex if you understand how to program a database. I think what you have to do is
- install MySQL and create the database table that you want to log to. The SQL statement in the example shows the fields you might want, or you can use a subset of those fields if you don't need so much information.
- modify the example program a little:
to the correct import for the MySQL driver
self.conn = mx.ODBC.Windows.connect(self.dsn, self.uid, self.pwd)
to the correct statement to connect to MySQL
change the SQL statement to correspond to your database schema
If you *haven't* used MySQL from Python before, you should probably learn a little about the basics first.
BTW the example is vulnerable to SQL injection attacks - if any of the log messages contain text from user input you should fix that. But get it working first, then come back and ask for help again.
More information about the Tutor