python3连接mysql及批量插入数据

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2018/4/13 0013 16:33
# @Author  :
# @QQ      : 
# @File    : py_con_mysql.py
# @Software: PyCharm Community Edition
"""
python connect mysql
"""
import os
import json
import pymysql

def conn_1():
    #mysql_conf = {'host': '10.0.0.0', 'port': 3306, 'user': 'dev', 'password': 'sctele@dev', 'db': 'test', 'charset': 'utf8'}
    mysql_conf = json.load(
        open(os.path.abspath(os.path.join(os.path.dirname(__name__)