[Dia2sqlpy-development] Fwd: Re: DIa2sql

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

----------  Forwarded Message  ----------

Subject: Re: DIa2sql
Date: Tue, 29 Apr 2003 22:40:25 -0400
From: Eric Arnoth <ea...@co...>
To: Aris Basic <ari...@si...>
Cc: dia...@li...

Aris:

I was able to run the output you sent me, I did not get the XML parsing
 error. I'm trying to figure out what XML package SuSE put in the RPM,  I=
've
 put in an enquiry to them, hopefully they'll educate me about the matter=
=2E=20
 If I don't hear back from them, I'll keep after them.

In the meanwhile, I'm still researching the various python XML packages t=
o
 try and understand it.  I'll also try and explore the 0.8.2 pyXML module=
 and
 see if I can't make my script work with that.

-Eric

On Tuesday 29 April 2003 07:30, Aris Basic wrote:
> It looks like the packages are to some degree compatible however they m=
ay
> produce a little bit diffrent parsing I guess.
>
>
> These are the files that i have from
> my python installation (gentoo)
> Python 2.2.2 (#1, Jan 12 2003, 17:07:25)
> [GCC 3.2.1 20021207 (Gentoo Linux 3.2.1-20021207)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>
> >>> import xml
> >>> xml.__version__
>
> '0.8.2'
>
> >>> xml.__doc__
>
> 'Extended XML support for Python\n\nThe full PyXML package, available f=
rom
> http://pyxml.sf.net, is installed.\n\nThis package contains seven
> sub-packages:\n\ndom -- The W3C Document Object Model.  This supports D=
OM
> Level 1 +\n       Namespaces.\n\nmarshal -- Converts Python objects to =
XML
> and back again.\n\nns -- Contains namespace URIs for various
> standards.\n\nparsers -- Python wrappers for XML parsers.\n\nsax -- The
> Simple API for XML, developed by XML-Dev, led by David\n       Megginso=
n
> and ported to Python by Lars Marius Garshol.  This\n       supports the=
 SAX
> 2 API.\n\nschema -- Support for XML schema languages.  Currently TREX i=
s
> the only\n          supported language.\n\nutils -- Various small utili=
ty
> modules.\n\nxpath -- XPath parsing and evaluation.  Implemented by
> Fourthought, Inc.\n'
>
> --- file list
>
> ls -lR /usr/lib/python2.2/xml*
> -rw-r--r--    1 root     root        34920 Jan 12 17:08
> /usr/lib/python2.2/xmllib.py
> -rw-r--r--    1 root     root        35471 Mar 21 10:40
> /usr/lib/python2.2/xmllib.pyc
> -rw-r--r--    1 root     root        34898 Jan 12 17:08
> /usr/lib/python2.2/xmllib.pyo
> -rw-r--r--    1 root     root        31728 Jan 12 17:08
> /usr/lib/python2.2/xmlrpclib.py
> -rw-r--r--    1 root     root        43716 Jan 12 17:08
> /usr/lib/python2.2/xmlrpclib.pyc
> -rw-r--r--    1 root     root        41550 Jan 12 17:08
> /usr/lib/python2.2/xmlrpclib.pyo
>
> /usr/lib/python2.2/xml:
> total 24
> -rw-r--r--    1 root     root         1011 Jan 12 17:08 __init__.py
> -rw-r--r--    1 root     root         1097 Feb 20 17:57 __init__.pyc
> -rw-r--r--    1 root     root         1082 Jan 12 17:08 __init__.pyo
> drwxr-xr-x    2 root     root         4096 Jan 12 17:08 dom
> drwxr-xr-x    2 root     root         4096 Jan 12 17:08 parsers
> drwxr-xr-x    2 root     root         4096 Jan 12 17:08 sax
>
> /usr/lib/python2.2/xml/dom:
> total 236
> -rw-r--r--    1 root     root         3653 Jan 12 17:08 __init__.py
> -rw-r--r--    1 root     root         8716 Jan 12 17:08 __init__.pyc
> -rw-r--r--    1 root     root         8437 Jan 12 17:08 __init__.pyo
> -rw-r--r--    1 root     root         2828 Jan 12 17:08 domreg.py
> -rw-r--r--    1 root     root         3305 Jan 12 17:08 domreg.pyc
> -rw-r--r--    1 root     root         3176 Jan 12 17:08 domreg.pyo
> -rw-r--r--    1 root     root        32220 Jan 12 17:08 minidom.py
> -rw-r--r--    1 root     root        52171 Jan 12 17:08 minidom.pyc
> -rw-r--r--    1 root     root        49609 Jan 12 17:08 minidom.pyo
> -rw-r--r--    1 root     root        11753 Jan 12 17:08 pulldom.py
> -rw-r--r--    1 root     root        18574 Jan 12 17:08 pulldom.pyc
> -rw-r--r--    1 root     root        17638 Jan 12 17:08 pulldom.pyo
>
> /usr/lib/python2.2/xml/parsers:
> total 24
> -rw-r--r--    1 root     root          167 Jan 12 17:08 __init__.py
> -rw-r--r--    1 root     root          337 Jan 12 17:08 __init__.pyc
> -rw-r--r--    1 root     root          331 Jan 12 17:08 __init__.pyo
> -rw-r--r--    1 root     root          219 Jan 12 17:08 expat.py
> -rw-r--r--    1 root     root          473 Jan 12 17:08 expat.pyc
> -rw-r--r--    1 root     root          440 Jan 12 17:08 expat.pyo
>
> /usr/lib/python2.2/xml/sax:
> total 256
> -rw-r--r--    1 root     root         3617 Jan 12 17:08 __init__.py
> -rw-r--r--    1 root     root         5049 Jan 12 17:08 __init__.pyc
> -rw-r--r--    1 root     root         4866 Jan 12 17:08 __init__.pyo
> -rw-r--r--    1 root     root         4662 Jan 12 17:08 _exceptions.py
> -rw-r--r--    1 root     root         7741 Jan 12 17:08 _exceptions.pyc
> -rw-r--r--    1 root     root         7519 Jan 12 17:08 _exceptions.pyo
> -rw-r--r--    1 root     root        11131 Jan 12 17:08 expatreader.py
> -rw-r--r--    1 root     root        17340 Jan 12 17:08 expatreader.pyc
> -rw-r--r--    1 root     root        16542 Jan 12 17:08 expatreader.pyo
> -rw-r--r--    1 root     root        13058 Jan 12 17:08 handler.py
> -rw-r--r--    1 root     root        14866 Jan 12 17:08 handler.pyc
> -rw-r--r--    1 root     root        14590 Jan 12 17:08 handler.pyo
> -rw-r--r--    1 root     root         8124 Jan 12 17:08 saxutils.py
> -rw-r--r--    1 root     root        16771 Jan 12 17:08 saxutils.pyc
> -rw-r--r--    1 root     root        16150 Jan 12 17:08 saxutils.pyo
> -rw-r--r--    1 root     root        12580 Jan 12 17:08 xmlreader.py
> -rw-r--r--    1 root     root        24941 Jan 12 17:08 xmlreader.pyc
> -rw-r--r--    1 root     root        24137 Jan 12 17:08 xmlreader.pyo
>
> On Tuesday 29 April 2003 13:00, Eric Arnoth wrote:
> > This is interesting...
> >
> > I visited the Sourceforge site for the project
> > (http://sourceforge.net/project/showfiles.php?group_id=3D6473) and th=
eir
> > highest rev is 0.8.2.
> >
> > I'm thinking perhaps my Python does not have PyXML, but some other XM=
L
> >
> > package.  Here's the __doc__ string output for my module:
> > >>> xml.__doc__
> >
> > 'Core XML support for Python.\n\nThis package contains three
> > sub-packages:\n\ndom -- The W3C Document Object Model.  This supports=
 DOM
> > Level 1 +\n       Namespaces.\n\nparsers -- Python wrappers for XML
> > parsers (currently only supports Expat).\n\nsax -- The Simple API for
> > XML, developed by XML-Dev, led by David\n       Megginson and ported =
to
> > Python by Lars Marius Garshol.  This\n       supports the SAX 2 API.\=
n'
> >
> > I'm running SuSE v8.1, and my Python is the native install.  Here's a=
n
> > rpm package I found, which seems to be what my python install is usin=
g:
> >
> > jefferson9:23pm[101]> rpm -qi python-xml-2.2.1-65
> > Name        : python-xml                   Relocations: (not
> > relocateable) Version     : 2.2.1                             Vendor:
> > SuSE Linux AG, Nuernberg, Germany
> > Release     : 65                            Build Date: Mon 14 Oct 20=
02
> > 11:55:35 PM EDT
> > Install date: Sat 01 Feb 2003 02:35:00 PM EST      Build Host:
> > D45.suse.de Group       : Development/Libraries/Python   Source RPM:
> > python-2.2.1-65.src.rpm
> > Size        : 467943                           License: Python
> > Packager    : http://www.suse.de/feedback
> > Summary     : Python XML interface
> > Description :
> > The expat-module is a Python interface to expat XML parser.
> > Since python2.x it is part of the core python distribution.
> > Distribution: SuSE Linux 8.1 (i386)
> >
> > /usr/lib/python2.2/lib-dynload/pyexpat.so
> > /usr/lib/python2.2/xml
> > /usr/lib/python2.2/xml/__init__.py
> > /usr/lib/python2.2/xml/__init__.pyc
> > /usr/lib/python2.2/xml/__init__.pyo
> > /usr/lib/python2.2/xml/dom
> > /usr/lib/python2.2/xml/dom/__init__.py
> > /usr/lib/python2.2/xml/dom/__init__.pyc
> > /usr/lib/python2.2/xml/dom/__init__.pyo
> > /usr/lib/python2.2/xml/dom/domreg.py
> > /usr/lib/python2.2/xml/dom/domreg.pyc
> > /usr/lib/python2.2/xml/dom/domreg.pyo
> > /usr/lib/python2.2/xml/dom/minidom.py
> > /usr/lib/python2.2/xml/dom/minidom.pyc
> > /usr/lib/python2.2/xml/dom/minidom.pyo
> > /usr/lib/python2.2/xml/dom/pulldom.py
> > /usr/lib/python2.2/xml/dom/pulldom.pyc
> > /usr/lib/python2.2/xml/dom/pulldom.pyo
> > /usr/lib/python2.2/xml/parsers
> > /usr/lib/python2.2/xml/parsers/__init__.py
> > /usr/lib/python2.2/xml/parsers/__init__.pyc
> > /usr/lib/python2.2/xml/parsers/__init__.pyo
> > /usr/lib/python2.2/xml/parsers/expat.py
> > /usr/lib/python2.2/xml/parsers/expat.pyc
> > /usr/lib/python2.2/xml/parsers/expat.pyo
> > /usr/lib/python2.2/xml/sax
> > /usr/lib/python2.2/xml/sax/__init__.py
> > /usr/lib/python2.2/xml/sax/__init__.pyc
> > /usr/lib/python2.2/xml/sax/__init__.pyo
> > /usr/lib/python2.2/xml/sax/_exceptions.py
> > /usr/lib/python2.2/xml/sax/_exceptions.pyc
> > /usr/lib/python2.2/xml/sax/_exceptions.pyo
> > /usr/lib/python2.2/xml/sax/expatreader.py
> > /usr/lib/python2.2/xml/sax/expatreader.pyc
> > /usr/lib/python2.2/xml/sax/expatreader.pyo
> > /usr/lib/python2.2/xml/sax/handler.py
> > /usr/lib/python2.2/xml/sax/handler.pyc
> > /usr/lib/python2.2/xml/sax/handler.pyo
> > /usr/lib/python2.2/xml/sax/saxutils.py
> > /usr/lib/python2.2/xml/sax/saxutils.pyc
> > /usr/lib/python2.2/xml/sax/saxutils.pyo
> > /usr/lib/python2.2/xml/sax/xmlreader.py
> > /usr/lib/python2.2/xml/sax/xmlreader.pyc
> > /usr/lib/python2.2/xml/sax/xmlreader.pyo
> >
> > On Saturday 26 April 2003 14:34, you wrote:
> > > it is python 2.2.2 on gentoo distribution there it loks like pyXML =
is
> > > separate package
> > >
> > > Python 2.2.2 (#1, Jan 12 2003, 17:07:25)
> > > [GCC 3.2.1 20021207 (Gentoo Linux 3.2.1-20021207)] on linux2
> > > Type "help", "copyright", "credits" or "license" for more informati=
on.
> > >
> > > >>> xml.__version__
> > >
> > > '0.8.2'
> > >
> > > hmm and i dont even have that 1.11 available :(
> > >
> > > On Saturday 26 April 2003 20:12, you wrote:
> > > > Which Python are you using?  I used Python 2.2, which has pyXML a=
s
> > > > part of the standard distro:
> > > >
> > > > jefferson2:11pm[101]> python
> > > > Python 2.2.1 (#1, Sep 10 2002, 17:49:17)
> > > > [GCC 3.2] on linux2
> > > > Type "help", "copyright", "credits" or "license" for more
> > > > information.
> > > >
> > > > >>> import xml
> > > > >>> xml.__version__
> > > >
> > > > '1.11'
> > > >
> > > > That might be the issue right there...
> > > >
> > > > -E
> > > >
> > > > On Saturday 26 April 2003 09:16, Aris Basic wrote:
> > > > > im usin dia 0.91 (because of GTK2), and i made some changes to
> > > > > dia2sql to remove the previous error , however im getting some =
new
> > > > > ones (reagrding references) it loks like the script saves some
> > > > > nameless or empty elements and references. At least Im guessing=
 it
> > > > > is that  I am using an additional object hwoeer i thought dia2s=
ql
> > > > > will ignore it ? (I dont know if its problem with that object o=
r
> > > > > not)
> > > > >
> > > > > I;ll try to do some more research regarding it by myself and if
> > > > > nothing then gonna come back to you with whole dia file :)
> > > > > Also previous error coudl also be caused by different pyXML
> > > > > versions, when i changed to 0.8.1 it gave me different error (a=
bout
> > > > > empty string or something like that)
> > > > >
> > > > > Aris
> > > > >
> > > > > On Saturday 26 April 2003 14:55, you wrote:
> > > > > > If you want to send me the .dia file, I can look at it and tr=
y
> > > > > > and figure out what the problem is.  What version of dia are =
you
> > > > > > using? I have only tried my script with Dia 0.90.
> > > > > >
> > > > > > It's not likely a problem, but when you did your SQL diagram,
> > > > > > were you sure to use the UML objects?  I don't know if you lo=
oked
> > > > > > at the tutorial
> > > > > > (http://honeypotdiary.org/earnoth/html/modules.php?name=3DCon=
tent&p
> > > > > >a=3D sh ow pa ge &pid=3D17) on my app's website, but there's o=
nly two
> > > > > > objects you can use. Of course, I don't know that that should
> > > > > > make any difference in the error you're getting below...
> > > > > >
> > > > > > -Eric
> > > > > >
> > > > > > On Saturday 26 April 2003 02:34, Aris Basic wrote:
> > > > > > > Thx for help, however i have some more problems :(
> > > > > > >
> > > > > > > =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
> > > > > > > Failure in XML parsing!
> > > > > > > Did you remember to save the Dia file without compression..=
=2E?
> > > > > > > =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
> > > > > > > Traceback (most recent call last):
> > > > > > >   File "./dia2sql.py", line 228, in __init__
> > > > > > >     parser.parse(open(filename))
> > > > > > >   File
> > > > > > > "/usr/lib/python2.2/site-packages/_xmlplus/sax/expatreader.=
py",
> > > > > > > line 107, in parse
> > > > > > >     self.reset()
> > > > > > >   File
> > > > > > > "/usr/lib/python2.2/site-packages/_xmlplus/sax/expatreader.=
py",
> > > > > > > line 236, in reset
> > > > > > >     self._parser =3D expat.ParserCreate(intern =3D self._in=
terning)
> > > > > > > TypeError: 'intern' is an invalid keyword argument for this
> > > > > > > function
> > > > > > >
> > > > > > >
> > > > > > > and my dia file is not compressed, this looks like problem =
in
> > > > > > > XML Package nad i guess it is not a dia2sql problem, but i
> > > > > > > wanted toc heck out anyway
> > > > > > >
> > > > > > > :)
> > > > > > >
> > > > > > > Thx
> > > > > > > Aris
> > > > > > >
> > > > > > > On Saturday 26 April 2003 00:52, you wrote:
> > > > > > > > Greetings, and thanks for trying my software!  Sorry I di=
dn't
> > > > > > > > email sooner, but I basically check my email before & aft=
er
> > > > > > > > work, which puts my reply time as high as 12 hour interva=
ls.
> > > > > > > >
> > > > > > > > :-P
> > > > > > > >
> > > > > > > > Here's the link to get the Options package:
> > > > > > > > http://py.vaults.ca/apyllo2.py/D77076052
> > > > > > > >
> > > > > > > > I initially found it on the Vaults of Parnassus:
> > > > > > > > http://www.vex.net/parnassus/
> > > > > > > >
> > > > > > > > If you like Python, I strongly recommend it.  It's the
> > > > > > > > closest thing I've found to a Python CPAN.
> > > > > > > >
> > > > > > > > Please feel free to let me know if you need any more help
> > > > > > > > getting dia2sqlpy to run, or have any feedback, or patche=
s to
> > > > > > > > offer, or questions, etc.
> > > > > > > >
> > > > > > > > Hope you enjoy the software.  Again, thanks for trying my
> > > > > > > > package.
> > > > > > > >
> > > > > > > > :-)
> > > > > > > >
> > > > > > > > -Eric
> > > > > > > >
> > > > > > > > On Friday 25 April 2003 07:58, you wrote:
> > > > > > > > > Hi
> > > > > > > > >
> > > > > > > > > I am trying to use your dia2sql script, however it trye=
s to
> > > > > > > > > use a Options package and I could not finde it anywhere=
,
> > > > > > > > > coudl you tell me the name of te package that has this
> > > > > > > > > Options package ?
> > > > > > > > >
> > > > > > > > > Thank You
> > > > > > > > > Aris Basic

--
Eric I. Arnoth    CISSP (http://www.isc2.org)
ea...@co...
http://mywebpages.comcast.net/earnoth
=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8=B8,=F8=A4=F8,=B8=B8,=F8=A4=BA=
=B0*=B0=BA=A4=F8,=B8=B8,=F8=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8=B8=
,=F8=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8
=B8,=F8

-------------------------------------------------------

--=20
Eric I. Arnoth    CISSP (http://www.isc2.org)       =20
ea...@co...               =20
http://mywebpages.comcast.net/earnoth
=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8=B8,=F8=A4=F8,=B8=B8,=F8=A4=BA=
=B0*=B0=BA=A4=F8,=B8=B8,=F8=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8=B8=
,=F8=A4=F8,=B8=B8,=F8=A4=BA=B0*=B0=BA=A4=F8,=B8=B8,=F8