postman显示服务器错误是什么原因,Postman 500内部服务器错误api错误

我正在用flask为web构建一个api

我已经有一个数据库和GET请求工作,但当我尝试POST它给我这个错误500 INTERNAL SERVER ERROR

这是我写的代码#User_schema

class UserSchema(ma.Schema):

class Mata:

fields = ('id', 'name', 'Email', 'Pass', 'Phone', 'Department', 'Major')

#init_schema

user_schema = UserSchema()

users_schema = UserSchema(many=True)

#create user

@app.route('/user', methods=['POST'])

def add_User():

#id = request.json['id']

name = request.json['name']

Email = request.json['Email']

Pass = request.json['Pass']

#Phone = request.json['Phone']

Department = request.json['Department']

Major = request.json['Major']

new_user = User(name, Email, Pass, Department, Major)

db.session.add(new_user)

db.session.commit()

return user_schema.jsonify(new_user)

这是我在邮递员上加的要求

^{pr2}$

我也在使用本地服务器

我看了其他的链接,每个人都在要求日志,如果我没有错的话,我想我是从那里得到的View > Developer > Show DevTools > Console

这是日志截图:(我想)

x0HhH.jpg

到底是什么问题?我不明白

编辑:以下是完整代码:from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

from flask_marshmallow import Marshmallow

import os

app = Flask(__name__)

basedir = os.path.abspath(os.path.dirname(__file__))

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.db'

app.config['SQLALCHEMY_TRACK_MODIFICATION'] = False

db = SQLAlchemy(app)

ma = Marshmallow(app)

class User (db.Model):

id = db.Column(db.Integer,primary_key=True)

name = db.Column(db.String(30))

Email = db.Column(db.String(30))

Pass = db.Column(db.String(30))

Phone = db.Column(db.Integer)

Department = db.Column(db.String(30))

Major = db.Column(db.String(30))

meeting = db.relationship('Meeting', backref='creator')

meetingroom = db.relationship('MeetingRoom', backref='reserver')

def _init_(self, name, Email, Pass, Phone, Department, Major):

self.name = name

self.Email = Email

self.Pass = Pass

self.Phone = Phone

self.Department = Department

self.Major = Major

class MeetingRoom (db.Model):

mrid = db.Column(db.Integer,primary_key=True)

reserver_id = db.Column(db.Integer, db.ForeignKey('user.id'))

#meetingm = db.relationship('Meeting', backref='roomno')

mid = db.Column(db.Integer, db.ForeignKey('meeting.Mid'))

class Meeting (db.Model):

Mid = db.Column(db.Integer,primary_key=True)

Mname = db.Column(db.String(100))

Des = db.Column(db.String(100))

Date = db.Column(db.String(20))

creator_id = db.Column(db.Integer, db.ForeignKey('user.id'))

meetingroomm = db.relationship('MeetingRoom', backref='mroom')

#roomno_id = db.Column(db.Integer, db.ForeignKey('meetingroom.mrid')

##json

@app.route('/users', methods=['GET'])

def getuser():

users = User.query.all()

output = []

for user in users:

user_data = {}

user_data['id'] = user.id

user_data['name'] = user.name

user_data['Email'] = user.Email

user_data['Pass'] = user.Pass

user_data['Phone'] = user.Phone

user_data['Department'] = user.Department

user_data['Major'] = user.Major

output.append(user_data)

return jsonify({'users' : output})

#User_schema

class UserSchema(ma.Schema):

class Mata:

fields = ('id', 'name', 'Email', 'Pass', 'Phone', 'Department', 'Major')

#init_schema

user_schema = UserSchema()

users_schema = UserSchema(many=True)

#create user

@app.route('/user', methods=['POST'])

def add_User():

#id = request.json['id']

name = request.json['name']

Email = request.json['Email']

Pass = request.json['Pass']

#Phone = request.json['Phone']

Department = request.json['Department']

Major = request.json['Major']

new_user = User(name, Email, Pass, Department, Major)

db.session.add(new_user)

db.session.commit()

return user_schema.jsonify(new_user)

#meeting_schema

class MeetingSchema(ma.Schema):

class Mata:

fields = ('Mid', 'Mname', 'Des', 'Date', 'creator_id')

#init_schema

meeting_schema = MeetingSchema()

meetings_schema = MeetingSchema(many=True)

#create meeting

@app.route('/meeting', methods=['POST'])

def add_meeting():

Mname = request.json['Mname']

Des = request.json['Des']

Date = request.json['Date']

new_meeting = Meeting(Mname, Des, Date)

db.session.add(new_meeting)

db.session.commit()

return user_schema.jsonify(new_meeting)

if __name__ == '__main__':

app.run(debug=True)

添加def错误后:cursor.execute(statement, parameters)

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked

[SQL: INSERT INTO user (name, "Email", "Pass", "Phone", "Department", "Major") VALUES (?, ?, ?, ?, ?, ?)]

[parameters: ('User 1', 'User1@.com', 'qq1', '0551', 'IT 1', 'IT 1')]

(Background on this error at: http://sqlalche.me/e/e3q8)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值