On 22 июл, 21:15, [email protected] wrote: > In your lib/app_globals.py set up a database pool (using DBUtils). > > eg. > > self.pool = PooledDB(MySQLdb, > int(app_conf['db.pool_size']), > user=app_conf['db.user'], > passwd=app_conf['db.password'], > host=app_conf['db.host'], > db=app_conf['db.name'], > cursorclass=MySQLdb.cursors.DictCursor) > > Then you can access a db connection from the pool in your controllers > using the 'g' variable: > > con = g.pool.connection() > cur = con.cursor() > cur.execute("select * from foo") > results = cur.fetchall() > > You can ofcourse encapsulate this in your Sql class. > > Hope that helps, > How to use transaction with DBUtils?
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
