scratchings/races.py

import model
import database
import arrow


venues = model.scrape_racenet_races_page()

query = """
    INSERT INTO race_program (
        race_date, venue, state, race, start_time, utctime)
    VALUES (%s, %s, %s, %s, %s, %s)
    ON CONFLICT (utctime) DO UPDATE SET
        race_date = excluded.race_date,
        race = excluded.race,
        start_time = excluded.start_time,
        state = excluded.state
"""
db = database.db
cursor = db.cursor()
if len(venues) > 0:
    for venue in venues:
        cursor.execute(query, venue)
    db.commit()
cursor.close()
db.close()