sqlobject-discuss

[SQLObject] Sort order in MultipleJoin

[deelan <de...@in...>]

hi there,

am i the only one having such basic requests, browsing the docs
and found something related try stuff and achieve nothing?

to recap: today i managed to get things work as expected with webware,
cheetah and sqlobject. remember my little Person/PhoneNumber example 
used in a previos messages of mine? it was a simple MultipleJoin test.
i instantiated a Person obj with:

p = Person(1) #look up personId = 1 in db
p.phoneNumbers #grab a list of PhoneNumber obj for person

with this code i was able to grab such list and format an HTML table 
with cheetah,  so far so good, but i was wondering, the result 
phonenumber list is unordered. is there a way to specifiy an order of 
such list? i've seen
a _defaultOrder in the manual but seems related to Person.q or 
Person.select. i've tried to specify a _defaultOrder in PhoneNumber with:

class PhoneNumber(SQLObject):
     """Phone number"""

     _defaultOrder = "PhoneType"

     ...

where PhoneType is a mysql enum column. i've done that to group result 
by phone type (mobile, home, office) but i didn't get any visible 
results. any hint? i would like to be able to grab a list of numbers via 
the "phoneNumbers" attribute, since the syntax is very clear and most of 
the time it would be enough.

thanks in advance

later,
deelan

Re: [SQLObject] Sort order in MultipleJoin

[Ian B. <ia...@co...>]

On Tue, 2003-05-13 at 14:52, deelan wrote:
> with this code i was able to grab such list and format an HTML table 
> with cheetah,  so far so good, but i was wondering, the result 
> phonenumber list is unordered. is there a way to specifiy an order of 
> such list? i've seen
> a _defaultOrder in the manual but seems related to Person.q or 
> Person.select. i've tried to specify a _defaultOrder in PhoneNumber with:

No, ordering doesn't apply to joins.  It would be nice if it did, I just
haven't done that.

  Ian

Re: [SQLObject] Sort order in MultipleJoin

[Luke O. <lu...@me...>]

> so far so good, but i was wondering, the result
> phonenumber list is unordered. is there a way to specifiy an order
> of such list? i've seen
> a _defaultOrder in the manual but seems related to Person.q or
> Person.select. i've tried to specify a _defaultOrder in PhoneNumber
> with:
>
> class PhoneNumber(SQLObject):
>      """Phone number"""
>
>      _defaultOrder = "PhoneType"
>

Yes, I highly support this modification. I've suggested it a time or
two, but we've been holding back to determine whether it's worthwhile
to use database-side ORDER BY (which requires a somewhat noticeable
change to the join SQL). For a while now, we've been using
python-side sorts without noticeable issues.

at the end of each performJoin function, replace:

  return [cls(id) for (id,) in ids]

with:

  objs = [cls(id) for (id,) in ids]
  if cls._defaultOrder:
    order = cls._defaultOrder
    objs.sort(lambda x,y: cmp(getattr(x, order), getattr(y, order)))
  return objs

Ugh, but functional.