def test_create_player(self):
session = Session()
player1 = Player('Josh', 'Juneau', 'forward')
player2 = Player('Jim', 'Baker', 'forward')
player3 = Player('Frank', 'Wierzbicki', 'defense')
player4 = Player('Leo', 'Soto', 'defense')
player5 = Player('Vic', 'Ng', 'center')
session.add(player1)
session.add(player2)
session.add(player3)
session.add(player4)
session.add(player5)
# But 5 are in the session, but not in the database
assert 5 == session.query(Player).count()
assert 0 == engine.execute("select count(id) from player").fetchone()[0]
session.commit()
# Check that 5 records are all in the database
assert 5 == session.query(Player).count()
assert 5 == engine.execute("select count(id) from player").fetchone()[0]
def test_create_player(self):
session = Session()
player1 = Player('Josh', 'Juneau', 'forward')
player2 = Player('Jim', 'Baker', 'forward')
player3 = Player('Frank', 'Wierzbicki', 'defense')
player4 = Player('Leo', 'Soto', 'defense')
player5 = Player('Vic', 'Ng', 'center')
session.add(player1)
session.add(player2)
session.add(player3)
session.add(player4)
session.add(player5)
# But 5 are in the session, but not in the database
assert 5 == session.query(Player).count()
assert 0 == engine.execute(
"select count(id) from player").fetchone()[0]
session.commit()
# Check that 5 records are all in the database
assert 5 == session.query(Player).count()
assert 5 == engine.execute(
"select count(id) from player").fetchone()[0]
def cleanup(self):
session = Session()
for player in session.query(Player):
session.delete(player)
session.commit()
def cleanup(self):
session = Session()
for player in session.query(Player):
session.delete(player)
session.commit()