Re: [sqlalchemy] changing the order of columns in primary keys, including when generated by mixins

2016-09-22 Thread Mike Bayer
On 09/22/2016 01:29 PM, Chris Withers wrote: On 22/09/2016 14:55, Mike Bayer wrote: On 09/22/2016 07:30 AM, Chris Withers wrote: How do you control the order in which columns are added to a multi-column primary key when using the declarative primary_key=True syntax? How about when one of

Re: [sqlalchemy] changing the order of columns in primary keys, including when generated by mixins

2016-09-22 Thread Chris Withers
On 22/09/2016 14:55, Mike Bayer wrote: On 09/22/2016 07:30 AM, Chris Withers wrote: How do you control the order in which columns are added to a multi-column primary key when using the declarative primary_key=True syntax? How about when one of those columns comes from a mixin? without

Re: [sqlalchemy] sa.DateTime(timezone=True) not emitting TIMESTAMP WITH TIMEZONE for Oracle

2016-09-22 Thread Mike Bayer
On 09/22/2016 10:21 AM, Seth P wrote: The documentation for DateTime, http://docs.sqlalchemy.org/en/latest/core/type_basics.html?highlight=datetime#sqlalchemy.types.DateTime, states Parameters:*timezone* – boolean. If True, and supported by the backend, will produce ‘TIMESTAMP WITH TIMEZONE’.

[sqlalchemy] sa.DateTime(timezone=True) not emitting TIMESTAMP WITH TIMEZONE for Oracle

2016-09-22 Thread Seth P
The documentation for DateTime, http://docs.sqlalchemy.org/en/latest/core/type_basics.html?highlight=datetime#sqlalchemy.types.DateTime, states Parameters:*timezone* – boolean. If True, and supported by the backend, will produce ‘TIMESTAMP WITH TIMEZONE’. For backends that don’t support

Re: [sqlalchemy] changing the order of columns in primary keys, including when generated by mixins

2016-09-22 Thread Mike Bayer
On 09/22/2016 07:30 AM, Chris Withers wrote: Hi All, How do you control the order in which columns are added to a multi-column primary key when using the declarative primary_key=True syntax? How about when one of those columns comes from a mixin? without mixins, the columns are processed in

Re: Is there a way to generate DDL of current state as of a revision?

2016-09-22 Thread Mike Bayer
On 09/22/2016 02:51 AM, Tom Walter wrote: I work in a team of people collaborating on database development and we'd like to start version controlling and deploy our changes with Alembic. I was wondering though if there is a way to generate the DDL for the current state of the whole schema as

[sqlalchemy] changing the order of columns in primary keys, including when generated by mixins

2016-09-22 Thread Chris Withers
Hi All, How do you control the order in which columns are added to a multi-column primary key when using the declarative primary_key=True syntax? How about when one of those columns comes from a mixin? Context is in the mail below, any help gratefully received! Chris Forwarded

Is there a way to generate DDL of current state as of a revision?

2016-09-22 Thread Tom Walter
I work in a team of people collaborating on database development and we'd like to start version controlling and deploy our changes with Alembic. I was wondering though if there is a way to generate the DDL for the current state of the whole schema as of a given revision... something like the