class TestTableExistence(unittest.TestCase):
@classmethod
def setUpClass(self):
self.db = Database('TEST')
self.db.make_tables()
@classmethod
def tearDownClass(self):
self.db.destroy_tables()
def tearDown(self):
self.db.truncate_tables()
def test_when_all_tables_exist(self):
assert 'game_stats' in self.db.Meta.tables.keys()
assert 'game' in self.db.Meta.tables.keys()
assert 'summoner' in self.db.Meta.tables.keys()
assert 'summoner_name' in self.db.Meta.tables.keys()
def test_all_tables_have_rigth_columns(self):
t = TableTester(self.db)
test = t.has_next_table()
while test:
test()
test = t.has_next_table()
class TestTableExistence(unittest.TestCase):
@classmethod
def setUpClass(self):
self.db = Database('TEST')
self.db.make_tables()
@classmethod
def tearDownClass(self):
self.db.destroy_tables()
def tearDown(self):
self.db.truncate_tables()
def test_when_all_tables_exist(self):
assert 'game_stats' in self.db.Meta.tables.keys()
assert 'game' in self.db.Meta.tables.keys()
assert 'summoner' in self.db.Meta.tables.keys()
assert 'summoner_name' in self.db.Meta.tables.keys()
def test_all_tables_have_rigth_columns(self):
t = TableTester(self.db)
test = t.has_next_table()
while test:
test()
test = t.has_next_table()
class TestObjectInitialization(unittest.TestCase):
@classmethod
def setUpClass(self):
self.db = Database()
self.db.make_tables()
@classmethod
def tearDownClass(self):
self.db.destroy_tables()
def tearDown(self):
self.db.truncate_tables()
def test_when_game_is_made(self):
session = self.db.SessionMaker()
def query_for_game(session):
return session.query(Game).first()
expected = add_a_game(session)
observed = query_for_game(session)
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(observed, expected)
def test_when_game_stats_is_made(self):
session = self.db.SessionMaker()
def query_for_game_stats():
return session.query(GameStats).filter_by(summoner_name='Bjerson').first()
expected = add_game_stats(session)
observed = query_for_game_stats()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(observed, expected)
def test_when_summoner_is_made(self):
session = self.db.SessionMaker()
def query_for_summoner():
return session.query(Summoner).first()
expected = add_a_summoner(session)
observed = query_for_summoner()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(observed, expected)
def test_when_summoner_name_is_made(self):
session = self.db.SessionMaker()
def query_for_summoner_name():
return session.query(SummonerName).first()
expected = add_a_summoner_name(session)
observed = query_for_summoner_name()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(observed, expected)
def test_when_they_work_together(self):
pass
class TestObjectInitialization(unittest.TestCase):
@classmethod
def setUpClass(self):
self.db = Database()
self.db.make_tables()
@classmethod
def tearDownClass(self):
self.db.destroy_tables()
def tearDown(self):
self.db.truncate_tables()
def test_when_game_is_made(self):
session = self.db.SessionMaker()
def query_for_game(session):
return session.query(Game).first()
expected = add_a_game(session)
observed = query_for_game(session)
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(
observed, expected)
def test_when_game_stats_is_made(self):
session = self.db.SessionMaker()
def query_for_game_stats():
return session.query(GameStats).filter_by(
summoner_name='Bjerson').first()
expected = add_game_stats(session)
observed = query_for_game_stats()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(
observed, expected)
def test_when_summoner_is_made(self):
session = self.db.SessionMaker()
def query_for_summoner():
return session.query(Summoner).first()
expected = add_a_summoner(session)
observed = query_for_summoner()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(
observed, expected)
def test_when_summoner_name_is_made(self):
session = self.db.SessionMaker()
def query_for_summoner_name():
return session.query(SummonerName).first()
expected = add_a_summoner_name(session)
observed = query_for_summoner_name()
session.close()
assert expected is observed, 'Observed:\t{0}\nExpected:\t{1}'.format(
observed, expected)
def test_when_they_work_together(self):
pass
