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()
