pymysql操作数据库

import pymysql

def main():
    _0 = [
        {'category_id': '20', 'category': '动漫专区', 'pictype': 0},
        {'category_id': '12', 'category': '日本', 'pictype': 0},
        {'category_id': '11', 'category': '系列', 'pictype': 0},
        {'category_id': '10', 'category': '系列', 'pictype': 0},
        {'category_id': '9', 'category': '专区', 'pictype': 0},
        {'category_id': '8', 'category': '优品', 'pictype': 0},
        {'category_id': '7', 'category': '家伦', 'pictype': 0},
        {'category_id': '6', 'category': '原频', 'pictype': 0},
    ]

    _1 = [{'category_id': '65', 'category': '恋', 'pictype': 1},
          {'category_id': '55', 'category': '课堂', 'pictype': 1},
          {'category_id': '53', 'category': '校园', 'pictype': 1},
          {'category_id': '52', 'category': '反差', 'pictype': 1},
          {'category_id': '51', 'category': '重密', 'pictype': 1},
          {'category_id': '49', 'category': '网星', 'pictype': 1},
          {'category_id': '48', 'category': '偷', 'pictype': 1},
          ]
    _10 = _1 + _0
    return _10


import pymysql

MYSQL_CONFIG = {
    'host': 'localhost',  # IP地址
    'port': 3306,  # 端口
    'user': 'root',  # 用户名
    'passwd': '123456',  # 密码
    'db': 'spider',  # 数据库
    'charset': 'utf8',  # 编码
}


def generate_sql(data_list):
    
    data = data_list[0]
    cols = ", ".join('`{}`'.format(k) for k in data.keys())
    val_cols = ', '.join('%({})s'.format(k) for k in data.keys())
    #sudu_category 改这个表名
    sql = """
    INSERT INTO sudu_category(%s) VALUES(%s)
    """ % (cols, val_cols)
    return sql


def main1():
    # student_list = [
    #     {'name': 'Tony', 'age': 19, 'sex': 'male'},
    #     {'name': 'Lisa', 'age': 18, 'sex': 'female'},
    #     {'name': 'Jack', 'age': 20, 'sex': 'male'}
    # ]
    student_list = main()

    conn = pymysql.connect(**MYSQL_CONFIG)  # 数据库连接
    cur = conn.cursor()  # 游标对象

    sql = generate_sql(student_list)

    cur.executemany(sql, student_list)
    conn.commit()

    cur.close()
    conn.close()


if __name__ == '__main__':
    main1()