def runQuerySeasonTeamCategory(self, season, team, force): query_file_path = os.getcwd() + '/db/' + inspect.stack()[1][3] + '.sql' file = open(query_file_path, 'r') query_sentence = file.read() return dbtool.executeQuery( self._db, query_sentence, [season, "%" + team + "%", season, "%" + team + "%"])
def queryPerformance(self, team): query_sentence = self.readQuery() return dbtool.executeQuery(self._db, query_sentence, ["%" + team + "%", "%" + team + "%"])
def queryGoalMinute(self, season, team, m_from, m_to): query_sentence = self.readQuery() return dbtool.executeQuery( self._db, query_sentence, [season, "%" + team + "%", m_from, m_to, season, "%" + team + "%"])
def queryOver25Category(self, season, team, force): query_sentence = self.readQuery() return dbtool.executeQuery( self._db, query_sentence, [force, force, season, "%" + team + "%", season, "%" + team + "%"])