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)
