def get_data_by_time(session, start_time, end_time): #return utils.list_db_objects(session, Temperature, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group(session, Temperature, select=[func.avg(Temperature.temperature).label("avg_temp"), func.hour(Temperature.created_at).label("hour")], group_by=func.hour(Temperature.created_at), created_at={'ge': str(start_time), 'le': str(end_time)})
def get_max_date(session, gateway_id, **kwargs): return utils.list_db_objects_by_group(session, ActualWeather, select=[func.max(ActualWeather.created_at).label("create_time")], group_by=None, region_id=gateway_id, order=0, **kwargs)
def get_data_by_time(session, start_time, end_time): #return utils.list_db_objects(session, Illuminance, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group(session, Illuminance, select=[func.avg(Illuminance.illuminance).label("avg_illuminance"), func.hour(Illuminance.created_at).label("hour")], group_by=func.hour(Illuminance.created_at), created_at={'ge': str(start_time), 'le': str(end_time)})
def get_data_by_time(session, start_time, end_time, resource_list): #return utils.list_db_objects(session, Illuminance, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group(session, Illuminance, select=[func.avg(Illuminance.illuminance).label("avg_illuminance"), func.hour(Illuminance.created_at).label("hour")], group_by=func.hour(Illuminance.created_at), created_at={'ge': str(start_time), 'le': str(end_time)}, resource_id={'in': resource_list})
def get_data_by_time(session, start_time, end_time): # return utils.list_db_objects(session, Gas, status=True, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group(session, Gas, select=[func.count(Gas.status).label("cnt"), func.hour(Gas.created_at).label("hour")], group_by=func.hour(Gas.created_at), status=True, created_at={'ge': str(start_time), 'le': str(end_time)})
def get_data_by_time(session, start_time, end_time, resource_list): # return utils.list_db_objects(session, Buzzer, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group(session, Buzzer, select=[func.count(Buzzer.status), func.hour(Buzzer.created_at)], group_by=func.hour(Buzzer.created_at), status=True, created_at={'ge': str(start_time), 'le': str(end_time)}, resource_id={'in': resource_list})
def get_data_by_time(session, start_time, end_time): # return utils.list_db_objects(session, Buzzer, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group( session, Buzzer, select=[func.count(Buzzer.status), func.hour(Buzzer.created_at)], group_by=func.hour(Buzzer.created_at), status=True, created_at={ 'ge': str(start_time), 'le': str(end_time) })
def get_data_by_time(session, start_time, end_time): # return utils.list_db_objects(session, Gas, status=True, created_at={'ge': str(start_time), 'le': str(end_time)}) return utils.list_db_objects_by_group( session, Gas, select=[ func.count(Gas.status).label("cnt"), func.hour(Gas.created_at).label("hour") ], group_by=func.hour(Gas.created_at), status=True, created_at={ 'ge': str(start_time), 'le': str(end_time) })