Dear sqlalchemy users, I'm pretty new to sqlalchemy and I've run into a
problem that I cant seem to figure out. Here is what I cant to do, I
have a table, wiith xml data in it. What I want to do is try and look
up an entry in the table, and if I don't find it, add a new entry into
the database with the default xml data in it. I thought I could do it
this way:
uin = dbsession.query(model.Wsi).get_by(uin=image)
if uin:
xml = uin.xml
else:
uin=model.Wsi()
uin.uin=image
xml = '<ZAS></ZAS>'
uin.xml = xml
dbsession.flush()
dbsession.save(uin)
however when I do this I get an error saying the Wsi is already
associated with an other session (InvalidRequestError: Object
'<wsi.models.Wsi object at 0x016DE950>' is already attached to session
'23980720' (this is '23998864')). I believe its the session that was
created with the first query, but I'm not sure how to recover that
session to use it rather then the one that I must be creating. Any and
all help would be great
Jose
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
