Re: [sqlalchemy] [alembic] Batch migrations with sqlite and naming conventions

2017-04-16 Thread Peter Erickson
to be fixed. On 04/11/2017 10:58 PM, Peter Erickson wrote: I'm sure that I'm missing a subtle point with batch migrations and naming conventions for SQLite databases, but I can't figure out what I'm doing wrong. After renaming a table, I'm using a batch migration to update a foreign key

[sqlalchemy] [alembic] Batch migrations with sqlite and naming conventions

2017-04-11 Thread Peter Erickson
I'm sure that I'm missing a subtle point with batch migrations and naming conventions for SQLite databases, but I can't figure out what I'm doing wrong. After renaming a table, I'm using a batch migration to update a foreign key in a child table. However, after recreating the child table 2

[sqlalchemy] Object delegation and SA inheritance

2012-03-05 Thread Peter Erickson
Is is possible to set the polymorphic_on attribute on an object that is not directly tied to a db table, but has access to the db attribute via delegation? I have a generic Product class that processes an XML to obtain its generic attributes (uuid, type, etc). Afterwards, the product is

[sqlalchemy] Filtering based on Composite() value

2010-04-30 Thread Peter Erickson
Is it possible to use like() on a composite object attribute to filter a particular query? I'm trying to pull records in from a postgres db based on a the value of a single attribute within a composite object. For example, with the setup below, I want to search for records that have a