def test_get_store_multiple_dynamic_db_creation(self):
expEnvironmentOneDbName = "environmentOne.db"
expEnvironmentTwoDbName = "environmentTwo.db"
envOne = Environment2(name="environmentOne")
envTwo = Environment2(name="environmentTwo")
strategy = SqlitePersistenceStrategy()
environmentOneDbPool = strategy.get_store(envOne, "Environment2")
environmentTwoDbPool = strategy.get_store(envTwo, "Environment2")
try:
yield environmentOneDbPool.runQuery('''select * from devices''')
except:
pass
try:
yield environmentTwoDbPool.runQuery('''select * from devices''')
except:
pass
self.assertTrue(os.path.exists(expEnvironmentOneDbName))
self.assertTrue(os.path.exists(expEnvironmentTwoDbName))
yield strategy.tear_down()
os.remove(expEnvironmentOneDbName)
os.remove(expEnvironmentTwoDbName)
def test_get_store_db_creation(self):
env = Environment2(name="environmentOne")
update = Update2(type="update", name="updateOne")
expEnvironmentDbName = "environmentOne.db"
expUpdateDbName = "pollapli.db"
strategy = SqlitePersistenceStrategy()
obsEnvironmentDbPool = strategy.get_store(env, "Environment2")
obsUpdateDbPool = strategy.get_store(update, "Update")
try:
yield obsUpdateDbPool.runQuery('''select * from devices''')
except:
pass
try:
yield obsEnvironmentDbPool.runQuery('''select * from devices''')
except:
pass
self.assertTrue(os.path.exists(expUpdateDbName))
self.assertTrue(os.path.exists(expEnvironmentDbName))
yield strategy.tear_down()
os.remove(expEnvironmentDbName)
os.remove(expUpdateDbName)
def test_get_store_correct_db_from_sub_elements(self):
expEnvironmentOneDbName = "environmentOne.db"
env = Environment2(name = "environmentOne")
device = Device(name = "arduino")
device. _parent = env
strategy = SqlitePersistenceStrategy()
deviceDbPool = strategy.get_store(device,"Device")
try:
yield deviceDbPool.runQuery('''select * from devices''')
except:pass
self.assertTrue(os.path.exists(expEnvironmentOneDbName))
yield strategy.tear_down()
os.remove(expEnvironmentOneDbName)
def test_get_store_correct_db_from_sub_elements(self):
expEnvironmentOneDbName = "environmentOne.db"
env = Environment2(name="environmentOne")
device = Device(name="arduino")
device._parent = env
strategy = SqlitePersistenceStrategy()
deviceDbPool = strategy.get_store(device, "Device")
try:
yield deviceDbPool.runQuery('''select * from devices''')
except:
pass
self.assertTrue(os.path.exists(expEnvironmentOneDbName))
yield strategy.tear_down()
os.remove(expEnvironmentOneDbName)
def test_get_store_multiple_dynamic_db_creation(self):
expEnvironmentOneDbName = "environmentOne.db"
expEnvironmentTwoDbName = "environmentTwo.db"
envOne = Environment2(name = "environmentOne")
envTwo = Environment2(name = "environmentTwo")
strategy = SqlitePersistenceStrategy()
environmentOneDbPool = strategy.get_store(envOne,"Environment2")
environmentTwoDbPool = strategy.get_store(envTwo,"Environment2")
try:
yield environmentOneDbPool.runQuery('''select * from devices''')
except:pass
try:
yield environmentTwoDbPool.runQuery('''select * from devices''')
except:pass
self.assertTrue(os.path.exists(expEnvironmentOneDbName))
self.assertTrue(os.path.exists(expEnvironmentTwoDbName))
yield strategy.tear_down()
os.remove(expEnvironmentOneDbName)
os.remove(expEnvironmentTwoDbName)
def test_get_store_db_creation(self):
env = Environment2(name = "environmentOne")
update = Update2(type = "update", name = "updateOne")
expEnvironmentDbName = "environmentOne.db"
expUpdateDbName = "pollapli.db"
strategy = SqlitePersistenceStrategy()
obsEnvironmentDbPool = strategy.get_store(env,"Environment2")
obsUpdateDbPool = strategy.get_store(update,"Update")
try:
yield obsUpdateDbPool.runQuery('''select * from devices''')
except:pass
try:
yield obsEnvironmentDbPool.runQuery('''select * from devices''')
except:pass
self.assertTrue(os.path.exists(expUpdateDbName))
self.assertTrue(os.path.exists(expEnvironmentDbName))
yield strategy.tear_down()
os.remove(expEnvironmentDbName)
os.remove(expUpdateDbName)
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)
