Re: [sqlalchemy] Excluding a single test case from the suite for a dialect

2019-04-12 Thread Mike Bayer
On Fri, Apr 12, 2019 at 6:26 PM jank wrote: > > I am struggling with a single test 'test_huge_int' for the Exasol dialect. > The reason the test is not working is specific to that database. I would like > to include it from the test suite, but just for that DB. Ideally without > changing anythi

[sqlalchemy] Re: If your message did not appear on this list, please post again.

2019-04-12 Thread Jonathan Vanasco
the 2 messages were caught for moderation in the spam filter. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a

[sqlalchemy] If your message did not appear on this list, please post again.

2019-04-12 Thread Jonathan Vanasco
I approved 2 messages earlier today from people who have not posted before, but they haven't appeared yet. There seems to be some oddity with Google Groups. If your message didn't appear, please repost them. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlal

[sqlalchemy] Excluding a single test case from the suite for a dialect

2019-04-12 Thread jank
I am struggling with a single test 'test_huge_int' for the Exasol dialect. The reason the test is not working is specific to that database. I would like to include it from the test suite, but just for that DB. Ideally without changing anything on the central test suite, as the reason that it do

[sqlalchemy] Heroku Fixie proxy with SQLAlchemy engine

2019-04-12 Thread siobhan
Hello there, I am looking to deploy an API server on Heroku that will use a SQLAlchemy (1.3.2) engine establishing a connection with Redshift data warehouse. I am considering using Heroku's Fixie proxy to get our server up and running, which would allow me to whitelist the static IP the proxy

Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-12 Thread Mike Bayer
it's likely that a database connection is being returned to the pool in an invalid state. Switching to NullPool temporarily might reveal that this solves all the issues ; at the very least, I would try setting pool_recycle to a low number, like 5 minutes, however this won't prevent the problem, ju

Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-12 Thread tonthon
Le 10/04/2019 à 17:12, Mike Bayer a écrit : On Wed, Apr 10, 2019 at 9:23 AM tonthon wrote: Hi, We're using sqlalchemy in a Pyramid Web Application. We use the ZopeTransactionExtension and our session factory is initialized this way : DBSession = scoped_session(sessionmaker(extension=ZopeT