How to Set Up Session-Level Database Migrations in Python

How to set up session-level database fixtures for testing in a Python application. It runs migrations once per session to improve efficiency. It demonstrates how to truncate all tables between tests using SQL TRUNCATE ... CASCADE, and how to properly dispose of the database manager afterward — ensuring a clean, reliable, and performant async DB testing environment.