[sqlalchemy] Re: Composite Foreign Key with ondelete='CASCADE' does not work on mysql

2011-05-30 Thread virhilo
You need to use InnoDB engine, so you tables definitions 'll look like: sensors = Table('sensors', metadata, ... mysql_engine='InnoDB' ) view_opts = Table('view_opts', metadata, ... mysql_engine='InnoDB' ) On 30 Maj, 17:38, neurino neur...@gmail.com wrote: I have a

[sqlalchemy] Re: Composite Foreign Key with ondelete='CASCADE' does not work on mysql

2011-05-30 Thread neurino
Sorry if I did not specified, yes it's InnoDB. So do I HAVE to put `mysql_engine='InnoDB'` in any Table using ondelete cascade? Is there a link to docs with some info on it? Thanks for your support On May 30, 7:04 pm, virhilo virh...@gmail.com wrote: You need to use InnoDB engine, so you

Re: [sqlalchemy] Re: Composite Foreign Key with ondelete='CASCADE' does not work on mysql

2011-05-30 Thread Michael Bayer
The table has to be created with both InnoDB as well as ON DELETE CASCADE, on the MySQL side, meaning these both must be present in the CREATE TABLE statement used to create the tables in the database. On the SQLAlchemy side, these options don't have any meaning outside the emission of the