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)
def createAliasTable():
alias = AliasDbLayer()
return alias.dropAndRecreateTable()
