async def delete_authors(postgres_pool: asyncpg.pool.Pool, authors_ids_to_delete: Set[int]): await asyncio.gather( postgres_pool.executemany( "DELETE FROM bookauthor WHERE author_id = $1", [(x, ) for x in authors_ids_to_delete] ), postgres_pool.executemany( "DELETE FROM author_annotation WHERE author_id = $1", [(x, ) for x in authors_ids_to_delete] ) ) await postgres_pool.executemany( "DELETE FROM author WHERE id = $1", [(x, ) for x in authors_ids_to_delete] )
async def delete_books(postgres_pool: asyncpg.pool.Pool, books_ids_to_delete: Set[int]): await asyncio.gather( postgres_pool.executemany("DELETE FROM bookauthor WHERE book_id = $1", [(x, ) for x in books_ids_to_delete]), postgres_pool.executemany("DELETE FROM seq WHERE book_id = $1", [(x, ) for x in books_ids_to_delete]), postgres_pool.executemany( "DELETE FROM book_annotation WHERE book_id = $1", [(x, ) for x in books_ids_to_delete]), postgres_pool.executemany("DELETE FROM translator WHERE book_id = $1", [(x, ) for x in books_ids_to_delete])) await postgres_pool.executemany("DELETE FROM book WHERE id = $1", [(x, ) for x in books_ids_to_delete])