Jun-10-2019, 11:56 AM
Hey im new to python and i have this error using python3 and psycopg2:
data gives :
data gives :
{'sensor_id': ['sensor3', 'sensor4'], 'end_ts': 2345, 'type_event': ['three', 'four'], 'id_event': 2, 'event_ids': [1, 2, 6, 8], 'start_ts': 4456, 'polygon': [[1, 5], [2, 9]]}of type dict and i have this code for inserting data to database : data = json.loads(request.data.decode())
array = list()
row1= []
for row1 in data:
data['id_event'] = row1[0]
data['sensor_id'] = row1[1]
data['type_event'] = row1[2]
data['start_ts'] = row1[3]
data['end_ts'] = row1[4]
data['polygon'] = row1[5]
postgreSQL_select_Query = "insert into event_table (Id_event, sensor_id, type_event, start_ts, end_ts, polygon) values (%s,%s,%s,%s,%s,%s)"
cursor.execute(postgreSQL_select_Query, [row1])and i get all data from json :{ "id_event": 2,
"sensor_id": [ "sensor3", "sensor4"],
"type_event": ["three", "four"],
"start_ts": 4456,
"end_ts": 2345,
"polygon": [[1,5], [2,9]],
"event_ids": [1, 2, 6, 8]
}when i run it using POST i get this error : cursor.execute(postgreSQL_select_Query, [row1]) IndexError: list index out of rangewhat am i doing wrong ?
