# -*- 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()