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

[neurino]

I have a composite Primary key in a table and a relative Foreign Key
in another as:

sensors = Table('sensors', metadata,
    Column('id_cu', Integer, ForeignKey('ctrl_units.id',
ondelete='CASCADE'),
            primary_key=True, autoincrement=False),
    Column('id_meas', Integer, primary_key=True, autoincrement=False),
    ...
    )

view_opts = Table('view_opts', metadata,
    Column('id', Integer, primary_key=True),
    Column('id_view', Integer, ForeignKey('views.id',
ondelete='CASCADE'),
            nullable=False),

    Column('id_cu', Integer, ForeignKey('ctrl_units.id'),
nullable=False),
    Column('id_meas', Integer, nullable=False),
    ForeignKeyConstraint(('id_cu', 'id_meas'),
                         ('sensors.id_cu', 'sensors.id_meas'),
                         ondelete='CASCADE'),
    ...
    )

mapped like this:

orm.mapper(Sensor, sensors,
    ....
    properties={
        'view_opts': orm.relationship(ViewOpt, backref='sensor',
            cascade='all, delete-orphan', passive_deletes=True,
            single_parent=True)
    })

Now when I delete a row from sensor relative view_opt rows are not
removed.

I can't understand if this depends on DDL, it's a MySQL bug, something
sqlalchemy related or whatever.

I know I set `passive_deletes=True`to get MySQL ONDELETE CASCADE take
care of it more and more quickly.

Any help appreciated, thanks for your support
neurino

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.