use autoload_with=<someconnection> when you create the Table. Dont use BoundMetaData.
On Aug 22, 2007, at 5:53 PM, mc wrote: > > Hi, > the following code creates 2 connections. > Is there way to make it 1, either by making the Table share > connection1 or > by releasing the connection Table used after it loaded the metadada? > TIA > > connect_s = 'mysql://%s:[EMAIL PROTECTED]/%s' % (user, pw, server, db) > engine = sqlalchemy.create_engine(connect_s) > connection1 = engine.connect() #connection proxy > # engine.echo=True # for debug > md = sqlalchemy.BoundMetaData(engine) > table = sqlalchemy.Table('name', md, autoload = True) > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---