set expire_on_commit=False on your sessionmaker.
On May 17, 2010, at 6:20 AM, Julian Scheid wrote:
> Is there a way to avoid the SELECT statement issued by the following
> test case, i.e. to have some_a "survive" the commit?
>
> --- 8< ---
>
> from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
> from sqlalchemy.orm import sessionmaker, relation
> from sqlalchemy.ext.declarative import declarative_base
>
> engine = create_engine("sqlite://", echo=True)
> session = sessionmaker(bind=engine)()
>
> Base = declarative_base()
>
> class A(Base):
> __tablename__ = 'a'
> id = Column(Integer, primary_key=True)
>
> class B(Base):
> __tablename__ = 'b'
> id = Column(Integer, primary_key=True)
> a_id = Column(Integer, ForeignKey('a.id'), nullable = False)
> a = relation(A)
>
> Base.metadata.create_all(bind=engine)
>
> some_a = A()
> session.add(some_a)
> session.commit()
>
> some_b = B(a=some_a)
> session.add(some_b)
> session.commit()
>
> --- >8 ---
>
> # Table creation etc omitted
>
> 2010-05-17 22:12:06,533 INFO sqlalchemy.engine.base.Engine.0x...41d0 BEGIN
> 2010-05-17 22:12:06,534 INFO sqlalchemy.engine.base.Engine.0x...41d0
> INSERT INTO a DEFAULT VALUES
> 2010-05-17 22:12:06,534 INFO sqlalchemy.engine.base.Engine.0x...41d0 []
> 2010-05-17 22:12:06,534 INFO sqlalchemy.engine.base.Engine.0x...41d0 COMMIT
> 2010-05-17 22:12:06,535 INFO sqlalchemy.engine.base.Engine.0x...41d0 BEGIN
> 2010-05-17 22:12:06,536 INFO sqlalchemy.engine.base.Engine.0x...41d0
> SELECT a.id AS a_id
> FROM a
> WHERE a.id = ?
> # <-- I'd like to avoid this
> 2010-05-17 22:12:06,536 INFO sqlalchemy.engine.base.Engine.0x...41d0 [1]
> 2010-05-17 22:12:06,537 INFO sqlalchemy.engine.base.Engine.0x...41d0
> INSERT INTO b (a_id) VALUES (?)
> 2010-05-17 22:12:06,537 INFO sqlalchemy.engine.base.Engine.0x...41d0 [1]
> 2010-05-17 22:12:06,537 INFO sqlalchemy.engine.base.Engine.0x...41d0 COMMIT
>
> --- 8< ---
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
