Michael,
On Mar 25, 3:00 pm, Michael Bayer mike...@zzzcomputing.com wrote:
SQLAlchemy also doesn't issue BEGIN. You might want to look at setting
autocommit to false on your MySQLdb connection, since that's the layer that
would be sending out BEGIN.
I looked into this. BTW, I use
Michael,
I apologize if I came off at all rude. I noticed how helpful you are
and I value your advice. Thank you for your patience.
On Mar 26, 1:21 pm, Michael Bayer mike...@zzzcomputing.com wrote:
It's not wasteful at all in the usual case unless one wants to have leftover
row/table locks
Hi. I use declarative orm with session. With my current
configuration, SQLAlchemy refreshes more often than I'd like. In
other words, when I look at the echo log, I see more SELECT statements
than I'd like. It issues a SELECT when I read an attribute, but I
don't want it to do that. What is
Michael
On Mar 25, 12:33 pm, Michael Bayer mike...@zzzcomputing.com wrote:
nothing ever refreshes automatically. only things that have been
expired, or were never loaded in the first place, are loaded when requested.
Good to know.
to reduce expirations,
2010-03-25 13:19:02,049 INFO sqlalchemy.engine.base.Engine.0x...f054 BEGIN
2010-03-25 13:19:02,049 INFO sqlalchemy.engine.base.Engine.0x...f054 UPDATE
xxx SET yyy=now() WHERE xxx.z = %s AND xxx.a = %s
2010-03-25 13:19:02,049 INFO sqlalchemy.engine.base.Engine.0x...f054 [193302,
Michael
On Mar 25, 1:27 pm, keith cascio keithautoma...@gmail.com wrote:
However, now that I did, things are more complicated, and SQLAlchemy 0.5
complains.
2010-03-25 13:19:02,049 INFO sqlalchemy.engine.base.Engine.0x...f054 BEGIN
2010-03-25 13:19:02,049 INFO sqlalchemy.engine.base.Engine
Michael
On Mar 25, 1:50 pm, Michael Bayer mike...@zzzcomputing.com wrote:
SQLA uses the DBAPI in its default mode of autocommit=False and is always
going to issue flushes followed by a COMMIT or ROLLBACK. There's also a
ROLLBACK which occurs automatically via the connection pool and you
Let's say I have an sqlalchemy.Table object t (bound to MetaData bound
to an engine with an open connection) with a composite primary key
defined (so t.primary_key() returns an object of type
PrimaryKeyConstraint), and I also have a tuple that represents a
specific value of that primary key. What