On Mon, 7 May 2001, Andrew S. wrote:
>On 2001.05.07 16:21 Lars Clausen wrote:
>> On Mon, 7 May 2001, Andrew S. wrote:
>>
>> > There is a Dia SQL export plug-in available at:
>> >
>> > ftp://ftp.tuxtopia.com/pub/dia/plug-ins/sql.tar.gz
>> > ftp://az.water.usgs.gov/pub/ashalper/src/dia/plug-ins/sql.tar.gz
>> >
>> > It currently only supports UML class diagrams, and can only generate
>> > plain SQL CREATE TABLE statements.
>> >
>> > The next version will support the { PRIMARY KEY | UNIQUE } syntax.
>> >
>> > Both of these FTP servers are probably quite flakey. If someone would
>> > like to add it to the CVS tree, I would be happy to maintain it there.
>>
>> How does this compare to the Dia2SQL project on SourceForge?
>
>Dia2SQL is a Perl script that takes a Dia diagram in EPS form and creates
>an SQL file from it (I think?). The plug-in is written in C and reads the
>native Dia diagram data structures. Long-term I'd like to do an SQL import
>filter too, and have the export filter map UML to the non-portable SQL
>dialects of different RDBMSs.
>
>I have not used Dia2SQL yet, but I would imagine that right now,
>functionally, there's not that much difference.
>
>Andy
There is a project on sourcefore called Alzabo which will create an SQL
database from an object representation or will go the opposite direction as
well (reverse engineer an existing SQL database to create an object
representation.
The object representation can be manipulated via html/browser screens and
the changes zapped back into the database.
I was thinking of writing a perl script which would create DIA UML diagrams
(the text file) from the internal representations in Alzabo (also written
in perl). These diagrams could be visualized in DIA, modified (move around
the boxes so result is better formatted), and then reparsed by a script to
be compatible with Alzabo, which would write the changes into the actual
database (and ignore/retain the visual formatting info)
Perhaps your Dia SQL plugin, or the Dia2SQL can do the same thing?
The basic need here is to build up enough tools so that once you have a Dia
UML diagram, something can be done with it besides hanging it up on the
wall.
BobG
