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

#-*- coding: ISO-8859-1 -*-
# pysqlite2/test/regression.py: pysqlite regression tests
#
# Copyright (C) 2007 Gerhard H�ring <gh@ghaering.de>
#
# This file is part of pysqlite.
#
# This software is provided 'as-is', without any express or implied
# warranty.  In no event will the authors be held liable for any damages
# arising from the use of this software.
#
# Permission is granted to anyone to use this software for any purpose,
# including commercial applications, and to alter it and redistribute it
# freely, subject to the following restrictions:
#
# 1. The origin of this software must not be misrepresented; you must not
#    claim that you wrote the original software. If you use this software
#    in a product, an acknowledgment in the product documentation would be
#    appreciated but is not required.
# 2. Altered source versions must be plainly marked as such, and must not be
#    misrepresented as being the original software.
# 3. This notice may not be removed or altered from any source distribution.

from __future__ import with_statement
import unittest
import sqlite3 as sqlite

did_rollback = False

class MyConnection(sqlite.Connection):
    def rollback(self):
        global did_rollback
        did_rollback = True
        sqlite.Connection.rollback(self)

class ContextTests(unittest.TestCase):
    def setUp(self):
        global did_rollback
        self.con = sqlite.connect(":memory:", factory=MyConnection)
        self.con.execute("create table test(c unique)")
        did_rollback = False

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

def CheckContextManager(self):
        """Can the connection be used as a context manager at all?"""
        with self.con:
            pass

def CheckContextManagerCommit(self):
        """Is a commit called in the context manager?"""
        with self.con:
            self.con.execute("insert into test(c) values ('foo')")
        self.con.rollback()
        count = self.con.execute("select count(*) from test").fetchone()[0]
        self.assertEqual(count, 1)

def CheckContextManagerRollback(self):
        """Is a rollback called in the context manager?"""
        global did_rollback
        self.assertEqual(did_rollback, False)
        try:
            with self.con:
                self.con.execute("insert into test(c) values (4)")
                self.con.execute("insert into test(c) values (4)")
        except sqlite.IntegrityError:
            pass
        self.assertEqual(did_rollback, True)

def suite():
    ctx_suite = unittest.makeSuite(ContextTests, "Check")
    return unittest.TestSuite((ctx_suite,))

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

if __name__ == "__main__":
    test()