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)