db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joerg Friedrich (JIRA)" <j...@apache.org>
Subject [jira] Kommentiert: (TORQUE-6) Generator does not generate foreign key constraints for Interbase/Firebird
Date Fri, 21 Apr 2006 19:50:06 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-6?page=comments#action_12375626 ] 

Joerg Friedrich commented on TORQUE-6:
--------------------------------------

In the past it looked like this:

    ALTER TABLE TACL
        ADD CONSTRAINT TACL_FK_1 FOREIGN KEY (PERSONKEY)
            REFERENCES TPERSON (PKEY);


    ALTER TABLE TACL
        ADD CONSTRAINT TACL_FK_2 FOREIGN KEY (ROLEKEY)
            REFERENCES TROLE (PKEY);


    ALTER TABLE TACL
        ADD CONSTRAINT TACL_FK_3 FOREIGN KEY (PROJKEY)
            REFERENCES TPROJECT (PKEY);


    ALTER TABLE TBASELINE
        ADD CONSTRAINT TBASELINE_FK_1 FOREIGN KEY (WORKITEMKEY)
            REFERENCES TWORKITEM (WORKITEMKEY);

I have not used the onUpdate and onDelete feature, since it does not work for all database
systems and thus we had to put this functionality into the application logic. 

The Firebird/Interbase manual states that it supports "ON DELETE CASCADE" and "ON UPDATE CASCADE"
(exactly like this) in constraints.


> Generator does not generate foreign key constraints for Interbase/Firebird
> --------------------------------------------------------------------------
>
>          Key: TORQUE-6
>          URL: http://issues.apache.org/jira/browse/TORQUE-6
>      Project: Torque
>         Type: Bug

>   Components: Generator
>     Versions: 3.2
>     Reporter: Joerg Friedrich

>
> The generator does not generate foreign key constraints for Interbase/Firebird. This
could probably be easily fixed by adding a file foreignkey.vm to the sql/base/interbase directory
in the templates jar (torque-gen-templates-3.2.jar) containing this:
> #foreach ($fk in $table.ForeignKeys)
>     FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
> #end

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message