Flask第17讲 Flask SQLAlchemy快速示例

1、下载SQLAlchemy：pip install SQLAlchemy

2、创建db文件夹

3、导入flask_sqlalchemy

3.1> 配置初始化文件

db = SQLAlchemy(app)

3.2>创建数据库名

app.config['SQLALCHEMY_DATABASE_URI'] = r'sqlite:///./db/test.db'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

3.3》创建表
#定义表
class User(db.Model):
    # --表名--
    __tableneme__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20),unique=True)
    email = db.Column(db.String(100), unique=True)
    age = db.Column(db.Integer)
    add = db.Column(db.String)
    creat_date = db.Column(db.DateTime,default=datetime.now)

    def __init__(self,name,email,age,add,creat_date=datetime.now()):
        self.name = name
        self.email = email
        self.age = age
        self.add = add
        self.creat_date = creat_date

    #表现函