Thanks everyone for all the help, it seems to be working now that I'm using explicit sessions rather then the threaded one I had been using Jose
Jose Galvez wrote: > 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 > > > ------------------------------------------------------------------------- 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
