Hi everybody,
I'm new with SQLAlchemy and I'm trying to understand better the Session
object.
First of all, why the expire_all() exists? Shouldn't it be always better to
expunge_all() instead? If it is expired, at the use of the instance another
query would be issued to reattach it anyway, so why keep "useless" instances
in the identity map (maybe i'm wrong about this fact, i dont know exactly
how the identity map works).
Second, when we should call the close() method? I dont think if i get it at
all. Let's say that I have the following DAO:
PersonDAO:
def insert(self, person):
session = Session()
session.add(person)
session.commit() // why the commit starts a new transaction?
should'n it only start again the next database access?
session.close() // is it necessary?
Is the a Session instance directly associated to a Connection in the pool?
With the default pool size of 5, after 5 call of the insert method, the
connection_overflow would be used? What's the time to a Session "expire"?
And just to finish. Why do we use remove() for the scoped_session instead of
the close()? Shouldn't it be semantically identical only overrided for the
contextual stuff?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
