def _get_match(self, racer_1, racer_2, week_number): params = (self._get_racer_id(racer_1), self._get_racer_id(racer_2), week_number) for row in self._db_conn.execute("SELECT timestamp,flags,number_of_races FROM match_data WHERE racer_1_id=? AND racer_2_id=? AND week_number=?", params): match = CondorMatch(racer_1, racer_2, week_number) if row[0]: match.set_from_timestamp(int(row[0])) match.flags = int(row[1]) match.set_number_of_races(int(row[2])) return match return None
def _get_match(self, racer_1, racer_2, week_number): params = (self._get_racer_id(racer_1), self._get_racer_id(racer_2), week_number) for row in self._db_conn.execute( "SELECT timestamp,flags,number_of_races FROM match_data WHERE racer_1_id=? AND racer_2_id=? AND week_number=?", params): match = CondorMatch(racer_1, racer_2, week_number) if row[0]: match.set_from_timestamp(int(row[0])) match.flags = int(row[1]) match.set_number_of_races(int(row[2])) return match return None
def get_upcoming_matches(self, time): matches = [] for row in self._db_conn.execute("SELECT racer_1_id,racer_2_id,week_number,timestamp,flags,number_of_races FROM match_data ORDER BY timestamp ASC"): racer_1 = self._get_racer_from_id(row[0]) racer_2 = self._get_racer_from_id(row[1]) week = int(row[2]) match = CondorMatch(racer_1, racer_2, week) match.flags = int(row[4]) match.set_number_of_races(int(row[5])) if match.confirmed and not match.played: match.set_from_timestamp(int(row[3])) if match.time - time > datetime.timedelta(minutes=-30): matches.append(match) return matches
def get_upcoming_matches(self, time): matches = [] for row in self._db_conn.execute( "SELECT racer_1_id,racer_2_id,week_number,timestamp,flags,number_of_races FROM match_data ORDER BY timestamp ASC" ): racer_1 = self._get_racer_from_id(row[0]) racer_2 = self._get_racer_from_id(row[1]) week = int(row[2]) match = CondorMatch(racer_1, racer_2, week) match.flags = int(row[4]) match.set_number_of_races(int(row[5])) if match.confirmed and not match.played: match.set_from_timestamp(int(row[3])) if match.time - time > datetime.timedelta(minutes=-30): matches.append(match) return matches