Login | Register
My pages Projects Community openCollabNet

Discussions > Notification of Issues > [argouml-issues] [Issue 6516] New - please add SQL import, export to class diagram

argouml
Discussion topic

Hide all messages in topic

All messages in topic

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author elbedd
Full name Laurent BRAUD
Date 2016-06-23 09:55:07 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from elbedd at tigris dot org Thu Jun 23 09:55:07 -0700 2016 -------
"- the diamond-shaped arrows could be used (learn more about uml) with
primary and foreign key relationships"
Not sure that it's true in all case. (but may be I'm wrong)

"- as much of the data types in MySQL manual could be added, with support
for BLOBs, time, date, timestamps, and if necessary, create new types in the
class diagram."
In the "level Physical", the type is the SQL one, and if doesn't exists the
UML datatype is created in the project (or package I don't remember).
I have try to add profil and get type in a profile when import SQL file, but
I have never success.

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author elbedd
Full name Laurent BRAUD
Date 2016-06-23 09:36:12 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from elbedd at tigris dot org Thu Jun 23 09:36:11 -0700 2016 -------
"anything with Eclipse would be a mistake I think."
It's just that the build process doesn't work (Something is missing In v0.35)
and I don't know why. If you want to try or reuse what I done and if you are
able to start ArgoUML from an IDE, maybe it can be helpfull for you.

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author jmichae3
Full name Jim Michaels
Date 2016-06-22 22:47:44 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from jmichae3 at tigris dot org Wed Jun 22 22:47:44 -0700 2016 -------
I looked at it, and was wondering if:
- postgresql could be added
- db2 could be added
- the diamond-shaped arrows could be used (learn more about uml) with primary
and foreign key relationships
- as much of the data types in MySQL manual could be added, with support for
BLOBs, time, date, timestamps, and if necessary, create new types in the class
diagram.

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author jmichae3
Full name Jim Michaels
Date 2016-06-22 22:41:14 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from jmichae3 at tigris dot org Wed Jun 22 22:41:13 -0700 2016 -------
anything with Eclipse would be a mistake I think. very few people know how to
even install eclipse. so I leave it alone.

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author elbedd
Full name Laurent BRAUD
Date 2016-06-20 13:20:04 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from elbedd at tigris dot org Mon Jun 20 13:20:03 -0700 2016 -------
Hi Jim,

To import, I implements a first version some year ago, but it doesn't work in
the build version (need launch with Eclispe). How to use import when started,
is explain here : http://argouml-sql.t​igris.org/ParsingDDL​Script.html

To launch with Eclipse, you need the core projects and the argouml-sql module.
The launcher is in the module.

[argouml-issues] [Issue 6516] please add SQL import, export to class diagram

Author jmichae3
Full name Jim Michaels
Date 2016-06-19 11:24:14 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516






------- Additional comments from jmichae3 at tigris dot org Sun Jun 19 11:24:14 -0700 2016 -------
Created an attachment (id=2287)
argouml2sql written in PHP to query pgsql DBMS, mysql

[argouml-issues] [Issue 6516] New - please add SQL import, export to class diagram

Author jmichae3
Full name Jim Michaels
Date 2016-06-19 11:10:13 PDT
Message http://argouml.tigri​s.org/issues/show_bu​g.cgi?id=6516
                 Issue #|6516
                 Summary|please add SQL import, export to class diagram
               Component|argouml
                 Version|current
                Platform|All
                     URL|
              OS/Version|All
                  Status|NEW
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|ENHANCEMENT
                Priority|P3
            Subcomponent|Class Diagram
             Assigned to|bobtarling
             Reported by|jmichae3






------- Additional comments from jmichae3 at tigris dot org Sun Jun 19 11:10:13 -0700 2016 -------
I can provide source code for argouml to a class diagram. but there needs to be
enhancements. as it turns out, the class diagram makes a nice replacement for an
ER diagram for most purposes. I as a db programmer/web designer need to import
and export SQL2000 or SQL2015.

and is there a version of UML that isn't unified? just call it DML for diagram
modeling language or something.
Messages per page: