def getTeamSeasonId(teamSeason):
if teamSeason.id > 0:
return teamSeason.id
teamSeasonSchema = TeamSeasonTranslator.toSchema(teamSeason)
fromTable = TeamSeasonsTable.retrieveByTeamAndSeason(
teamSeasonSchema.team, teamSeasonSchema.season)
if fromTable is not None:
return fromTable.id
return TeamSeasonsTable.create(teamSeasonSchema)
def setup():
if not DatabaseSetup.tableExists(TeamsTable.name):
TeamsTable.createTable()
TeamsTable.populateTable()
if not DatabaseSetup.tableExists(TeamSeasonsTable.name):
TeamSeasonsTable.createTable()
if not DatabaseSetup.tableExists(PlayersTable.name):
PlayersTable.createTable()
if not DatabaseSetup.tableExists(BattingSeasonsTable.name):
BattingSeasonsTable.createTable()
if not DatabaseSetup.tableExists(PitchingSeasonsTable.name):
PitchingSeasonsTable.createTable()
def __createTeamSeason(self):
teamSeasonSchema = TeamSeasonSchema()
teamSeasonSchema.team = self.teamId
teamSeasonSchema.season = self.season
teamSeasonId = TeamSeasonsTable.create(teamSeasonSchema)
teamSeasonSchema.id = teamSeasonId
return TeamSeasonTranslator.toDomain(teamSeasonSchema)
def getTeamSeason(teamSeasonId):
teamSeasonSchema = TeamSeasonsTable.retrieve(teamSeasonId)
return TeamSeasonTranslator.toDomain(teamSeasonSchema)
def getValue(teamId):
teamSeasonsForTeam = TeamSeasonsTable.retrieveByTeam(teamId)
if len(teamSeasonsForTeam) > 0:
teamSeasonsForm = TeamSeasonSelection.buildForm(teamSeasonsForTeam)
return int(prompt(teamSeasonsForm)['season'])
return None
def __getExistingTeamSeason(self):
return TeamSeasonsTable.retrieveByTeamAndSeason(
self.teamId, self.season)