Re: [sqlalchemy] Mock DBAPI connection for testing custom creator

2017-10-17 Thread Mike Bayer
On Tue, Oct 17, 2017 at 4:58 PM, Sam Lee wrote: > Hi, > > I am passing a custom creator to sqlalchemy.create_engine(). > And, I want to simulate the following scenario in automated test without > using actual database connection: > > 1. Request a connection from pool: connects to DB. > 2. DB goes

Re: [sqlalchemy] New comment feature in 1.2 is great - why not MSSQL support?

2017-10-17 Thread Mike Bayer
On Oct 17, 2017 3:29 PM, wrote: Hi - I see that there is support for commenting columns coming in v1.2... but only for Postgres, MySQL, and Oracle (https://github.com/zzzeek/ sqlalchemy/blob/6ff05dae071fcf3213024a4004511a9bd049d1e6/test/requirements. py#L118). SQL Server has a 'description' fie

[sqlalchemy] tx_isolation deprecated in mysql 5.7

2017-10-17 Thread Chris Frey
Hi, Just a heads-up. When running against a recent mysql 5.7+ I get the following message: /var/www/cdsm/pyroot/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:2513: Warning: (1287L, "'@@tx_isolation' is deprecated and will be removed in a future release. Please use '@

[sqlalchemy] Mock DBAPI connection for testing custom creator

2017-10-17 Thread Sam Lee
Hi, I am passing a custom creator to sqlalchemy.create_engine(). And, I want to simulate the following scenario in automated test without using actual database connection: 1. Request a connection from pool: connects to DB. 2. DB goes down. 3. Request a connection from pool: connection is invalid

[sqlalchemy] New comment feature in 1.2 is great - why not MSSQL support?

2017-10-17 Thread scott
Hi - I see that there is support for commenting columns coming in v1.2... but only for Postgres, MySQL, and Oracle (https://github.com/zzzeek/sqlalchemy/blob/6ff05dae071fcf3213024a4004511a9bd049d1e6/test/requirements.py#L118). SQL Server has a 'description' field in the column that seems to be