我正在嘗試使用 Flask 發布和獲取物件，但我一直在獲取sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: object.
我試著做 POST 到http://127.0.0.1/data
，我提供的 json 是
{
"oid": "123456789",
"size": "1234"
}
下面是我的代碼
from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.sqlite3'
db = SQLAlchemy(app)
class Object(db.Model):
oid = db.Column(db.Integer, primary_key=True)
size = db.Column(db.Integer)
def __repr__(self):
return f'Object: {self.oid}, Size: {self.size}'
@app.route('/')
def index():
return 'DSAP_2022'
@app.route('/data/<oid>', methods=['GET'])
def getObject(oid):
obj = Object.query.filter_by(oid=oid).first()
if obj is None:
return 'Object not found', 404
return repr(obj)
@app.route('/data', methods=['POST'])
def putObject():
obj = Object(oid=request.json['oid'], size=request.json['size'])
db.session.add(obj)
db.session.commit()
return 'OK'
if __name__ == '__main__':
app.run()
我正在使用 Postman 提交我的請求。并且 index() 有效，但是由于相同的錯誤，getObject 和 putObject 都不起作用。
uj5u.com熱心網友回復：
您永遠不會呼叫db.create_all()創建資料庫表。你需要類似的東西：
from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.sqlite3'
db = SQLAlchemy(app)
class Object(db.Model):
oid = db.Column(db.Integer, primary_key=True)
size = db.Column(db.Integer)
def __repr__(self):
return f'Object: {self.oid}, Size: {self.size}'
# Create tables corresponding to sqlalchemy models
db.create_all()
@app.route('/')
def index():
return 'DSAP_2022'
@app.route('/data/<oid>', methods=['GET'])
def getObject(oid):
obj = Object.query.filter_by(oid=oid).first()
if obj is None:
return 'Object not found', 404
return repr(obj)
@app.route('/data', methods=['POST'])
def putObject():
obj = Object(oid=request.json['oid'], size=request.json['size'])
db.session.add(obj)
db.session.commit()
return 'OK'
if __name__ == '__main__':
app.run()
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/488177.html
標籤：Python python-3.x 休息 烧瓶 要求