summaryrefslogtreecommitdiffstats
path: root/Doc/includes/sqlite3/collation_reverse.py
diff options
context:
space:
mode:
Diffstat (limited to 'Doc/includes/sqlite3/collation_reverse.py')
-rw-r--r--Doc/includes/sqlite3/collation_reverse.py9
1 files changed, 2 insertions, 7 deletions
diff --git a/Doc/includes/sqlite3/collation_reverse.py b/Doc/includes/sqlite3/collation_reverse.py
index 3504a35..e956402 100644
--- a/Doc/includes/sqlite3/collation_reverse.py
+++ b/Doc/includes/sqlite3/collation_reverse.py
@@ -1,12 +1,7 @@
import sqlite3
def collate_reverse(string1, string2):
- if string1 == string2:
- return 0
- elif string1 < string2:
- return 1
- else:
- return -1
+ return -cmp(string1, string2)
con = sqlite3.connect(":memory:")
con.create_collation("reverse", collate_reverse)
@@ -16,5 +11,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()