ticket 75 needs to be implemented:
http://www.sqlalchemy.org/trac/ticket/75
On Jun 7, 2006, at 2:03 PM, Alessandro wrote:
> Hi,
> I have two tables; one of them refers to the first one with a
> "foreignkey".
> I need the "on delete" clause, how can I do with sqlalchemy?
>
> I saw in the documentation that it is possible with mappers
> (cascade='delete'); must I use mappers? can't I do without them?
>
>
> And if I use the mappers, is the code good for sqlite? As far I know,
> sqlite doesn't implement foreignkeys, but sqlalchemy can add a magic
> layer.. I have found anything regarding sqlite limitations with
> sqlalchemy.
>
>
> Here my code (simplified):
>
> enginedbcom = create_engine('mysql://[EMAIL PROTECTED]/schema')
> dbcom = BoundMetaData(enginedbcom)
> users2 = Table('users2', dbcom,
> Column('name', String(30), nullable=False,
> primary_key=True),
> Column('password', String(30)),
> mysql_engine='InnoDB')
>
> groups = Table('groups', dbcom,
> Column('name', String(30), nullable=False,
> primary_key=True),
> mysql_engine='InnoDB')
>
> rooms = Table('rooms', dbcom,
> Column('name', String(30), nullable=False,
> primary_key=True),
> mysql_engine='InnoDB')
>
> usersVSgroups = Table('usersVSgroups', dbcom,
> Column('username', String(30),
> ForeignKey("users2.name"),
> nullable=False),
> Column('groupname', String(30),
> ForeignKey("groups.name"),
> nullable=False),
> mysql_engine='InnoDB',
> )
>
>
> Thanks
> Alessandro
>
>
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
