Re: Dia SQL export plug-in available
On 2001.05.09 08:53 Bob Gustafson wrote: > 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 plug-in cannot do that right now. All it does is write the SQL DDL for a UML logical database schema in the syntax described in *The Unified Modeling Language User Guide*, pp. 110-112, and all it does are the SQL CREATE TABLE statements (i.e. not all the things the Dia UML diagram is capable of representing). I don't know about Dia2SQL. I haven't used it yet. The next thing for the plug-in is to write the import filter, which to do it right, involves an SQL parser, which makes it a much bigger job than the export filter (why, o why didn't I take that compilers class?...) I'm not opposed to supporting Alzabo per se, but I'd be wary of making the plug-in solely dependent on it. > 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. Yes, I agree. However, I'm a little nervous about overloading a fast, lightweight, high quality diagramming program with too many code-generation features. That is why I opted for the plug-in approach. So data modeling types like me could use the plug-in if they wished, but others not interested in databases would not need to have it installed. Andy
Re: Dia SQL export plug-in available
> 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. handy. I know somebody else who is doing something like that and has just rolled his own, I'll mail the url to him. also I could use it or chunks of it (assuming its under a decent license) for autodia. It sounds very useful. > 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) Try using autodia's Diagram and DiagramFoo modules - they do most of the hard work, better still write a Handler - I'd appreciate any feedback on how the framework works for stuff like that. > Perhaps your Dia SQL plugin, or the Dia2SQL can do the same thing? I think Dia2sql reads the Dia XML (fairly easy as long as you don't use DOM) and creates Dia XML statements. This can be taken further and actually inereact directly with a Dataase if you feel like living on the egde and have some perl skillz up your sleeve. > 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. So far I have enough tools to create Dia UML diagrams from most data sources. Next I plan to add support for GraphViz (which handily lays out diagrams) and then do UML to Code / SQL / XML / Documentation / HTML. A.
Re: Dia SQL export plug-in available
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
Re: Dia SQL export plug-in available
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
Re: Dia SQL export plug-in available
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? -Lars -- Lars Clausen (http://shasta.cs.uiuc.edu/~lrclause) | HÃ¥rdgrim of Numenor "I do not agree with a word that you say, but I| Retainer of Sir Kegg will defend to the death your right to say it."| of Westfield --Evelyn Beatrice Hall paraphrasing Voltaire | Chaos Berserker of Khorne