SQLAlchemy是Python中最流行的ORM对象关系映射框架之一它提供了高效且灵活的数据库操作方式。本文将介绍如何使用SQLAlchemy ORM进行数据库操作。目录安装SQLAlchemy核心概念连接数据库定义数据模型创建数据库表基本CRUD操作查询数据关系操作事务管理最佳实践安装bashpip install sqlalchemy如果需要连接特定数据库还需安装相应的驱动程序bash# PostgreSQL pip install psycopg2-binary # MySQL pip install mysql-connector-python # SQLite (Python标准库已包含无需额外安装)核心概念Engine数据库连接的引擎负责与数据库通信Session数据库会话管理所有持久化操作Model数据模型类对应数据库中的表Query查询对象用于构建和执行数据库查询连接数据库pythonfrom sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker # 创建数据库连接引擎 # SQLite示例 engine create_engine(sqlite:///example.db, echoTrue) # PostgreSQL示例 # engine create_engine(postgresql://username:passwordlocalhost:5432/mydatabase) # MySQL示例 # engine create_engine(mysqlmysqlconnector://username:passwordlocalhost:3306/mydatabase) # 创建会话工厂 SessionLocal sessionmaker(autocommitFalse, autoflushFalse, bindengine) # 创建会话实例 session SessionLocal()定义数据模型pythonfrom sqlalchemy import Column, Integer, String, ForeignKey from sqlalchemy.orm import relationship, declarative_base # 创建基类 Base declarative_base() class User(Base): __tablename__ users id Column(Integer, primary_keyTrue, indexTrue) name Column(String(50), nullableFalse) email Column(String(100), uniqueTrue, indexTrue) # 定义一对多关系 posts relationship(Post, back_populatesauthor) class Post(Base): __tablename__ posts id Column(Integer, primary_keyTrue, indexTrue) title Column(String(100), nullableFalse) content Column(String(500)) author_id Column(Integer, ForeignKey(users.id)) # 定义多对一关系 author relationship(User, back_populatesposts) # 定义多对多关系通过关联表 tags relationship(Tag, secondarypost_tags, back_populatesposts) class Tag(Base): __tablename__ tags id Column(Integer, primary_keyTrue, indexTrue) name Column(String(30), uniqueTrue, nullableFalse) posts relationship(Post, secondarypost_tags, back_populatestags) # 关联表用于多对多关系 class PostTag(Base): __tablename__ post_tags post_id Column(Integer, ForeignKey(posts.id), primary_keyTrue) tag_id Column(Integer, ForeignKey(tags.id), primary_keyTrue)创建数据库表python# 创建所有表 Base.metadata.create_all(bindengine) # 删除所有表 # Base.metadata.drop_all(bindengine)基本CRUD操作创建数据python# 创建新用户 new_user User(name张三, emailzhangsanexample.com) session.add(new_user) session.commit() # 批量创建 session.add_all([ User(name李四, emaillisiexample.com), User(name王五, emailwangwuexample.com) ]) session.commit()读取数据python# 获取所有用户 users session.query(User).all() # 获取第一个用户 first_user session.query(User).first() # 根据ID获取用户 user session.query(User).get(1)更新数据python# 查询并更新 user session.query(User).get(1) user.name 张三四 session.commit() # 批量更新 session.query(User).filter(User.name.like(张%)).update({name: 张氏}, synchronize_sessionFalse) session.commit()删除数据python# 查询并删除 user session.query(User).get(1) session.delete(user) session.commit() # 批量删除 session.query(User).filter(User.name 李四).delete(synchronize_sessionFalse) session.commit()查询数据基本查询python# 获取所有记录 users session.query(User).all() # 获取特定字段 names session.query(User.name).all() # 排序 users session.query(User).order_by(User.name.desc()).all() # 限制结果数量 users session.query(User).limit(10).all() # 偏移量 users session.query(User).offset(5).limit(10).all()过滤查询pythonfrom sqlalchemy import or_ # 等值过滤 user session.query(User).filter(User.name 张三).first() # 模糊查询 users session.query(User).filter(User.name.like(张%)).all() # IN查询 users session.query(User).filter(User.name.in_([张三, 李四])).all() # 多条件查询 users session.query(User).filter( User.name 张三, User.email.like(%example.com) ).all() # 或条件 users session.query(User).filter( or_(User.name 张三, User.name 李四) ).all() # 不等于 users session.query(User).filter(User.name ! 张三).all()聚合查询pythonfrom sqlalchemy import func # 计数 count session.query(User).count() # 分组计数 user_post_count session.query( User.name, func.count(Post.id) ).join(Post).group_by(User.name).all() # 求和、平均值等 avg_id session.query(func.avg(User.id)).scalar()连接查询python# 内连接 results session.query(User, Post).join(Post).filter(Post.title.like(%Python%)).all() # 左外连接 results session.query(User, Post).outerjoin(Post).all() # 指定连接条件 results session.query(User, Post).join(Post, User.id Post.author_id).all()关系操作python# 创建带关系的对象 user User(name赵六, emailzhaoliuexample.com) post Post(title我的第一篇博客, contentHello World!, authoruser) session.add(post) session.commit() # 通过关系访问 print(f文章 {post.title} 的作者是 {post.author.name}) print(f用户 {user.name} 的所有文章:) for p in user.posts: print(f - {p.title}) # 多对多关系操作 python_tag Tag(namePython) sqlalchemy_tag Tag(nameSQLAlchemy) post.tags.append(python_tag) post.tags.append(sqlalchemy_tag) session.commit() print(f文章 {post.title} 的标签:) for tag in post.tags: print(f - {tag.name})事务管理python# 自动提交事务 try: user User(name测试用户, emailtestexample.com) session.add(user) session.commit() except Exception as e: session.rollback() print(f发生错误: {e}) # 使用事务上下文管理器 from sqlalchemy.orm import Session def create_user(session: Session, name: str, email: str): try: user User(namename, emailemail) session.add(user) session.commit() return user except: session.rollback() raise # 嵌套事务 with session.begin_nested(): user User(name事务用户, emailtransactionexample.com) session.add(user) # 保存点 savepoint session.begin_nested() try: user User(name保存点用户, emailsavepointexample.com) session.add(user) savepoint.commit() except: savepoint.rollback()最佳实践会话管理为每个请求创建新会话请求结束后关闭异常处理始终处理异常并适当回滚事务延迟加载注意N1查询问题使用 eager loading 优化连接池合理配置连接池大小和超时设置数据验证在模型层或应用层验证数据完整性python# 使用上下文管理器管理会话 from contextlib import contextmanager contextmanager def get_db(): db SessionLocal() try: yield db db.commit() except Exception: db.rollback() raise finally: db.close() # 使用示例 with get_db() as db: user User(name上下文用户, emailcontextexample.com) db.add(user)总结SQLAlchemy ORM提供了强大而灵活的数据库操作方式通过本文的介绍您应该能够安装和配置SQLAlchemy定义数据模型和关系执行基本的CRUD操作构建复杂查询管理数据库事务遵循最佳实践SQLAlchemy还有更多高级特性如混合属性、事件监听、自定义查询等值得进一步探索学习。https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1KDZhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KDWhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1KDUhttps://gitee.com/uhxmi402/drrkojgpmd/issues/IE1KDPhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KDOhttps://gitee.com/rljff657/mzmrchfrqs/issues/IE1KDIhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KDHhttps://gitee.com/rljff657/mzmrchfrqs/issues/IE1KDEhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KDChttps://gitee.com/orryk657/irzzqkzwms/issues/IE1KD9https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KD8https://gitee.com/dezon161/ctoglwpbph/issues/IE1KD7https://gitee.com/rdnai193/vvculbegtq/issues/IE1KD6https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KD5https://gitee.com/dezon161/ctoglwpbph/issues/IE1KD4https://gitee.com/orryk657/irzzqkzwms/issues/IE1KD0https://gitee.com/mruqf709/swptkzkbvx/issues/IE1KD3https://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KD1https://gitee.com/rdnai193/vvculbegtq/issues/IE1KCZhttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KCWhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KCThttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KCRhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KCOhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1KCKhttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KCJhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1KCHhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KCGhttps://gitee.com/rljff657/mzmrchfrqs/issues/IE1KCEhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1KCAhttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KC5https://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KC3https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1KC1https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KC0https://gitee.com/yljan750/uaxvswzqza/issues/IE1KBWhttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KBYhttps://gitee.com/micnq872/jfafdbycww/issues/IE1KBUhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1KBShttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KBOhttps://gitee.com/micnq872/jfafdbycww/issues/IE1KBMhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1KBLhttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KBIhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1KBHhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KBFhttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KBBhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1KB8https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1KBAhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KB7https://gitee.com/yljan750/uaxvswzqza/issues/IE1KB6https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KB5https://gitee.com/wcikz373/qhvjgruysq/issues/IE1KB1https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KAZhttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KAThttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KAQhttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KAMhttps://gitee.com/rljff657/mzmrchfrqs/issues/IE1KAJhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KAHhttps://gitee.com/wcikz373/qhvjgruysq/issues/IE1KAFhttps://gitee.com/rljff657/mzmrchfrqs/issues/IE1KAEhttps://gitee.com/dezon161/ctoglwpbph/issues/IE1KAAhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1KA6https://gitee.com/rljff657/mzmrchfrqs/issues/IE1KA5https://gitee.com/orryk657/irzzqkzwms/issues/IE1KA2https://gitee.com/iyajs331/cqqnrwspzr/issues/IE1KA0https://gitee.com/dezon161/ctoglwpbph/issues/IE1K9Yhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K9Thttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K9Ohttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K9Lhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K9Khttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K9Hhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1K9Ghttps://gitee.com/micnq872/jfafdbycww/issues/IE1K9Ehttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K9Chttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K99https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K98https://gitee.com/yljan750/uaxvswzqza/issues/IE1K94https://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K92https://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K91https://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K8Xhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K8Jhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K8Rhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K8Nhttps://gitee.com/micnq872/jfafdbycww/issues/IE1K8Mhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K8Khttps://gitee.com/micnq872/jfafdbycww/issues/IE1K8Ehttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K8Fhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K8Dhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K88https://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K89https://gitee.com/rdnai193/vvculbegtq/issues/IE1K85https://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K83https://gitee.com/micnq872/jfafdbycww/issues/IE1K80https://gitee.com/rdnai193/vvculbegtq/issues/IE1K7Whttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K7Shttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K7Ohttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K7Khttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K7Jhttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K7Fhttps://gitee.com/rkwmj028/qvomeiasrj/issues/IE1K7Ehttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K7Bhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K79https://gitee.com/rdnai193/vvculbegtq/issues/IE1K78https://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K72https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K71https://gitee.com/orryk657/irzzqkzwms/issues/IE1K6Zhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K70https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K6Yhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K6Shttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K6Thttps://gitee.com/rdnai193/vvculbegtq/issues/IE1K6Lhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K6Ihttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K6Fhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K6Ehttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K6Chttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K67https://gitee.com/orryk657/irzzqkzwms/issues/IE1K61https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K5Zhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K5Xhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K5Vhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K5Whttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K5Uhttps://gitee.com/micnq872/jfafdbycww/issues/IE1K5Thttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K5Rhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K5Ohttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K5Mhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K5Jhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K5Khttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K5Chttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K5Dhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K5Bhttps://gitee.com/micnq872/jfafdbycww/issues/IE1K5Ahttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K54https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K4Zhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K50https://gitee.com/micnq872/jfafdbycww/issues/IE1K4Uhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K4Whttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K4Thttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K4Shttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K4Phttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K4Qhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K4Jhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K4Hhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K4Ghttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K4Fhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K4Chttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K4Ahttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K49https://gitee.com/orryk657/irzzqkzwms/issues/IE1K39https://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K47https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K43https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K42https://gitee.com/jydjd116/gwptjucsdg/issues/IE1K3Yhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K3Vhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K3Thttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K3Shttps://gitee.com/yljan750/uaxvswzqza/issues/IE1K3Rhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K3Nhttps://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K3Mhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K3Lhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K3Hhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K3Ehttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K36https://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K35https://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K33https://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K30https://gitee.com/yyvtp015/alydnkhzqt/issues/IE1K2Zhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K2Xhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K2Uhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1K2Ohttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K2Mhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K2Fhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1K2Ghttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K1Thttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K2Bhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1K29https://gitee.com/orryk657/irzzqkzwms/issues/IE1K25https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K23https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1K21https://gitee.com/jydjd116/gwptjucsdg/issues/IE1K22https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K20https://gitee.com/yljan750/uaxvswzqza/issues/IE1K1Xhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K1Uhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K1Ohttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1K1Qhttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K1Lhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K1Khttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K1Ihttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1K1Dhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K1Fhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K1Ghttps://gitee.com/orryk657/irzzqkzwms/issues/IE1K1Ahttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K19https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K17https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1K13https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K11https://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K0Zhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1K10https://gitee.com/ghspc880/ttimpjmdpm/issues/IE1K0Vhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K0Uhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1K0Thttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K0Phttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1K0Ohttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1K0Nhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K0Jhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K0Hhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1K0Dhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1K0Ghttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1K0Fhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1K0Bhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1K09https://gitee.com/rbadn378/fwwhlxndtj/issues/IE1K08https://gitee.com/bkfhd295/cwjmwukugk/issues/IE1K05https://gitee.com/yljan750/uaxvswzqza/issues/IE1JZXhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZZhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1K01https://gitee.com/jydjd116/gwptjucsdg/issues/IE1JZThttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZUhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JZRhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JZOhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JZPhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZNhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JZJhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JZChttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JZHhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZEhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JZAhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1JZ9https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZ5https://gitee.com/yljan750/uaxvswzqza/issues/IE1JZ2https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JZ1https://gitee.com/iyajs331/cqqnrwspzr/issues/IE1JYYhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JYUhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JYThttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1JYRhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JYNhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JYMhttps://gitee.com/iyajs331/cqqnrwspzr/issues/IE1JYKhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JYEhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JYDhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JYBhttps://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JY7https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JY6https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JY2https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JY0https://gitee.com/rbadn378/fwwhlxndtj/issues/IE1JXYhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JXThttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JXRhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JXPhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JXNhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JXMhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JXLhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JXHhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JXGhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JXDhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JX9https://gitee.com/ceauo759/wutybscwnl/issues/IE1JX5https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JX6https://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JWWhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JWXhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JWUhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JWThttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JWShttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JWQhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JWOhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JWNhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JWLhttps://gitee.com/ncqsv159/kcwhakorkh/issues/IE1JWJhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JWGhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JWEhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JW9https://gitee.com/kzupu701/lgdbpnwgel/issues/IE1JW7https://gitee.com/qydqo733/xleosvzwda/issues/IE1JW4https://gitee.com/kzupu701/lgdbpnwgel/issues/IE1JW5https://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JW2https://gitee.com/yljan750/uaxvswzqza/issues/IE1JW0https://gitee.com/yljan750/uaxvswzqza/issues/IE1JVVhttps://gitee.com/kzupu701/lgdbpnwgel/issues/IE1JVWhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JVThttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JVRhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JVQhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JVPhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JVMhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JVKhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JVEhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JVChttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JVAhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JV8https://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JV5https://gitee.com/yljan750/uaxvswzqza/issues/IE1JV4https://gitee.com/qydqo733/xleosvzwda/issues/IE1JV2https://gitee.com/yljan750/uaxvswzqza/issues/IE1JUZhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JUYhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JUThttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JUShttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JURhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JULhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JUJhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JUKhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JUGhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JUFhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1JUEhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JUDhttps://gitee.com/yljan750/uaxvswzqza/issues/IE1JUBhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JUAhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JU7https://gitee.com/qydqo733/xleosvzwda/issues/IE1JU6https://gitee.com/udfay139/lunkufifdx/issues/IE1JU2https://gitee.com/qydqo733/xleosvzwda/issues/IE1JTYhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JTVhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JTShttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JTQhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1JTLhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JTIhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JTGhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JTEhttps://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JTDhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JTBhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JTAhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JT9https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JT8https://gitee.com/ceauo759/wutybscwnl/issues/IE1JT7https://gitee.com/ceauo759/wutybscwnl/issues/IE1JT5https://gitee.com/jydjd116/gwptjucsdg/issues/IE1JT3https://gitee.com/jydjd116/gwptjucsdg/issues/IE1JSXhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JSWhttps://gitee.com/bkfhd295/cwjmwukugk/issues/IE1JSVhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JSRhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JSLhttps://gitee.com/xshzy037/heyfqiscjd/issues/IE1JSFhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JSDhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JSBhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JSAhttps://gitee.com/xshzy037/heyfqiscjd/issues/IE1JS9https://gitee.com/ceauo759/wutybscwnl/issues/IE1JS8https://gitee.com/hyrye290/wbptsjfigr/issues/IE1JS7https://gitee.com/udfay139/lunkufifdx/issues/IE1JS6https://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JS5https://gitee.com/qydqo733/xleosvzwda/issues/IE1JS3https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JS0https://gitee.com/xshzy037/heyfqiscjd/issues/IE1JRUhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JRWhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JRRhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JRQhttps://gitee.com/jupqh308/ywjhgeodit/issues/IE1JRNhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JRLhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JRIhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JREhttps://gitee.com/xshzy037/heyfqiscjd/issues/IE1JRAhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JR8https://gitee.com/ceauo759/wutybscwnl/issues/IE1JR9https://gitee.com/udfay139/lunkufifdx/issues/IE1JR6https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JR4https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JR3https://gitee.com/hyrye290/wbptsjfigr/issues/IE1JR2https://gitee.com/ceauo759/wutybscwnl/issues/IE1JR1https://gitee.com/rlkuc654/ecitjnqnsc/issues/IE1JR0https://gitee.com/xshzy037/heyfqiscjd/issues/IE1JQVhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JQYhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JQShttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JQRhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JQPhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JQNhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JQLhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JQIhttps://gitee.com/jydjd116/gwptjucsdg/issues/IE1JQGhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JQChttps://gitee.com/udfay139/lunkufifdx/issues/IE1JQBhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JQ9https://gitee.com/jydjd116/gwptjucsdg/issues/IE1JQ6https://gitee.com/hyrye290/wbptsjfigr/issues/IE1JQ2https://gitee.com/qydqo733/xleosvzwda/issues/IE1JQ1https://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JQ0https://gitee.com/ceauo759/wutybscwnl/issues/IE1JPXhttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JPUhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JPQhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JPMhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JPIhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JPHhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JPEhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JPBhttps://gitee.com/ceauo759/wutybscwnl/issues/IE1JP8https://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JP5https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JP4https://gitee.com/udfay139/lunkufifdx/issues/IE1JP3https://gitee.com/jupqh308/ywjhgeodit/issues/IE1JOVhttps://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JOXhttps://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JORhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JOPhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JOKhttps://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JOGhttps://gitee.com/kpoxf064/qhgpzieput/issues/IE1JOEhttps://gitee.com/ghspc880/ttimpjmdpm/issues/IE1JOChttps://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JOBhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JO9https://gitee.com/kpoxf064/qhgpzieput/issues/IE1JO7https://gitee.com/udfay139/lunkufifdx/issues/IE1JO4https://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JO3https://gitee.com/hyrye290/wbptsjfigr/issues/IE1JNZhttps://gitee.com/cipyg633/oharhypnrc/issues/IE1JO0https://gitee.com/kpoxf064/qhgpzieput/issues/IE1JNXhttps://gitee.com/qpafg481/vpdnyvfqif/issues/IE1JNVhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JNThttps://gitee.com/udfay139/lunkufifdx/issues/IE1JNShttps://gitee.com/hrlyz432/bghzqudnmx/issues/IE1JNQhttps://gitee.com/cipyg633/oharhypnrc/issues/IE1JNPhttps://gitee.com/udfay139/lunkufifdx/issues/IE1JNNhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JNKhttps://gitee.com/cipyg633/oharhypnrc/issues/IE1JNHhttps://gitee.com/qydqo733/xleosvzwda/issues/IE1JNGhttps://gitee.com/xshzy037/heyfqiscjd/issues/IE1JNJhttps://gitee.com/xshzy037/heyfqiscjd/issues/IE1JNDhttps://gitee.com/hyrye290/wbptsjfigr/issues/IE1JNB