django 按天水平分表并插入数据

    db = pymysql.connect("localhost", "数据库管理员名", "数据库密码", "数据库名")
    cursor = db.cursor()

    unix_time = str(int(time.time()))
    win_time = datetime.datetime.now().strftime('%Y%m%d')
    table_name = 'engineeringdata' + win_time

    sql_create = 'create table if not exists %s like engineeringdata' % table_name
    insert_sql1 = 'insert into %s' % table_name
    insert_sql2 = '(date,type,IDproject,value) values(%s,%s,%s,%s)'
    insert_sql = insert_sql1 + insert_sql2
    print(insert_sql)
    value_insert = [unix_time, '1', '1', '1']

    cursor.execute(insert_sql, value_insert)
    cursor.close()
    db.commit()