def __init__(self, pathManager=None): self._path_manager = pathManager self._persistenceStrategy = SqlitePersistenceStrategy() self._db_pool = adbapi.ConnectionPool("sqlite3", "pollapli.db", check_same_thread=False) self._updateDao = UpdateSqliteDao( db_pool=self._db_pool, persistenceStrategy=self._persistenceStrategy) self._environmentDao = EnvironmentSqliteDao( db_pool=self._db_pool, persistenceStrategy=self._persistenceStrategy) self._deviceDao = DeviceSqliteDao( db_pool=self._db_pool, persistenceStrategy=self._persistenceStrategy) self._taskDao = TaskSqliteDao(db_pool=self._db_pool)
class DeviceSqliteDaoTests(unittest.TestCase): def setUp(self): self._dbpool = adbapi.ConnectionPool("sqlite3",'pollapli.db',check_same_thread=False) self._deviceSqliteDao=DeviceSqliteDao(self._dbpool) @defer.inlineCallbacks def tearDown(self): yield self._dbpool.close() os.remove('pollapli.db') @defer.inlineCallbacks def test_save_device_new(self): input = Device(name="TestDevice",description="A test description") yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id = 1) self.assertEquals(obs,exp) @defer.inlineCallbacks def test_save_device_existing(self): input = Device(name="TestDevice",description="A test description") yield self._deviceSqliteDao.save_device(input) input.name = "TestDeviceModified" yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id = 1) self.assertEquals(obs,exp) @defer.inlineCallbacks def test_save_devices(self): input = [Device(name="TestDevice",description="A test description",status="inactive"), Device(name="TestDevice",description="A test description",status="active")] yield self._deviceSqliteDao.save_devices(input) expLDevices = input obsLDevices = yield self._deviceSqliteDao.load_devices() self.assertEquals(expLDevices,obsLDevices) @defer.inlineCallbacks def test_load_devicebyid(self): input = Device(name = "TestDevice",description = "A test description load",status = "active") yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id = 1) self.assertEquals(obs,exp) @defer.inlineCallbacks def test_load_multiple_devices(self): input = [Device(name="TestDeviceOne",description="A test description",status="inactive"),Device(name="TestDeviceTwo",description="Another test description",status="active")] yield self._deviceSqliteDao.save_devices(input) exp = input obs = yield self._deviceSqliteDao.load_devices() self.assertEquals(obs,exp)
def setUp(self): self._dbpool = adbapi.ConnectionPool("sqlite3",'pollapli.db',check_same_thread=False) self._deviceSqliteDao=DeviceSqliteDao(self._dbpool)
class DeviceSqliteDaoTests(unittest.TestCase): def setUp(self): self._dbpool = adbapi.ConnectionPool("sqlite3", 'pollapli.db', check_same_thread=False) self._deviceSqliteDao = DeviceSqliteDao(self._dbpool) @defer.inlineCallbacks def tearDown(self): yield self._dbpool.close() os.remove('pollapli.db') @defer.inlineCallbacks def test_save_device_new(self): input = Device(name="TestDevice", description="A test description") yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id=1) self.assertEquals(obs, exp) @defer.inlineCallbacks def test_save_device_existing(self): input = Device(name="TestDevice", description="A test description") yield self._deviceSqliteDao.save_device(input) input.name = "TestDeviceModified" yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id=1) self.assertEquals(obs, exp) @defer.inlineCallbacks def test_save_devices(self): input = [ Device(name="TestDevice", description="A test description", status="inactive"), Device(name="TestDevice", description="A test description", status="active") ] yield self._deviceSqliteDao.save_devices(input) expLDevices = input obsLDevices = yield self._deviceSqliteDao.load_devices() self.assertEquals(expLDevices, obsLDevices) @defer.inlineCallbacks def test_load_devicebyid(self): input = Device(name="TestDevice", description="A test description load", status="active") yield self._deviceSqliteDao.save_device(input) exp = input obs = yield self._deviceSqliteDao.load_device(id=1) self.assertEquals(obs, exp) @defer.inlineCallbacks def test_load_multiple_devices(self): input = [ Device(name="TestDeviceOne", description="A test description", status="inactive"), Device(name="TestDeviceTwo", description="Another test description", status="active") ] yield self._deviceSqliteDao.save_devices(input) exp = input obs = yield self._deviceSqliteDao.load_devices() self.assertEquals(obs, exp)
def setUp(self): self._dbpool = adbapi.ConnectionPool("sqlite3", 'pollapli.db', check_same_thread=False) self._deviceSqliteDao = DeviceSqliteDao(self._dbpool)