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.py20
1 files changed, 0 insertions, 20 deletions
diff --git a/Doc/includes/sqlite3/collation_reverse.py b/Doc/includes/sqlite3/collation_reverse.py
deleted file mode 100644
index 3504a35..0000000
--- a/Doc/includes/sqlite3/collation_reverse.py
+++ /dev/null
@@ -1,20 +0,0 @@
-import sqlite3
-
-def collate_reverse(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)
-
-cur = con.cursor()
-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)
-con.close()