I use SqlAlchemy in a Pyramid app. All my models, connections, etc
are within and set up by Pyramid.
I'm trying to do a maintenance script, and am a bit confused.
In my script, thanks to a bootstraped commandline Pyramid feature, i
have a Session which can query objects. great.
results = dbSession.query( model.core.Useraccount )\
.filter(\
model.core.Useraccount.last_login.op("IS")(None)
)\
.all()
here's my problem. i want to do execute a command like this:
stmt = model.core.Useraccount.update()\
.where( model.core.Useraccount.id.in_( list_of_uids ) )\
.values( last_login = 'now()' )
connection.execute(stmt)
I'm not actually updating the last_login field. just using this as an
example.
So here are my questions:
1. can i get the connection out of a scoped session ?
2. i'm getting an error that Useraccount doesn't have an 'update'
method.
i based the example above on this
http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html#correlated-updates
I think this is all based on a portion of SqlAlchemy that my
environment doesn't have access to (in that everything is set up for
scoped sessions, not sql expressions). If so, is there another way to
execute an update query ?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
