Hi all.
I just stumbled across an after_attach event handler in my code. That
handler used to replace a None reference with a persistent instance that
was already loaded.
After a few changes, it ended up doing a query to load that instance. It
seems this messes up the session state, which caused a query to change
from
INSERT INTO group_items (group_id, item_id, item_order) VALUES (?, ?, ?)
(242, 244, 0)
into the less usefull
INSERT INTO group_items (group_id, item_id, item_order) VALUES (?, ?, ?)
(None, None, None)
Both the group and the item where created correctly so I ended up with a
database which has all the data, just missing their relationships ;-)
I reverted to running the query when first connecting to the database.
What I would like to know: Is it officially impossible to run queries
from session events? What session functionality is usable from within
session events? (I know that session.{dirty, new, deleted} works fine).
Thanks and happy holidays,
Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:[email protected]
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
--
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.
