Example #1
0
    def testCommit(self):
        #set test value
        rvalue1 = str(random.random())
        rvalue2 = str(random.random())
        self.db['keyC1'] = rvalue1
        self.db['keyC2'] = rvalue2

        self.assertTrue('keyC1' in self.db)
        self.assertTrue('keyC2' in self.db)
        self.assertEqual(self.db['keyC1'], rvalue1)
        self.assertEqual(self.db['keyC2'], rvalue2)

        #commit changes
        self.db.commit()

        #delete key2 and not commit, so other user
        #must find that 'key2' still in db!
        del self.db['keyC2']

        #make sure this db not foud 'key2'
        self.assertTrue('keyC1' in self.db)
        self.assertFalse('keyC2' in self.db)
        self.assertEqual(self.db['keyC1'], rvalue1)

        #open and other instance and check 'key2' exist
        try:
            tmpdb = pyunqlite.connect('testdb.tmp')

            self.assertTrue('keyC1' in tmpdb)
            self.assertTrue('keyC2' in tmpdb)
            self.assertEqual(self.db['keyC1'], rvalue1)

        finally:
            tmpdb.close()
    def testCommit(self):
        #set test value
        rvalue1 = str(random.random())
        rvalue2 = str(random.random())
        self.db['keyC1'] = rvalue1
        self.db['keyC2'] = rvalue2

        self.assertTrue('keyC1' in self.db)
        self.assertTrue('keyC2' in self.db)
        self.assertEqual(self.db['keyC1'], rvalue1)
        self.assertEqual(self.db['keyC2'], rvalue2)

        #commit changes
        self.db.commit()

        #delete key2 and not commit, so other user
        #must find that 'key2' still in db!
        del self.db['keyC2']

        #make sure this db not foud 'key2'
        self.assertTrue('keyC1' in self.db)
        self.assertFalse('keyC2' in self.db)
        self.assertEqual(self.db['keyC1'], rvalue1)

        #open and other instance and check 'key2' exist
        try:
            tmpdb = pyunqlite.connect('testdb.tmp')

            self.assertTrue('keyC1' in tmpdb)
            self.assertTrue('keyC2' in tmpdb)
            self.assertEqual(self.db['keyC1'], rvalue1)

        finally:
            tmpdb.close()
Example #3
0
    def setUp(self):
        if os.path.isfile('testdb.tmp'):
            os.remove('testdb.tmp')

        self.db = pyunqlite.connect('testdb.tmp')
        pass
Example #4
0
 def setUp(self):
     self.db = pyunqlite.connect(':mem:')
    def setUp(self):
        if os.path.isfile('testdb.tmp'):
            os.remove('testdb.tmp')

        self.db = pyunqlite.connect('testdb.tmp')
        pass
 def setUp(self):
     self.db = pyunqlite.connect(':mem:')