利用python3插入多条MySQL语句(python脚本)

下载模块

pip3 install pymysql

python脚本

#!/usr/bin/python3
#插入多数据
#导入模块
import pymysql
li = []
#创建连接
conn = pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    passwd='123456',
    db='host_info',
    charset='utf8mb4'
)
# 获取游标
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
# 定义想要插入的数据数据
base_info = [{
    "manufacturer": "VMware, Inc.",
    "pod_name": "VMware7,1",
    "sn": "VMware-56 4d 2d 4c 91 1e 48 15-5b d2 73 9c ec 98 da 22",
    "host_name": "sharkyum.com",
    "kernel": "3.10.0-957.el7.x86_64",
    "os": "CentOS Linux release 7.6.1810 (Core)",
    "cpu_name": "Intel(R) Core(TM) i5-5350U CPU @ 1.80GHz"},
    {
    "manufacturer": "VMware, Inc.",
    "pod_name": "VMware7,1",
    "sn": "VMware-56 4d 2d 4c 91 1e 48 15-5b d2 73 9c ec 98 da 22",
    "host_name": "sharkyum.com",
    "kernel": "3.10.0-957.el7.x86_64",
    "os": "CentOS Linux ",
    "cpu_name": "Intel(R) Core(TM) i5-5350U CPU @ 1.80GHz"}]
#定义sql语句
sql = '''
    insert into base_info(
    manufacturer, pod_name,
    sn, host_name,
    kernel, os, cpu_name)
    values(%s, %s, %s, %s, %s, %s, %s);'''
def foo():
    #把数据放到列表中
    for i in base_info:
        infos = tuple(i.values())
        li.append(infos)
# 执行 sql 语句
    cursor.executemany(sql, li)
    # 提交更改
    conn.commit()
    # 关闭游标对象
    cursor.close()
    # 关闭连接对象
    conn.close()
foo()