Hi Looking for some guidance and advice on using xml as an update source for my to be data web project. If I am consistently going to be updating data into the database from XML files what is a good method?
Should I be creating a Sax parser as in this example http://iamtgc.com/importing-xml-into-a-database-with-python-and-sqlalchemy/ . To be clear the XML I am importing from is not basic, using from that example my xml would like more like. So i would need to filter the values out that I want which I have acheived using xmltodict. <!-- books.xml --> <catalog> <book isbn="1-880985-26-8" binding="paperback" ebook="mobi" altformat="pdf" etc="ManyMore"> <title>The Consumer</title> <author>M. Gira</author> </book> <book isbn="0-679775-43-9" binding="paperback" ebook="mobi" altformat="pdf" etc="ManyMore"> <title>The Wind-Up Bird Chronicle</title> <author>Haruki Murakami</author> </book> <!-- imagine more entries here... --> </catalog> Copies are available here http://old.racingnsw.com.au/Site/_content/racebooks/20140515GOSF0.xml Or should I be attempting to filter and convert the XML to json format and import into SQLAlchemy. Or other, searching around I cannot, strangely find one and only one way to do it. It seems to be a mish mosh of good luck, well from perspective of someone looking to implement this for the first time. Probably painfully obvious to those who have done it before. Anyway thank you for your time. Sayth -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.