我對庫 lask-sqlalchemy 有一些困難，我嘗試使用下面的代碼創建我的數據庫，我沒有錯誤但沒有創建表。_init.pyfrom flask import Flaskfrom flask_cors import CORSapp = Flask(__name__)CORS(app)app.config.from_json("C:/Users/lquastana/PycharmProjects/flask_demo/conf/api-config.json")app.app_context().push()數據庫.pyfrom flask_sqlalchemy import SQLAlchemyfrom api_lab import appdb = SQLAlchemy(app)成員.pyfrom api_lab.models.db import dbclass Member(db.Model): __table_args__ = {"schema": "public"} id = db.Column(db.BigInteger, primary_key=True, autoincrement=True) id_company = db.Column(db.BigInteger, db.ForeignKey("compagny.id"), index=True, nullable=False) nom = db.Column(db.String(80), unique=True, nullable=False) age = db.Column(db.Integer, unique=True, nullable=False) def __repr__(self): return '<Member %r>' % self.nomrun_api.pyfrom api_lab import appfrom api_lab.models.db import dbdef main(): host = app.config["ENV"]["HOST"] port = app.config["ENV"]["PORT"] debug = app.config["ENV"]["DEBUG"] app.run(host=host, port=port, debug= debug)if __name__ == '__main__': db.create_all() #main()
1 回答
慕斯王
TA貢獻1864條經驗 獲得超2個贊
您應該將所有與初始化相關的邏輯放入init .py 使用 SQLAlchemy 設置與您的 app.config 的數據庫連接
初始化.py
from api_lab import app
from api_lab.models.db import db
from flask_sqlalchemy import SQLAlchemy
app.config.from_json("C:/Users/lquastana/PycharmProjects/flask_demo/conf/api-config.json")
app.app_context().push()
db = SQLAlchemy(app)
# initialize the DB
db.create_all()
添加回答
舉報
0/150
提交
取消