python--异步操作mysql

import asyncio
import aiomysql


async def execute():
    # 网络IO操作：连接MSQL
    conn = await aiomysql.connect(host='localhost',port=3306,user='root', password='123456', db='crawler')

    # 网络IO操作：创建CUSOR
    cur = await conn.cursor()

    # 网络IO操作：执行SQL
    await cur.execute("select * from crawler_city_town limit 1")

    # 网络IO操作：获取SQL结果
    result = await cur.fetchall()
    print(result)

    # 网络IO操作：关闭连接
    await cur.close()
    conn.close()

asyncio.run(execute())


async def execute(host, password):
    # 网络IO操作：先去连接47.93.4.197:6379，遇到IO则自动切换任务，去连接47.93.4.198:6379
    conn = await aiomysql.connect(host='localhost',port=3306,user='root', password='123456', db='crawler')

    # 网络IO操作：遇到IO会自动切换任务
    cur = await conn.cursor()

    # 网络IO操作：遇到IO会自动切换任务
    await cur.execute("select * from crawler_city_town limit 1")

    # 网络IO操作：遇到IO会自动切换任务
    result = await cur.fetchall()
    print(result)

    # 网络IO操作：遇到IO会自动切换任务
    await cur.close()
    conn.close()
    print('结束', host)


task_list = [
    execute('47.93.4.197:6379', '123456'),
    execute('47.93.4.198:6379', '123456')
]
asyncio.run(execute())