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)
})
