早些年的简单测试数据库写入性能的脚本，完整版本不能放，初级的小部分放出来

早些年的简单测试数据库写入性能的脚本，完整版本不能放，初级的小部分放出来。

在这里插入代码片
import asyncio
import time
import pymysql
import datetime

db_config = {
    'host': '数据库IP',
    'port': '数据库端口',
    'username': '账户',
    'password': '密码',
    'database': '数据库名称',
    'charset': 'utf8'
}
# mysql 插入数据数量，单表单库， 
sql_nums = {
    'level_1': 10000,
    'level_2': 500000,
    'level_3': 500000,
    'level_4': 1000000,
    'level_5': 5000000,
    'level_6': 10000000
}
def connmysql():
    connect = pymysql.Connect(
        host=db_config['host'],
        port=int(db_config['port']),
        user=db_config['username'],
        passwd=db_config['password'],
        db=db_config['database'],
        charset=db_config['charset']
    )
    return connect

def inert_1():
    #demo int all
    db = connmysql()
    cur = db.cursor()
    uId = 11111
    xddUid = 111
    areaCode =1111
    phoneNumber ='aaaaaaaa'
    sqlbtc ="""insert into demos(uId,xddUid,areaCode,phoneNumber) values """
    sql1 = """ ( """
    sql2 = """ )"""
    for i in range(sql_nums['level_2']):
        sqlbtcs = sqlbtc + sql1 + str(uId) +','+ str(xddUid)+','+  str(areaCode)+','+ "'"+ str(phoneNumber) + "'"+ sql2 + ";"
        #print(sqlbtcs)
        aaa = cur.execute(sqlbtcs)
        db.commit()
    db.close()
    time.sleep(5)
    print('insert_1') 


def inert_2():
    db = connmysql()
    cur = db.cursor()
    #game 表    
    gname = '测试游戏'
    intro =  'ssssss'
    icon_pic =  'xxxxx'
    h5_back =  'xxxxx'
    H5_gift_img = 'xxxxxx'
    big_pic = 'xxxxxxx'
    isrecommend = 1
    islatest = 1
    nums = 1
    domain = 'xx'
    stype =1
    hashkey = 'asdasdasdasdas'
    orderid = 123
    fburl = 'xxxxx'
    eventurl = 'xxxxx'
    fbplayurl = 'xxxxxx'
    downloadurl = 'xxxxxxx'
    landerurl = 'xxxxxxxxx'
    androidurl = 'xxxxxxxx'
    androidurl2 = 'xxxxxxxxxx'
    iosurl = 'xxxxxxxx'
    status = 1
    close_time = 123456
    sstype =1
    best_pic = 'xxxxxx'
    logo_pic = 'xxxxxxx'
    uplinetime = 123456
    gamecoin = 'sssss'
    ishot =1
    isbest = 1
    iswebatm =1
    isrebate =1
    start =123456
    end = 123456
    share_name = 'aaaaaa'
    share_description = 'aaaaaa'
    share_caption = 'aaaaaaaaaa'
    share_link = 'aaaaaaaaaaa'
    share_picture = 'aaaaaaaaaaa'
    invite_title = 'aaaaaaaaaa'
    invite_message = 'aaaaaaaaaaaaaaa'
    fb_display_name = 'aaaaaaaaaaaaaa'
    rebate_1 = 'bbbbbbbbb'
    rebate_2 ='bbbbbbbbbb'
    rebate_3 ='bbbbbbbbbbbb'
    thdPackageName = 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
    packageName = 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
    gpPublicKey = 'sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss'
    first_pay_limit = 123
    independent = 1
    every_pay_limit = 123 
    vendor_sid = 123
    gpClientId = 'dddddddddddddddddddddddddddddddddddddd'
    is_run = 1
    is_recharge =1
    mobile_app_id = 'vvvvvvvvvvvvvvvvvvvvvvvv'
    three_terminal = 1
    cp_game_url = 'sssssssssssssssssssss'
    cp_game_stop_time = 123
    recharge_say =''
    recharge_type =1
    is_lander =1
    gamepage ='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
    box_open_subscribe =1
 
    sqlbtc ="""insert into gp_game_copy(gid,gname,intro,icon_pic,h5_back,H5_gift_img,big_pic,isrecommend,islatest,nums,domain,stype,hashkey,orderid,fburl,eventurl,fbplayurl,downloadurl,landerurl,androidurl,androidurl2,iosurl,status,close_time,type,best_pic,logo_pic,uplinetime,gamecoin,ishot,isbest,iswebatm,isrebate,start,end,share_name,share_description,share_caption,share_link,share_picture,invite_title,invite_message,fb_display_name,rebate_1,rebate_2,rebate_3,thdPackageName,packageName,gpPublicKey,first_pay_limit,independent,every_pay_limit,vendor_sid,gpClientid,is_run,is_recharge,mobile_app_id,three_terminal,cp_game_url,cp_game_stop_time,recharge_say,recharge_type,is_lander,gamepage,box_open_subscribe) values ("""
    sql2 = """ )"""
    for i in range(sql_nums['level_2']):
        gid = 1000 + i
        sqlbtcs = sqlbtc  + str(gid) +','+ "'"+ str(gname) + "'" + ','+ "'"+ str(intro) + "'" + ','+ "'"+ str(icon_pic) + "'" + ','+ "'"+ str(h5_back) + "'" + ','+ "'"+ str(H5_gift_img) + "'" + ','+ "'"+ str(big_pic) + "'" + ','+ str(isrecommend)  + ',' + str(islatest)  + ',' + str(nums)  + ',' + "'"+ str(domain)+ "'" + ','+ str(stype)  + ',' + "'"+ str(hashkey) + "'" + ','+ str(orderid)  + ',' + "'"+ str(fburl)+ "'" + ','+ "'"+ str(eventurl) + "'" + ','+ "'"+ str(fbplayurl) + "'" + ','+ "'"+ str(downloadurl) + "'" + ','+ "'"+ str(landerurl) + "'" + ','+ "'"+ str(androidurl) + "'" + ','+ "'"+ str(androidurl2) + "'" + ','+ "'"+ str(iosurl)+ "'" + ','+ str(status)  + ',' + str(close_time) + ',' + str(sstype)  + ',' + "'"+ str(best_pic) + "'" + ','+ "'"+ str(logo_pic) + "'" + ','+ str(uplinetime)  + ',' + "'"+ str(gamecoin) + "'" + ','+ str(ishot) + ',' + str(isbest)  + ',' + str(iswebatm) + ',' + str(isrebate)  + ',' + str(start) + ',' + str(end)  + ',' + "'"+ str(share_name) + "'" + ','+ "'"+ str(share_description) + "'" + ','+ "'"+ str(share_caption) + "'" + ','+ "'"+ str(share_link) + "'" + ','+ "'"+ str(share_picture) + "'" + ','+ "'"+ str(invite_title) + "'" + ','+ "'"+ str(invite_message)+ "'" + ','+  "'"+ str(fb_display_name) + "'" + ','+  "'"+ str(rebate_1) + "'" + ','+ "'"+ str(rebate_2) + "'" + ',  ' + "'"+ str(rebate_3) + "'" + ','+ "'" + str(thdPackageName) + "'" + ','+ "'"+ str(packageName) + "'" + ',' + "'"+ str(gpPublicKey) + "'" +',' + str(first_pay_limit)  + ',' + "'" +str(independent) +"'" + ',' + str(every_pay_limit) + ',' + str(vendor_sid) + ',' + "'"+ str(gpClientId) + "'" + ','+  str(is_run)  + ',' +  str(is_recharge) +',' +  "'"+ str(mobile_app_id) + "'" + ','+  str(three_terminal)  + ',' +  "'"+ str(cp_game_url) + "'" + ',' + str(cp_game_stop_time) + ',' + "'"+ str(recharge_say) + "'" + ','+ str(recharge_type) + ',' +  str(is_lander)  + ',' +"'"+ str(gamepage) + "'" + ','+ str(box_open_subscribe)  + sql2 +";"
        #print(sqlbtcs)
        
        aaa = cur.execute(sqlbtcs)
        db.commit()
    db.close()
    time.sleep(5)
    print('insert_2') 
    
    
def inert_3():
    time.sleep(5)
    print('insert_3') 
    
    
def inert_4():
    time.sleep(5)
    print('insert_4') 

def mains_1():
    db = connmysql()
    cur = db.cursor()
    print('gp_member start')
    start = time.time()
    str_name = 'testa_test_1'
    str_name2 = 'testa_test_2'
    str_name3 = 'testa_test_3'
    str_name4 = 'testa_test_4'
    str_name5 = 'testa_test_5'
    str_name6 = 'testa_test_6'
    str_passwd = 'c是大事大所大所多撒多a324'
    srt_email = '123456@qq.com'
    srt_stype = 'PARTNER'
    ustatus = 0
    isadmin = 0
    third_id = '奥术大师大所大所大所'
    thirdAuth = '是大事大所大4cdf8f3342853f2721c93bc'
    isbind= 0
    isformal=0
    mydot=0
    mycredit=0
    salt= '87ce0e'
    vip= 0
    vip_expires= 0
    bonus= 0
    getgifttime= 0
    bad_record= 0
    partner= 'asdasda'
    partner_uid= '奥术大师大所大'
    tmpemail= 'aaa'
    vipdot= 0
    giftdot= 0
    remitdot= 0
    platform=  'WEB'
    token= 'aaa'
    fb_token_business= '奥术大师大所多'
    regImei= 'aaa'
    createTime= 1657957495
    regOsId= 0
    areaCode= 60
    phoneNumber='01151354531'
    for i in range(sql_nums['level_2']):
    #for i in range(2):
      #print(i)
      str_uname = str_name2 + str(i)
      sqlbtc ="""insert into gp_member(username,password,email,stype,ustatus,isadmin,third_id,thirdAuth,isbind,isformal,mydot,mycredit,salt,vip,vip_expires,bonus,getgifttime,bad_record,partner,partner_uid,tmpemail,vipdot,giftdot,remitdot,platform,token,fb_token_business,regImei,createTime,regOsId,areaCode,phoneNumber) values """
      sql1 = """ ( """
      sql2 = """ )"""
      sqlbtcs = sqlbtc + sql1 + "'"+ str(str_uname) +"'"+','+ "'"+ str(str_passwd)+"'"+','+ "'"+ str(srt_email)+"'"+','+ "'"+ str(srt_stype)+"'"+','+ str(ustatus)+','+ str(isadmin) +','+ "'"+ str(third_id) +"'"+',' + "'"+ str(thirdAuth) + "'"+','+ str(isbind) +','+str(isformal)+','+ str(mydot) +','+ str(mycredit) +',' +"'"+ str(salt) + "'"+ ','+ str(vip) +','+ str(vip_expires) +','+ str(bonus) +','+ str(getgifttime) +','+ str(bad_record) +','+ "'"+ str(partner) + "'" + ','+ "'"+ str(partner_uid) + "'" + ','+"'"+ str(tmpemail)+ "'" + ','+str(vipdot) +','+ str(giftdot) +','+ str(remitdot) +','+"'"+ str(platform) +"'"+ ','+ "'"+ str(token) +"'"+ ','+ "'"+ str(fb_token_business) + "'"+ ','+ "'"+ str(regImei) + "'"+ ','+ str(createTime) +',' + str(regOsId)+ ','+ str(areaCode) +','+"'"+ str(phoneNumber) + "'"+ sql2 + ";"
    #print(sqlbtcs)
      aaa = cur.execute(sqlbtcs)
      db.commit()
    db.close()
    #print(time.time())
    end =  time.time()
    res = end - start
    print("本次操作执行时间为")
    print(res)

async def first():
    print('first函数调用开始,下面将会等待3秒模拟函数运行完毕')
    await asyncio.sleep(3)
    print('first函数执行完毕')
    print(time.time())


async def last():
    print(time.time())
    print('last函数调用开始')
    await asyncio.sleep(2)
    print('last函数执行完毕')


async def func(delay):
    print('开始异步同时执行的函数+延迟: ' + str(delay))
    await asyncio.sleep(2)
    print('--异步函数执行完毕+延迟: ' + str(delay))


async def main():
    await first()  # 这里先调用first()函数,并且等它执行完了才会开始
    await asyncio.gather(
        func(inert_1()),
        #func(inert_2()),
        #func(inert_3()),
        #func(inert_4()),
        #func(mains_1())
    )
    await last()


asyncio.run(main())