def addPrices(self, aRegion, aDict):
id = self.getRegionId(aRegion)
self._logger.info('DatabaseHandler :: addPrices : id : %s', id)
if id is None:
id = self.addRegionToDb(aRegion)
self._logger.info(
'DatabaseHandler :: addPrices : values deleted : %s',
self.deleteValues(id))
sql.processFunctionOnDb(self._myPool,
self._logger, sql.addPricesSQL, id, aDict)
def getRegionId(self, aRegion):
result = sql.processFunctionOnDb(self._myPool,
self._logger,
sql.checkForRegionSQL, aRegion)
if result:
return result
else:
None
def getPrices(self, aRegion):
id = self.getRegionId(aRegion)
if id:
dict = sql.processFunctionOnDb(self._myPool,
self._logger, sql.getPricesSQL, id)
return dict
else:
return None
def deleteValues(self, aId):
return sql.processFunctionOnDb(self._myPool,
self._logger, sql.deleteValuesSQL, aId)
def addRegionToDb(self, aRegion):
result = sql.processFunctionOnDb(self._myPool,
self._logger,
sql.addRegionToDbSQL, aRegion)
return result
