Tests should be performed on a SQLite test db

[igorbenav]

No description provided.

[igorbenav]

Maybe just overriding the dependency will be a simpler solution with the same benefits

[mithun2003]

In one of our projects, we encountered an issue with a test case. The problem was identified in the following code snippet:

`async def async_get_db() -> AsyncSession:
     async_session = local_session
     async with async_session() as db:
         yield db
         db.commit()`

The last db.commit() statement was saving data to the database during test execution. Upon removing this line, the data was no longer saved during testing, and the test case started working as expected. It's worth noting that regular database data saving continued to function properly.

[igorbenav]

Hey, @mithun2003, thanks! I'll change it. I should also fix the tests and do this migration to SQLite as soon as possible, trying to find the time