Thank you, I will look into this.
On Aug 22, 12:44 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> you can build this functionality using the DDL() construct provided by
> SQLAlchemy:
>
> http://www.sqlalchemy.org/docs/05/sqlalchemy_schema.html#docstrings_s...
>
> the ForeignKey objects on the table can be pulled out using:
>
> for c in table.c:
> for fk in c.foreign_keys:
> do_something_with_fk(fk)
>
> On Aug 22, 2008, at 11:19 AM, Randy Syring wrote:
>
>
>
> > I would like sqlalchemy to generate triggers on an SQLite database to
> > enforce foreign key relationships. The method is documented here:
>
> >http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers
>
> > and I have written a foreign key trigger generator here:
>
> >http://rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_...
>
> > Although it does not recognize the kind of references sqlalchemy
> > generates in the CREATE TABLE statements.
>
> > Anyway, the point of this post is that I would like to know how I
> > should go about extending sqlalchemy so that when I use ForeignKey
> > constructs in the metadata, create statements on the tables would also
> > create the triggers and drop statements on the tables would drop the
> > said triggers to enforce the Foreign Key relationship.
>
> > Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
