Re: Dia to SQL conversion

2012-05-10 Thread Slavko
Hi, Dňa Thu, 10 May 2012 21:59:07 +0200 Steffen Macke napísal: > Sorry that I got you wrong here. The parsediasql code seems to be older > here than sqlite's support > for foreign keys. no problem :-) > Consider adding a bug/report feature request on CPAN > > https://rt.cpan.org/Public/Dist/

Re: Dia to SQL conversion

2012-05-10 Thread Steffen Macke
Hi Slavko, On 05/10/2012 09:32 PM, Slavko wrote: 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

Re: Dia to SQL conversion

2012-05-10 Thread Slavko
Hi, Dňa Thu, 10 May 2012 21:08:33 +0200 Steffen Macke 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

Re: Dia to SQL conversion

2012-05-10 Thread Steffen Macke
Hi Slavko, sorry for the late reply. On 04/30/2012 09:53 PM, Slavko wrote: Parse-Dia-SQL, to get the dia examles and learn how things are working. I was success to create SQL from my simple attempts, simple tables, custom types (typemaps), default values, etc. But i am not able find way to cre

Dia to SQL conversion

2012-04-30 Thread Slavko
Hi, i want to start with SQLite3 database modeling by dia. I am not UML, SQL nor SQLite expert. I found nice article for this (http://left.subtree.org/2007/12/05/database-design-with-dia/), which points me to Parse-Dia-SQL at CPAN and then i found that it has a official debian's package and insta