导入
# pip install flask_sqlalchemy
from flask_sqlalchemy import SQLAlchemy
#app = Flask(__name__)
# 创建数据库对象
db=SQLAlchemy(app)
#链接数据库
# 配置数据库
# 设置链接数据库的URI mysql+pymysql://数据库用户名:密码@ip:端口/数据库名
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql+pymysql://root:密码@IP地址:3306/数据库名" app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False
分析表结构
班级表
表名
grades
字段
name
boyNum
girlNum
isDelete
学生表
表名
students
字段
name
age
gender
content
grade_id
isDelete
class Student(db.Model):
#指定表名
__tablename__ = "students"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
age = db.Column(db.Integer)
gender = db.Column(db.Boolean)
content = db.Column(db.String(40))
isDelete = db.Column(db.Boolean, default=False)
#外键
# 表名.主键属性
# 数据库中对应字段名为grade(如果是Django字段会为grade_id)
grade = db.Column(db.Integer, db.ForeignKey("grades.id"))
def __init__(self, name, age, gender, content, grade):
self.name = name
self.age = age
self.gender = gender
self.content = content
self.grade = grade
class Student(db.Model):
#指定表名
__tablename__ = "students"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
age = db.Column(db.Integer)
gender = db.Column(db.Boolean)
content = db.Column(db.String(40))
isDelete = db.Column(db.Boolean, default=False)
#外键
# 表名.主键属性
# 数据库中对应字段名为grade(如果是Django字段会为grade_id)
grade = db.Column(db.Integer, db.ForeignKey("grades.id"))
def __init__(self, name, age, gender, content, grade):
self.name = name
self.age = age
self.gender = gender
self.content = content
self.grade = grade
if __name__ == '__main__': db.create_all()