def app(): app = create_app(TestConfig()) with app.app_context(): db.drop_all() db.create_all() yield app
def main(): app = create_app() with app.app_context(): db.create_all() write_to_db(app)
def _app(config_class, init_scheduler=False) -> Flask: __app: Flask = create_app(config_class, init_scheduler) if config_class is TestingConfig: db.drop_all() db.create_all() return __app
def main(): app = create_app() with app.app_context(): db.create_all() read_from_file_and_write_to_db() geocode_cities()
def initdb(drop): """Initialize the database.""" if drop: click.confirm( 'This operation will delete the database, do you want to continue?', abort=True) db.drop_all() click.echo('Drop tables.') db.create_all() click.echo('Initialized database.')
def db(app): _db.app = app with app.app_context(): _db.create_all() yield _db _db.session.close() _db.drop_all()
def db(app): """ Setup our database, this only gets executed once per session. :param app: Pytest fixture :return: SQLAlchemy database session """ _db.drop_all() _db.create_all() return _db
def create_app(config=Config): app = Flask(__name__, template_folder='../build', static_folder='../build') CORS(app) app.config.from_object(config) register_extensions(app) with app.app_context(): db.create_all() return app
def extensions(app): """ Register 0 or more extenstions (mutates the app thats passed in) :param app: Flask application instance :return: None """ db.init_app(app) with app.app_context(): db.create_all() return None
def _db(): """Create and configure a new db instance for pytest-flask-sqlalchemy.""" db_fd, db_path = tempfile.mkstemp() app = create_app() app.config["TESTING"] = True app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False app.config["DATABASE"] = db_path app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite://" with app.app_context(): db.init_app(app) db.create_all() yield db os.close(db_fd) os.unlink(db_path)
def app(): """Create and configure a new app instance for tests.""" # create a temp file to isolate the db for each test db_fd, db_path = tempfile.mkstemp() app = create_app() app.config["TESTING"] = True app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False app.config["DATABASE"] = db_path app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite://" # create the db and load test data with app.app_context(): db.init_app(app) db.create_all() yield app # close and remove the temporary db os.close(db_fd) os.unlink(db_path)
if __name__ == "__main__": test = False app = create_app() if test: from flask import jsonify from datetime import datetime, time from backend.player.schemas import player_schema, level_schema, players_schema from backend.game.schemas import game_schema, game_details_schema from backend.draw_group.schemas import draw_group_schema with app.app_context(): db.create_all() all_players = Player.query.all() result = players_schema.dump(all_players) jsonify(result) players = db.session.query(Player).all() player_1 = players[0] level_1 = player_1.levels[0] draw_group_1 = player_1.draw_groups[0] game_1 = draw_group_1.game result = player_schema.dump(player_1) print(result) result = level_schema.dump(level_1)
def db(): db_ext.create_all() yield db_ext db_ext.drop_all()