def db_create_tables():
app = create_app()
with app.app_context():
db.drop_all()
db.create_all()
yield
with app.app_context():
db.drop_all()
def initdb():
"Clear the existing database and create a fresh one (drop_all && create_all)"
if prompt_bool("Are you sure you want to lose all your data"):
db.drop_all()
db.create_all()
load_all_fixtures(db, app)
db.session.commit()
def app(monkey_session) -> Flask:
"""A testing instance of the Flask application."""
monkey_session.setenv('APP_ENV', 'testing')
app = create_app()
# Creates in memory tables..
with app.app_context():
db.create_all()
yield app
# Drops from memory tables.
with app.app_context():
db.drop_all()
def base_setup():
"""
This function prepares and destruct the flask application and the database
before and after each test.
All lines before the yield statement will be executed before the tests
and each line after the yield statement will be called at the end of the tests
"""
app, _ = create_app(config_file="config_test.ini", test=True)
app_context = app.app_context()
app_context.push()
create_testEnv(app, db)
client = app.test_client()
yield app, app_context, db, client
db.session.remove()
db.drop_all()
app_context.pop()
def insertdata():
"""Recreate and repopulate an existing testing database."""
with app.test_request_context():
flask.g.cache_keys = defaultdict(set)
try:
user = User.from_pk(1)
except sqlalchemy.exc.ProgrammingError as e:
click.secho(
'Please manually create the database before running the createdata command.',
fg='red',
bold=True,
)
raise click.Abort
if user and user.username != 'user_one':
click.secho(
'The username of the first user is not user_one. Are you sure this '
'is a testing database? Please clear it yourself and re-try.',
fg='red',
bold=True,
)
raise click.Abort
cache.clear()
db.session.commit()
with app.app_context():
db.drop_all()
db.create_all()
with app.test_request_context():
for p in POPULATORS:
p.populate()
CorePopulator.add_permissions(SitePermissions.GOD_MODE)
cache.clear()
click.echo(f'Updated and inserted development data into the database!')
def db_drop():
db.drop_all()
print('Database dropped!')
def drop_db():
"""Drops the db tables."""
db.drop_all()
def dropdb():
"Clear the existing database (drop_all)"
if prompt_bool("Are you sure you want to lose all your data"):
db.drop_all()
def drop_db():
db.drop_all()
def testTearDown(self):
db.session.remove()
db.drop_all()
os.remove(DATABASE_PATH)
def recreate_db():
db.drop_all()
db.create_all()
db.session.commit()
return 'Database Recreated'
def tearDown(self):
db.session.remove()
db.drop_all()
def testTearDown(self):
db.session.remove()
db.drop_all()
os.remove(DATABASE_PATH)
def tearDown(self):
db.session.remove()
db.drop_all()
self.app_context.pop()
def drop_tables():
"""Drop my db tables."""
db.drop_all()
print('***** Datebase Tables Dropped ****')
from flask import Flask, render_template, request, jsonify
from core import db
from models.plant import Plant
from models.log import Log
import arrow
#Time & Date
utc = arrow.utcnow()
local = utc.to('US/Pacific')
application = Flask(__name__)
app = application
app.config.from_pyfile('config.py')
db.init_app(app)
with app.app_context():
db.drop_all()
db.create_all()
#Blueprint imports
from controllers.page import index
app.register_blueprint(index)
from controllers.api import api
app.register_blueprint(api)
if __name__ == '__main__':
app.run(host='0.0.0.0')
def setUp(self):
db.drop_all()
with self.app.app_context():
db.create_all()
self.init_db()
def tearDown(self):
close_all_sessions()
db.drop_all()
def main():
app = create_app()
with app.app_context():
db.drop_all()
db.create_all()
db.session.commit()