Re: SQL support

[Carlo Calderoni <calderoni carlo gmail com>]

Hi Wolfgang,
There are some tools around (if you are a linux user, you can
easily find them with your distro package manager, search "dia" :D ).
Maybe some of them require some hacking here and there.

You could have a look at http://live.gnome.org/Dia/Python, there are some scripts written in Python that use Dia Python plugin.
If you are new to Python, it could be usefull this python script ( http://code.activestate.com/recipes/137951/ ) to investigate "dia" itself using Dia's python console.

I use Dia for code, documentation, database schema and query generator.
I've made a simple dia plugin in python, i use it to launch my php and c++ generator scripts directly from Dia. If you want, have a look at this message http://mail.gnome.org/archives/dia-list/2010-February/msg00002.html and have a look at the code . 

Its not my intention to spam my little work, but its the first code i ever wrote in dia python and if you are new to it too, it could be easier to understand: <200 lines of code, integration in dia menu, diagram inspection, using Gtk dialogs, call of external scripts (i let a more experienced python programmer to have a look at it before publishing, checking for crap parts ;) )

However, the dia python scripts that you find in dia git tree are my main documentation for dia python programming :).

If you don't like python, well, Dia files are plain XML; DOM and XPath are your friends.


By the way, Dia is my favorite tool for code generation :D
I'm going to open sources of my Dia libs and scripts, just need to clean some parts before. I work with them every day. If you want to have a look at them write to me.

I hope I've helped

2010/2/18 Wolfgang Beikircher <Wolfgang Beikircher raiffeisen it>

Hi guys!

I'm a developer in a rather small software company and I'm using dia to draw my database diagrams. A pretty nice option for me would be that I can generate some basic SQL code out of my diagrams (and maybe vice versa too). So, I searched for some plugins but found nothing. It seems that DIA isn't the favorite tool for code generation. :)

Anyway, if I would extend DIA (lets say through a plugin or something similar) where should I begin? Is that even possible to extend DIA that way? Are there any efforts to implement these feature? Am I one the complete wrong train and should I use some other tool?

Cheers,
Wolfgang Beikircher



_______________________________________________
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