allow customized sort in model.get_list() and META ordering

[mattimustang@…]

I would like to be able to sort a field by more than just its alpha or numerical ascending/descending order:

eg. With the model:

class A(meta.Model):
    ip = meta.IPAddressField()
    class META: ordering = ['ip']

The list of IP's gets sorted like this:

192.168.1.1
192.168.1.10
192.168.1.11
192.168.1.2
192.168.1.20

rather than how I would like to have it sorted:

192.168.1.1
192.168.1.2
192.168.1.10
192.168.1.11
192.168.1.20

Is it possible to add a model.get_list(order_by=('ip', sort_ip_function)) or as well as some equivalent in META like 'ordering = (('ip', sort_ip_function),)' option to allow some kind of customized sorting to happen?

thanks

matthew

ps. Do Managers in magic-removal address this?

[Luke Plant]

Django does all it's ordering using SQL, so this isn't feasible. You could do extra ordering after retrieving the data, but it wouldn't work as expected: these don't do the same thing:

[get all items] -> [sort by (1 then 2)]

[get all items] -> [sort by 1] -> [sort by 2]

The only way to do this at all would be to use some server side custom sorting function, which would depend on what is available with your choice of database.

[Adrian Holovaty]

Closing for the reason Luke pointed out above.