使用SQLAlchemy烧瓶将json文件插入postgres

Question

我正试图使用flash/sqlalchemy将json文件插入postgress数据库，但我遇到了

TypeError: 'farmers' is an invalid keyword argument for Farmer

这是我的上传脚本：

import os
import flask
from flask_sqlalchemy import SQLAlchemy
from flask import Flask, jsonify, send_from_directory
from sqlalchemy.dialects.postgresql import JSON
APP = Flask(__name__)
APP.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:admin@localhost:5432/flaskwebapp'
db = SQLAlchemy(APP)
class Farmers(db.Model):
Farmers = db.Column(db.Integer, primary_key=True)
W = db.Column(db.Integer)
Z = db.Column(db.Integer)
J1_I = db.Column(db.Integer)

def insert_data():

f1 = Farmers(farmers={"farmers":[{"W":1000000,"Z":22758,"J1_I":0.66},{"W":3500000,"Z":21374,"J1_I":2.69},{"W":2500000,"Z":14321,"J1_I":0.76},{"W":2500000,"Z":14321,"J1_I":0.76}]})
db.session.add(f1)
db.session.commit()
print('Data inserted to DB!')
insert_data()

这是有问题的json文件，但我不认为这是一个问题，因为我可以在cmd:中读取它

{
"farmers":[ {
"W":1000000,
"Z":22758,
"J1_I":0.66
},
{
"W":3500000,
"Z":21374,
"J1_I":2.69
},
{
"W":2500000,
"Z":14321,
"J1_I":0.76
},
{
"W":2500000,
"Z":14321,
"J1_I":0.76
}]}

你知道我为什么不能上传数据吗？

Answer 1

模型构造函数不接受列表，您需要单独传递每个字典：

farmer_data = {"farmers":[{"W":1000000,"Z":22758,"J1_I":0.66},{"W":3500000,"Z":21374,"J1_I":2.69},{"W":2500000,"Z":14321,"J1_I":0.76},{"W":2500000,"Z":14321,"J1_I":0.76}]}
farmers = [Farmer(**data) for data in farmer_data["farmers"]]
db.session.add_all(farmers)
db.session.commit()