代码
import pymysql
pymysql.install_as_MySQLdb()
from sqlalchemy import create_engine, Column, Integer, String, update
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
# 数据库连接信息
engine = create_engine('mysql://root:liziyi666@localhost:3306/作业', echo=True)
# engine = create_engine("mysql://username:password@hostname:port/dbname", echo=True)
# db = pymysql.connect(host="localhost", port=3306, user="root", password="liziyi666", db="douban",
# charset="utf8")
# 创建 Session 对象
Session = sessionmaker(bind=engine)
session = Session()
# 创建一个基类,用于定义数据表模型
# Base = declarative_base()
from sqlalchemy.orm import declarative_base
Base = declarative_base()
# 定义数据表模型
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String(10))
age = Column(Integer)
# 创建数据表
Base.metadata.create_all(engine)
# 插入数据
session.add_all([
User(name='Alice', age=25),
User(name='Bob', age=30),
User(name='Charlie', age=35)
])
# 提交更改
session.commit()
# 更新数据
session.query(User).filter_by(name='Bob').update({User.age: 40})
# 提交更改
session.commit()
# 删除数据
session.query(User).filter_by(name='Charlie').delete()
# 提交更改
session.commit()
# 查询数据
print(session.query(User).all())
结果展示