def test_team1_winner(self): self.team1 = Team("Team 1", "Edinburgh, Scotland", "Murrayfield", 67000, 4, 0, 4, 0, 4, 2) self.fixture = Fixture(self.team1, self.team2) self.assertEqual(2, self.team1.score) self.assertEqual(1, self.team2.score) self.assertEqual(self.fixture.team1.team_name, self.fixture.determine_winner(self.team1, self.team2))
def create_fixture(): team1 = request.form["team1_id"] team2 = request.form["team2_id"] team1 = team_repository.select(team1) team2 = team_repository.select(team2) new_fixture = Fixture(team1, team2) fixture_repository.save(new_fixture) return redirect("/fixtures")
def select(id): sql = "SELECT * FROM fixtures WHERE id = %s" values = [id] result = run_sql(sql, values)[0] team1 = team_repository.select(result["team1_id"]) team2 = team_repository.select(result["team2_id"]) fixture = Fixture(team1, team2, result['team1_score'], result['team2_score'], id) return fixture
def update_team(id): team1 = request.form["team1"] team2 = request.form["team2"] # team1.score = request.form["fixture.team1.score"] # team2.score = request.form["fixture.team2.score"] fixture = Fixture(team1, team2, id) fixture_repository.update(fixture) return redirect("/fixtures")
def create_fixture(): team1 = request.form["team1"] team2 = request.form["team2"] fixture = Fixture(team1, team2, id) if (fixture.team1 == fixture.team2): return redirect("/fixtures") else: fixture_repository.save(fixture) return redirect("/fixtures")
def get_fixture(path_to_file) -> []: fixture = [] with open(path_to_file, 'r') as csvfile: f_csv = csv.reader(csvfile, delimiter=',') next(f_csv) for f in f_csv: fix = Fixture(date=f[0],local=int(f[1]),visitante=int(f[2])) fixture.append(fix) return fixture
def select_all(): fixtures = [] sql = "SELECT * FROM fixtures" results = run_sql(sql) for result in results: team1 = team_repository.select(result["team1_id"]) team2 = team_repository.select(result["team2_id"]) fixture = Fixture(team1, team2, result["id"]) fixtures.append(fixture) return fixtures
def select(id): fixture = None sql = "SELECT * FROM fixtures WHERE id = %s" values = [id] result = run_sql(sql, values)[0] if result is not None: playlist = playlist_repo.select(result['playlist_id']) possible_game = possible_game_repo.select(result['possible_game_id']) fixture = Fixture(playlist, possible_game, result['id']) return fixture
def select_all(): fixtures = [] sql = "SELECT * FROM fixtures" results = run_sql(sql) for result in results: playlist = playlist_repo.select(result['playlist_id']) possible_game = possible_game_repo.select(result['possible_game_id']) fixture = Fixture(playlist, possible_game, result['id']) fixtures.append(fixture) return fixtures
def update_fixture(id): team1_id = request.form["team1_id"] team2_id = request.form["team2_id"] team1 = team_repository.select(team1_id) team2 = team_repository.select(team2_id) team1_score = request.form["team1_score"] team2_score = request.form["team2_score"] fixture = Fixture(team1, team2, team1_score, team2_score, id) fixture_repository.update(fixture) return redirect("/fixtures")
def add_fixture(self): fh = self.scene.fixture_hierarchy() if fh: new_strand = max(fh.keys()) new_address = max(fh[new_strand].keys()) + 1 else: new_strand = 0 new_address = 0 fixture = Fixture(controller=self, strand=new_strand, address=new_address) self.scene.add_fixture(fixture) self.update_canvas() self.create_pixel_array()
def _hydrate(self): assert self._controller is not None assert self._fixtures is None assert self._fixture_hierarchy is None if self._data.get("fixtures", None): self._fixtures = [ Fixture(data=fd, controller=self._controller) for fd in self._data["fixtures"] ] else: self._fixtures = [] self._fixture_hierarchy = defaultdict(dict) for f in self._fixtures: self._fixture_hierarchy[f.strand()][f.address()] = f
def show_team_fixtures(id): sql = "SELECT * FROM fixtures WHERE team1_id = %s OR team2_id = %s" fixtures = [] values = [id, id] results = run_sql(sql, values) for result in results: # get instance of Team class for the team that matches team1_id # get instance of team class for the team matching team2_id # create fixture object that has team1, team2, score1 and score2 # then append to fixtures team1 = team_repository.select(result["team1_id"]) team2 = team_repository.select(result["team2_id"]) fixture = Fixture(team1, team2, result["team1_score"], result["team2_score"]) # import pdb; pdb.set_trace() fixtures.append(fixture) return fixtures
def select(id): sql = "SELECT * FROM fixtures WHERE id = %s" values = [id] result = run_sql(sql, values)[0] fixture = Fixture(result["team1_id"], result["team2_id"], result["id"]) return fixture
def setUp(self): self.team1 = Team("Team 1", "Edinburgh, Scotland", "Murrayfield", 67000, 4, 0, 4, 0, 4, 1) self.team2 = Team("Team 2", "Glasgow, Scotland", "Hampden", 52000, 4, 0, 4, 0, 4, 1) self.fixture = Fixture(self.team1, self.team2)
0) team_repository.save(team_2) team_3 = Team("Juventus", "Turin, Italy", "Juventus Stadium", 41000, 4, 0, 4, 0, 4, 2) team_repository.save(team_3) team_4 = Team("Barcelona", "Barcelona, Catalonia, Spain", "Camp Nou", 99000, 4, 0, 4, 0, 4, 1) team_repository.save(team_4) team_5 = Team("AC Milan", "Milan, Italy", "Stadio Giuseppe Meazza (San Siro)", 80000, 4, 0, 4, 0, 4, 0) team_repository.save(team_5) fixture_1 = Fixture(team_1, team_2) fixture_repository.save(fixture_1) fixture_2 = Fixture(team_3, team_4) fixture_repository.save(fixture_2) fixture_3 = Fixture(team_1, team_3) fixture_repository.save(fixture_3) fixture_4 = Fixture(team_2, team_4) fixture_repository.save(fixture_4) fixture_5 = Fixture(team_1, team_4) fixture_repository.save(fixture_5) fixture_6 = Fixture(team_1, team_5)
import pdb from models.fixture import Fixture from models.team import Team import repositories.fixture_repository as fixture_repository import repositories.team_repository as team_repository fixture_repository.delete_all() team_repository.delete_all() team1 = Team("Hibs") team_repository.save(team1) team2 = Team("Hearts") team_repository.save(team2) team3 = Team("Celtic") team_repository.save(team3) team4 = Team("GB") team_repository.save(team4) fixture1 = Fixture(team1, team2) fixture_repository.save(fixture1) fixture2 = Fixture(team3, team4) fixture_repository.save(fixture2) pdb.set_trace()