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)
