def test_timestamps(self):
timestamp01 = self.now()
self.session.rollback()
self.sleep()
uid = Uid(uid='*****@*****.**')
self.session.add(uid)
self.session.commit()
created01 = uid.created
modified01 = uid.modified
self.sleep()
timestamp02 = self.now()
self.session.rollback()
self.assertTrue(timestamp01 < created01)
self.assertTrue(timestamp01 < modified01)
self.assertTrue(created01 < timestamp02)
self.assertTrue(modified01 < timestamp02)
self.sleep()
uid.name = 'ftp team'
self.session.commit()
created02 = uid.created
modified02 = uid.modified
self.assertEqual(created01, created02)
self.assertTrue(modified01 < modified02)
self.sleep()
self.session.rollback()
timestamp03 = self.now()
self.assertTrue(modified02 < timestamp03)
def test_timestamps(self):
timestamp01 = self.now()
self.session.rollback()
self.sleep()
uid = Uid(uid='*****@*****.**')
self.session.add(uid)
self.session.commit()
created01 = uid.created
modified01 = uid.modified
self.sleep()
timestamp02 = self.now()
self.session.rollback()
self.assertTrue(timestamp01 < created01)
self.assertTrue(timestamp01 < modified01)
self.assertTrue(created01 < timestamp02)
self.assertTrue(modified01 < timestamp02)
self.sleep()
uid.name = 'ftp team'
self.session.commit()
created02 = uid.created
modified02 = uid.modified
self.assertEqual(created01, created02)
self.assertTrue(modified01 < modified02)
self.sleep()
self.session.rollback()
timestamp03 = self.now()
self.assertTrue(modified02 < timestamp03)
def test_session(self):
"""
Tests the ORMObject.session() method.
"""
uid = Uid(uid="foobar")
self.session.add(uid)
self.assertEqual(self.session, uid.session())
def test_session(self):
'''
Tests the ORMObject.session() method.
'''
uid = Uid(uid='foobar')
self.session.add(uid)
self.assertEqual(self.session, uid.session())
def test_session(self):
'''
Tests the ORMObject.session() method.
'''
uid = Uid(uid='foobar')
self.session.add(uid)
self.assertEqual(self.session, uid.session())
def test_expunge(self):
'''
Test expunge() of objects from session and the object_session()
function.
'''
# test expunge()
uid = Uid(uid='foobar')
self.session.add(uid)
self.assertTrue(uid in self.session)
self.session.expunge(uid)
self.assertTrue(uid not in self.session)
# test close()
self.session.add(uid)
self.assertTrue(uid in self.session)
self.session.close()
self.assertTrue(uid not in self.session)
# make uid persistent
self.session.add(uid)
self.session.commit()
self.assertTrue(uid in self.session)
# test rollback() for persistent object
self.session.rollback()
self.assertTrue(uid in self.session)
# test expunge() for persistent object
self.session.expunge(uid)
self.assertTrue(uid not in self.session)
# test close() for persistent object
self.session.add(uid)
self.assertTrue(uid in self.session)
self.session.close()
self.assertTrue(uid not in self.session)
def test_clone(self):
'''
Tests the ORMObject.clone() method.
'''
uid1 = Uid(uid='foobar')
# no session yet
self.assertRaises(RuntimeError, uid1.clone)
self.session.add(uid1)
# object not persistent yet
self.assertRaises(RuntimeError, uid1.clone)
self.session.commit()
# test without session parameter
uid2 = uid1.clone()
self.assertTrue(uid1 is not uid2)
self.assertEqual(uid1.uid, uid2.uid)
self.assertTrue(uid2 not in uid1.session())
self.assertTrue(uid1 not in uid2.session())
# test with explicit session parameter
new_session = DBConn().session()
uid3 = uid1.clone(session=new_session)
self.assertEqual(uid1.uid, uid3.uid)
self.assertTrue(uid3 in new_session)
# test for ressource leaks with mass cloning
for _ in xrange(1, 1000):
uid1.clone()
def test_relation(self):
fingerprint = Fingerprint(fingerprint='deadbeefdeadbeef')
self.session.add(fingerprint)
query = self.session.query(Fingerprint)
self.assertEqual(1, query.count())
self.assertEqual('deadbeefdeadbeef', query.one().fingerprint)
fingerprint.uid = Uid(uid='*****@*****.**', name='ftpteam')
uid = self.session.query(Uid).one()
self.assertEqual('*****@*****.**', uid.uid)
self.assertEqual('ftpteam', uid.name)
self.assertEqual(1, len(uid.fingerprint))
self.assertEqual('deadbeefdeadbeef', uid.fingerprint[0].fingerprint)
def test_clone(self):
"""
Tests the ORMObject.clone() method.
"""
uid1 = Uid(uid="foobar")
# no session yet
self.assertRaises(RuntimeError, uid1.clone)
self.session.add(uid1)
# object not persistent yet
self.assertRaises(RuntimeError, uid1.clone)
self.session.commit()
# test without session parameter
uid2 = uid1.clone()
self.assertTrue(uid1 is not uid2)
self.assertEqual(uid1.uid, uid2.uid)
self.assertTrue(uid2 not in uid1.session())
self.assertTrue(uid1 not in uid2.session())
# test with explicit session parameter
new_session = DBConn().session()
uid3 = uid1.clone(session=new_session)
self.assertEqual(uid1.uid, uid3.uid)
self.assertTrue(uid3 in new_session)
# test for ressource leaks with mass cloning
for _ in xrange(1, 1000):
uid1.clone()
def test_refresh(self):
'''
Test the refresh() of an object.
'''
self.uid = Uid(uid='foobar')
self.assertEqual(None, self.uid.uid_id)
self.session.add(self.uid)
self.assertEqual(None, self.uid.uid_id)
self.session.flush()
self.assertTrue(self.uid.uid_id is not None)
self.session.rollback()
self.assertRaises(InvalidRequestError, self.refresh)
def test_crud(self):
"""
Test INSERT, UPDATE, DELETE, ROLLBACK, and COMMIT behaviour of the
session.
"""
# test INSERT
uid = Uid(uid="foobar")
self.assertTrue(uid not in self.session)
self.session.add(uid)
self.assertTrue(uid in self.session)
self.assertTrue(uid in self.session.new)
self.session.flush()
self.assertTrue(uid in self.session)
self.assertTrue(uid not in self.session.new)
# test UPDATE
uid.uid = "foobar2"
self.assertTrue(uid in self.session.dirty)
self.session.flush()
self.assertTrue(uid not in self.session.dirty)
# test ROLLBACK
self.session.rollback()
self.assertTrue(uid not in self.session)
# test COMMIT
uid = Uid(uid="foobar")
self.session.add(uid)
self.assertTrue(uid in self.session.new)
self.session.commit()
self.assertTrue(uid in self.session)
self.assertTrue(uid not in self.session.new)
# test DELETE
self.session.delete(uid)
self.assertTrue(uid in self.session)
self.assertTrue(uid in self.session.deleted)
self.session.flush()
self.assertTrue(uid not in self.session)
self.assertTrue(uid not in self.session.deleted)
def test_crud(self):
'''
Test INSERT, UPDATE, DELETE, ROLLBACK, and COMMIT behaviour of the
session.
'''
# test INSERT
uid = Uid(uid='foobar')
self.assertTrue(uid not in self.session)
self.session.add(uid)
self.assertTrue(uid in self.session)
self.assertTrue(uid in self.session.new)
self.session.flush()
self.assertTrue(uid in self.session)
self.assertTrue(uid not in self.session.new)
# test UPDATE
uid.uid = 'foobar2'
self.assertTrue(uid in self.session.dirty)
self.session.flush()
self.assertTrue(uid not in self.session.dirty)
# test ROLLBACK
self.session.rollback()
self.assertTrue(uid not in self.session)
# test COMMIT
uid = Uid(uid='foobar')
self.session.add(uid)
self.assertTrue(uid in self.session.new)
self.session.commit()
self.assertTrue(uid in self.session)
self.assertTrue(uid not in self.session.new)
# test DELETE
self.session.delete(uid)
self.assertTrue(uid in self.session)
self.assertTrue(uid in self.session.deleted)
self.session.flush()
self.assertTrue(uid not in self.session)
self.assertTrue(uid not in self.session.deleted)
def test_timestamps(self):
'''
Test the basic transaction behaviour. The session is not configured for
autocommit mode and that is why we always have an open transaction that
ends with either rollback() or commit().
'''
# timestamps will always be the same in one transaction
timestamp01 = self.now()
self.sleep()
timestamp02 = self.now()
self.assertEqual(timestamp01, timestamp02)
uid = Uid(uid='foobar')
self.session.add(uid)
self.session.flush()
self.assertEqual(timestamp01, uid.created)
# ... but different in multiple transactions
self.session.rollback()
timestamp03 = self.now()
self.assertTrue(timestamp01 < timestamp03)
uid = Uid(uid='foobar')
self.session.add(uid)
self.session.flush()
self.assertTrue(timestamp01 < uid.created)
def uid_duplicate_uid(self):
self.session.add(Uid(uid='duplicate'))
self.session.add(Uid(uid='duplicate'))
self.session.flush()
def uid_no_uid(self):
self.session.add(Uid(name='foobar'))
self.session.flush()