python棉花糖模式Json

2024-10-03 09:07:45 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试使用下面列出的模式验证JSON文件,我希望返回JSON类型,如下所示:

{
   "status" : 101,
   "questions" :
   [
     {
       "hCode": "A",
       "qId": 402,
       "questionEn": "q1",
       "rowNo": 1
     },
     {
       "hCode": "A",
       "qId": 403,
       "questionEn": "q2",
       "rowNo": 2
     }
   ]
}

这是我的棉花糖序列化代码

class QuestionModel(db.Model):
__tablename__ = 'questions'
qId = db.Column(db.Integer, primary_key=True)
hCode = db.Column(db.String(2), nullable=False)
rowNo = db.Column(db.Integer, nullable=False)
questionEn = db.Column(db.String(300), nullable=True)

def __init__(self, qId, hCode, rowNo, questionEn):
    self.qId = qId
    self.hCode = hCode
    self.rowNo = rowNo
    self.questionEn = questionEn

def __repr__(self):
    return f"questions(qId = {self.qId}, hCode = {self.hCode}, rowNo = {self.rowNo}, " \
           f"questionEn = {self.questionEn}) "


class QuestionModelSchema(ma.Schema):
   class Meta:
       fields = ("qId", "hCode", "rowNo", "questionEn")


question_schema = QuestionModelSchema()
questions_schema = QuestionModelSchema(many=True)


@app.route('/qlist')
def get_questions():
   Questions = QuestionModel.query.all()
   return questions_schema.jsonify(Questions)

我应该如何更改代码以验证我提到的JSON文件


Tags: selfjsontruedbschemadefcolumnclass