[sqlalchemy] from_obj kwarg in SA 0.4.x

2008-04-12 Thread Acm
In SQLAlchemy 0.3.11 I had a query similar to the following: session.query(User).select(user_def.c.id==1, from_obj=[user_def.join(role_def)]) (where user_def and role_def are instances of Table and User is an object mapped to table user_def) Now I installed SQLAlchemy 0.4.5 and have to modify

[sqlalchemy] Re: simulate sql view from table definition

2008-04-10 Thread Acm
Thank you. However, when the types of user (defined as Table()) and adults (the select object) are different types. I would like the adults variable to be of the same type as user. Is this possible? Thanks On Apr 9, 1:18 pm, Gerhard Häring [EMAIL PROTECTED] wrote: Acm wrote: I am working

[sqlalchemy] simulate sql view from table definition

2008-04-09 Thread Acm
I am working with SQLAlchemy 0.4.5 I have this table definition: table1_def = Table('mytablename', metadata, schema='myschemaname', autoload=True) Now I would like a view on this table such that I only load the records where column1 = 0. I would like to define my view something as

[sqlalchemy] InstrumentedList in SA 0.4.3

2008-03-05 Thread Acm
With SA version 0.3.11 I used to import InstrumentedList as follows: from sqlalchemy.orm.attributes import InstrumentedList Now I upgraded to SA 0.4.3 and cannot import InstrumentedList from the same file. I looked into the SQLAlchemy file attribute.py and noticed that this file uses the

[sqlalchemy] Elixir performance

2007-09-04 Thread Acm
I am trying out Elixir 0.3.0 over SQLAlchemy 0.3.10 in a Python 2.5 environment. Are there any known performance issues with Elixir for CRUD (Create Select Update Delete) commands? Thanks. --~--~-~--~~~---~--~~ You received this message because you are