[sqlalchemy] Re: ForeignKey and onupdate/ondelete

2006-12-08 Thread Manlio Perillo

Michael Bayer ha scritto:
 use ForeignKeyConstraint.
 

Yes, I have used it.
But why ForeignKey does not allow this?



Regards  Manlio Perillo

--~--~-~--~~~---~--~~
 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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: ForeignKey and onupdate/ondelete

2006-12-08 Thread Michael Bayer

it was modeled after SQL CREATE TABLE syntax itself, where the
ForeignKey keyword looks like column REFERENCES
sometable(othercolumn) and does not allow any ON UPDATE or ON DELETE
clauses at that level; they would be declared at the bottom of the
table def inside the CONSTRAINT foo FOREIGN KEY... line.

I suppose I could put onupdate/ondelete into ForeignKey but I am trying
to minimize the number of ways to do the same thing.  ill try to
remember to add this in the next release.


--~--~-~--~~~---~--~~
 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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---