Re: Adding SQL support
> > p.s. how do you do the accent on the 'a' in your name ? :) > On US keyboards, it is the key just to the right of the P key, with the appropriate keyboard settings. Swedish also has ö and ä. The å is pronounced like the ou in bought or the oa in goat, depending on where you come from (in Sweden, that is) Hope this made for an interesting and entertaining diversion. Now back to work... Dia kicks ass ('speciallyu Visio!) Det var som fan! Regards, Richard.
Re: Adding SQL support
Steve Crossan wrote: > > Hi Marten, [...] > p.s. how do you do the accent on the 'a' in your name ? :) He simply hits the 'å' button on his keyboard. -+-Ben-+-
Re: Adding SQL support
Hi Marten, Yes, any work you currently have would be very useful - it would be nice to see how you've approached the problem before we dive in. Don't spend any time on it if you're busy, but if it's not too much hassle we'd be very grateful. thanks Steve p.s. how do you do the accent on the 'a' in your name ? :) http://www.runtime-collective.com t: 01273 234290 f: 01273 234291 m: 0789 984 1684 On 18 Apr 2001, Mårten Svantesson wrote: > Steve Crossan <[EMAIL PROTECTED]> writes: > > > Cliff, Marten, > > > > Are you aware of the dia2sql project? > > > > http://sourceforge.net/projects/dia2sql/ > > Yes, but at this stage I'm not interested in creating databases with > Dia. > > > I found this while searching for a tool such as you describe. Marten - > > have you progressed at all with your project to use dia to describe > > database objects? At Runtime we are interested in such a tool, and if it > > doesn't exist in building one, or helping to build one. I'd like to find > > out what efforts already exist before starting. > > Unfortunately I still haven't had the time to make a usable object. A > realistic goal would be to have something ready by end of July. I > simply don't have any time before the summer. If you want it I could > package what I've got and throw in some notes on how I'm trying to > implement it. > > -- > - Mårten > > mail: [EMAIL PROTECTED]*** ICQ: 4356928 > mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29 > >
Re: Adding SQL support
Steve Crossan <[EMAIL PROTECTED]> writes: > Cliff, Marten, > > Are you aware of the dia2sql project? > > http://sourceforge.net/projects/dia2sql/ Yes, but at this stage I'm not interested in creating databases with Dia. > I found this while searching for a tool such as you describe. Marten - > have you progressed at all with your project to use dia to describe > database objects? At Runtime we are interested in such a tool, and if it > doesn't exist in building one, or helping to build one. I'd like to find > out what efforts already exist before starting. Unfortunately I still haven't had the time to make a usable object. A realistic goal would be to have something ready by end of July. I simply don't have any time before the summer. If you want it I could package what I've got and throw in some notes on how I'm trying to implement it. -- - Mårten mail: [EMAIL PROTECTED]*** ICQ: 4356928 mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29
Re: Adding SQL support
On Sun, 15 Apr 2001 14:26:47 +0100 (BST) Steve was chatting the other day about Re: Adding SQL support and said: > Cliff, Marten, > > Are you aware of the dia2sql project? > > http://sourceforge.net/projects/dia2sql/ > > I found this while searching for a tool such as you describe. Marten - > have you progressed at all with your project to use dia to describe > database objects? At Runtime we are interested in such a tool, and if it > doesn't exist in building one, or helping to build one. I'd like to find > out what efforts already exist before starting. > I was trying to use the ER diagram in a way like dia2sql uses the UML, but its not possible with it. Since everything is an object, I couldnt know the cardinality of an entity. I would like something too. -- ICQ: 15605359 Bicho =^..^= First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi. Por que no pensaran los hombres como los animales? Pink Panther ---$B5$8!BN$N0lCW(B $B=k$54($5$bH`4_$^$G!#(B $B%"%s(B $B%"%s(B $B%"%s(B $B$H$C$F$bBg9%$-(B
Re: Adding SQL support
Cliff, Marten, Are you aware of the dia2sql project? http://sourceforge.net/projects/dia2sql/ I found this while searching for a tool such as you describe. Marten - have you progressed at all with your project to use dia to describe database objects? At Runtime we are interested in such a tool, and if it doesn't exist in building one, or helping to build one. I'd like to find out what efforts already exist before starting. thanks very much Steve Crossan http://www.runtime-collective.com t: 01273 648676 f: 01273 648367 m: 0789 984 1684
Re: Adding SQL support
My apologies to those who have asked for the code mentioned below. It is available at ftp://pdx.or.com/pub/dia-with-er.tar.gz This is based on the 1.86 release. The warnings: - This code was, as I mentioned, started by Alfredo Kengi Kojima. I only added what I needed to get the task at hand done. - I've never written a line of GNOME anything before, so I was winging it. - There's lots of debugging output. - Only some SQL types are supported, but they are easily added. - I've gutted the code the reduces 1-to-1 relationships into one table Here is the line in my Makefile to build two pieces of code: schema: prov.dia /home/bennett/work/sqlgen/sqlgen -d -f prov.dia \ -o schema -m methods-dynamic.pl The "prov.dia" file is the dia diagram. The "schema" file is the file generated to create the tables. The "methods-dynamic.pl" file is a set of perl routines to check referential integrity and do adds in MySQL (which doesn't support foreign keys). It's unlikely that I will ever get back to this project, so if someone is willing, feel free to "make it go". I believe Alfredo would agree. The only things changed (that I remember) were adding an "E-R" object and sheet, the rest of the source should be the same old Dia. Good luck. -Erik Erik Bennett[EMAIL PROTECTED] > I've got some rudimentary stuff put together. Actually it's based on > work done by Alfredo Kengi Kojima <[EMAIL PROTECTED]>. > > It has some site specific stuff in it (an implementation of foreign > keys for MySQL), but it does work. I'm no longer working on the code, > but I do successfully use the code. Let me know if anyone wants it. > I don't think Alfredo will mind, but I'll let him comment if he's > still on this list. > > -Erik > > Erik Bennett[EMAIL PROTECTED] > > > > > Clifford Meece <[EMAIL PROTECTED]> writes: > > > > > Hi, > > > I'm brand new to Dia, so please let me know if I'm treading on ground > > > already covered. > > > I would like to contribute to the dia project by adding data modeling > > > support with an 'export to SQL' option. I may even build in the ability > > > to go straight to the SQL server to create tables. Initially I would > > > like to support MySQL, but eventually add support for other RDBS later. > > >My initial thoughts were to take the existing code for UML support > > > and modify it for an SQL library. > > >Also, I can offer some website space for the Dia project if it is > > > needed. > > > > > > Other areas that I would like to contribute are: > > > 1. Automatic export from an SQL database of network infrastructure data > > > to a Dia network Diagram. This will tie in to an existing project that > > > I am working on. > > > > I'm actually working on something like this. The first goal is to make > > it possible to place table description from databases as objects in > > Dia. It's MySql I'm working with and the idea is that dia will get > > the table description from the database in real time. The information > > to connect to the database will be saved in the file (if desired), > > enabling Dia to update the table descriptions on loading of the file. > > > > I haven't come that far, but I'm pretty confident that something will > > come out of it. (I made it my assignment in a GUI-programming > > course. There's no deadline though...) > > > > I'm interrested in cooperating with others of course. > > > > Other ideas are automatic placement of connectors between primary and > > foreign keys, editing and creation of tables and use of GNOME-DB > > to connect to other databases than MySql. > > > > -- > > - Mårten > > > > mail: [EMAIL PROTECTED]*** ICQ: 4356928 > > mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29 > > > > > > > -Erik > > Erik Bennett[EMAIL PROTECTED] > -Erik Erik Bennett[EMAIL PROTECTED]
Re: Adding SQL support
I would be very interested. Can you just attach a tarball and send me email? Cliff "(Erik Bennett)" wrote: > > I've got some rudimentary stuff put together. Actually it's based on > work done by Alfredo Kengi Kojima <[EMAIL PROTECTED]>. > > It has some site specific stuff in it (an implementation of foreign > keys for MySQL), but it does work. I'm no longer working on the code, > but I do successfully use the code. Let me know if anyone wants it. > I don't think Alfredo will mind, but I'll let him comment if he's > still on this list. > > -Erik > > Erik Bennett[EMAIL PROTECTED] > > > Clifford Meece <[EMAIL PROTECTED]> writes: > > > > > Hi, > > > I'm brand new to Dia, so please let me know if I'm treading on ground > > > already covered. > > > I would like to contribute to the dia project by adding data modeling > > > support with an 'export to SQL' option. I may even build in the ability > > > to go straight to the SQL server to create tables. Initially I would > > > like to support MySQL, but eventually add support for other RDBS later. > > >My initial thoughts were to take the existing code for UML support > > > and modify it for an SQL library. > > >Also, I can offer some website space for the Dia project if it is > > > needed. > > > > > > Other areas that I would like to contribute are: > > > 1. Automatic export from an SQL database of network infrastructure data > > > to a Dia network Diagram. This will tie in to an existing project that > > > I am working on. > > > > I'm actually working on something like this. The first goal is to make > > it possible to place table description from databases as objects in > > Dia. It's MySql I'm working with and the idea is that dia will get > > the table description from the database in real time. The information > > to connect to the database will be saved in the file (if desired), > > enabling Dia to update the table descriptions on loading of the file. > > > > I haven't come that far, but I'm pretty confident that something will > > come out of it. (I made it my assignment in a GUI-programming > > course. There's no deadline though...) > > > > I'm interrested in cooperating with others of course. > > > > Other ideas are automatic placement of connectors between primary and > > foreign keys, editing and creation of tables and use of GNOME-DB > > to connect to other databases than MySql. > > > > -- > > - Mårten > > > > mail: [EMAIL PROTECTED]*** ICQ: 4356928 > > mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29 > > > > > > -Erik > > Erik Bennett[EMAIL PROTECTED]
Re: Adding SQL support
Mårten Svantesson wrote: > > Clifford Meece <[EMAIL PROTECTED]> writes: > > > Hi, > > I'm brand new to Dia, so please let me know if I'm treading on ground > > already covered. > > I would like to contribute to the dia project by adding data modeling > > support with an 'export to SQL' option. I may even build in the ability > > to go straight to the SQL server to create tables. Initially I would > > like to support MySQL, but eventually add support for other RDBS later. > >My initial thoughts were to take the existing code for UML support > > and modify it for an SQL library. > >Also, I can offer some website space for the Dia project if it is > > needed. > > > > Other areas that I would like to contribute are: > > 1. Automatic export from an SQL database of network infrastructure data > > to a Dia network Diagram. This will tie in to an existing project that > > I am working on. > > I'm actually working on something like this. The first goal is to make > it possible to place table description from databases as objects in > Dia. It's MySql I'm working with and the idea is that dia will get > the table description from the database in real time. The information > to connect to the database will be saved in the file (if desired), > enabling Dia to update the table descriptions on loading of the file. Sounds good. Also consider the possibility that you have a Database with network infrastructure data(switches, routers, IP addresses, uplink ports) and Dia could automagically construct a diagram from that info. In this scenario dia is still pulling from a database, but it is not drawing a picture of the _tables_ , but of the _data_ in them. I think the first step is to get some Dia objects that look like SQL tables and can be filled with objects that represent SQL columns that have SQL datatypes. We should borrow heavily from the UML library for this, because the SQL tables will look very similar. They would just have a slightly different look, and the connectors would be different. Then we write an export filter that would create an SQL command file for each table object. I'll work on the Dia->SQL side, if you want to handle the SQL->Dia side. MySQL is my preferred platform as well, so we're all set there. I guess we need to decide exactly what the XML version of the SQL tables would be. > > I haven't come that far, but I'm pretty confident that something will > come out of it. (I made it my assignment in a GUI-programming > course. There's no deadline though...) > > I'm interrested in cooperating with others of course. > > Other ideas are automatic placement of connectors between primary and > foreign keys, editing and creation of tables and use of GNOME-DB > to connect to other databases than MySql. > > -- > - Mårten > > mail: [EMAIL PROTECTED]*** ICQ: 4356928 > mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29 >
Re: Adding SQL support
"Scot E. Wilcoxon" wrote: > > > I would like to contribute to the dia project by adding data > modeling > > support with an 'export to SQL' option. I may even build in the > ability > > to go straight to the SQL server to create tables. > > Are you thinking of something like the Toolkit for Conceptual Modeling? > http://wwwhome.cs.utwente.nl/~tcm/ > Yes. I just took a look at that project and it looks good. > Or are you thinking of interfacing the UML editor to SQL, so editing a > UML > representation of a table would make the same change to the table in the > DB? > Yes, that would be one of the longer range goals. > Or are you thinking of saving a drawing in a DB instead of in an XML > file? No, I wasn't planning on doing that. Cliff Meece
Re: Adding SQL support
I've got some rudimentary stuff put together. Actually it's based on work done by Alfredo Kengi Kojima <[EMAIL PROTECTED]>. It has some site specific stuff in it (an implementation of foreign keys for MySQL), but it does work. I'm no longer working on the code, but I do successfully use the code. Let me know if anyone wants it. I don't think Alfredo will mind, but I'll let him comment if he's still on this list. -Erik Erik Bennett[EMAIL PROTECTED] > Clifford Meece <[EMAIL PROTECTED]> writes: > > > Hi, > > I'm brand new to Dia, so please let me know if I'm treading on ground > > already covered. > > I would like to contribute to the dia project by adding data modeling > > support with an 'export to SQL' option. I may even build in the ability > > to go straight to the SQL server to create tables. Initially I would > > like to support MySQL, but eventually add support for other RDBS later. > >My initial thoughts were to take the existing code for UML support > > and modify it for an SQL library. > >Also, I can offer some website space for the Dia project if it is > > needed. > > > > Other areas that I would like to contribute are: > > 1. Automatic export from an SQL database of network infrastructure data > > to a Dia network Diagram. This will tie in to an existing project that > > I am working on. > > I'm actually working on something like this. The first goal is to make > it possible to place table description from databases as objects in > Dia. It's MySql I'm working with and the idea is that dia will get > the table description from the database in real time. The information > to connect to the database will be saved in the file (if desired), > enabling Dia to update the table descriptions on loading of the file. > > I haven't come that far, but I'm pretty confident that something will > come out of it. (I made it my assignment in a GUI-programming > course. There's no deadline though...) > > I'm interrested in cooperating with others of course. > > Other ideas are automatic placement of connectors between primary and > foreign keys, editing and creation of tables and use of GNOME-DB > to connect to other databases than MySql. > > -- > - Mårten > > mail: [EMAIL PROTECTED]*** ICQ: 4356928 > mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29 > > -Erik Erik Bennett[EMAIL PROTECTED]
Re: Adding SQL support
Clifford Meece <[EMAIL PROTECTED]> writes: > Hi, > I'm brand new to Dia, so please let me know if I'm treading on ground > already covered. > I would like to contribute to the dia project by adding data modeling > support with an 'export to SQL' option. I may even build in the ability > to go straight to the SQL server to create tables. Initially I would > like to support MySQL, but eventually add support for other RDBS later. >My initial thoughts were to take the existing code for UML support > and modify it for an SQL library. >Also, I can offer some website space for the Dia project if it is > needed. > > Other areas that I would like to contribute are: > 1. Automatic export from an SQL database of network infrastructure data > to a Dia network Diagram. This will tie in to an existing project that > I am working on. I'm actually working on something like this. The first goal is to make it possible to place table description from databases as objects in Dia. It's MySql I'm working with and the idea is that dia will get the table description from the database in real time. The information to connect to the database will be saved in the file (if desired), enabling Dia to update the table descriptions on loading of the file. I haven't come that far, but I'm pretty confident that something will come out of it. (I made it my assignment in a GUI-programming course. There's no deadline though...) I'm interrested in cooperating with others of course. Other ideas are automatic placement of connectors between primary and foreign keys, editing and creation of tables and use of GNOME-DB to connect to other databases than MySql. -- - Mårten mail: [EMAIL PROTECTED]*** ICQ: 4356928 mobile: +46 (0)707390385 *** phone: +46 (0)8 16 62 29
Re: Adding SQL support
I don't know anything about the internal code, but I was thinking of reading the XML dia file and using it to generate a) SQL, b) python code to read/write/query that DB, c) cgi's to provide a gui for the read/write. I did a bit of that for tcm, but ran out of time. (This time around I'll make no committments.) On Tue, 27 Feb 2001, Clifford Meece wrote: > Date: Tue, 27 Feb 2001 22:12:25 -0600 > To: [EMAIL PROTECTED] > From: Clifford Meece <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Sender: [EMAIL PROTECTED] > Subject: Adding SQL support > > Hi, > I'm brand new to Dia, so please let me know if I'm treading on > ground > already covered. > I would like to contribute to the dia project by adding data > modeling > support with an 'export to SQL' option. I may even build in the > ability > to go straight to the SQL server to create tables. Initially I > would > like to support MySQL, but eventually add support for other RDBS > later. >My initial thoughts were to take the existing code for UML > support > and modify it for an SQL library. >Also, I can offer some website space for the Dia project if it > is > needed. > > Other areas that I would like to contribute are: > 1. Automatic export from an SQL database of network infrastructure > data > to a Dia network Diagram. This will tie in to an existing project > that > I am working on. > 2. Dia plugin for netscape. > 3. A system so that Dia can be used for collaborative work. > > I'm interested in what the Dia community thinks of these ideas. > > Sincerely, > Cliff Meece > > > -- Harry George [EMAIL PROTECTED]
Re: Adding SQL support
> I would like to contribute to the dia project by adding data modeling > support with an 'export to SQL' option. I may even build in the ability > to go straight to the SQL server to create tables. Are you thinking of something like the Toolkit for Conceptual Modeling? http://wwwhome.cs.utwente.nl/~tcm/ Or are you thinking of interfacing the UML editor to SQL, so editing a UML representation of a table would make the same change to the table in the DB? Or are you thinking of saving a drawing in a DB instead of in an XML file?