[sqlalchemy] Re: set_shard problems

2008-11-28 Thread Ids
Excellent work! Indeed r5335 did fix the problem. Thank you very much for your help. Regards, Ids --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: Invalid Request Error at session level.

2008-11-28 Thread Michael Bayer
On Nov 28, 2008, at 1:42 AM, Harish Vishwanath wrote: I am guarding my commits with a mutex, if you are using one session per thread then there is no need to use mutexing. but the queries are unguarded. if you are using a single Query object in multiple threads simultaneously, that

[sqlalchemy] offline metadata configuration, change storage and metadata snapshot.

2008-11-28 Thread [EMAIL PROTECTED]
Hi All I'm writing a program for graphically configuring database schemas. To do this, I want to use the sqlalchemy schema.py objects to store my metadata as its changed and modified. To do this, I think i will need three things. 1. Apply the meta data changes to a development database, As this

[sqlalchemy] Re: offline metadata configuration, change storage and metadata snapshot.

2008-11-28 Thread Michael Bayer
On Nov 28, 2008, at 6:58 AM, [EMAIL PROTECTED] wrote: Hi All I'm writing a program for graphically configuring database schemas. To do this, I want to use the sqlalchemy schema.py objects to store my metadata as its changed and modified. To do this, I think i will need three things. 1.

[sqlalchemy] Re: offline metadata configuration, change storage and metadata snapshot.

2008-11-28 Thread [EMAIL PROTECTED]
Thanks. I thought of using pickle but it says not everything can be picked, So i was concerned the metadata objects might be in the unlucky group. The other problem i have with pickle is what happens when i upgrade to a newer version of sqlAlchemy some of the metadata objects might change. How

[sqlalchemy] New instance ExtraStat with identity key (...) conflicts with persistent instance ExtraStat

2008-11-28 Thread Doug Farrell
Hi all, I'm having a problem with a new instance of a relation conflicting with an existing instance. I'm using SA 0.5rc with Sqlite3. Here are my simplified classes: class Stat(sqladb.Base): __tablename__ = stats name = Column(String(32), primary_key=True) total=

[sqlalchemy] Re: New instance ExtraStat with identity key (...) conflicts with persistent instance ExtraStat

2008-11-28 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farrell Sent: 28 November 2008 18:22 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] New instance ExtraStat with identity key (...) conflicts with persistent instance ExtraStat

[sqlalchemy] query.with_polymorphic()

2008-11-28 Thread az
what should query.with_polymorphic generate? e.g. given query(A).with_polymorphic( B,D) it does something like select ... from A left outer join B left outer join D and no discriminator filter.. which includes all A's regardless of their type... svil

[sqlalchemy] Re: query.with_polymorphic()

2008-11-28 Thread Michael Bayer
with_polymorphic doesn't limit what classes are loaded. It only controls how the SQL is rendered such that fewer subsequent queries are needed when attributes are referenced on the resulting objects, and also so that you can specify filtering criterion on those joined tables. On Nov 28,

[sqlalchemy] Re: New instance ExtraStat with identity key (...) conflicts with persistent instance ExtraStat

2008-11-28 Thread [EMAIL PROTECTED]
What was your justification of changing the name of my thread to a completely different topic instead of starting a new thread? I don't think thats good etiquette. On Nov 29, 5:22 am, Doug Farrell [EMAIL PROTECTED] wrote: Hi all, I'm having a problem with a new instance of a relation

[sqlalchemy] Re: New instance ExtraStat with identity key (...) conflicts with persistent instance ExtraStat

2008-11-28 Thread [EMAIL PROTECTED]
What was your justification of changing the name of my thread to a completely different topic instead of starting a new thread? I don't think thats good etiquette. On Nov 29, 5:22 am, Doug Farrell [EMAIL PROTECTED] wrote: Hi all, I'm having a problem with a new instance of a relation