R3 = Column(Integer, default=0)
R4 = Column(Integer, default=0)
R5 = Column(Integer, default=0)
total = Column(Integer, default=0)
toPar = Column(String(10), default="")
pos = Column(String(10), default="0")
class StatsModel(Base):
__tablename__ = 'StatsTable'
id = Column(Integer, autoincrement=True, unique=True)
__table_args__ = (PrimaryKeyConstraint('playerId', 'compLevelId',
'roundsPlayed', 'year',
'masterStat', 'minorStat'), )
playerId = Column(Integer, ForeignKey("PlayerTable.id"))
compLevelId = Column(Integer, ForeignKey("CompetitionLevelTable.id"))
year = Column(Integer, nullable=False, autoincrement=False)
roundsPlayed = Column(Integer, default=0)
masterStat = Column(String(10), default="")
minorStat = Column(String(10), default="")
statValue = Column(String(10), default="")
SportsModelSession = DatabaseConnection.CreateSportModelDBEngineSession(Base)
# sportsModelSession.add_all(
# [CompetitionLevel(name = "PGA Tour"),
# CompetitionLevel(name = "Web.com Tour"),
# CompetitionLevel(name = "Euro Tour")]
# )
# sportsModelSession.commit()
