[sqlalchemy] Re: Context based execution

2011-04-01 Thread bool
Thanks Michael. I will try your suggestion. But I would like the date context to be applied while executing and not actually modify the select statement to support the use-case where I have a select statement and would the same select to be executed in different date contexts.

Re: [sqlalchemy] Is this a bug?(about Overriding Reflected Columns)

2011-04-01 Thread Michael Bayer
On Apr 1, 2011, at 1:12 AM, Inside Zhou wrote: Thank you for you answer,but I'm sorry,I don't quite follow you. My confusion is that with the s.query(User).all(),SA issues SQL stmt the same as user_table.select().execute(),but why the latter stmt can return the row what I expected

Re: [sqlalchemy] Re: Context based execution

2011-04-01 Thread Michael Bayer
On Apr 1, 2011, at 2:41 AM, bool wrote: Thanks Michael. I will try your suggestion. But I would like the date context to be applied while executing and not actually modify the select statement to support the use-case where I have a select statement and would the same select to be executed

[sqlalchemy] Re: difficult error from Base.metadata.create_all(engine)

2011-04-01 Thread farcat
Hi Michael, Still stuck, I don't mixin foreign keys or relationships. When is a Column attached to a table in declarative? My code is: import datetime from datatypes import * from accessors import member_accessor, reference_accessor from sqlalchemy import * from sqlalchemy.orm import

[sqlalchemy] BIGINT Warning Message

2011-04-01 Thread rivka
Hi, I have a database where two columns are defined as BigInteger: pNum = Column(BigInteger, primary_key=True, autoincrement=False) pPubDate = Column(BigInteger) When I open the database I get two warnings: /engine/reflection.py:46: SAWarning: Did not recognize type 'BIGINT' of column

Re: [sqlalchemy] Re: difficult error from Base.metadata.create_all(engine)

2011-04-01 Thread Michael Bayer
On Apr 1, 2011, at 2:52 PM, farcat wrote: Hi Michael, Still stuck, I don't mixin foreign keys or relationships. When is a Column attached to a table in declarative? so you have a few things like: class AtomBase(BaseBase): id = Column(Integer, primary_key=True) where AtomBase does

Re: [sqlalchemy] BIGINT Warning Message

2011-04-01 Thread Michael Bayer
On Apr 1, 2011, at 4:47 PM, rivka wrote: Hi, I have a database where two columns are defined as BigInteger: pNum = Column(BigInteger, primary_key=True, autoincrement=False) pPubDate = Column(BigInteger) When I open the database I get two warnings: /engine/reflection.py:46: