Home | History | Annotate | Download | only in sqlite3 
      1 import sqlite3
      2 
      3 def collate_reverse(string1, string2):
      4     if string1 == string2:
      5         return 0
      6     elif string1 < string2:
      7         return 1
      8     else:
      9         return -1
     10 
     11 con = sqlite3.connect(":memory:")
     12 con.create_collation("reverse", collate_reverse)
     13 
     14 cur = con.cursor()
     15 cur.execute("create table test(x)")
     16 cur.executemany("insert into test(x) values (?)", [("a",), ("b",)])
     17 cur.execute("select x from test order by x collate reverse")
     18 for row in cur:
     19     print(row)
     20 con.close()
     21