You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(4) |
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(3) |
Feb
|
Mar
(1) |
Apr
(3) |
May
(1) |
Jun
|
Jul
(9) |
Aug
(4) |
Sep
(1) |
Oct
|
Nov
|
Dec
(10) |
2003 |
Jan
(13) |
Feb
(39) |
Mar
|
Apr
(17) |
May
(3) |
Jun
(3) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
(6) |
Nov
|
Dec
|
2004 |
Jan
|
Feb
(2) |
Mar
(3) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
(3) |
Oct
|
Nov
|
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
(7) |
Nov
|
Dec
|
2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
(7) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
2018 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Alejandro I. <ai...@ya...> - 2021-06-16 19:02:45
|
NVM the email below. I had forgotten I had write access to the repository. SF is really confusing and I thought I was pushing to MY fork of the repo and wanted to setup a pull request. Sorry I pushed directly to master but anyway people will be happy with these fixes ;-) The changes are local to SQL/DDL and well tested since I actually use this almost on a daily basis. I finally fixed the missing code that we somehow failed to merge back in 0.8.5 (circa 2012) and a long-time limitation of a single FK per child. The code is much clearer/readable now and I documented what it actually does and it's caveats/ https://sourceforge.net/p/dia2code/git/ci/3e0e3135162e16ebdba64687c25af396b6cafdaf/tree/dia2code/generate_code_sql.c?diff=42adb77040b823e72de23c6d6a7405d6e8e66260 https://sourceforge.net/p/dia2code/git/ci/3e0e3135162e16ebdba64687c25af396b6cafdaf/tree/dia2code/main.c?diff=42adb77040b823e72de23c6d6a7405d6e8e66260 All the best, Alejandro Imass On Wed, Jun 16, 2021 at 1:33 PM Alejandro Imass <ai...@ya...> wrote: > Hey there! > > I would like to submit a patch because I found that in an old submission > back in 2012 somehow the code for the -sqlx fkidx switch got left out of > the merge for 0.8.5. It's a simple patch but not sure what the procedure is > these days... > > TIA! > Alejandro Imass > |
From: Alejandro I. <ai...@ya...> - 2021-06-16 17:33:43
|
Hey there! I would like to submit a patch because I found that in an old submission back in 2012 somehow the code for the -sqlx fkidx switch got left out of the merge for 0.8.5. It's a simple patch but not sure what the procedure is these days... TIA! Alejandro Imass |
From: Csányi P. <csa...@gm...> - 2018-04-20 06:07:31
|
Hi, I just installed dia2code on my Gentoo linux system. When I run dia2code in an xterm window, I get this output: dia2code version 1.0.0, Copyright (C) 2000-2014 Javier O'Hara Dia2Code comes with ABSOLUTELY NO WARRANTY This is free software, and you are welcome to redistribute it under certain conditions; read the COPYING file for details. Usage: dia2code [-h|--help] [-d <dir>] [--buildtree] [-l <license file> [-nc] [-cl <classlist>] [-v] [--version] [--tab <number>] [-ext <extension>] [-bext <extension>] [-nl] [-1] <-t (ada|as3|c|cpp|csharp|idl|java|php(5)|python|ruby|shp|sql)> <diagramfile> profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-umlPackage.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-umlOperation.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-umlClassNode.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-umlClass.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-umlAttribute.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-string2.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-scan_tree.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-parse_diagram.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-main.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-GenerateCodePhp.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-GenerateCodeJava.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-GenerateCodeCSharp.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-GenerateCodeCpp.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-GenerateCode.gcda:Skip profiling:/var/tmp/portage/app-office:Cannot create directory profiling:/var/tmp/portage/app-office/dia2code-1.0.0/work/dia2code-1.0.0/src/dia2code-DiaGram.gcda:Skip How can I solve this problem? -- Best, Pali |
From: Alejandro I. <ai...@ya...> - 2012-12-18 23:03:06
|
Hi Oliver, I already downloaded the git version (I understood the CSV versions were obsolete) and fixed the files there but I haven't commited until I heard from you. If you remember, you gave me rights to the project but I really haven't tried to commit so I don't know if I'm actually able to. Also, I downloaded the static HTML pages and planned to update them over the holidays. I can post the patch to the list and take it from there but I could also take over the maintenance of the sql converter for good if you guys agree. We use it in production so we are a pretty good QA ;-) Just tell me how to proceed. I could also branch in git but it seems overkill for just one file! -- Alejandro On Tue, Dec 18, 2012 at 4:40 PM, Oliver Kellogg <oli...@t-...> wrote: > Hello Alejandro, > > Please post your patch to the dia2code-general list for review. > This would eventually become 0.8.6 but at this point I'm not sure > when is the right time for a new release. > I'd suggest waiting until a few more changes accumulate > (people who need your SQL generator fix urgently can > always build from CVS, no?) > > Thanks, > > Oliver > > ----- Original message ----- >> From: Alejandro Imass <ai...@ya...> >> To: Oliver Kellogg <oli...@t-...> >> Subject: Re: [Dia2code-general] New patches for 0.8.5 >> Date: Tue, 18 Dec 2012 00:40:57 +0100 > >> Hi Oliver, >> >> I'm double checking the 0.8.5 release and I need to fix something on >> the SQL converter. Should we re-release 0.8.5.1, 0.8.5.6 or just >> re-pack 0.8.5 with the fix? Pls. let me know how you usually handle >> this... >> >> Thanks, >> >> -- >> Alejandro >> >> On Sat, Jul 7, 2012 at 1:54 PM, Alejandro Imass <ai...@ya...> >> wrote: >> > On Sat, Jul 7, 2012 at 1:23 PM, Oliver Kellogg >> > <oli...@t-...> wrote: >> >> On 2012-0707 18:01, Alejandro Imass wrote: >> >> >> >>> Is there any way I can help maintain / revamp the Web site?? >> >> >> Alejandro, >> >> >> >> I added you to the project. >> >> You should be able to access the dia2code web site contents >> >> (see https://sourceforge.net/apps/trac/sourceforge/wiki/WikiStart >> for details.) >> >> >> Welcome aboard! >> > >> >> > Wow Thanks! It's a great pleasure for us to help!! >> > >> > -- >> > Alejandro >> > >> > >> >> >> >> Oliver >> >> >> >> >> >> >> > > > |
From: Oliver K. <oli...@t-...> - 2012-12-18 21:40:29
|
Hello Alejandro, Please post your patch to the dia2code-general list for review. This would eventually become 0.8.6 but at this point I'm not sure when is the right time for a new release. I'd suggest waiting until a few more changes accumulate (people who need your SQL generator fix urgently can always build from CVS, no?) Thanks, Oliver ----- Original message ----- > From: Alejandro Imass <ai...@ya...> > To: Oliver Kellogg <oli...@t-...> > Subject: Re: [Dia2code-general] New patches for 0.8.5 > Date: Tue, 18 Dec 2012 00:40:57 +0100 > Hi Oliver, > > I'm double checking the 0.8.5 release and I need to fix something on > the SQL converter. Should we re-release 0.8.5.1, 0.8.5.6 or just > re-pack 0.8.5 with the fix? Pls. let me know how you usually handle > this... > > Thanks, > > -- > Alejandro > > On Sat, Jul 7, 2012 at 1:54 PM, Alejandro Imass <ai...@ya...> > wrote: > > On Sat, Jul 7, 2012 at 1:23 PM, Oliver Kellogg > > <oli...@t-...> wrote: > >> On 2012-0707 18:01, Alejandro Imass wrote: > >> > >>> Is there any way I can help maintain / revamp the Web site?? >> > >> Alejandro, > >> > >> I added you to the project. > >> You should be able to access the dia2code web site contents > >> (see https://sourceforge.net/apps/trac/sourceforge/wiki/WikiStart > for details.) >> > >> Welcome aboard! > > > > > Wow Thanks! It's a great pleasure for us to help!! > > > > -- > > Alejandro > > > > > >> > >> Oliver > >> > >> > >> > |
From: Alejandro I. <ai...@ya...> - 2012-07-07 17:54:39
|
On Sat, Jul 7, 2012 at 1:23 PM, Oliver Kellogg <oli...@t-...> wrote: > On 2012-0707 18:01, Alejandro Imass wrote: > >> Is there any way I can help maintain / revamp the Web site?? > > Alejandro, > > I added you to the project. > You should be able to access the dia2code web site contents > (see https://sourceforge.net/apps/trac/sourceforge/wiki/WikiStart for details.) > > Welcome aboard! Wow Thanks! It's a great pleasure for us to help!! -- Alejandro > > Oliver > > > |
From: Oliver K. <oli...@t-...> - 2012-07-07 17:24:09
|
On 2012-0707 18:01, Alejandro Imass wrote: > Is there any way I can help maintain / revamp the Web site?? Alejandro, I added you to the project. You should be able to access the dia2code web site contents (see https://sourceforge.net/apps/trac/sourceforge/wiki/WikiStart for details.) Welcome aboard! Oliver |
From: Alejandro I. <ai...@ya...> - 2012-07-07 16:01:38
|
Is there any way I can help maintain / revamp the Web site?? On Sat, Jul 7, 2012 at 11:56 AM, Oliver Kellogg <oli...@t-...> wrote: > Hi Alejandro, > > I reviewed your patch, applied it, and re-released 0.8.5. > > Thanks for contributing, > > Oliver > > > ----- Original message ----- >> From: Alejandro Imass <ai...@ya...> >> To: dia2code General list <dia...@li...> >> Subject: [Dia2code-general] New patches for 0.8.5 >> Date: Sat, 07 Jul 2012 16:47:31 +0200 > >> Hi, >> >> This patch is diff from 0.8.4 as downloaded from sf.net against our >> latest production version. >> >> - It fixes matching against _id instead of id for surrogate fk >> convention in popular ORMs >> - It adds an -sqlx command line parameter to include extra option list >> for future enhancements to the sql module. >> >> Currently the only sqlx option is "fkidx" which will generate indexes >> for each FK created. Future options I'm thinking for this sqlx >> parameter in the future may include some RDBMS-specific options or >> forcing to adhere to SQL-92, SQL:1999, etc. >> >> As always, thanks for creating and maintaining this great tool we use >> in our work every single day! >> >> -- >> Alejandro Imass >> >> > > |
From: Oliver K. <oli...@t-...> - 2012-07-07 15:56:51
|
Hi Alejandro, I reviewed your patch, applied it, and re-released 0.8.5. Thanks for contributing, Oliver ----- Original message ----- > From: Alejandro Imass <ai...@ya...> > To: dia2code General list <dia...@li...> > Subject: [Dia2code-general] New patches for 0.8.5 > Date: Sat, 07 Jul 2012 16:47:31 +0200 > Hi, > > This patch is diff from 0.8.4 as downloaded from sf.net against our > latest production version. > > - It fixes matching against _id instead of id for surrogate fk > convention in popular ORMs > - It adds an -sqlx command line parameter to include extra option list > for future enhancements to the sql module. > > Currently the only sqlx option is "fkidx" which will generate indexes > for each FK created. Future options I'm thinking for this sqlx > parameter in the future may include some RDBMS-specific options or > forcing to adhere to SQL-92, SQL:1999, etc. > > As always, thanks for creating and maintaining this great tool we use > in our work every single day! > > -- > Alejandro Imass > > |
From: Alejandro I. <ai...@ya...> - 2012-07-07 14:54:22
|
Hi, This patch is diff from 0.8.4 as downloaded from sf.net against our latest production version. - It fixes matching against _id instead of id for surrogate fk convention in popular ORMs - It adds an -sqlx command line parameter to include extra option list for future enhancements to the sql module. Currently the only sqlx option is "fkidx" which will generate indexes for each FK created. Future options I'm thinking for this sqlx parameter in the future may include some RDBMS-specific options or forcing to adhere to SQL-92, SQL:1999, etc. As always, thanks for creating and maintaining this great tool we use in our work every single day! -- Alejandro Imass |
From: Alejandro I. <ai...@ya...> - 2012-07-06 18:28:24
|
Can't you just create 0.8.5 from latest 0.8.4 and grant me commit rights on that branch??? I have some new stuff we added to our last patch I sent you like automatic index generation for FK's for RDBMS like Pg which don't create these indexes by default. Please let us know ASAP, we would really like to see 0.8.5 in FreeBSD, macPorts and Debian/Ubuntu. Thanks!! -- Alejandro Imass On Thu, Jul 5, 2012 at 10:33 AM, Alejandro Imass <ai...@ya...> wrote: > It's been several months and I don't see 0.8.5 anywhere, we don't want > to keep running an internal hacked version so is there a possibility > you could release the 0.8.5 so we can have a test drive and push it's > release to the package maintainers @ FreeBSD, MacPorts, Ubuntu. > > Thanks, > > -- > Alejandro Imass > > On Wed, Oct 26, 2011 at 12:31 PM, oli...@t-... > <oli...@t-...> wrote: >> Hi Alejandro, >> >> First of all thanks for your patches. >> I am sorry that they went unattended for so long, somehow I missed >> answering your first mail from many months ago. >> >> On 2011-10-25 15:50:28 +0200, Alejandro Imass wrote: >> >>> We will start testing with 0.8.4 and start moving away slowly but >>> surely from our internal patched versions and let you know how it >>> goes. >> >> That's great. >> Feel free to submit further patches, I will try to integrate them. >> I will probably release a version 0.8.5 in the not so distant future as >> I happened to find another unaddressed bug short after 0.8.4 was >> released, >> https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/173628 >> >>> Eventually we would like submit a detailed how-to or similar on >>> how we have been using DIA and dia2code for real-world UML2 and >>> UML/SQL modeling. We feel it's a small contribution compared to how >>> much our business depends on these tools. >> >> Sounds cool! >> >> -- Oliver >> >> >> |
From: Alejandro I. <ai...@ya...> - 2012-07-05 16:26:52
|
It's been several months and I don't see 0.8.5 anywhere, we don't want to keep running an internal hacked version so is there a possibility you could release the 0.8.5 so we can have a test drive and push it's release to the package maintainers @ FreeBSD, MacPorts, Ubuntu. Thanks, -- Alejandro Imass On Wed, Oct 26, 2011 at 12:31 PM, oli...@t-... <oli...@t-...> wrote: > Hi Alejandro, > > First of all thanks for your patches. > I am sorry that they went unattended for so long, somehow I missed > answering your first mail from many months ago. > > On 2011-10-25 15:50:28 +0200, Alejandro Imass wrote: > >> We will start testing with 0.8.4 and start moving away slowly but >> surely from our internal patched versions and let you know how it >> goes. > > That's great. > Feel free to submit further patches, I will try to integrate them. > I will probably release a version 0.8.5 in the not so distant future as > I happened to find another unaddressed bug short after 0.8.4 was > released, > https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/173628 > >> Eventually we would like submit a detailed how-to or similar on >> how we have been using DIA and dia2code for real-world UML2 and >> UML/SQL modeling. We feel it's a small contribution compared to how >> much our business depends on these tools. > > Sounds cool! > > -- Oliver > > > |
From: Ale S. <ale...@gm...> - 2012-05-27 10:39:43
|
Hi, sorry for the late reply, but I do have an answer for you: In UML there actually isn't an "interface type", but interfaces are defined by giving a class the stereotype "Interface". In dia this can be done through the class properties window, second field on the first tab. dia2code reads this information and correctly generates code for the interface. I noticed that this question didn't go to the dia mailing list. I don't know why, but you would've received a quick answer there... Greetings, Ale On 05/25/2012 03:52 AM, JIA Pei wrote: > > Hi, all: > > 1) Just start using DIA. It seems DIA only targets at C++, rather than > Java. > On the one hand, in the DIA UML, there is no type "interface" for Java. > On the other hand, as for the tool dia2code, it's supposed to be able > to produce Java code. > My question: without a model of "interface" in DIA, how is dia2code > able to produce a Java interface? > > 2) Is there any possibility that DIA take "interface" into its > consideration? > Or, is there a substitute way for DIA to deal with the concept > "interface"? > > > Cheers > Pei > > > > > -- > > Pei JIA > > Email: jp...@gm... <mailto:jp...@gm...> > cell: +1 604-362-5816 <tel:%2B1%20604-362-5816> > > Welcome to Vision Open > http://www.visionopen.com > > > _______________________________________________ > dia-list mailing list > dia...@gn... > https://mail.gnome.org/mailman/listinfo/dia-list > FAQ at http://live.gnome.org/Dia/Faq > Main page at http://live.gnome.org/Dia > > |
From: JIA P. <jp...@gm...> - 2012-05-25 01:52:21
|
Hi, all: 1) Just start using DIA. It seems DIA only targets at C++, rather than Java. On the one hand, in the DIA UML, there is no type "interface" for Java. On the other hand, as for the tool dia2code, it's supposed to be able to produce Java code. My question: without a model of "interface" in DIA, how is dia2code able to produce a Java interface? 2) Is there any possibility that DIA take "interface" into its consideration? Or, is there a substitute way for DIA to deal with the concept "interface"? Cheers Pei -- Pei JIA Email: jp...@gm... cell: +1 604-362-5816 Welcome to Vision Open http://www.visionopen.com |
From: <oli...@t-...> - 2011-10-26 16:31:34
|
Hi Alejandro, First of all thanks for your patches. I am sorry that they went unattended for so long, somehow I missed answering your first mail from many months ago. On 2011-10-25 15:50:28 +0200, Alejandro Imass wrote: > We will start testing with 0.8.4 and start moving away slowly but > surely from our internal patched versions and let you know how it > goes. That's great. Feel free to submit further patches, I will try to integrate them. I will probably release a version 0.8.5 in the not so distant future as I happened to find another unaddressed bug short after 0.8.4 was released, https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/173628 > Eventually we would like submit a detailed how-to or similar on > how we have been using DIA and dia2code for real-world UML2 and > UML/SQL modeling. We feel it's a small contribution compared to how > much our business depends on these tools. Sounds cool! -- Oliver |
From: Alejandro I. <ai...@ya...> - 2011-10-25 14:14:53
|
Hey Oliver, et al! I had even forgotten I had submitted a patch ;-) Somehow I never got the mails below... So we've kept using internal hacked versions. On Tue, Oct 25, 2011 at 1:31 AM, oli...@t-... <oli...@t-...> wrote: > BTW I have released dia2code 0.8.4 where the association name bug is fixed > (https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295) > That is awesome news my friend! I thought the project was kinda abandoned, so I'm very happy to see it alive and well!! We will start testing with 0.8.4 and start moving away slowly but surely from our internal patched versions and let you know how it goes. Eventually we would like submit a detailed how-to or similar on how we have been using DIA and dia2code for real-world UML2 and UML/SQL modeling. We feel it's a small contribution compared to how much our business depends on these tools. Thanks for the great work and for making Open Source a better place! -- Alejandro Imass > -- Oliver > > ----- Original message ----- > From: "oli...@t-..." <oli...@t-...> > To: "Germán" <ger...@ya...>, dia...@li... > Subject: Re: [Dia2code-general] Newcomer, old user, help offered, patch for SQL module 0.83 > Sent: Mon, 17 Oct 2011 22:39:25 +0200 > > On 2011-10-17, Germán <ger...@ya...> wrote: >> >> Alejandro patch(parse_diagram.patch) solves the same problem as >> that of ftdebugger. Likewise, I do not have the necessary knowledge >> on the code to decide what is the best solution. > > Okay. I looked again at Alejandro's parse_diagram.patch and I think > it is redundant to ftdebugger's patch. > >> if you used the patch of Ftdebugger, you can continue applying the patch >> from Alejandro to make use of the feature "surrogate >> keys"(generate_code_sql.patch). > > Okay, I did that: > > RCS file: /cvsroot/dia2code/dia2code/dia2code/generate_code_sql.c,v > ---------------------------- > revision 1.5 > date: 2011/10/17 20:26:54; author: okellogg; state: Exp; lines: +24 -1 > Apply generate_code_sql.patch by Alejandro Imass, see >> [...] >> 3) In generate_code_sql.c you are assuming that the FK columns have >> the same name on both sides (which is not very common), and with with >> the advent and ever-popular use of ORM technologies such as Propel >> (PHP) and DBIx::Class (Perl) the current naming convention/trend is to >> work with simple serial "surrogate keys", and FKs are 'standardized' >> to the form xxx_id where xxx is the FK table and the FK is _always_ >> "id". So in the attached patch, I check for this convention and warn >> if not being used. > ---------------------------- > >> And finally, you can apply the patch >> that fixes the problem I found. > > Yes, I did that also in generate_code_sql.c revision 1.5 > > Hope this helps, > > Oliver > > > |
From: <oli...@t-...> - 2011-10-25 05:31:42
|
BTW I have released dia2code 0.8.4 where the association name bug is fixed (https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295) -- Oliver ----- Original message ----- From: "oli...@t-..." <oli...@t-...> To: "Germán" <ger...@ya...>, dia...@li... Subject: Re: [Dia2code-general] Newcomer, old user, help offered, patch for SQL module 0.83 Sent: Mon, 17 Oct 2011 22:39:25 +0200 On 2011-10-17, Germán <ger...@ya...> wrote: > > Alejandro patch(parse_diagram.patch) solves the same problem as > that of ftdebugger. Likewise, I do not have the necessary knowledge > on the code to decide what is the best solution. Okay. I looked again at Alejandro's parse_diagram.patch and I think it is redundant to ftdebugger's patch. > if you used the patch of Ftdebugger, you can continue applying the patch > from Alejandro to make use of the feature "surrogate > keys"(generate_code_sql.patch). Okay, I did that: RCS file: /cvsroot/dia2code/dia2code/dia2code/generate_code_sql.c,v ---------------------------- revision 1.5 date: 2011/10/17 20:26:54; author: okellogg; state: Exp; lines: +24 -1 Apply generate_code_sql.patch by Alejandro Imass, see > [...] > 3) In generate_code_sql.c you are assuming that the FK columns have > the same name on both sides (which is not very common), and with with > the advent and ever-popular use of ORM technologies such as Propel > (PHP) and DBIx::Class (Perl) the current naming convention/trend is to > work with simple serial "surrogate keys", and FKs are 'standardized' > to the form xxx_id where xxx is the FK table and the FK is _always_ > "id". So in the attached patch, I check for this convention and warn > if not being used. ---------------------------- > And finally, you can apply the patch > that fixes the problem I found. Yes, I did that also in generate_code_sql.c revision 1.5 Hope this helps, Oliver ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct _______________________________________________ Dia2code-general mailing list Dia...@li... https://lists.sourceforge.net/lists/listinfo/dia2code-general |
From: <oli...@t-...> - 2011-10-17 20:39:34
|
On 2011-10-17, Germán <ger...@ya...> wrote: > > Alejandro patch(parse_diagram.patch) solves the same problem as > that of ftdebugger. Likewise, I do not have the necessary knowledge > on the code to decide what is the best solution. Okay. I looked again at Alejandro's parse_diagram.patch and I think it is redundant to ftdebugger's patch. > if you used the patch of Ftdebugger, you can continue applying the patch > from Alejandro to make use of the feature "surrogate > keys"(generate_code_sql.patch). Okay, I did that: RCS file: /cvsroot/dia2code/dia2code/dia2code/generate_code_sql.c,v ---------------------------- revision 1.5 date: 2011/10/17 20:26:54; author: okellogg; state: Exp; lines: +24 -1 Apply generate_code_sql.patch by Alejandro Imass, see > [...] > 3) In generate_code_sql.c you are assuming that the FK columns have > the same name on both sides (which is not very common), and with with > the advent and ever-popular use of ORM technologies such as Propel > (PHP) and DBIx::Class (Perl) the current naming convention/trend is to > work with simple serial "surrogate keys", and FKs are 'standardized' > to the form xxx_id where xxx is the FK table and the FK is _always_ > "id". So in the attached patch, I check for this convention and warn > if not being used. ---------------------------- > And finally, you can apply the patch > that fixes the problem I found. Yes, I did that also in generate_code_sql.c revision 1.5 Hope this helps, Oliver |
From: Germán <ger...@ya...> - 2011-10-16 22:42:24
|
Hi, Alejandro patch(parse_diagram.patch) solves the same problem as that of ftdebugger. Likewise, I do not have the necessary knowledge on the code to decide what is the best solution. if you used the patch of Ftdebugger, you can continue applying the patch from Alejandro to make use of the feature "surrogate keys"(generate_code_sql.patch). And finally, you can apply the patch that fixes the problem I found. On Sun, 16 Oct 2011 17:11:17 +0200 "oli...@t-..." <oli...@t-...> wrote: > Hi Germán, > > Thanks for your bug report. > Going back to the original mail from Alejandro Imass > (http://sourceforge.net/mailarchive/forum.php?thread_name=AANLkTimiVOtXNg6RSuMuPgBjD8a%3D7prL4B0TzawCBXL0%40mail.gmail.com&forum_name=dia2code-general), > I realize that nobody ever answered to that mail. > Alejandro wrote: > > [...] > > I think these 2 patches are quite harmless to the current 0.83 and > > maybe to more current versions of dia2code. I have seen a couple of > > postings regarding the "unnamed association bug" like this one: > > https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 > > I read up on that bug report and applied the parse_diagram.patch : > > RCS file: /cvsroot/dia2code/dia2code/dia2code/parse_diagram.c,v > Working file: dia2code/parse_diagram.c > ---------------------------- > revision 1.4 > date: 2011/10/16 14:22:33; author: okellogg; state: Exp; lines: +38 -37 > Attachment 2146249 from > https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 > lets dia2code find the name of an association given in the diagram. > Thanks to Evgeny Shpilevsky (ftdebugger) for the parse_diagram.patch. > ---------------------------- > > However, now the patch to parse_diagram.c by Alejandro cannot be applied. > > Could you have a look? > > Thanks, > > Oliver > |
From: <oli...@t-...> - 2011-10-16 15:11:33
|
Hi Germán, Thanks for your bug report. Going back to the original mail from Alejandro Imass (http://sourceforge.net/mailarchive/forum.php?thread_name=AANLkTimiVOtXNg6RSuMuPgBjD8a%3D7prL4B0TzawCBXL0%40mail.gmail.com&forum_name=dia2code-general), I realize that nobody ever answered to that mail. Alejandro wrote: > [...] > I think these 2 patches are quite harmless to the current 0.83 and > maybe to more current versions of dia2code. I have seen a couple of > postings regarding the "unnamed association bug" like this one: > https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 I read up on that bug report and applied the parse_diagram.patch : RCS file: /cvsroot/dia2code/dia2code/dia2code/parse_diagram.c,v Working file: dia2code/parse_diagram.c ---------------------------- revision 1.4 date: 2011/10/16 14:22:33; author: okellogg; state: Exp; lines: +38 -37 Attachment 2146249 from https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 lets dia2code find the name of an association given in the diagram. Thanks to Evgeny Shpilevsky (ftdebugger) for the parse_diagram.patch. ---------------------------- However, now the patch to parse_diagram.c by Alejandro cannot be applied. Could you have a look? Thanks, Oliver ----- Original message ----- From: Germán <ger...@ya...> To: dia...@li... Subject: Re: [Dia2code-general] Newcomer, old user, help offered, patch for SQL module 0.83 Date: Sat, 15 Oct 2011 02:34:00 +0200 Hello, and thanks for the info about the "association bugs". I was bumping into the same problem of the foreign keys. Then I found your work on svn. But when I tried it returned me a warning telling me the name of the association had to end with '_id'. And indeed, the name ended with '_id', then I dared to modify your code and I was able to make it work (was only a little error). Here is the patch. --- generate_code_sql.c (revisión: 7) +++ generate_code_sql.c (copia de trabajo) @@ -156,9 +156,8 @@ */ - char tail[4]; const char *fk_col = temp->name; - strncpy(tail, fk_col+sizeof(fk_col)-2, 3); + const char *tail=&fk_col[strlen(fk_col)-3]; if(!strcmp("_id", tail)){ fk_col = "id"; } Warning: Never use sizeof() to take care of the length of an string. If applied to a pointer is going to return the size it occupies in memory the pointer, usually will get value 4 for 32-bit machines. Therefore, always use strlen. Be careful also to put the null terminator for strings. Anyway, here you have an alternative way to cut the tail of a string. Greetings from Argentina. (That explains my poor English) -- Germán <ger...@ya...> ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct _______________________________________________ Dia2code-general mailing list Dia...@li... https://lists.sourceforge.net/lists/listinfo/dia2code-general |
From: Germán <ger...@ya...> - 2011-10-15 00:34:08
|
Hello, and thanks for the info about the "association bugs". I was bumping into the same problem of the foreign keys. Then I found your work on svn. But when I tried it returned me a warning telling me the name of the association had to end with '_id'. And indeed, the name ended with '_id', then I dared to modify your code and I was able to make it work (was only a little error). Here is the patch. --- generate_code_sql.c (revisión: 7) +++ generate_code_sql.c (copia de trabajo) @@ -156,9 +156,8 @@ */ - char tail[4]; const char *fk_col = temp->name; - strncpy(tail, fk_col+sizeof(fk_col)-2, 3); + const char *tail=&fk_col[strlen(fk_col)-3]; if(!strcmp("_id", tail)){ fk_col = "id"; } Warning: Never use sizeof() to take care of the length of an string. If applied to a pointer is going to return the size it occupies in memory the pointer, usually will get value 4 for 32-bit machines. Therefore, always use strlen. Be careful also to put the null terminator for strings. Anyway, here you have an alternative way to cut the tail of a string. Greetings from Argentina. (That explains my poor English) -- Germán <ger...@ya...> |
From: Ale S. <ale...@gm...> - 2011-09-21 07:56:20
|
Hi, I am setting up my installation of Dia, dia2code etc. When I did a little test, weird lines like: // ## Implementation preserve start class attributes. showed up in the generated files. *I was wondering why.* Maybe I didn't fill some info in? Because I don't see it in the examples on http://dia2code.sourceforge.net/examples.html Kind regards, Ale |
From: Alejandro I. <ai...@ya...> - 2011-03-03 12:50:51
|
Hi folks, First of all let me say that I really appreciate and would like to publicly "THANK YOU!" for having made dia2code possible. I know how ungrateful user communities tend to be, so I just wanted to let you know we are a happy user and use dia2code on a daily basis for a real-world business and profit from it. Having said that, I have had a to-do in my agenda for many years now to contribute to this project but getting my small company off the ground has been so hard that we merely had enough budget to pay salaries for the past 4 years. But things are finally getting off the ground so I can start crossing-out some of these pending items, and my debt to this project is one of these items. A little introduction and background on my use of dia2code... I have been playing around with DIA since I discovered it in Debian packages, I'm pretty sure it was Debian Hamm (2.0) stable or perhaps unstable-almost-Woody but honestly I can't remember back that far. What I do remember is that all the way back in 2001 I had chosen DIA and dia2code as my basic UML modeling tools that I would use "someday" when I had the guts to leave my job and create a fully Open source company. That finally happened in late 2006 and in 2007 I had finally formed it with an old friend, and officially started using these tools for real production work. When 0.83 was first distributed on Debian, I believe it was Etch (4.0) our "old way" of doing things broke, so out of desperation we simply took a source version and patched it for our specific needs (basically commenting out the bulk of the PK stuff) and never touched it since. But I promised myself that when we had a little oxygen I would put an effort to understand what you guys were trying to do with associations, aggregations, compositions and such, and how those things mapped to SQL for the common mortal. So here we are in 2011 I have finally sat down to hack at it.... OK so here's what I've done so far and would like your take and possibly continue my contribution to SQL generation from UML class models. 1) In parse_diagram.c I think you are expecting/using an old version of the DIA XML because the deep level of nesting for the first UML -Association loop simply does not resemble anything I'm looking at in the DIA 0.97 XMLs. Also, I could not find an attribute named "ends" _anywhere_ in the DIA UML objects, so after a lot of head banging trying to understand that bit, I decided to leave it alone and focus on the second attribute iteration that you use for connections. 2) So, regardless of (1) when you get to the second loop for the connections, the "name" is always null. I _supposed_ that you were meaning to set the name in the first loop but when I see you are also determining "direction" in the second loop I am not quite sure of that, that is, that the loops are actually related or they are 2 separate cases? Anyway, I made a small hack to capture the association name in the second loop and make sure it gets set. 3) In generate_code_sql.c you are assuming that the FK columns have the same name on both sides (which is not very common), and with with the advent and ever-popular use of ORM technologies such as Propel (PHP) and DBIx::Class (Perl) the current naming convention/trend is to work with simple serial "surrogate keys", and FKs are 'standardized' to the form xxx_id where xxx is the FK table and the FK is _always_ "id". So in the attached patch, I check for this convention and warn if not being used. http://en.wikipedia.org/wiki/Surrogate_key I think these 2 patches are quite harmless to the current 0.83 and maybe to more current versions of dia2code. I have seen a couple of postings regarding the "unnamed association bug" like this one: https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 If you think I'm on the right track please let me know as I could continue to work and contribute to the associations in general, though mainly targeted to SQL generation. I would like to continue to work on many-to-many, primary key and additional indexes creations... as well as trying some experiments with roles or another naming convention for the assoc to make the FK stuff more general (to support real old-school FKs and multi-columns PKs as well). I am admittedly a bit rusty in C but *I love it* and used to be quite proficient, though I currently work mostly in Perl so I am spoiled ;-) I do have a lot of experience however with the libxml2 API through XML::LibXML which is a simple wrapper to C's libxml2 that you are using. Anyway, I'd appreciate your comments and the possibility of actively contributing to this project for a while. The patches are attached but you can check out my up-to-date work anonymously at: svn://svn.yabarana.com/dia2code-0.8.3-corcaribe /trunk is the my old 2007 version where I just commented all the FK stuff and expanded th 80 char limit because of my literal declaration of FK directly on the UML Class attributes. In /branches you will find a vanilla 0.83 and my new work in the dia2code-0.8.3 and dia2code-0.8.3_yabafixes directories respectively. In the root of branches you will also find the latest versions of the attached patches to this mail. Best, -- Alejandro Imass P.S. I don't work much with CVS but I'm quite proficient with SVN, have you ever considered migrating to SVN? |
From: Alejandro I. <ai...@ya...> - 2011-03-03 12:50:28
|
Hi folks, First of all let me say that I really appreciate and would like to publicly "THANK YOU!" for having made dia2code possible. I know how ungrateful user communities tend to be, so I just wanted to let you know we are a happy user and use dia2code on a daily basis for a real-world business and profit from it. Having said that, I have had a to-do in my agenda for many years now to contribute to this project but getting my small company off the ground has been so hard that we merely had enough budget to pay salaries for the past 4 years. But things are finally getting off the ground so I can start crossing-out some of these pending items, and my debt to this project is one of these items. A little introduction and background on my use of dia2code... I have been playing around with DIA since I discovered it in Debian packages, I'm pretty sure it was Debian Hamm (2.0) stable or perhaps unstable-almost-Woody but honestly I can't remember back that far. What I do remember is that all the way back in 2001 I had chosen DIA and dia2code as my basic UML modeling tools that I would use "someday" when I had the guts to leave my job and create a fully Open source company. That finally happened in late 2006 and in 2007 I had finally formed it with an old friend, and officially started using these tools for real production work. When 0.83 was first distributed on Debian, I believe it was Etch (4.0) our "old way" of doing things broke, so out of desperation we simply took a source version and patched it for our specific needs (basically commenting out the bulk of the PK stuff) and never touched it since. But I promised myself that when we had a little oxygen I would put an effort to understand what you guys were trying to do with associations, aggregations, compositions and such, and how those things mapped to SQL for the common mortal. So here we are in 2011 I have finally sat down to hack at it.... OK so here's what I've done so far and would like your take and possibly continue my contribution to SQL generation from UML class models. 1) In parse_diagram.c I think you are expecting/using an old version of the DIA XML because the deep level of nesting for the first UML -Association loop simply does not resemble anything I'm looking at in the DIA 0.97 XMLs. Also, I could not find an attribute named "ends" _anywhere_ in the DIA UML objects, so after a lot of head banging trying to understand that bit, I decided to leave it alone and focus on the second attribute iteration that you use for connections. 2) So, regardless of (1) when you get to the second loop for the connections, the "name" is always null. I _supposed_ that you were meaning to set the name in the first loop but when I see you are also determining "direction" in the second loop I am not quite sure of that, that is, that the loops are actually related or they are 2 separate cases? Anyway, I made a small hack to capture the association name in the second loop and make sure it gets set. 3) In generate_code_sql.c you are assuming that the FK columns have the same name on both sides (which is not very common), and with with the advent and ever-popular use of ORM technologies such as Propel (PHP) and DBIx::Class (Perl) the current naming convention/trend is to work with simple serial "surrogate keys", and FKs are 'standardized' to the form xxx_id where xxx is the FK table and the FK is _always_ "id". So in the attached patch, I check for this convention and warn if not being used. http://en.wikipedia.org/wiki/Surrogate_key I think these 2 patches are quite harmless to the current 0.83 and maybe to more current versions of dia2code. I have seen a couple of postings regarding the "unnamed association bug" like this one: https://bugs.launchpad.net/ubuntu/+source/dia2code/+bug/442295 If you think I'm on the right track please let me know as I could continue to work and contribute to the associations in general, though mainly targeted to SQL generation. I would like to continue to work on many-to-many, primary key and additional indexes creations... as well as trying some experiments with roles or another naming convention for the assoc to make the FK stuff more general (to support real old-school FKs and multi-columns PKs as well). I am admittedly a bit rusty in C but *I love it* and used to be quite proficient, though I currently work mostly in Perl so I am spoiled ;-) I do have a lot of experience however with the libxml2 API through XML::LibXML which is a simple wrapper to C's libxml2 that you are using. Anyway, I'd appreciate your comments and the possibility of actively contributing to this project for a while. The patches are attached but you can check out my up-to-date work anonymously at: svn://svn.yabarana.com/dia2code-0.8.3-corcaribe /trunk is the my old 2007 version where I just commented all the FK stuff and expanded th 80 char limit because of my literal declaration of FK directly on the UML Class attributes. In /branches you will find a vanilla 0.83 and my new work in the dia2code-0.8.3 and dia2code-0.8.3_yabafixes directories respectively. In the root of branches you will also find the latest versions of the attached patches to this mail. Best, -- Alejandro Imass P.S. I don't work much with CVS but I'm quite proficient with SVN, have you ever considered migrating to SVN? |
From: Charles S. <cha...@gm...> - 2009-09-30 14:03:08
|
Hi Ashley, I no longer have the source files. I'm sending the patch that I've sent some time ago. This patch was generated against the 0.8.3 source code pack that is in the dia2code site. Cheers On Wed, Sep 30, 2009 at 6:59 AM, Ashley Kitson <as...@zw...> wrote: > Charles > > you posted some amends to the PHP5 code generator a while back. Could you > post the contents of the entire file please. I'd like to use it as you seem > to have solved a couple of problems with it. > > -- > Kind Regards > Ashley > > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9-12, 2009. Register now! > http://p.sf.net/sfu/devconf > _______________________________________________ > Dia2code-general mailing list > Dia...@li... > https://lists.sourceforge.net/lists/listinfo/dia2code-general > > -- Charles Schaefer UaiTI (www.uaiti.com.br) Email: cha...@gm... ch...@ua... Tels.: +55 31 9317-2862 +55 31 3247-6207 ATENÇÃO: Não imprima este e-mail. A natureza agradece. E seu bolso também. WARNING: Don't print this e-mail. The nature is thankful. And your money too. |