Creating an Arbitrage Alert System from Scratch using Python and Supabase Day 10 — Posting Fixture Data to Database

Welcome Back Everyone, Its day 10 and today we will go through the method for scraping and adding fixtures to our database finally. The full code can be found here —

GitHub - paulc160/day_10_code

For now the code is messy, but I will spend the next few days creating a real structured project and make all of this into its own file and functions.

Let me know if you have any issues running this code.

To begin there is one slight change we need to make in our database. You need to add a new column called time_scraped and this can just be of type text.

Now moving into the code there is a change I have made to the driver_code function which holds our logic to create a chromedriver instance.

driver.maximize_window()

This function will start chromedriver maximized instead, which should prevent any issues such as chromeriver being unable to click elements as they are not shown on screen.

I have also added 4 new arrays to our flashscore scraper as shown below, which are self explanatory.

home_teams = []
away_teams = []…