继承sqlalchmey 来创建操作数据库（一次添加多个用户）

from datetime import datetime
from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData, ForeignKey, Text, DateTime
import pymysql


#创建数据库连接
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

engine = create_engine(
    "****:3306/aitest?charset=utf8"
)

Base = declarative_base()
# 定义表
class Log(Base):
    """
    日志表定义
    """
    __tablename__='logs'

    id = Column(Integer, primary_key=True)
    uid = Column(Integer)
    type = Column(String(255))
    username = Column(String(50))
    create_time = Column(DateTime, default=datetime.now)
    params = Column(Text, default='')


 # 创建数据表，如果数据表存在，则忽视
Base.metadata.create_all(engine)

if __name__=='__main__':
    Session=sessionmaker(bind=engine)
    session=Session()
    logs1=Log(uid=1,type="add",username="admin",params="添加数据……")
    logs2 = Log(uid=1, type="delete", username="admin", params="删除数据……")
    logs3 = Log(uid=1, type="change", username="admin", params="改变数据……")

    session.add_all([logs3,logs2,logs1])
    session.commit()