Database for HK racing

I would like someone to write python code to screen scrape data from the [login to view URL] website. Sorry for the abrupt nature of the instructions below. It was for internal use only. Hong Kong Racing Database Spec We want a database for Hong Kong racing. Full data goes back to 2008-2009 season. They generally race two days a week. Do it in sqlite3. It is on python already by default. Please comment all code 1. Need 2 tables in database. HorseTable Fields: RaceID, Place, HorseNumber, HorseName, HorseID, JockeyName, JockeyID, TrainerName, TrainerID, ActualWeight, DeclaredWeight, Draw, FinishTime, WinOdds, Gear, 1stSectPos, 1stSectDist, 2ndSectPos, 2ndSectDist, 3rdSectPos, 3rdSectDist, 4thSectPos, 4thSectDist, 5thSectPos, 5thSectDist, 6thSectPos, 6thSectDist RaceTable Fields: RaceID, RaceNumber, Date, CourseName, Class, Distance, PrizeMoney, Going, CourseDescription, SectTime1, SectTime2, SectTime3, SectTime4, SectTime5, SectTime6 Add anything else to fields you think we might need? 2. Need Python code to setup database (sqlite3 example) import sqlite3 # set up new database conn = [login to view URL]("D:\\bf_only_soccer\\[login to view URL]") conn.text_factory = str cur = [login to view URL]() # create new table [login to view URL]("CREATE TABLE main(event_id INT, HL FLOAT, HB FLOAT, AL FLOAT, AB FLOAT)") # insert string of values 'x' into table [login to view URL]("INSERT INTO main VALUES (?,?,?,?,?);", x) 3. Need Python code to screen scrape all historical data from [login to view URL] [login to view URL] 4. Need Python code that will automatically update database after each new race