Running tests leaves data in the DB when finished.

[SuperPauly]

Describe the bug So this might be the config I have used. But I've noticed after I run the tests it leaves data in files, messages, conversations, collections and users tables possibly more.

To Reproduce Steps to reproduce the behaviour: Run the integration tests.

Expected behavior After the tests run it should clear out all data created and inserted.

Desktop (please complete the following information): r2r v3.5.10

Additional context Not sure if this was intended to be run on a 'test_db' or 'postgres' database but it leaves data in both after it's done.

Also, I'm curios to why the conftest.py are different in how they connect. The Unit tests it looks for an environment variables connection string but in the integration tests it uses inheritance from the R2RAsyncClient and R2RClient modules? How come 2 different methods of connecting to the DB, wouldn't i be easier to use 1 method.

Thanks.