from datetime import datetime
import pymysql


conn = pymysql.connect(
    host='localhost',
    user='root',
    password='88zlcks',
    db='test',
    charset='utf8'
)

curs = conn.cursor(pymysql.cursors.DictCursor)

single_dict = {
    # 'id': 1,  # auto increment
    'name': 'live2skull',
    'insert_date': datetime.now().isoformat()
}

# insert only one row
sql = 'INSERT INTO test_table({keys}) VALUES({values})'.format(
    keys=','.join(single_dict.keys()),
    values=','.join(['%('+str(i)+')s' for i in single_dict.keys()]),
)
curs.execute(sql, single_dict)

# insert multiple rows
multiple_dict = [
    {
        # 'id': 2,  # auto increment
        'name': 'live2skull2',
        'insert_date': datetime.now().isoformat()
    },
    {
        # 'id': 3,  # auto increment
        'name': 'live2skull3',
        'insert_date': datetime.now().isoformat()
    },
]

sql = 'INSERT INTO test_table({keys}) VALUES({values})'.format(
    keys=','.join(multiple_dict[0].keys()),
    values=','.join(['%('+str(i)+')s' for i in multiple_dict[0].keys()]),
)
curs.executemany(sql, multiple_dict)

conn.commit()
conn.close()