Uche Ogbuji wrote: > On Tue, 2004-11-02 at 10:21, kumar s wrote: > >>Dear group, >> I apologize for asking a very basic question here and >>also I am afraid if this is not the correct place to >>ask. >> >>I have a database and I am plannig to pump my data in >>the tables into XML files. For the kind of data in my >>database table, there is already a proposed DTD out >>there. >> >>What I should be do in order to convert my existing >>data in tables into XML files. >> >>Do I have to: >>1. Create any parser to convert the data into XML >>structure. >>2. Validate the integrity of XML structure based on >>DTD provided. >> >>I might not have all the data fields supported in the >>DTD in my database. Is it okay if I leave some fields >>as blank. >> >>This e-mail is a jump-start e-mail for me. I program >>in python by never touched XML and I am excited to do >>that. > > > Well, since it sounds as if you'd like to solve your XML processing task > using Python, this probably is the right place. The only problem I can > see with your question is that there is not really enough detail for > anyone to help. Sounds as if you want to export data from a database > (what sort? SQL? Object? Hash table? You say "tables" so I'd guess > SQL). Which DBMS? Does it have XML export capabilities you can just > use without writing your own code? Does the DTD *require* (not just > allow) fields for which the source database has no value? If so, are > there business rules you can apply to set defaults? etc. etc. I could > ask a hundred questions, but it's much better if you just get specific > and tell us what tools you're using, your precise goals, etc. Snippets > of code or data samples will probably get you the best responses. >
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. Thanks. _______________________________________________ XML-SIG maillist - XML-SIG@python.org http://mail.python.org/mailman/listinfo/xml-sig
