Develop Mock for SQLite Cache Database for unit tests

[faza]

Create a mock version of our SQLite cache database to enhance our testing framework. This will allow our tests to run without interacting with the actual database, improving test speed and reliability while avoiding side effects on the development or production databases.

Acceptance Criteria:

• The mock should mimic the behavior of our actual SQLite cache DB schema and operations.
• Capability to set up predefined data states for testing specific database interactions.
• Include examples of unit tests utilizing the mock to validate database-related logic.