Feature: Setup async db integration/e2e tests

[ArielMAJ]

Type of feature

🍕 Feature

Current behavior

Currently, database isn't considered in tests.

Suggested solution

DB interaction should be tested with an async connection. The database should be dropped and recreated for every function using fixtures.

Additional context

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

Contributing Docs

• I agree to follow this project's Contribution Docs