# HG changeset patch # User Sylvain Thénault # Date 1253114784 -7200 # Node ID 559387273d98cae9eb5e10875db5b4d5dcc2b741 # Parent 49728db93b3e131c36e2ef55e8ebda9894654cfe remove annoying sqlite, not cw, test diff -r 49728db93b3e -r 559387273d98 server/test/unittest_extlite.py --- a/server/test/unittest_extlite.py Wed Sep 16 17:16:29 2009 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,58 +0,0 @@ -import threading, os, time - -from logilab.common.testlib import TestCase, unittest_main -from logilab.common.db import get_connection - -class SQLiteTC(TestCase): - sqlite_file = '_extlite_test.sqlite' - - def _cleanup(self): - try: - os.remove(self.sqlite_file) - except: - pass - - def setUp(self): - self._cleanup() - cnx1 = get_connection('sqlite', database=self.sqlite_file) - cu = cnx1.cursor() - cu.execute('CREATE TABLE toto(name integer);') - cnx1.commit() - cnx1.close() - - def tearDown(self): - self._cleanup() - - def test(self): - lock = threading.Lock() - - def run_thread(): - cnx2 = get_connection('sqlite', database=self.sqlite_file) - lock.acquire() - cu = cnx2.cursor() - cu.execute('SELECT name FROM toto') - self.failIf(cu.fetchall()) - cnx2.commit() - lock.release() - time.sleep(0.1) - lock.acquire() - cu.execute('SELECT name FROM toto') - self.failUnless(cu.fetchall()) - lock.release() - - cnx1 = get_connection('sqlite', database=self.sqlite_file) - lock.acquire() - thread = threading.Thread(target=run_thread) - thread.start() - cu = cnx1.cursor() - cu.execute('SELECT name FROM toto') - lock.release() - time.sleep(0.1) - cnx1.commit() - lock.acquire() - cu.execute("INSERT INTO toto(name) VALUES ('toto')") - cnx1.commit() - lock.release() - -if __name__ == '__main__': - unittest_main()