diff options
Diffstat (limited to 'Doc/includes/sqlite3/collation_reverse.py')
| -rw-r--r-- | Doc/includes/sqlite3/collation_reverse.py | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/Doc/includes/sqlite3/collation_reverse.py b/Doc/includes/sqlite3/collation_reverse.py index e956402..3504a35 100644 --- a/Doc/includes/sqlite3/collation_reverse.py +++ b/Doc/includes/sqlite3/collation_reverse.py @@ -1,7 +1,12 @@ import sqlite3 def collate_reverse(string1, string2): - return -cmp(string1, string2) + if string1 == string2: + return 0 + elif string1 < string2: + return 1 + else: + return -1 con = sqlite3.connect(":memory:") con.create_collation("reverse", collate_reverse) @@ -11,5 +16,5 @@ cur.execute("create table test(x)") cur.executemany("insert into test(x) values (?)", [("a",), ("b",)]) cur.execute("select x from test order by x collate reverse") for row in cur: - print row + print(row) con.close() |