import os
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate
from sqlalchemy import event

from .config import config


db = SQLAlchemy()
migrate = Migrate(render_as_batch=True)

def create_app(config_mode):
    app = Flask(__name__)
    app.config.from_object(config[config_mode])

    db.init_app(app)
    migrate.init_app(app,db,)
    
    with app.app_context():
        @event.listens_for(db.engine, 'connect')
        def set_sqlite_pragma(dbapi_connection, connection_record):
            cursor = dbapi_connection.cursor()
            cursor.execute("PRAGMA foreign_keys=ON;")
            cursor.close()



    return app

app = create_app(os.getenv("CONFIG_MODE"))


@app.route('/')
def hello():
    return "Hellord"

from .Film import urls
from .FilmManufacturer import urls
from .FilmFormat import urls
from .Location import urls
from .CameraFormat import urls
from .Camera import urls
from .CameraManufacturer import urls


if __name__ == "__main__":
    app.run(debug=True,port=8008)
    print(os.getenv("CONFIG_MODE"))