Your SQL database will support SQL commands like DESCRIBE TABLE. For MySQL I have used: cursor.execute( 'SHOW COLUMNS FROM %s' % tablename) for row in cursor.fetchall(): fname = row[0] # my live code also saved the type info
to build a dictionary of field names and types for a table to control processing. I presume your XML is supposed to look something like: <tablename> <record> <fieldname1>value_1</fieldname1> <fieldname2>value_2</fieldname2> ... </record><record> ... </tablename> If that description fits what you are trying to do, then you should not have too much difficulty coding up the pieces. This glosses over difficulties with XML character rules in tags and elements, encoding binary data, etc. On Thu, 2005-05-05 at 15:09 -0600, Uche Ogbuji wrote: > 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. > -- Lloyd Kvam Venix Corp _______________________________________________ XML-SIG maillist - XML-SIG@python.org http://mail.python.org/mailman/listinfo/xml-sig