Mike Howarth schrieb: > I've been having a few problems with connecting to SQL Server, initially I > was using dblib however found some problems with returning text fields > whereby all text fields were ignored and it bawked at multiline sql > statements. > > Having found these major stumbling blocks I've started using pymssql which > seems less flaky. One problem I've stumbled across is that I seem to reach > my max connections on the database fairly easily (given how my script was > written) and therefore have used the singleton pattern on my database > object. > > Great problem solved, or so I thought. > > Using the following code I'm finding that the Set is now also being enforced > as a singleton as well. > > class Set(Database,Product): > > def __init__(self, *args, **kw): > > Database.__init__(self) > Product.__init__(self) > > def dosomething(self): > cu = self.c.cursor() > > Having sat back and thought about it, its easy to understand why this is > occurring given I'm indicating that Set belongs to Database and therefore > this is a singleton as well. > > Being relatively new to Python I'm unsure on how to then go about using a > database object between each class. Can anyone advise me on how they > approach this, and whether there is a common approach to this?
You might consider using a ORM mapper, like SQLObject or SQLAlchemy. If they support your backend, that is. Apart from that, this might help: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/302088 Store a connection per thread. Diez -- http://mail.python.org/mailman/listinfo/python-list
