not really reading this thread since it isn't too SQLA specific but if you're parsing XML, unless you have unusual memory/performance requirements you just use lxml with etree to set up a DOM, and that's it.
On May 15, 2014, at 5:33 PM, Sayth Renshaw <[email protected]> wrote: > Is there an advantage to using xslt compared to converting it to something > like json? > > Sayth > > On 16/05/2014 3:37 am, "AM" <[email protected]> wrote: > On 05/14/2014 04:23 AM, Sayth Renshaw wrote: > 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 [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > The last time I had to domething like this, I converted all xml attributes to > tags using an XSLT sheet and then used lxml to populate a sqla object. > > You can also do it manually as in the link but use lxml etree which might > make the code a bit easier to read. IMO sax is a bit more performant than > etree but can get a bit confusing. > > HTH > AM > > -- > You received this message because you are subscribed to a topic in the Google > Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/zpjw1nOkRWg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
