[sqlalchemy] Re: SQLAlchemy keeps dropping sessions

2018-06-05 Thread rvd
Seems I was able to mitigate the issue by adding the pool pre_ping and setting the recycle parameter to 1 minute. Seems indeed to be an RDS thing. Thanks everyone! On Sunday, June 3, 2018 at 7:17:55 PM UTC-7, rvd wrote: > > Hi all, > > I am writing a Flask API that needs to communicate with man

Re: [sqlalchemy] Issues with Type conversions with raw queries

2018-06-05 Thread Mike Bayer
If this is a custom dialect there's a lot that needs to be checked. The columns in the "*" would need to line up with *columns, and you might want to try passing a dictionary of colname->datatype for more specificity. If the dialect uses uppercase names for case-insensitive identifiers, that wo

Re: [sqlalchemy] Issues with Type conversions with raw queries

2018-06-05 Thread Fokko Driesprong
Thanks Mike for the quick response. Personally I don't mind missing this functionality. Although when rewriting the code as following: tbl = Table('one_row_complex', MetaData(bind=engine)).columns row = connection.execute( text('SELECT * FROM one_row_complex').columns(*tbl) ).fetchone() self