Mercurial > cpython-lru_cache-weakref

diff Lib/sqlite3/test/dump.py @ 74892:4b105d328fe7 3.2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix sqlite3.Connection.iterdump on tables/fields with reserved names or quotes Closes #9750
author Petri Lehtinen <petri@digip.org>
date Sun, 12 Feb 2012 21:05:31 +0200
parents 872abed7d069
children 2cdb599172ab
line wrap: on
line diff
--- a/Lib/sqlite3/test/dump.py	Sun Feb 12 19:14:17 2012 +0100
+++ b/Lib/sqlite3/test/dump.py	Sun Feb 12 21:05:31 2012 +0200
@@ -13,6 +13,14 @@
 
     def CheckTableDump(self):
         expected_sqls = [
+                """CREATE TABLE "index"("index" blob);"""
+                ,
+                """INSERT INTO "index" VALUES(X'01');"""
+                ,
+                """CREATE TABLE "quoted""table"("quoted""field" text);"""
+                ,
+                """INSERT INTO "quoted""table" VALUES('quoted''value');"""
+                ,
                 "CREATE TABLE t1(id integer primary key, s1 text, " \
                 "t1_i1 integer not null, i2 integer, unique (s1), " \
                 "constraint t1_idx1 unique (i2));"