Dear all,
I make a query to find the highest version of a document and then I
want to set a flag to column "actual" to 1 (TRUE) to all entries
satisfying the query. I dont want to loop through hits but to set this
flag "in a one stroke" with update. However I get this error:
sqlalchemy.exc.InvalidRequestError: Could not evaluate current
criteria in Python. Specify 'fetch' or False for the
synchronize_session parameter. (Related to the line with update
function!!). What is the problem or is there any alternative?
Thanks
metadata,session,engine=myf(confile)
mytab = Table(dbname, metadata, autoload=True)
class SomeTable(object):
pass
mapper(SomeTable,mytab).compile()
vquery=session.query(func.max(mytab.columns['version']),mytab.columns['id']).group_by(mytab.columns['id'])
endquery=session.query(mytab).filter(tuple_(mytab.columns['version'],mytab.columns['id']
).in_(vquery))
endquery.update({mytab.columns["actual"]:"1"})
ses.commit()
--
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.
