我正在使用python進(jìn)行一個(gè)項(xiàng)目，其中我使用請求從REST API獲取json，然后繼續(xù)將其加載到PostgreSQL數(shù)據(jù)庫中。API 響應(yīng)的 json 的結(jié)構(gòu)如下所示。我的主要問題是關(guān)于嵌套字段，如和嵌套在數(shù)組中的字段，如.location.latinfoinfo[0].value{"items": [ { "id": 300436, "item_id_parent": null, "reference": "", "subreference1": "CAMS\/1", "subreference2": "CAMS\/1", "reference_alpha": null, "reference_numeric": null, "oid": "CAMS\/1", "code": null, "code_custom": null, "name": "284", "image": "https:\/\/static.inventsys.com.br\/278\/thumb\/f-3298886-200x200c.jpg", "situations": [], "project_id": 10762, "project": { "id": 10762, "name": "Fauna EGR", "color": null }, "category_id": 20685, "category": { "id": 20685, "name": "EGR FAUNA - Armadilhas" }, "area_id": null, "area": null, "location": { "lat": -30.136699676514, "lng": -50.910511016846, "address": { "region": "RS", "city": "Viam?o", "district": null, "zipcode": null, "street": "Rodovia Tapir Rocha", "street_number": null, "desc": null, "full": "Rodovia Tapir Rocha Viam?o \/ BR" } },這里的問題是，如果我只使用前四個(gè)變量運(yùn)行代碼，它工作正常，所以我想當(dāng)涉及到我想要解析的嵌套字段時(shí)，我的語法都是錯(cuò)誤的。如何最好地引用這些字段？提前感謝大家！
1 回答
MYYA
TA貢獻(xiàn)1868條經(jīng)驗(yàn) 獲得超4個(gè)贊
供將來參考，像這樣解決它：
for item in registros:
armadilhafields = [
item['id'],
item['name'],
item['image'],
item['category_id'],
item['category']['name'],
item['location']['lat'],
item['location']['lng'],
item['files'][0]['url_orig'],
item['info'][0]['value'],
item['info'][1]['value'],
item['info'][2]['value'],
item['info'][3]['value'],
item['info'][4]['value'],
item['info'][5]['value'],
item['info'][6]['value'],
item['info'][7]['value'],
item['info'][8]['value'],
item['info'][9]['value'],
item['info'][10]['value'],
]
my_data = [field for field in armadilhafields]
cur.execute("INSERT INTO egrfauna_armadilhas VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", tuple(my_data))
conn.commit()
添加回答
舉報(bào)
0/150
提交
取消