Gecko [ beriskala.com ]

Name	Size	Permission	Date
__init__.py	0 B	-rw-r--r--	2024-04-10 08:28
__init__.pyc	132 B	-rw-r--r--	2024-04-10 08:28
__init__.pyo	132 B	-rw-r--r--	2024-04-10 08:28
dbapi.py	29.64 KB	-rw-r--r--	2024-04-10 08:28
dbapi.pyc	41.27 KB	-rw-r--r--	2024-04-10 08:28
dbapi.pyo	41.23 KB	-rw-r--r--	2024-04-10 08:28
dump.py	2.86 KB	-rw-r--r--	2024-04-10 08:28
dump.pyc	3.47 KB	-rw-r--r--	2024-04-10 08:28
dump.pyo	3.47 KB	-rw-r--r--	2024-04-10 08:28
factory.py	11.3 KB	-rw-r--r--	2024-04-10 08:28
factory.pyc	15.01 KB	-rw-r--r--	2024-04-10 08:28
factory.pyo	15.01 KB	-rw-r--r--	2024-04-10 08:28
hooks.py	7.8 KB	-rw-r--r--	2024-04-10 08:28
hooks.pyc	9.68 KB	-rw-r--r--	2024-04-10 08:28
hooks.pyo	9.68 KB	-rw-r--r--	2024-04-10 08:28
py25tests.py	2.67 KB	-rw-r--r--	2024-04-10 08:28
py25tests.pyc	2.92 KB	-rw-r--r--	2024-04-10 08:28
py25tests.pyo	2.92 KB	-rw-r--r--	2024-04-10 08:28
regression.py	15.02 KB	-rw-r--r--	2024-04-10 08:28
regression.pyc	18.56 KB	-rw-r--r--	2024-04-10 08:28
regression.pyo	18.56 KB	-rw-r--r--	2024-04-10 08:28
transactions.py	7.17 KB	-rw-r--r--	2024-04-10 08:28
transactions.pyc	7.93 KB	-rw-r--r--	2024-04-10 08:28
transactions.pyo	7.93 KB	-rw-r--r--	2024-04-10 08:28
types.py	14.66 KB	-rw-r--r--	2024-04-10 08:28
types.pyc	19.94 KB	-rw-r--r--	2024-04-10 08:28
types.pyo	19.94 KB	-rw-r--r--	2024-04-10 08:28
userfunctions.py	14.95 KB	-rw-r--r--	2024-04-10 08:28
userfunctions.pyc	24.09 KB	-rw-r--r--	2024-04-10 08:28
userfunctions.pyo	24.09 KB	-rw-r--r--	2024-04-10 08:28

Rename

# Author: Paul Kippes <kippesp@gmail.com>

import unittest
import sqlite3 as sqlite

class DumpTests(unittest.TestCase):
    def setUp(self):
        self.cx = sqlite.connect(":memory:")
        self.cu = self.cx.cursor()

def tearDown(self):
        self.cx.close()

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));"
                ,
                "INSERT INTO \"t1\" VALUES(1,'foo',10,20);"
                ,
                "INSERT INTO \"t1\" VALUES(2,'foo2',30,30);"
                ,
                u"INSERT INTO \"t1\" VALUES(3,'f\xc3\xb6',40,10);"
                ,
                "CREATE TABLE t2(id integer, t2_i1 integer, " \
                "t2_i2 integer, primary key (id)," \
                "foreign key(t2_i1) references t1(t1_i1));"
                ,
                "CREATE TRIGGER trigger_1 update of t1_i1 on t1 " \
                "begin " \
                "update t2 set t2_i1 = new.t1_i1 where t2_i1 = old.t1_i1; " \
                "end;"
                ,
                "CREATE VIEW v1 as select * from t1 left join t2 " \
                "using (id);"
                ]
        [self.cu.execute(s) for s in expected_sqls]
        i = self.cx.iterdump()
        actual_sqls = [s for s in i]
        expected_sqls = ['BEGIN TRANSACTION;'] + expected_sqls + \
            ['COMMIT;']
        [self.assertEqual(expected_sqls[i], actual_sqls[i])
            for i in xrange(len(expected_sqls))]

def CheckUnorderableRow(self):
        # iterdump() should be able to cope with unorderable row types (issue #15545)
        class UnorderableRow:
            def __init__(self, cursor, row):
                self.row = row
            def __getitem__(self, index):
                return self.row[index]
        self.cx.row_factory = UnorderableRow
        CREATE_ALPHA = """CREATE TABLE "alpha" ("one");"""
        CREATE_BETA = """CREATE TABLE "beta" ("two");"""
        expected = [
            "BEGIN TRANSACTION;",
            CREATE_ALPHA,
            CREATE_BETA,
            "COMMIT;"
            ]
        self.cu.execute(CREATE_BETA)
        self.cu.execute(CREATE_ALPHA)
        got = list(self.cx.iterdump())
        self.assertEqual(expected, got)

def suite():
    return unittest.TestSuite(unittest.makeSuite(DumpTests, "Check"))

def test():
    runner = unittest.TextTestRunner()
    runner.run(suite())

if __name__ == "__main__":
    test()