[sqlalchemy] Adding MapperExtensions after Mappers created

2009-03-18 Thread jarrod.ches...@gmail.com
How do i add a MapperExtension to a mapper after the mapper has been created with the mapper() function --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: SELECT statement inside in_

2009-03-18 Thread Glauco
Sanjay ha scritto: I got that the obvious way is just writing the string query, i.e. query.filter(col IN SELECT col FROM some_table) something like this: query.filter( col.in_( select([col],...).correlate(None) )) Glauco --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: Adding MapperExtensions after Mappers created

2009-03-18 Thread Michael Bayer
theres a collection calledextension i believe, which has an append() method (also unsure of that name). jarrod.ches...@gmail.com wrote: How do i add a MapperExtension to a mapper after the mapper has been created with the mapper() function

[sqlalchemy] Re: SELECT statement inside in_

2009-03-18 Thread Michael Bayer
Sanjay wrote: Hi, I want to write something like query.filter(BizObj.col.in_(SELECT col FROM some_table)). Could not find out how to do it. The code on neither the above nor the below worked. query.filter(BizObj.col1.in_(sqlalchemy.sql.text(SELECT col1 FROM sometable))). in_() is

[sqlalchemy] Re: SELECT statement inside in_

2009-03-18 Thread Mike Conley
On Wed, Mar 18, 2009 at 11:00 AM, Michael Bayer mike...@zzzcomputing.comwrote: Sanjay wrote: Hi, I want to write something like query.filter(BizObj.col.in_(SELECT col FROM some_table)). Could not find out how to do it. The code on neither the above nor the below worked.

[sqlalchemy] Re: SELECT statement inside in_

2009-03-18 Thread Michael Bayer
col.in_(select([MyClass.col2])) Mike Conley wrote: On Wed, Mar 18, 2009 at 11:00 AM, Michael Bayer mike...@zzzcomputing.comwrote: Sanjay wrote: Hi, I want to write something like query.filter(BizObj.col.in_(SELECT col FROM some_table)). Could not find out how to do it. The

[sqlalchemy] adding some sql function to several dialects

2009-03-18 Thread che
Hi, i need to add several functions to all dialects that i'll plan to use in order to be fully database-independent. Does anybody have tips how to achieve this? For example i want to add function year( date) to sqlite and postgres dialects. TIA, Stefan

[sqlalchemy] Re: adding some sql function to several dialects

2009-03-18 Thread Michael Bayer
we'll be adding a feature for this soon. here is a non-public way to do it for now which will work throughout 0.5: from sqlalchemy.sql.expression import ClauseElement class year(ClauseElement): __visit_name__ = 'year' def __init__(self, value): self.value = value def

[sqlalchemy] interval tree table

2009-03-18 Thread bard stéphane
is there an easy way to represent an interval tree table in sqlAlchemy Interval Tree is very common way to represent tree. with right, left, level indices, node, leaf (left - right = 1) ? --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Re: interval tree table

2009-03-18 Thread az
On Wednesday 18 March 2009 22:31:37 bard stéphane wrote: is there an easy way to represent an interval tree table in sqlAlchemy Interval Tree is very common way to represent tree. with right, left, level indices, node, leaf (left - right = 1) ? FIY see this thread with various tree

[sqlalchemy] Re: interval tree table

2009-03-18 Thread Michael Bayer
bard stéphane wrote: is there an easy way to represent an interval tree table in sqlAlchemy Interval Tree is very common way to represent tree. with right, left, level indices, node, leaf (left - right = 1) ? there's no restriction using the SQL expression language. The ORM can do it too,

[sqlalchemy] Re: Any one tried to use SqlAlchemy with XML RPC?

2009-03-18 Thread 一首诗
This is my ORM class definition: #= class User(Base): __tablename__ = 'b_taa_user' user_id = Column(Integer, primary_key=True, autoincrement=True, nullable=False) # 用户ID user_name = Column(Unicode(255), unique=True, nullable=False, server_default=) # 用户名称

[sqlalchemy] Re: Any one tried to use SqlAlchemy with XML RPC?

2009-03-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19.03.2009 5:24 Uhr, 一首诗 wrote: This is my ORM class definition: #= class User(Base): __tablename__ = 'b_taa_user' user_id = Column(Integer, primary_key=True, autoincrement=True, nullable=False) # 用户ID

[sqlalchemy] Re: Any one tried to use SqlAlchemy with XML RPC?

2009-03-18 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19.03.2009 6:49 Uhr, Arthur Pemberton wrote: SQLAlchemy needs a concept of Data Transfer Objects so that it can be easily transmitted and reconstituted as necessary and everyone doesn't have to reimplemented the idea themselves. There are