[Tutor] logging to a database
captnswing
captnswing at gmx.net
Sat Nov 12 18:14:39 CET 2005
thanks kent,
I actually got it working!
-frank
On 11 nov 2005, at 12.26, Kent Johnson wrote:
> captnswing wrote:
>> 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
>> mysql
>
> 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:
> change
> import mx.ODBC.Windows
> to the correct import for the MySQL driver
>
> change
> 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.
>
> Kent
>
> --
> http://www.kentsjohnson.com
>
> _______________________________________________
> Tutor maillist - Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
More information about the Tutor
mailing list