I was just having a problem with a one-to-many relationship array coming out in
the wrong order. Looking
here<http://www.sqlalchemy.org/docs/orm/relationships.html#relationships-api>,
It wasn't too hard to figure out that I needed to do:
myFoos = relationship(Foo, order_by = Foo.id)
I was a little surprised though that this isn't the default behaviour. Going by
the results that I was getting before I fixed the problem, it looked like the
default was in order from least to most recently modified.
So I'd like to suggest that the default beahviour be to order the array by id,
when there is one.
I realise that this wouldn't be as simple as adding a default parameter value
to relationship.__init__(), as it would have to be something like order_by =
eval(argument).id, and Python won't let you make a default parameter value
based on a previous parameter (I just tried it- def Foo(bar = 1, baz =
bar):pass raises a name error for bar).
That said, I'm sure it would be doable. I think it would be a good improvement,
although if it's going to be harder than I realise, it might not be worth it,
given that it's so easy to just do it yourself manually.
cheers,
Cam.
Cameron Jackson
Engineering Intern
Air Operations
Thales Australia
Thales Australia Centre, WTC Northbank Wharf, Concourse Level,
Siddeley Street, Melbourne, VIC 3005, Australia
Tel: +61 3 8630 4591
[email protected]<mailto:[email protected]> |
www.thalesgroup.com.au<http://www.thalesgroup.com.au>
-------------------------------------------------------------------------
DISCLAIMER: This e-mail transmission and any documents, files and
previous e-mail messages attached to it are private and confidential.
They may contain proprietary or copyright material or information that
is subject to legal professional privilege. They are for the use of
the intended recipient only. Any unauthorised viewing, use, disclosure,
copying, alteration, storage or distribution of, or reliance on, this
message is strictly prohibited. No part may be reproduced, adapted or
transmitted without the written permission of the owner. If you have
received this transmission in error, or are not an authorised recipient,
please immediately notify the sender by return email, delete this
message and all copies from your e-mail system, and destroy any printed
copies. Receipt by anyone other than the intended recipient should not
be deemed a waiver of any privilege or protection. Thales Australia
does not warrant or represent that this e-mail or any documents, files
and previous e-mail messages attached are error or virus free.
-------------------------------------------------------------------------
--
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.
