Thank You as well Burak. I have read the suggestions offered and it's my lack of knowledge preventing me from knowing which way to proceed.
The XML file that I will(legally) download contains data. This would fit if manually entered into 5 related tables, There would then be addition info updated or added to this data by the user into these tables and a 6th table. I am starting from scratch as my last solution was not manageable and I can do better with Python I feel. To reduce manually inputting I found the XML file and had thought updating the data XML file 2 twice a week into the database to add new data to the database would reduce that. Then later add/edit/view data via a flask, pylons, django site (undecided on that tech yet). Which way fits this way of thinking, what should I be reading and experimenting with? XML persistence? Is it even a valid process design to do? Would SLAlchemy excel at this? Sayth On Fri, Nov 1, 2013 at 10:39 AM, <sqlalchemy@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/sqlalchemy/topics > > - Process guide - XML <#14210e2bc93093a0_group_thread_0> [4 Updates] > > Process guide - > XML<http://groups.google.com/group/sqlalchemy/t/6e03217a60551470> > > Sayth Renshaw <flebber.c...@gmail.com> Oct 31 04:20AM -0700 > > Hi > > Looking for some guidance using SQLAlchemy. In particular using > SQLAlchemy > to parse an XML file to the database. > > I have read the docs in SQLAlchemy on creating database and classes > and > tables and then started reading > http://docs.sqlalchemy.org/en/rel_0_9/orm/index.html?highlight=xml > However i want to understand the end process of importing the XML in > and > considerations and restrictions of this. Finding a lot of my search > results > are returning 'persisting xml' tutorials and examples, or very basic > examples of typed in database entries (album, artist examples etc) > > Can anyone help advise how I would go about this? Any tutorials or > information appreciated. Have read tutorials on lxml and elementree as > well > but again I don't understand if SQLAlchemy needs me to parse via this > first > if so what is important to understand, or has SQLA another mechanism > for > handinling importing XML nodes to classes? > > Thank you > > Sayth > > > > > Simon King <si...@simonking.org.uk> Oct 31 12:35PM > > > handinling importing XML nodes to classes? > > > Thank you > > > Sayth > > SQLAlchemy itself doesn't really have any relationship at all with > XML, but in the source distribution, there are some examples of how > you might import data from an XML file into a database. See: > > http://docs.sqlalchemy.org/en/latest/orm/examples.html#xml-persistence > > and > > > > https://bitbucket.org/zzzeek/sqlalchemy/src/eee219bc7e0656fb8afa9879bda799ab1d71b285/examples/elementtree?at=master > > Which approach you follow really depends on how you are going to be > working with the data. > > Hope that helps, > > Simon > > > > > Sayth Renshaw <flebber.c...@gmail.com> Nov 01 07:17AM +1100 > > On Thursday, October 31, 2013, Simon King wrote: > > > > Simon > > > -- > > > Thanks Simon will have a look at these after work, I appreciate you > taking > the time to respond. > > Sayth > > > > > Burak Arslan <burak.ars...@arskom.com.tr> Oct 31 10:44PM +0200 > > On 10/31/13 13:20, Sayth Renshaw wrote: > > Hi > > > Looking for some guidance using SQLAlchemy. In particular using > > SQLAlchemy to parse an XML file to the database. > > Do you want to map an xml schema to a database schema, or you just are > looking for advice on how to put the xml blob on a database? > > If the former, http://spyne.io/#s=sql&ser=Xml&show=Schema and > > > http://spyne.io/docs/2.10/reference/util.html#spyne.util.xml.get_xml_as_object > could help you get started. > > This way, you can persist an xml document efficiently in a relational > database (numbers go to an int column, etc.) > > For the latter, Spyne has a PGXml type that saves an lxml.etree.Element > instance to the xml column in a postgres database. > > https://github.com/arskom/spyne/blob/2_10/spyne/util/sqlalchemy.py#L196 > > Hope it helps. > > Best, > Burak > > > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
