Facebook Meta / SQL Database / Fast API / Facebook Groups Scrapper

Описание: Has Fast api application which has 1 root (andpoint) making a GET request to which - we get JSON with all groups and their all posts from the database
Every 2 hours Crone updates database and populates it with new information from facebook groups.
The list of Facebook groups are provided in TOML file
During the parsing process, if the group is not in the database, we create a new entry in the table Groups, where we record data about the new group
Database has the following columns of data:
The number of members in group, url link, group name. Posts which records the last 10 posts from every group. Column "author" (name), the text of the post, the date of publication. Must be a mandatory field Foreign Key, which points to a group of the table Groups, and to which group the post belongs.
Used SQLite for simplicity