Is there an advantage to using xslt compared to converting it to something like json?
Sayth On 16/05/2014 3:37 am, "AM" <ams....@gmail.com> 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 sqlalchemy+unsubscr...@googlegroups.com <mailto:sqlalchemy+ >> unsubscr...@googlegroups.com>. >> To post to this group, send email to sqlalchemy@googlegroups.com <mailto: >> sqlalchemy@googlegroups.com>. >> 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 > 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. > -- 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.