def get_name(id):
query = "select name from config where id ='{}';".format(id)
logging.info(query)
try:
result = dbHandler.dbFetchOne(query)
return result[0]
except Exception as e:
logging.info("Error: " + e)
def get_max_ts_irr_hist():
query = "select last_updated from irr_set_hist order by last_updated desc limit 1;"
logging.info(query)
try:
result = dbHandler.dbFetchOne(query)
return result[0]
except Exception as e:
logging.info("Error: " + e)
def get_max_ts_irr(setting_id):
query = "select last_updated from irr_set_cust where setting_id ='{}';".format(
setting_id)
logging.info(query)
try:
result = dbHandler.dbFetchOne(query)
return result[0]
except Exception as e:
logging.info("Error: " + e)
def get_irr_set_comn():
query = "select setting_id, max_sprinkle_dur, offset_bef_sprinkle, max_wind_speed, humid,skip_sprinkle_from,skip_sprinkle_to,last_updated from irr_set_comn;"
logging.info(query)
try:
result = dbHandler.dbFetchOne(query)
return result[0], result[1], result[2], result[3], result[4], result[
5], result[6], result[7]
except Exception as e:
logging.info("Error: " + e)