diff options
Diffstat (limited to 'Doc/lib/sqlite3/collation_reverse.py')
-rw-r--r-- | Doc/lib/sqlite3/collation_reverse.py | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/Doc/lib/sqlite3/collation_reverse.py b/Doc/lib/sqlite3/collation_reverse.py index 107f49d..e956402 100644 --- a/Doc/lib/sqlite3/collation_reverse.py +++ b/Doc/lib/sqlite3/collation_reverse.py @@ -1,15 +1,15 @@ -import sqlite3
-
-def collate_reverse(string1, string2):
- return -cmp(string1, string2)
-
-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()
+import sqlite3 + +def collate_reverse(string1, string2): + return -cmp(string1, string2) + +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() |