Flask MySQL 增删改查 demo

# -*- coding: utf-8 -*-
from helloFlask import app
from flask_sqlalchemy import SQLAlchemy

app.config[
    'SQLALCHEMY_DATABASE_URI'] = 'mysql://root:******@localhost:3306/my_db'  # 这里登陆的是root用户，要填上自己的密码，MySQL的默认端口是3306，填上之前创建的数据库名text1
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True  # 设置这一项是每次请求结束后都会自动提交数据库中的变动
db = SQLAlchemy(app)  # 实例化


class Role(db.Model):
    __tablename__ = 'roles'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64), unique=True)


if __name__ == "__main__":
    # 执行创建表
    # db.create_all()

    # 插入一条数据
    # db.session.add(Role(name="zhangsan"))
    # db.session.commit()

    # 插入多条数据
    # users=[Role(name="lisi"),Role(name="wangwu"),Role(name="zhaosi")]
    # db.session.add_all(users)
    # db.session.commit()

    # 获取所有数据
    # users=Role.query.all()
    # for user in users:
    #     print user.name

    # 获取第一条数据
    # user1=Role.query.first()
    # print user1.name

    # 获取name=zhangsan的user
    # user2=Role.query.filter_by(name='zhangsan').first()
    # print user2.name

    # select * from roles where name='zhangsan'and xxx
    # user3 = Role.query.filter_by(name='zhangsan', id=1).first()
    # print user3.name

    #更新数据
    # user3 = Role.query.filter_by(name='zhangsan', id=1).first()
    # user3.name='zhangsi'
    # db.session.commit()

    #删除
    user3 = Role.query.filter_by(name='zhangsi', id=1).first()
    db.session.delete(user3)
    db.session.commit()