Re: [sqlalchemy] skipping MSSQL TIMESTAMP column on INSERT

2011-09-25 Thread Matt Bodman
Thanks so much Michael.. just to wrap up this thread, I got it working like this: class Thing(Base): __tablename__ = 'tbThings' __table_args__ = ( {'autoload':True,'autoload_with':engine,'extend_existing':True} ) LastUpdated = Column('LastUpdated', TIMESTAMP,

[sqlalchemy] Auto discover primary key field in tables defined using metadata

2011-09-25 Thread Devraj
Hi all, SQLAlchemy 0.7.1 / Python 2.7.1 on Ubuntu 11.04 server / Apache 2.2.x + mod_wsgi 3.3.x I am *very* new to SQLAlchemy, so please be kind. We are trying to use SQLAlchemy with an existing database / tables. Our preference is to use the Metadata auto discover mechanism so we don't have to

Re: [sqlalchemy] Auto discover primary key field in tables defined using metadata

2011-09-25 Thread Michael Bayer
On Sep 25, 2011, at 9:21 PM, Devraj wrote: Hi all, SQLAlchemy 0.7.1 / Python 2.7.1 on Ubuntu 11.04 server / Apache 2.2.x + mod_wsgi 3.3.x I am *very* new to SQLAlchemy, so please be kind. We are trying to use SQLAlchemy with an existing database / tables. Our preference is to use the

[sqlalchemy] Autoloading ManyToMany association table

2011-09-25 Thread Matt Bodman
I am autoloading an MSSQL db. There are a few ManyToMany assoc tables. I'm not sure how to map everything. Here's a typical example of how they look in the db: Table: tbUsersToGroups PK: ID_UserToGroup FK: User_ID FK: Group_ID So I can successfully autoload that assoc table and