数据持久化技术（Python）的使用

pip install pymysql

import pymysql
db = pymysql.connect(    # mysql 地址    host='182.92.129.158',    # 账号和密码    user='tmp',    password='ceshiren.com',    # 数据库    db='tmp',    charset='utf8mb4')
if __name__ == '__main__':    with db.cursor() as cursor:        # 查看数据库中有多少表        sql = "show tables;"        # 执行 sql 语句        cursor.execute(sql)        # 查看所有数据        print(cursor.fetchall())        # 查询 name = aaaaaa 的数据        sql = "select * from test_case_table where name=%s"        cursor.execute(sql, ["aaaaaa"])        print(cursor.fetchall())(('test_case_table',),)(('aaaaaa', '新的测试用例', 'test_hello.py', 'def test'),)

pip3 install SQLAlchemy

engine = create_engine("mysql+pymysql://tmp:ceshiren.com@182.92.129.158/tmp?charset=utf8",echo=True,)

from sqlalchemy import create_engine, Column, Integer, Stringfrom sqlalchemy.orm import declarative_base
engine = create_engine("mysql+pymysql://tmp:ceshiren.com@182.92.129.158/tmp?charset=utf8",                       echo=True,                       )# 其子类将 Python 类和数据库表关联映射起来Base = declarative_base()# 继承 Baseclass Users(Base):    __tablename__ = "users"
    id = Column(Integer, primary_key=True)    name = Column(String(64), unique=True)
    def __init__(self, name):        self.name = name
if __name__ == '__main__':    # 生成数据库表，如果有此库会忽略    Base.metadata.create_all(engine)

from sqlalchemy.orm import sessionmaker# 创建sessionSession = sessionmaker(bind=engine)session = Session()# 添加新数据add_user = Users("student1")# 提交session.add(add_user)session.commit()# 查询result = session.query(Users).filter_by(name="student1").first()print(result.id, result.name)

1 student1