tracinginsights/api

1from sqlalchemy import Column, Float, Integer, String2from sqlalchemy.ext.declarative import declarative_base3 4# from . import database5 6import database7 8 9class RacePace(database.Base):10    __tablename__ = "race_pace"11 12    id = Column(Integer, primary_key=True, autoincrement=True, index=True)13    year = Column(Integer)14    event = Column(String)15    session = Column(String)16    Driver = Column(String)17    LapTime = Column(Float)18    Diff = Column(Float)19    Team = Column(String)20    fill = Column(String)21 22 23class TopSpeed(database.Base):24    __tablename__ = "top_speed"25 26    id = Column(Integer, primary_key=True, autoincrement=True, index=True)27    year = Column(Integer)28    event = Column(String)29    session = Column(String)30    driver = Column(String)31    top_speed = Column(Integer)32    compound = Column(String)33    team = Column(String)34    fill = Column(String)35 36 37class Overtakes(database.Base):38    __tablename__ = "overtakes"39 40    id = Column(Integer, primary_key=True, autoincrement=True, index=True)41    year = Column(Integer)42    event = Column(String)43    driver = Column(String)44    overtakes = Column(Integer)45    overtaken = Column(Integer)46 47 48class FastestLap(database.Base):49    __tablename__ = "fastest_lap"50 51    id = Column(Integer, primary_key=True, autoincrement=True, index=True)52    year = Column(Integer)53    event = Column(String)54    session = Column(String)55    driver = Column(String)56    lap_time = Column(Float)57    diff = Column(Float)58    team = Column(String)59    fill = Column(String)60 61 62class DriverStandings(database.Base):63    __tablename__ = "driver_standings"64 65    id = Column(Integer, primary_key=True, autoincrement=True, index=True)66    year = Column(Integer)67    driver = Column(String)68    points = Column(Integer)69    car = Column(String)70    fill = Column(String)71 72 73class AvailableYears(database.Base):74    __tablename__ = "available_years"75 76    id = Column(Integer, primary_key=True, autoincrement=True, index=True)77    year = Column(Integer)78 79 80class AvailableEvents(database.Base):81    __tablename__ = "available_events"82 83    id = Column(Integer, primary_key=True, autoincrement=True, index=True)84    year = Column(Integer)85    event = Column(String)86 87 88class AvailableSessions(database.Base):89    __tablename__ = "available_sessions"90 91    id = Column(Integer, primary_key=True, autoincrement=True, index=True)92    year = Column(Integer)93    event = Column(String)94    session = Column(String)95 96 97class AvailableDrivers(database.Base):98    __tablename__ = "available_drivers"99 100    id = Column(Integer, primary_key=True, autoincrement=True, index=True)101    color = Column(String)102    label = Column(String)103    value = Column(String)104