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 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.
