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