Re: [sqlalchemy] flush one-to-one related objects?

thanks. i think i can just go through "insp.mapper.relationships". i don't need to iterate/walk. -- 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

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

On Wed, Oct 18, 2017 at 9:50 PM, Sam Lee wrote: > Thank you. > I didn't even post stacktrace and those were the exact errors!! because I've gotten them before and I knew from your description what you were seeing, they are very specific to what psycopg2 is doing. > I'll take

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

Thank you. I didn't even post stacktrace and those were the exact errors!! I'll take a look at test/engine/test_reconnect.py and probably test against Pool directly. What I'm testing is a bit silly cause I'm testing sqlalchemy behavior :P Thanks. Sam On Tue, Oct 17, 2017 at 10:21 PM, Mike

Re: [sqlalchemy] missing select() in CompoundSelectTest ?

On Wed, Oct 18, 2017 at 10:18 AM, Gijs Molenaar wrote: > Hi again! > > This is the hopefully the last mail since this is the last failing test for > the MonetDB dialect! > > I noticed that some tests in the CompoundSelectTest class do a select() on > the union: > >

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar wrote: > hi! > > > Not sure if this a bug or something I should in my SQLAlchemy dialect, but > currently > > > expr = (table.c.x + table.c.y).label('lx') > select([func.count(table.c.id), expr]).group_by(expr).order_by(expr)

[sqlalchemy] SQLAlchemy enum in external file

I have Postgres DB with a table of pending operations. One column in the operation in an enum with the status of the enum. I used the standard python (2.7) enum, with AutoNumber (myenum.py): class AutoNumber(enum.Enum): def __new__(cls): value = len(cls.__members__) + 1

[sqlalchemy] missing select() in CompoundSelectTest ?

Hi again! This is the hopefully the last mail since this is the last failing test for the MonetDB dialect! I noticed that some tests in the CompoundSelectTest class do a select() on the union: https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/testing/suite/test_select.py#L298