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