Re: [sqlalchemy] server_onupdate issue

2012-10-01 Thread Roy Shan
Michael, Thanks for your clarification. I understand what server_onupdate does now. It's weird that I saw some examples like this one: https://groups.google.com/d/topic/sqlalchemy/qYpPtgNXzAg/discussion On Monday, October 1, 2012 1:52:22 PM UTC+8, Michael Bayer wrote: On Sep 30, 2012, at

Re: [sqlalchemy] Double many-to-many relation filter headache

2012-10-01 Thread Vlad K.
To answer my own question, seems like SQLA won't automatically process inner joins if you supply individual columns to the session.query(), if had to pass the declarative model class itself for this to work as expected. Unless I'm doing something wrong, I guess I should use deferred columns

Re: [sqlalchemy] server_onupdate issue

2012-10-01 Thread Michael Bayer
yeah in that thread I was forgetting/unaware that MySQL's TIMESTAMP generates a default and on update implicitly, so when he looked back at MySQL's rendering of the table, it included these defaults. On Oct 1, 2012, at 3:12 AM, Roy Shan wrote: Michael, Thanks for your clarification. I

Re: [sqlalchemy] Double many-to-many relation filter headache

2012-10-01 Thread Michael Bayer
On Oct 1, 2012, at 7:21 AM, Vlad K. wrote: To answer my own question, seems like SQLA won't automatically process inner joins if you supply individual columns to the session.query(), if had to pass the declarative model class itself for this to work as expected. If I understand

[sqlalchemy] SQLAlchemy 0.7.9 Released

2012-10-01 Thread Michael Bayer
SQLAlchemy 0.7.9 is released. This is a maintenance release primarily containing bug fixes applied to both the 0.7 and 0.8 SQLAlchemy series. 0.7.9 includes some adjustments that will also be present in 0.8, including changes to the event-dispatch system which dramatically reduce the amount of

[sqlalchemy] Alembic 0.4.0 Released

2012-10-01 Thread Michael Bayer
Alembic 0.4.0 is now available. Alembic is the migrations tool for SQLAlchemy, including such features as minimalist script construction, autogeneration of candidate migrations, and offline script generation. Included in this release is a *big* change by Bruno Binet that adds full blown

Re: [sqlalchemy] Alembic 0.4.0 Released

2012-10-01 Thread limodou
On Tue, Oct 2, 2012 at 8:27 AM, Michael Bayer mike...@zzzcomputing.comwrote: Alembic 0.4.0 is now available. Alembic is the migrations tool for SQLAlchemy, including such features as minimalist script construction, autogeneration of candidate migrations, and offline script generation.

[sqlalchemy] Alembic bulk_insert when primary key is a String

2012-10-01 Thread Christopher Loverich
Hello.* Loving* alembic sqlachemy - really great libraries. Just having a bit of trouble with something: op.create_table('generalprocedures_lu', sa.Column('procedure', sa.String(length=80), nullable=False), sa.PrimaryKeyConstraint('procedure') )

Re: [sqlalchemy] Alembic bulk_insert when primary key is a String

2012-10-01 Thread Michael Bayer
yeah you just need to create table() there with the columns you want as well: proc_table = table('generalprocedures_lu', column('procedure', String)) op.bulk_insert(proc_table, ...) On Oct 1, 2012, at 10:49 PM, Christopher Loverich wrote: Hello. Loving alembic sqlachemy - really great