[sqlalchemy] Accessing several databases

Hello, I'm intending to use sqalchemy with orm for loading and storing my application's project files. Each sqlite database would be a project file, that will have several tables. I'd like to work with projects like this: project1=AppProject(/tmp/pr1.sqlite);

RE: [sqlalchemy] Accessing several databases

-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Julian J. M. Sent: 16 June 2011 11:43 To: sqlalchemy Subject: [sqlalchemy] Accessing several databases Hello, I'm intending to use sqalchemy with orm for loading and storing

RE: [sqlalchemy] mapping a class linked with two other classes (AttributeError: 'str' object has no attribute '_sa_instance_state')

-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Jules Stevenson Sent: 16 June 2011 08:44 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] mapping a class linked with two other classes (AttributeError: 'str' object has no

Re: [sqlalchemy] Accessing several databases

Thank you very much. I'll try that. I was confused by this howto: http://turbogears.org/2.1/docs/main/MultipleDatabases.html They call declarative_base() for each each database... I thought I needed that for each AppProject instance... Anyway, thanks agaon for the example. I'll let you know.

Re: [sqlalchemy] mapping a class linked with two other classes (AttributeError: 'str' object has no attribute '_sa_instance_state')

Hi Simon, thank you very much for your help (again!), and yes, that's how I'm using the mapping :). I'm now getting an SQL error, I think because the user is not being pulled automatically through when trying to add the ArkUserContactGUID: OperationalError: (OperationalError) (1364, Field

Re: [sqlalchemy] mapping a class linked with two other classes (AttributeError: 'str' object has no attribute '_sa_instance_state')

Ack, ignore :). There was no direct relationship to the user at all, doh. So I'm passing that into the ArkUserContactGUID construction, and all works well. Thanks again for the help, much appreciated. Jules -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] Accessing several databases

ah good to know, I'm always wondering why people get confused about things like this... On Jun 16, 2011, at 9:33 AM, Julian J. M. wrote: Thank you very much. I'll try that. I was confused by this howto: http://turbogears.org/2.1/docs/main/MultipleDatabases.html They call

[sqlalchemy] Versioning and multi-level inheritance

Hello, I'm trying to use the versioning recipe describe on the website along with a multi-level inheritance model (Joined-Table inheritance) Here are my declarative statements: [code] class Sample(Base): __metaclass__ = VersionedMeta __tablename__ = 'sample' __table_args__ =

Re: [sqlalchemy] Versioning and multi-level inheritance

apply this patch to history_meta.py diff -r 7c65c0cdd3c8 examples/versioning/history_meta.py --- a/examples/versioning/history_meta.py Tue Jun 14 19:57:21 2011 -0400 +++ b/examples/versioning/history_meta.py Thu Jun 16 12:04:43 2011 -0400 @@ -35,7 +35,7 @@ col.unique =