MySQL -->Python-->XML for JSviz

Picio picioslug at gmail.com
Tue Jul 3 10:08:19 EDT 2007


Hello all, I need some advice to choose an xml generator for jsviz a
tool in javascript to create some wonderful graphs (SnowFlake or Force
directed).

Starting from a SQL table (mysql) I need to create a XML file with a
structure like this:
<node root....>
      <node id... text... ></node>
      <node id... text... ></node>
      <node id... text... ></node>
                  <node id... text... ></node>
                  <node id... text... ></node>
      <node id... text... ></node>
</node>

Where nodes attributes are the MySQL table fields (the PK will be the
attribute).
I know there are a lot of good tools to do this in pyhton (some maybe
is already shipped with pyton itself), but since I need a lot of
flexibility for the future I'd like to use an Object relational mapper
like SQLAlchemy or SQLObject todo the job. When I say flexibility, I
have in mind a solution to have multiple formats coming outside of the
ORM:
json, csv, plain text etc...
Am I wrong?
Can someone advice something?




More information about the Python-list mailing list