> On Nov 7, 2014, at 2:02 PM, Chris Withers <[email protected]> wrote: > > On 07/11/2014 14:14, Michael Bayer wrote: >> >> session.connection().connection is the same connection that >> session.rollback() will be referring towards. though when you have that >> DBAPI connection (it is in fact still wrapped by ConnectionFairy), you >> shouldn’t call commit() or rollback() on that connection itself. >> >> session.connection() doesn’t necessarily create a “new” connection, it >> returns “the connection that this Session is currently using”, and if there >> isn’t one, it creates it. >> >> I don’t know your problem yet, you need to dig some more. maybe try >> StaticPool / AssertionPool to narrow it down? > > So, turns out the pandas.io.sql.read_frame in the version of pandas I'm using > has a con.commit() in it. wtf?! > > Guess I'll raise that as a bug in Pandas if they haven't fixed it in a > subsequent release…
didn’t pandas introduce SQLAlchemy integration? http://pandas.pydata.org/pandas-docs/dev/generated/pandas.read_sql_query.html accepts a SQLAlchemy Connection object. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
