[sqlalchemy] cascade delete in relationship and session.execute(table.update())

Hi, Currently I am trying to implement a feature that transfers all products in a store to another store, and then destroy the old store which contains no product. The sqlalchemy version is 0.6.8. class Product(PolymorphicClass): #there are different types of the product __tablename__ = "

Re: [sqlalchemy] MSSQL/PyODBC reflection problem

this is #2355: http://www.sqlalchemy.org/trac/ticket/2355 Pyodbc + MSSQL is not yet tested for Py3K. (note it's on the map as 'development': www.sqlalchemy.org/docs/core/engines.html#supported-databases ) PyODBC + MSSQL is a tricky platform overall so you might need to stick with py2k for th

[sqlalchemy] MSSQL/PyODBC reflection problem

I'm using python 3.2.2, sqlalchemy 0.7.4 and pyodbc 3.0.2 from sqlalchemy import create_engine, MetaData, Table engine = create_engine('mssql+pyodbc://user:pass@dsn') metadata = MetaData(engine) my_view = Table("PGRDAT", metadata, autoload=True) and getting this error: Traceback (most recent ca