Creating an Arbitrage Alert System from scratch using Python and Supabase Day 7— Scraping Flashscore Fixtures

Hey Guys, its Day 7 and today we will discuss some background and plan the next phase of this project.

Now that we have all of our teams scraped from each website, we will now move on to scraping and creating fixtures in a new db table which we will call football_fixtures. This table will contain fixture data such as unique match_id, team data and team common ids, league, match data and time. The idea here is to have fixtures stored here so that we can accurately compare each websites odds via the data in this table.

The tables fields will be the below-

On the screen as shown above where we create the table we will also add a number of foreign key relationships.

The first is the home_team_common_id will be a foreign key of the team_common_id in the football_teams_common table.

Hit save and repeat the process for away_team_common_id and league_common_id.

Create the new table and add the following new RLS policies.