使用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)
