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)