def test11_SteadyDBConnectionPingCheck(self):
Connection.has_ping = False
Connection.num_pings = 0
db = SteadyDBconnect(dbapi)
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 0)
db.close()
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 0)
self.assert_(db._ping_check() is None)
self.assertEqual(Connection.num_pings, 1)
db = SteadyDBconnect(dbapi, ping=7)
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 2)
db.close()
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 2)
self.assert_(db._ping_check() is None)
self.assertEqual(Connection.num_pings, 2)
Connection.has_ping = True
db = SteadyDBconnect(dbapi)
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 2)
db.close()
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 2)
self.assert_(db._ping_check())
self.assertEqual(Connection.num_pings, 3)
db = SteadyDBconnect(dbapi, ping=1)
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 3)
db.close()
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 3)
self.assert_(db._ping_check())
self.assertEqual(Connection.num_pings, 4)
db.close()
self.assert_(db._ping_check())
self.assertEqual(Connection.num_pings, 5)
db = SteadyDBconnect(dbapi, ping=7)
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 7)
db.close()
db.cursor().execute("select test")
self.assertEqual(Connection.num_pings, 9)
db = SteadyDBconnect(dbapi, ping=3)
self.assertEqual(Connection.num_pings, 9)
db.cursor()
self.assertEqual(Connection.num_pings, 10)
db.close()
cursor = db.cursor()
self.assertEqual(Connection.num_pings, 11)
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 11)
db = SteadyDBconnect(dbapi, ping=5)
self.assertEqual(Connection.num_pings, 11)
db.cursor()
self.assertEqual(Connection.num_pings, 11)
db.close()
cursor = db.cursor()
self.assertEqual(Connection.num_pings, 11)
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 12)
db.close()
cursor = db.cursor()
self.assertEqual(Connection.num_pings, 12)
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 13)
db = SteadyDBconnect(dbapi, ping=7)
self.assertEqual(Connection.num_pings, 13)
db.cursor()
self.assertEqual(Connection.num_pings, 14)
db.close()
cursor = db.cursor()
self.assertEqual(Connection.num_pings, 15)
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 16)
db.close()
cursor = db.cursor()
self.assertEqual(Connection.num_pings, 17)
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 18)
db.close()
cursor.execute("select test")
self.assertEqual(Connection.num_pings, 20)
Connection.has_ping = False
Connection.num_pings = 0
