#-*- 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.failUnlessEqual(count, 1)

    def CheckContextManagerRollback(self):

        """Is a rollback called in the context manager?"""

        global did_rollback

        self.failUnlessEqual(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.failUnlessEqual(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()