from flask_sqlalchemy import *
from flask import *
DIALCT = "mysql"
DRIVER = "pymysql"
USERNAME = "root"
PASSWORD = "xzh123456"
HOST = "192.168.0.xx"
PORT = "3306"
DATABASE = "Plate"
DB_URI = "{}+{}://{}:{}@{}:{}/{}?charset=utf8".format(DIALCT, DRIVER, USERNAME, PASSWORD, HOST, PORT, DATABASE)
app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = DB_URI
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['DEBUG'] = True
app.config['JSON_AS_ASCII'] = False
db = SQLAlchemy(app)
class User(db.Model):
__tableName__ = "user"
username = db.Column(db.String(50), primary_key=True)
password = db.Column(db.String(50), nullable=False)
address = db.Column(db.String(50), nullable=False)
phone = db.Column(db.String(50), nullable=False)
db.create_all()
Flask中flask_sqlalchemy使用
最新推荐文章于 2024-03-23 19:45:52 发布