can i set up a mysql db connection as a class ?

[nephish]

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="localhos t", user="MyUser",
passwd="MyPassw ord", db="Stuff")
cursor=db.curso r()

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

[Ed Leafe]

On Apr 27, 2006, at 8:15 PM, ne*****@xit.net wrote:

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 ?

We do something like this in Dabo. We define connections, giving
each an identifying name, and the application object loads the
definitions at startup (without actually connecting). When a business
object needs a connection, they call
self.Applicatio n.getConnection ByName(connName ). If that connection
hasn't been made, the app connects and returns a reference to the
connection. It also stores the reference, so that the next time a
business object requests that connection, it simply returns the
existing reference.

<shameless plug>
If you're developing database applications, especially if they
involve a GUI, you really should take a look at Dabo. It's an app
framework written by database developers for database developers.
</shameless plug>

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com