`_drop_tables()` uses a separate database connection, which means that with a sqlite in-memory database it operates on a different database. Rather create the tables at the beginning of each test using the database layer directly instead of going through the API.