def getListScenarios(): dao = DAO() scenarios = dao.getListScenarios() states = dao.getListStates() sc_list = [] for scenario in scenarios: st_list = [] for state in states : if state.id_scenario == scenario.id: capteur = dao.getSensor(state.id_sensor, state.type_sensor) st_list.append({'id': state.id, 'id_capteur' : state.id_sensor, 'name': capteur.name, 'type': state.type_sensor, 'value' : state.value, 'operator' : state.operator}) sc_list.append({'id': scenario.id, 'name' : scenario.name, 'states' : st_list, 'timestamp' : scenario.timestamp, 'status' : scenario.status}) return json.dumps(sc_list)