[XML-SIG] How to convert my data in database to XML

[Uche Ogbuji]

On Wed, 2005-05-04 at 03:03 -0400, Kun Xi wrote:
> Hello. I have the same question:
> The data is store in Sql database, but the database schema is determined
> in the runtime. I need to generate the xml file without knowing the
> table structure, sound insane? Is there any tool, framework that could
> read the configuration file and serialize the xml file from/to the
> database ?
> 
> I don't need the o/r mapping, I just need a filter between the xml and
> database.

And by "configuration file", I assume you mean SQL DDL.

This is the sort of thing that most DBMS vendors sell as features or
add-ons.  Many OSS projects have such tools as well.  I don't know of
anything general purpose in Python for this.


-- 
Uche Ogbuji                               Fourthought, Inc.
http://uche.ogbuji.net                    http://fourthought.com
http://copia.ogbuji.net                   http://4Suite.org
Use CSS to display XML, part 2 - http://www-128.ibm.com/developerworks/edu/x-dw-x-xmlcss2-i.html
XML Output with 4Suite & Amara - http://www.xml.com/pub/a/2005/04/20/py-xml.html
Use XSLT to prepare XML for import into OpenOffice Calc - http://www.ibm.com/developerworks/xml/library/x-oocalc/
Schema standardization for top-down semantic transparency - http://www-128.ibm.com/developerworks/xml/library/x-think31.html