def executePrimeAllDatabases():
result = []
stats = StatLineDbLayer()
result.append(stats.dropTable())
careerTotalsResult = PrimeAllDatabasesResult.createCareerTotals()
for operations in careerTotalsResult:
result.append(operations)
# FK Constraints -- must go last
personsResult = PrimeAllDatabasesResult.createPersonTable()
for operation in personsResult:
result.append(operation)\
teamsResult = PrimeAllDatabasesResult.createTeamsTable()
for operation in teamsResult:
result.append(operation)
seasonResult = PrimeAllDatabasesResult.createSeasonTable()
for operation in seasonResult:
result.append(operation)
aliasResult = PrimeAllDatabasesResult.createAliasTable()
for operation in aliasResult:
result.append(operation)
result.append(stats.createTable())
return result
def ViewProfile(self, request, route):
env = Environment(loader=PackageLoader('PDOT', Configuration.pagesFolder))
dbLayer = PlayersDbLayer()
foundPlayer = dbLayer.queryById(route['playerId'])
aliasLayer = AliasDbLayer()
knownAliases = aliasLayer.getAliasesForOfficialName(foundPlayer.firstName, foundPlayer.lastName)
statLineLayer = StatLineDbLayer()
statsArray = statLineLayer.queryStatsForId(foundPlayer.uniqueId)
if foundPlayer.uniqueId is not None:
template = env.get_template(Configuration.webpageDirectory['playerProfile'])
return template.render(route=route, futureQuote=self.getFutureQuote(), serverVersion=DatabaseUtility.getVersion(),
playerName=foundPlayer.firstName + ' ' + foundPlayer.lastName,
uniqueId=foundPlayer.uniqueId,
firstName=foundPlayer.firstName,
lastName=foundPlayer.lastName,
height=foundPlayer.height,
weight=foundPlayer.weight,
born=foundPlayer.born,
playedFrom=foundPlayer.playedFrom,
playedTo=foundPlayer.playedTo,
aliases=knownAliases,
statsResults=statsArray,
url=self.url)
else:
template = env.get_template(Configuration.webpageDirectory['playerProfileError'])
return template.render(route=route, futureQuote=self.getFutureQuote(), serverVersion=DatabaseUtility.getVersion(),
uniqueId=route['playerId'],
url=self.url)
