def test_mtom_players(self): event1 = Event('TheEvent', date.today()+timedelta(days=1)) self.session.add(event1) # self.layer.commit() event1 = self.session.query(Event).one() nation1 = Nation('Nation1', event1.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event1.id_, 'GBR') self.session.add(nation2) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.nation1_score = 3 game.nation2_score = 0 self.session.add(game) # self.layer.commit() event1 = self.session.query(Event).one() game = self.session.query(Game).one() nations = self.session.query(Nation).all() player1 = Player('Freddy', 'midfield', nations[0].id_, event1.id_) player2 = Player('Hans', 'defence', nations[0].id_, event1.id_) game.players.append(player1) game.players.append(player2) # self.layer.commit() game = self.session.query(Game).one() players = self.session.query(Player).all() self.assertEqual(len(game.players), 2) self.assertEqual(players[0].games[0], game)
def test_creation(self): event1 = Event('TheEvent', date.today()+timedelta(days=1)) self.session.add(event1) event1 = self.session.query(Event).one() nation1 = Nation('Nation1', event1.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event1.id_, 'GBR') self.session.add(nation2) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.nation1_score = 3 game.nation2_score = 0 self.session.add(game) player1 = Player('Freddy', 'Midfield', nations[0].id_, event1.id_) self.session.add(player1) # self.layer.commit() player = self.session.query(Player).one() game = self.session.query(Game).one() stats1 = Playerstatistics(player.id_, game.id_, 5) self.session.add(stats1) # self.layer.commit() myplayer = self.session.query(Player).one() game = self.session.query(Game).one() stats = self.session.query(Playerstatistics).one() self.assertEqual(stats.__repr__(), '<Statistics for Player Freddy. Points: 5>') points = myplayer.get_points_for_game(game.id_, self.session) self.assertEqual(points, 5)
def test_creation(self): event1 = Event('TheEvent', date.today()+timedelta(days=1)) self.session.add(event1) event = self.session.query(Event).one() nation1 = Nation('Nation1', event.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event.id_, 'GBR') self.session.add(nation2) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.score_nation1 = 3 game.score_nation2 = 0 self.session.add(game) # self.layer.commit() team1 = Team('testi.testmann', event.id_, 'TheTeam') self.session.add(team1) # self.layer.commit() team = self.session.query(Team).one() game = self.session.query(Game).one() stats1 = Teamstatistics(team.id_, game.id_, 5) self.session.add(stats1) # self.layer.commit() team = self.session.query(Team).one() game = self.session.query(Game).one() stats = self.session.query(Teamstatistics).one() self.assertEqual(stats.__repr__(), '<Statistics for Team TheTeam. Points: 5>')
def test_creation(self): event1 = Event('TheEvent', date.today()+timedelta(days=1)) # self.layer.commit() self.session.add(event1) event1 = self.session.query(Event).one() nation1 = Nation('Nation1', event1.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event1.id_, 'GBR') self.session.add(nation2) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.nation1_score = 3 game.nation2_score = 0 self.session.add(game) # self.layer.commit() nation = self.session.query(Nation).first() player1 = Player('Freddy', 'Goalkeeper', nation.id_, event.id_) self.session.add(player1) # self.layer.commit() player1 = self.session.query(Player).one() game = self.session.query(Game).one() save1 = Save(player1.id_, game.id_) self.session.add(save1) # self.layer.commit() saves = self.session.query(Save).all() self.assertEqual(len(saves),1) self.assertEqual(saves[0].__repr__(), '<Save <Player Freddy>, 1>')
def test_creation(self): event1 = Event('TheEvent', date.today()+timedelta(days=1)) self.session.add(event1) # self.layer.commit() event1 = self.session.query(Event).one() nation1 = Nation('Nation1', event1.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event1.id_, 'GBR') self.session.add(nation2) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1',nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.nation1_score = 3 game.nation2_score = 0 self.session.add(game) # self.layer.commit() games = self.session.query(Game).all() self.assertEqual(len(games), 1) self.assertEqual(games[0].__repr__(), '<Game SWE-GBR>')
def test_creation(self): event = Event('TheEvent', date.today()+timedelta(days=1)) self.session.add(event) # self.layer.commit() event = self.session.query(Event).one() nation1 = Nation('Nation1', event.id_, 'SWE') self.session.add(nation1) nation2 = Nation('Nation2', event.id_, 'GBR') self.session.add(nation2) nation3 = Nation('Nation3', event.id_, 'FRA') self.session.add(nation3) team1 = Team('TheTeam', 'testi.testmann') self.session.add(team1) # self.layer.commit() nations = self.session.query(Nation).all() event = self.session.query(Event).one() game = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[1].id_) game.score_nation1 = 3 game.score_nation2 = 0 game2 = Game(datetime.now(), event.id_,'group1', nation1_id=nations[0].id_, nation2_id=nations[2].id_) game2.score_nation1 = 0 game2.score_nation2 = 1 self.session.add(game) self.session.add(game2) # self.layer.commit() team = self.session.query(Team).first() nation = self.session.query(Nation).first() event = self.session.query(Event).one() player1 = Player('Freddy', 'midfield', nation.id_, event.id_) self.session.add(player1) # self.layer.commit() team = self.session.query(Team).first() player1 = self.session.query(Player).first() team.players.append(Teams_Players(team.id_, player1, is_starter=True)) player1 = self.session.query(Player).one() game = self.session.query(Game).all() game[0].players.append(player1) game[1].players.append(player1) goal1 = Goal(player1.id_, game[0].id_, False) self.session.add(goal1) card1 = Card(player1.id_, game[0].id_, 'Yellow') self.session.add(card1) # self.layer.commit() player1 = self.session.query(Player).one() log = player1.get_log() goal = self.session.query(Goal).first() card = self.session.query(Card).first() self.assertEqual(len(log), 4) self.assertEqual(log[0][0], card) self.assertEqual(log[1][0], goal) self.assertEqual(log[2][1], 4) self.assertEqual(log[3][1], -2) team = self.session.query(Team).one()