I've been going batty on this all morning.
I have a "permissions check" routine that repeatedly queries for a certain
Foo2Bar table
class Foo2Bar(Base):
__tablename__ = 'foo_2_bar'
id_foo = Column(Integer, ForeignKey("foo.id"), primary_key=True)
id_bar = Column(Integer, ForeignKey("bar.id"), primary_key=True)
print "Get Foo2Bar() 4x"
print id(s.query(Foo2Bar).get((1,2)))
print id(s.query(Foo2Bar).get((1,2)))
print id(s.query(Foo2Bar).get((1,2)))
print id(s.query(Foo2Bar).get((1,2)))
When I do this on a test harness, it works exactly like it should. It only
hits the database once.
When I do this in my app, it hits the database (postgres) unreliably.
I set up extensive logging and used a bunch of breakpoints with pdb.
The session is the same at every point, there is an object already in the
identity map for the composite key -- but it appears to get overridden each
time.
If i put a `get()` in a loop 40x, it only gets the first one. but every
prior request is pulled from the database.
does anyone have a clue what could cause this behavior?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
