use fixtures to properly test the db

[mariobassem]

currently, the only test for the database is the end-to-end test, where a lot of components are included beside the database.
to properly have unit tests for the database alone, we could have test fixtures, maybe using this. this way database results could be easily predicted and tested.

[xmonader]

nuse yabasha

[Nabil-Salah]

6-11-2024

I worked on a database insertions fixture
Started using fixtures to test db on getnode

[Nabil-Salah]

7-11-2024

I worked on making setup test to load a fresh version of the fixture database
Started using fixtures to test db on GetFarm and agreed on a file structure

[Nabil-Salah]

12-11-2024

work completed

writing test functions for the remaing database functions ( now all of server getters - indexer utils are tested )

Work in Progress

for (DeleteOldGpus - GetHealthyNodeTwinIds ) -> they will need more work on the database fixture

[Nabil-Salah]

13-11-2024

Work completed on a database fixture that test all database getters and indexers