On Feb 23, 2006, at 12:21 AM, Kapil Thangavelu wrote:
not sure if its related but i've looking for on delete and on update actions functionality, ie. on delete cascade. i've been using a foreign key subclass below and some db specific engine changes (attached) in get_col_spec method (though its straight ansi afaik, though not in mysql till 5.0), the affects of this on in memory representation of relation collections aren't clear to me, ie. if this is a use case where such bookkeeping would be nesc. even if its not such a case, this functionality is something i'd like to see in sqlalchemy, as on delete/on update fk column action specification is really helpful, i think.
I will look into this, namely I want to see where it fits into ANSI sql, how well it applies to all the DB's etc. I also want to look into, if I add this to the base schema package, then what else do we probably need to add (i.e. i dont want the schema package to fulfill an arbitrary level of features but then be missing others.)
anyway I just logged this in as ticket # 75, we can comment further over there.
------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
