#pip install flask_sqlalchemy
from flask_sqlalchemy import SQLAlchemy
from flask import Flask
app = Flask(_name_)
#创建数据库
app.config['SQLALCHEMY_DATABASE_URI'] = "sqlite:///"+"保存路径”
app.config['SQLALCHEMY_TRACK_MODIFICATTONS'] = False
app.config['SECRET_KEY'] = '*****'
db = SQLAlchemy(app)
#创建数据表
class Student(db.model)
__tablename__ = 'Student'
id = db.Column(db.Interger,primary_key=True)
name = db.Column(db.String(64),nullable = False)
gender = db.Column(db.Enum("男",“女”),nullable=False)
phone = db.Column(db.String(11),nullable = False)
class Course(db.model)
__tablename__ = 'Course'
name = db.Column(db.String(64),nullable=False)
teather_id = db.Column(db.Interger,primary_key=Ture)
id = db.Column(db.Interger,primary_key=True)
class Teacher(db.model)
__tablename__ = 'Teacher'
id = db.Column(db.Interger,primary_key=True)
name = db.Column(db.String(64),nullable=False)
gender = db.Column(db.Enum("男",“女”),nullable=False)
phone = db.Column(db.String(11),nullable = False)
class Grade(db.model)
__tablename__ = 'Grade'
id = db.Column(db.Interger,primary_key=True)
if __name__
flask_sqlalchemy
最新推荐文章于 2024-05-31 18:17:11 发布