SqlAlchemy MySql 批量保存数据

使用SqlAlchemy 使用SQL 语句 批量保存数据

from sqlalchemy import create_engine

engine = create_engine('mysql://user:pwd@host:port/db_name')
session = engine.connect()

data = [
        (1,2),
        (3,5),
        (4,6),
    ]
# or
data = [
        [1,2],
        [3,5],
        [4,6],
    ]
    
session.execute("INSERT INTO `test`(`val`,`testcol`)VALUES( %s, %s);" , data)


 data = [
        {"val" :1  ,"testcol": 2 },
        {"val" :3  ,"testcol": 5 },
        {"val" :4  ,"testcol": 6 },
    ] 
    
session.execute("INSERT INTO `test`(`val`,`testcol`)VALUES( %(val)s, %(testcol)s);" , data)

http://docs.sqlalchemy.org/en/latest/core/tutorial.html