SQLAlchemy 框架高级查询操作and_ ,or_,in_ notin_, desc,asc,

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String



# 1.创建数据库引擎，链接数据库
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/sqlalchemy_s14?charset=utf8')

# 2.创建ORM基类
Base = declarative_base()


# 3.创建表
class Account(Base):
    __tablename__ = 'account'
    id = Column(Integer, primary_key=True)
    name = Column(String(32), nullable=False, unique=True)
    age = Column(Integer)
    gender = Column(String(32))


# 4.将所有继承Base的类序列化成数据表
Base.metadata.create_all(engine)
# Base.metadata.drop_all(engine)

1.增加

from sqlalchemy.orm import sessionmaker
from more_crud.create_table01 import engine,Account


# 1.创建session会话窗口，用于操作数据库中的数据表
Session = sessionmaker(bind=engine)
db_session = Session()


# 2.批量新增数据
account_all = [Account(name="杨幂",age=27,gender="女"),Account(name="迪丽热巴",age=25,gender="女"),Account(name