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
