Hi, Dňa Thu, 10 May 2012 21:08:33 +0200 Steffen Macke <d...@diagramr.biz> napísal:
> sorry for the late reply. no problem ;-) > > able find way to create FOREIGN KEY constraint for my relations. My > > expectation is, that this will be created from UML associations (which > > i take from rt53783.dia example. > I just tested > > parsediasql --file long_fk_name.dia --db sqlite3 > > successfully (Parse-Dia-Sql version 0.20). the same version here > So I guess it's just a matter of using the UML association a little bit > differently. Perhaps i wrote my previous mail in wrong manner, i am sorry, my english is poor. The parsediasql produces the triggers for foreign keys in sqlite3 for me, but i expect the constraint definition, for example: CREATE TABLE table_name( some_id INTEGER, some_other INTEGER, FOREIGN KEY(some_other) REFERENCES another_table(another_id) ); or the same by other way: CREATE TABLE table_name( some_id INTEGER, some_other REFERENCES another_table(another_id) ); as described here http://sqlite.org/foreignkeys.html I tried parse my SQL model to some other DB types - i forgot which, because i did many tries in last days :-) And for these not SQLite3 types i got SQL with direct foreign keys definitions (without triggers). Then IMO the SQLite sopport for foreign keys in parsediasql is poor (outdated?). I do not tried if this triggers are working yet, but i think that it will be working. I see only one problem, that the constraints definition is more readable and straightforward, than triggers definition. And more short :-) regards -- s pozdravom Slavko http://slavino.sk
signature.asc
Description: PGP signature
_______________________________________________ dia-list mailing list dia-list@gnome.org http://mail.gnome.org/mailman/listinfo/dia-list FAQ at http://live.gnome.org/Dia/Faq Main page at http://live.gnome.org/Dia
