What is a good way to test data that changes dynamically?

I have made a Python program which scrapes data from a dataset and stores it into a PostgreSql database. The database is updated very frequently.

I have so far tried using mock and returning some fake data to test the different parts of the program. But, this definitely can't be the most effective way to test my code?

What will be some more efficient tests, as compared to this?

I need help on:

• What will be some better libraries (if any) as compared to unittest, to do this.

• If there is something more efficient than mock.

• Suggestions on test cases that I could put in place.

Thanks!