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()