[sqlalchemy] Dumping select data to SQL with relationships

2009-06-30 Thread Arthur Pemberton
Good day, I'd like to know if there is a quick way to do the following: 1) reflect an existing database (I know SA does this well) 2) SELECT a few entries of a main table Foo, preserving all relationships 3) generate INSERT statements to create the selected Foo entries and their relationships

[sqlalchemy] Re: Any one tried to use SqlAlchemy with XML RPC?

2009-03-19 Thread Arthur Pemberton
2009/3/19 Andreas Jung li...@zopyx.com: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19.03.2009 6:49 Uhr, Arthur Pemberton wrote: SQLAlchemy needs a concept of Data Transfer Objects so that it can be easily transmitted and reconstituted as necessary and everyone doesn't have

[sqlalchemy] Re: Any one tried to use SqlAlchemy with XML RPC?

2009-03-19 Thread Arthur Pemberton
On Thu, Mar 19, 2009 at 2:34 AM, Andreas Jung li...@zopyx.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19.03.2009 8:32 Uhr, Arthur Pemberton wrote: 2009/3/19 Andreas Jung li...@zopyx.com: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19.03.2009 6:49 Uhr, Arthur

[sqlalchemy] Transparent Web Service with SqlAlchmey?

2008-12-24 Thread Arthur Pemberton
My googling hasn't yet been fruitful Are there any existing solutions which would essentially allow me to build a web service which can be consumed by a 'client side' python app which would serve SqlAlchmey models transparently such that data would be be retrieved from the web service end,

[sqlalchemy] Best way to populate with data?

2008-09-29 Thread Arthur Pemberton
What is the best way to populate an app with data, for base data and test data purposes? Is there an easy way to maintain some XML files with the base and tests data? or is it the best way to just have a python script with the data hard coded into it? -- Fedora 9 : sulphur is good for the skin

[sqlalchemy] DTOs and RPC

2008-08-27 Thread Arthur Pemberton
I am looking into what are the best practices, common methods of doing things like RPC with SqlAlchemy declarative_base sublcasses. Is there a concept of DTO? Or is this something I would have to build into it myself? Thank you. -- Fedora 7 : sipping some of that moonshine ( www.pembo13.com )