Le Tuesday 24 June 2008 07:08:46 swapna mudavath, vous avez écrit :
> can anybody help me in this....
>
> -swapna
>
> ---------- Forwarded message ----------
> From: swapna mudavath <[EMAIL PROTECTED]>
> Date: Mon, Jun 23, 2008 at 5:27 PM
> Subject: xml to mysql (vice versa ) too
> To: Python-list@python.org
>
>
> Hi,
>
> I need to write a python script to store data which is in XML to MYSQL and
> even vice versa....
> what should be the approach?
> i am able to establish a connection,create tables and insert data .....
> but how to read an xml file and store in MYSQL....
> my XML structure is like
>
> <list title=" xyz", id = "1",........>
> <item name=" abc" ,pos="1",........>
> </item>
> <item name =" hgdf", pos ="3",......>
> </item>
> .
> ....
> ...
> </list>
This is not valid xml, there is no commas in attribute list in xml.
> can somebody please help me......i am really confused!!!!!!
>
> thanks in advance :)
You could try with minidom if your xml stream isn't too large, else sax parser
is to be considered, but minidom is pretty easy to use.
Give it a try and come back with more specific questions.
In [82]: from xml.dom.minidom import parseString
In [83]: xml = """<list title=" xyz" id= "1">
<item name=" abc" pos="1">
</item>
<item name=" hgdf" pos ="3">
</item>
</list>"""
In [89]: def print_nodes(node) :
print node
if node.attributes :
for n, v in node.attributes.items() : print n, v
for i in node.childNodes : print_nodes(i)
....:
....:
In [94]: dom = parseString(xml)
In [95]: print_nodes(dom)
<xml.dom.minidom.Document instance at 0xc2b7e8>
<DOM Element: list at 0xc2b998>
id 1
title xyz
<DOM Text node "
">
<DOM Element: item at 0xc2bd40>
name abc
pos 1
<DOM Text node "
">
<DOM Text node "
">
<DOM Element: item at 0xc30050>
name hgdf
pos 3
<DOM Text node "
">
<DOM Text node "
">
--
_____________
Maric Michaud
--
http://mail.python.org/mailman/listinfo/python-list
