[sqlalchemy] Process guide - XML

2013-10-31 Thread Sayth Renshaw
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

Re: [sqlalchemy] Process guide - XML

2013-10-31 Thread Simon King
On Thu, Oct 31, 2013 at 11:20 AM, Sayth Renshaw flebber.c...@gmail.com wrote: 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

Re: [sqlalchemy] Process guide - XML

2013-10-31 Thread Sayth Renshaw
On Thursday, October 31, 2013, Simon King wrote: On Thu, Oct 31, 2013 at 11:20 AM, Sayth Renshaw wrote: 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

Re: [sqlalchemy] Process guide - XML

2013-10-31 Thread Burak Arslan
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

[sqlalchemy] SQLAlchemy Many-to-many table with multiple foreign key entries

2013-10-31 Thread thinkwelldesigns
http://stackoverflow.com/questions/19716518/sqlalchemy-many-to-many-table-with-multiple-foreign-key-entires# I'm new with sqlalchemy and I want to do this as simply as possible, yet correctly. I want to track domain use across multiple companies on a monthly basis, so I set up the

Re: [sqlalchemy] SQLAlchemy Many-to-many table with multiple foreign key entries

2013-10-31 Thread Michael Bayer
I don’t see a primary key on your monthlyusage table, which is where the issue is occurring, so it depends on which col is the PK. typically the pk would be a composite of the company_id and domain_id columns. On Oct 31, 2013, at 10:20 PM, thinkwelldesi...@gmail.com wrote: I'm new with