write sql results to XML using python

Question

using SQL server 2005+

for over a year now, I've been running a query to return all users from the database for whom i'd like generate a report for. at the end of the query, I've added

for xml auto

The result of this is a link to a file where the xml lives (one row, one column). I then take this file and pass it through some xslt and am left with the final xml that a java program I created nearly two years ago can parse.

What i'd like to do is skip the whole middle part and simply automate this all with python. Run the query, put the results into xml format and then either use the xslt or simply format the xml that's returned into the format that I need for the application.

I've searched far and wide on the internet but I'm afraid I'm not sure enough of the technologies available to find just what I'm looking for.

Any help in directing me to an answer would be greatly appreciated.

I don't understand the purpose of this. If what you have works, then why change it? — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Nov 10, 2010 at 18:48
what i have works, but i'd like to AUTOMATE what I have. each of the steps i enumerate above is done manually. — Ramy
– Ramy, Commented Nov 10, 2010 at 18:52

Ignacio Vazquez-Abrams · Accepted Answer · 2010-11-10 18:56:56Z

2

PyODBC to talk to MS SQL Server, libxml2 to handle the XSLT, and subprocess to run your Java program.

answered Nov 10, 2010 at 18:56

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ramy Over a year ago

will give this a shot shortly. Thanks for all your help today Ignacio.

Collectives™ on Stack Overflow

write sql results to XML using python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related