def setUp(self):
app.config['SQLALCHEMEY_DATABASE_URI'] = "sqlite://"
app.config['TESTING'] = True
self.show_results = False
self.pp = PrettyPrinter(indent=4)
self.counter = 1
self.app = app.test_client()
self.to_delete = []
self.bats_to_delete = []
self.games_to_delete = []
self.fun_to_delete = []
self.espys_to_delete = []
self.teams_to_delete = []
self.players_to_delete = []
self.sponsors_to_delete = []
self.leagues_to_delete = []
self.divisions_to_delete = []
if (not self.tables_created()):
DB.engine.execute('''
DROP TABLE IF EXISTS fun;
DROP TABLE IF EXISTS roster;
DROP TABLE IF EXISTS bat;
DROP TABLE IF EXISTS espys;
DROP TABLE IF EXISTS game;
DROP TABLE IF EXISTS team;
DROP TABLE IF EXISTS player;
DROP TABLE IF EXISTS sponsor;
DROP TABLE IF EXISTS league;
DROP TABLE IF EXISTS division;
''')
DB.create_all()
def setUp(self):
self.show_results = False
self.pp = PrettyPrinter(indent=4)
self.db_fd, app.config['DATABASE'] = tempfile.mkstemp()
self.d = "2014-8-23"
self.t = "11:37"
self.counter = 1
app.config['TESTING'] = True
self.app = app.test_client()
self.to_delete = []
self.bats_to_delete = []
self.games_to_delete = []
self.fun_to_delete = []
self.espys_to_delete = []
self.teams_to_delete = []
self.players_to_delete = []
self.sponsors_to_delete = []
self.leagues_to_delete = []
if (not self.tables_created()):
DB.engine.execute('''
DROP TABLE IF EXISTS fun;
DROP TABLE IF EXISTS roster;
DROP TABLE IF EXISTS bat;
DROP TABLE IF EXISTS espys;
DROP TABLE IF EXISTS game;
DROP TABLE IF EXISTS team;
DROP TABLE IF EXISTS player;
DROP TABLE IF EXISTS sponsor;
DROP TABLE IF EXISTS league;
''')
DB.create_all()
def app():
""" Fixture for app initialized with test config. """
db_fd, db_path = tempfile.mkstemp()
app = create_app({
"SQLALCHEMY_DATABASE_URI": f"sqlite:///{db_path}",
"SQLALCHEMY_TRACK_MODIFICATIONS": False,
})
with app.app_context():
DB.create_all()
yield app
os.close(db_fd)
os.unlink(db_path)
def create_fresh_tables():
"""Creates fresh tables and deletes any previous information."""
# delete old information
DB.session.commit()
DB.engine.execute('''
DROP TABLE IF EXISTS fun;
DROP TABLE IF EXISTS roster;
DROP TABLE IF EXISTS bat;
DROP TABLE IF EXISTS espys;
DROP TABLE IF EXISTS game;
DROP TABLE IF EXISTS team;
DROP TABLE IF EXISTS player;
DROP TABLE IF EXISTS sponsor;
DROP TABLE IF EXISTS league;
''')
DB.create_all()
def create_fresh_tables():
"""Creates fresh tables and deletes any previous information."""
# delete old information
DB.session.commit()
DB.engine.execute("DROP TABLE IF EXISTS join_league_request;")
DB.engine.execute("DROP TABLE IF EXISTS flask_dance_oauth;")
DB.engine.execute("DROP TABLE IF EXISTS fun;")
DB.engine.execute("DROP TABLE IF EXISTS roster;")
DB.engine.execute("DROP TABLE IF EXISTS bat;")
DB.engine.execute("DROP TABLE IF EXISTS espys;")
DB.engine.execute("DROP TABLE IF EXISTS game;")
DB.engine.execute("DROP TABLE IF EXISTS division;")
DB.engine.execute("DROP TABLE IF EXISTS team;")
DB.engine.execute("DROP TABLE IF EXISTS player;")
DB.engine.execute("DROP TABLE IF EXISTS sponsor;")
DB.engine.execute("DROP TABLE IF EXISTS league;")
DB.create_all()
def setUp(self):
self.show_results = False
self.pp = PrettyPrinter(indent=4)
self.db_fd, app.config['DATABASE'] = tempfile.mkstemp()
self.d = "2014-8-23"
self.t = "11:37"
app.config['TESTING'] = True
self.app = app.test_client()
DB.engine.execute('''
DROP TABLE IF EXISTS fun;
DROP TABLE IF EXISTS roster;
DROP TABLE IF EXISTS bat;
DROP TABLE IF EXISTS espys;
DROP TABLE IF EXISTS game;
DROP TABLE IF EXISTS team;
DROP TABLE IF EXISTS player;
DROP TABLE IF EXISTS sponsor;
DROP TABLE IF EXISTS league;
''')
DB.create_all()
from api.model import Player, Team, Sponsor, Game, League, Bat, Espys, Fun
from random import randint
# delete old information
DB.session.commit()
DB.engine.execute('''
DROP TABLE IF EXISTS fun;
DROP TABLE IF EXISTS roster;
DROP TABLE IF EXISTS bat;
DROP TABLE IF EXISTS espys;
DROP TABLE IF EXISTS game;
DROP TABLE IF EXISTS team;
DROP TABLE IF EXISTS player;
DROP TABLE IF EXISTS sponsor;
DROP TABLE IF EXISTS league;
''')
DB.create_all()
FUNS = {
2002:89,
2003: 100,
2004: 177,
2005:186,
2006:176,
2007: 254,
2008: 290,
2009: 342,
2010: 304,
2011: 377,
2012: 377,
2013: 461,
2014: 349,
2015: 501
