obj._sa_instance_state.sort_key?? Will that always be sorted how
get() expects? Is there a more "public" way to get that?
On Mar 19, 1:42 pm, Kent Bower <k...@retailarchitects.com> wrote:
> By the way, must get() always accept a primary key? For composite
> keys is there a shortcut to access its "ident" (in the correct
> order)? (So I could get the ident tuple and pass it to get() with
> populate_existing()....)
>
> On Mar 19, 2010, at 1:12 PM, Michael Bayer <mike...@zzzcomputing.com>
> wrote:
>
>
>
>
>
> > On Mar 19, 2010, at 12:34 PM, Kent wrote:
>
> >> With query() I can add with_lockmode('for update'). Can I do so on a
> >> session.refresh()? What about a get()?
>
> > a get() yes. a refresh() no, but that's a fine idea so I've
> > committed a flag for that in rab5a31b4f3bf. A substitute is
> > query.populate_existing().with_lockmode('for_update').get(object.id).
>
> >> I see this as a useful approach to a two phase large query, where one
> >> wants to avoid locking a large number of rows. First you would issue
> >> a non-locking query and then, once you have a candidate object you
> >> could call refresh with a lock, so you know you have the most recent
> >> data and that it is locked.
>
> >> --
> >> You received this message because you are subscribed to the Google
> >> Groups "sqlalchemy" group.
> >> To post to this group, send email to sqlalch...@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> sqlalchemy+unsubscr...@googlegroups.com
> >> .
> >> For more options, visit this group
> >> athttp://groups.google.com/group/sqlalchemy?hl=en
> >> .
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com
> > .
> > For more options, visit this group
> > athttp://groups.google.com/group/sqlalchemy?hl=en
> > .
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
