使用ORM新增数据在Mysql中的操作步骤

user_obj = User(
username="use1",
passWord="123456",
real_name = "用户1",
age=12
)

#  添加1个对象
session.add(user_obj)

#  添加多个对象
session.add_all([user1,user2,user3])

# 方法一 实例化session
from sqlalchemy.orm import Session

with Session(engine) as session:
    session.add(User())
    session.commit()

#  方法二 使用工厂函数创建
from sqlalchemy.orm import sessionmaker

Session = sessionmaker(engine)

with Session.begin()  as session:
    session.add(User())

with Session(engine) as  session:
    session.add（user_obj）
    session.add_all([user1,user1,user1])
    session.commit()

with Session(engine) as session:
    session.begin()
    try:
        session.add(user1)
        session.add(user2)
    except:
        session.rollback()
        raise
    else:
        session.commit()