Re: [sqlfairy-developers] first cut at output module for dia drawing tool

[Jess R. <cas...@de...>]

Hi Russell,

Did you try looking in the CVS repository first? There appears to be a 
Producer::DiaUml there, that might well fit your needs..

Yes, our release cycle is slow, expect a dev release in the next week or 
so though!

Jess


On Tue, 16 May 2006, Russell Fulton wrote:

> Hi Folks,
> 	 I'm not on the list so please include me in any replies.
>
> I recently found myself having to document some database schema with
> only open source resources and Mac OS X.  I got dia installed and after
> a little fiddling around decided that it was going to take a long time
> constructing the UML diagrams by hand.  So I started looking for
> something that would take the SQL and at least turn out the class
> objects from the table create statements.  The nearest thing I found was
> sqlfairy, so I started hacking the MySql output module to produce the
> xml that dia needs.
>
> Firstly congratulations on a nice clean structure!  I figured out that
> all I needed was to write a Dia.pm and put -t Dia ...
>
> I have a Dia.pm that does a very rough basic job of converting sql to
> dia uml drawings.
>
> How rough?  Very ;) at the moment I just fill in the attributes with
> field names and types, no attempt is made to deal with the constraints
> and all the resulting objects have the same origin on the canvas.  Nor
> does it make any attempt to graphically map the table and key associations.
>
> Adding the constraints and doing something a bit prettier with the
> origins is fairly trivial and I might to that,  Working out the table
> and key associations is doable but decidedly non trivial.
>
> Anyway, I'm very happy to feed the code back to the project if there is
> interest.
>
> Russell
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> -- 
> sqlfairy-developers mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
>
>