... or to any other special order.
For me was creazy that I was not able to sort items (names) in IS_IN_DB
lists alphabetically.
IS_IN_DB has lot of undocumented questions but I think nothing can help.
Of course when running from Postgres, you will receive records with proper
locale order.
However with SQLite you need (maybe) a hacked and special compiled SQLite
to have correct order.
Otherwise you start with uppercase ascii, then follow lowercase ascii, and
at the end are accented (non-ascii) characters. Crazy.
Now I use this hack in my model:
import locale
locale.setlocale(locale.LC_ALL, 'cs_CZ.UTF-8')
class IS_IN_DB_(IS_IN_DB):
def build_set(self):
super(IS_IN_DB_, self).build_set()
records = [(lbl, self.theset[pos]) for pos, lbl in enumerate(self.
labels)]
records.sort(key=lambda x: locale.strxfrm(x[0]))
self.labels = [rec[0] for rec in records]
self.theset = [rec[1] for rec in records]
db.define_table('payment',
Field('idauth_user', 'reference auth_user', requires=IS_EMPTY_OR(
IS_IN_DB_(db, db.auth_user.id, '%(nick)s'))),
...)
Not optimal, but works !
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
