[sqlalchemy] Re: Query using a join with an AND rule

2008-11-14 Thread joelanman
Got it - the whole thing needs to be in a tuple: query.join((aliased, and_(aliased.object_id == Object.id, aliased.name == 'test'))) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this

[sqlalchemy] klas.some2many_rel == obj ?

2008-11-14 Thread az
isn't it going to be usable if klas.some2many_relation == obj is automaticaly rendered as klas.some2many_relation.contains( obj) ? unless the == in that case has some other meaning... i'm using some query-building-functions over mixture of plain references and many2many and switching

[sqlalchemy] Re: Using deferred with declarative

2008-11-14 Thread Allen Bierbaum
Does anyone have any ideas on this? Does declarative simply not support the deferred property? -Allen On Sat, Nov 8, 2008 at 11:32 AM, Allen Bierbaum [EMAIL PROTECTED] wrote: We have been using the declarative successfully in our codebase for a couple months now with 0.4.x, but we have just

[sqlalchemy] Re: klas.some2many_rel == obj ?

2008-11-14 Thread Michael Bayer
On Nov 14, 2008, at 11:22 AM, [EMAIL PROTECTED] wrote: isn't it going to be usable if klas.some2many_relation == obj is automaticaly rendered as klas.some2many_relation.contains( obj) ? unless the == in that case has some other meaning... we took that case out, its behavior was

[sqlalchemy] Re: Using deferred with declarative

2008-11-14 Thread Michael Bayer
I replied to this - simply use: class MyClass(Base): myattribute = deferred(Column(String(50)) On Nov 14, 2008, at 11:39 AM, Allen Bierbaum wrote: Does anyone have any ideas on this? Does declarative simply not support the deferred property? -Allen On Sat, Nov 8, 2008 at 11:32

[sqlalchemy] Re: Using deferred with declarative

2008-11-14 Thread Allen Bierbaum
Nope. Very strange. It didn't come through to my gmail account. Oh well, thanks for the pointer. -Allen On Fri, Nov 14, 2008 at 10:55 AM, King Simon-NFHD78 [EMAIL PROTECTED] wrote: -Original Message- From: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Allen

[sqlalchemy] Re: Using deferred with declarative

2008-11-14 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Allen Bierbaum Sent: 14 November 2008 16:40 To: sqlalchemy Subject: [sqlalchemy] Re: Using deferred with declarative Does anyone have any ideas on this? Does declarative simply not

[sqlalchemy] Re: klas.some2many_rel == obj ?

2008-11-14 Thread az
On Friday 14 November 2008 19:00:30 Michael Bayer wrote: On Nov 14, 2008, at 11:22 AM, [EMAIL PROTECTED] wrote: isn't it going to be usable if klas.some2many_relation == obj is automaticaly rendered as klas.some2many_relation.contains( obj) ? unless the == in that case has some other

[sqlalchemy] SQLAlchemy 0.5rc4 Released

2008-11-14 Thread Michael Bayer
0.5rc4 is out, I wanted to get it out quickly since people were hitting a garbage-collection bug that was introduced in 0.5rc3. I'm using rc4 on a production site right now so I'm pretty confident that it's quite solid and hopefully I won't start changing more things before an 0.5.0

[sqlalchemy] Problem in Code

2008-11-14 Thread Ash
Hello, I am using sqlalchemy version 0.4.6 While running i am gettng the error Code : engine = sqlalchemy.create_engine(postgres://[EMAIL PROTECTED]:5432/ aaa,echo=True) metadata = sqlalchemy.MetaData(engine) table_a1=sqlalchemy.Table('table_a1', metadata, autoload=True) I am getting error in

[sqlalchemy] Re: Problem in Code

2008-11-14 Thread Ash
Sorry i got the error and now its working On Nov 15, 11:10 am, Ash [EMAIL PROTECTED] wrote: Hello, I am using sqlalchemy version 0.4.6 While running i am gettng the error Code : engine = sqlalchemy.create_engine(postgres://[EMAIL PROTECTED]:5432/ aaa,echo=True) metadata =