已自行解決,代碼如下:
json格式:[
{
"標題": "小武",
"內容": "測試",
"類型":["情感","文學","散文"]
"文章資源":[
{
"title":"小武.1998.HD.1080p.x264.aac.Mandarine .CHS.mkv ",
"links":"https://www.xxx1.com"
},
{
"title":"小武.1998.HD.1080p.x264.aac.Mandarin.CHS.mp4",
"links":"https://www.xxx2.com"
}
]
},
{
...
}
]from (自己項目名稱).wsgi import *
from (app名稱).models import Types,DetailInfo,MagnetLink
import json
def insertDB():
with open('E:\\workspace\\xxxxx.json', 'r', encoding='utf8') as f:
data = json.load(f)
for list in data:
#先寫入分類(多對多關系)
for t in list['類型']:
c = Types.objects.get_or_create(name=t)[0]
# 然后插入文章
article = DetailInfo.objects.get_or_create(title=list['標題'],
context=list['內容'])[0]
# 最后獲取文章id
article_id = article.id
for m in list['文章資源']:
print(m)
# 根據id插入數據到文章資源表中(一對多)
ResourcesLink.objects.get_or_create(detailinfo_id=article_id,title=m['title'],link=m['links'])[0]
article.types.add(c)