def main():
from app.core import db
if len(sys.argv) > 1:
if sys.argv[1] == 'create':
db.create_all()
elif sys.argv[1] == 'drop':
db.drop_all()
elif sys.argv[1] == 'fill':
db.populate()
else:
print_help()
else:
app.run()
from os import path
from flask import Flask
from flask_security import current_user
from flask_session import Session
from app.core import db, security, mail
import app.models as models_sounds
from .site import mod_site
import app.admin.models_security as models_security
from .admin import mod_admin
app = Flask(__name__, static_folder='static')
app.config.from_pyfile('config.py')
Session(app)
mail.init_app(app)
db.init_app(app)
db.create_all(app=app) # app=app weil sonst applicationbound error
security.init_app(app, models_security.user_datastore)
app.register_blueprint(mod_admin, url_prefix='/admin')
app.register_blueprint(mod_site)
app.jinja_env.globals.update(config=app.config)
app.jinja_env.globals.update(current_user=current_user)
app.jinja_env.globals.update(path=path)
# seed_security()
data_movie = {'name': 'Transformers', 'genre': 'action', 'year': 2007}
data_movie_upd = {
'name': 'Teenage Mutant Ninja Turtles',
'genre': 'bad movie',
'year': 2014
}
app = Flask(__name__, instance_relative_config=False)
app.config['SQLALCHEMY_DATABASE_URI'] = DB_URL
app.config[
'SQLALCHEMY_TRACK_MODIFICATIONS'] = False # silence the deprecation warning
db.init_app(app)
with app.app_context():
db.create_all()
actor = Actor.create(**data_actor)
print('created actor:', actor.__dict__, '\\n')
movie = Movie.create(**data_movie)
print('created movie:', movie.__dict__, '\\n')
upd_actor = Actor.update(1, **data_actor_upd)
print('updated actor:', upd_actor.__dict__, '\\n')
upd_movie = Movie.update(1, **data_movie_upd)
print('updated movie:', upd_movie.__dict__, '\\n')
add_rels_actor = Actor.add_relation(1, upd_movie)
movie_2 = Movie.create(**data_movie)
add_more_rels_actor = Actor.add_relation(1, movie_2)
def refreshdb():
""" Drop then reinitialize the database """
db.drop_all()
db.create_all()
print(colored('The SQL database has been recreated!', 'green'))
def initdb():
""" Create the SQL database. """
db.create_all()
print(colored('The SQL database has been created', 'green'))
def reset_db():
db.drop_all()
db.create_all()
def reset_db():
db.drop_all()
db.create_all()