can i set up a mysql db connection as a class ?
*binarystar*
binarystar. at binarystar.org
Fri Apr 28 00:00:20 EDT 2006
that's definitely the way to go ..
-create a database_object
-initialise at start up
-then pass the database object to other classes as needed ...
If you want to get really fancy have a look at some ORM's ... I think
there is a Python one called SQLObject?
nephish at xit.net wrote:
> hey there,
> i have a huge app that connects to MySQL. There are three threads that
> are continually connecting and disconnecting to the db. The problem is,
> if there is an error, it faults out sometimes without closing the
> connection. i connect like this.
> db = MySQLdb.connect(host="localhost", user="MyUser",
> passwd="MyPassword", db="Stuff")
> cursor=db.cursor()
>
> then i use the cursor.execute("SELECT yadda yadda
>
> my question is, is there a way i can set up a global connection so that
> when the program loads, it connects once, then stays connected ? maybe
> i could assign instances of the cursor ?
>
> please someone let me know if you have any good ideas
>
> sk
>
More information about the Python-list
mailing list