[sqlalchemy] Re: Two foreignkey's to the same table, rendering a join error.

2008-10-05 Thread Michael Bayer
you can use strings with Python in them when you use declarative even with args like primaryjoin, so you could say things like: class Policy(DeclarativeBase): __tablename__ = 'policy' policy_state =

[sqlalchemy] Re: ambiguous order_by column error

2008-10-05 Thread Michael Bayer
On Oct 3, 6:05 pm, Brett [EMAIL PROTECTED] wrote: The following code give an error about an ambiguous column on the order_by.  This can easily be fixed by changing the order by column to 'anything.code' but I would assume that since the query will return objects of type Anything then it

[sqlalchemy] Re: Attribute extension in 0.5rc1

2008-10-05 Thread Michael Bayer
That's more of a function specific to your application. SQLA's attribute events are specifically so you can squeeze in the middle of its own instrumentation. On Oct 3, 6:09 pm, Brett [EMAIL PROTECTED] wrote: I was trying to send events to listeners when attributes changed on my model.  It

[sqlalchemy] Consideration using data model with Sqlalchemy

2008-10-05 Thread Krishgy
Hi All, We are using sqlalchemy with Pylons project. Currently, pylons controllers are directly using the sqlalchemy for handling the request. Due to our bad query handling approach, contents and algorithm computation, our application works very slow even for single user :-(. I can use the