Re: [sqlalchemy] Loading model in a text fixture causes load options to be ignored

2018-07-03 Thread Mike Bayer
Once you load the object with get(), it's done, it's in the session's identity map and doing another get() on it will just give you back that same object from memory without emitting SQL. If you want to reload it you either have to session.expire() it, session.close() / session.expire_all() to

[sqlalchemy] Loading model in a text fixture causes load options to be ignored

2018-07-03 Thread phil . nachum
Hello, I'm encountering an issue where loading a model in a text fixture causes the load options to be ignored when I load the same model in a Flask endpoint I have these two models class Plate(db.Model): container_id = db.Column(db.Integer, db.ForeignKey('containers.id')) container

Re: [sqlalchemy] Bug? Query / Execute Mismatch When Given Duplicate Columns

2018-07-03 Thread Jonathan Vanasco
On Tuesday, July 3, 2018 at 9:37:04 AM UTC-4, Mike Bayer wrote: > > This architecture has been liberalized but this assumption still remains > within the Core and it's possible the ORM may or may not have some > remaining reliance on this assumption as well. > I assumed the RowProxy also

Re: [sqlalchemy] Bug? Query / Execute Mismatch When Given Duplicate Columns

2018-07-03 Thread Mike Bayer
Yes that's intentional, the select() construct deduplicates redundant column names as for many years the result system relied upon column names in the cursor to organize its results. This architecture has been liberalized but this assumption still remains within the Core and it's possible the

Re: [sqlalchemy] Redefine table

2018-07-03 Thread Javier Collado Jiménez
It worked perfectly! Thank you! El lunes, 2 de julio de 2018, 17:00:45 (UTC+2), Mike Bayer escribió: > > tables can be altered additively, sure > > from sqlalchemy import * > from sqlalchemy.schema import CreateTable > > m = MetaData() > > # table w/ no PK > t = Table( > "nopk", m, >