Python asyncio.sleep 表现得像一个拦截器

It is not asyncio.sleep that is blocking you here. It is that you await each coroutine store in your for-loop. That means literally you wait for it to execute completely before continuing with your iteration.

If you want to schedule each coroutine immediately, but not wait for it to finish, you can use asyncio.create_task on them. Just make sure to await all the tasks at some point.

Here is a simplified example:

from asyncio import create_task, gather, run, sleep


async def store(text: str, delay: bool = False) -> None:
    print(text)
    if delay:
        await sleep(5)


texts = [
    ("hi", False),
    ("how", False),
    ("are", False),
    ("you", True),
]


async def run_tests() -> None:
    last_finished: str | None = None
    tasks = []
    for text, delay in texts:
        tasks.append(create_task(store(text, delay=delay)))
        if not delay:
            last_finished = text
    await gather(*tasks)
    assert last_finished == "are"


if __name__ == "__main__":
    run(run_tests())

I used asyncio.gather here for convenience to await all the tasks at the end.

If you are on Python >=3.11, you can use a asyncio.TaskGroup context manager instead:

from asyncio import TaskGroup, run, sleep

...

async def run_tests() -> None:
    last_finished: str | None = None
    async with TaskGroup() as task_group:
        for text, delay in texts:
            task_group.create_task(store(text, delay=delay))
            if not delay:
                last_finished = text
    assert last_finished == "are"

But I have to say the variable naming you use is a bit confusing because last_finished suggests that the coroutine that was scheduled last (with the "are" text) is also the one that is done last. That is not true in general!

Once a coroutine is scheduled, there are no inherent guarantees that it will finish before or after some other scheduled coroutine, no matter which was scheduled first. To ensure that, you would have to make use of some sort of synchronization primitive.

Depending on the actual context, this may be especially important because you were talking about writing things to a database. But in this super simple example the order is likely to hold true.