[sqlalchemy] Re: flask-sqlalchemy - auto-complete in editor?

2017-05-30 Thread Jonathan Vanasco
You're going to have better luck asking this question in a flask community or, if this is in relation to your IDE, a community for that. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal,

Re: [sqlalchemy] .distinct() silently ignored for DBs other than Postgres

2017-05-30 Thread mike bayer
On 05/30/2017 07:42 AM, Christopher Wilson wrote: Dear Michael and fellow SQLAlchemy users/developers, I think I have found an issue with the use of distinct() over specified columns on a Query: http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.distinct As the

Re: [sqlalchemy] insert performance vs executemany and max_allowed_packet limit

2017-05-30 Thread mike bayer
On 05/29/2017 11:34 PM, Михаил Доронин wrote: Umm, what I've meant is how to use postgresql on_conflict_do_update in such a way that sqlalchemy would use executemany behind the scenes. In examples it usage looks like this. stmt = insert(table, values) stmt =

[sqlalchemy] .distinct() silently ignored for DBs other than Postgres

2017-05-30 Thread Christopher Wilson
Dear Michael and fellow SQLAlchemy users/developers, I think I have found an issue with the use of distinct() over specified columns on a Query: http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.distinct As the Postgres documentation notes, this is a non-standard

Re: [sqlalchemy] Purpose of assertion in table reflection test (1.1.9)

2017-05-30 Thread jan.karstens via sqlalchemy
Thank you so much for the detailed answer. Very much appreciated, this should get me on the right track to fix this for the eXAsoL dialect. The ExaSolution database (this is the original product name, Exasol being the company name - but no user cares and calls the DB Exasol) was originally a