Hi, I am having an issue with my code where I get a database connection unavailable after a few accesses of the site.
This is my main.py
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from os import path
from flask_login import LoginManager
from socket import gethostname
db = SQLAlchemy()
def create_app():
app = Flask(__name__)
app.config["SECRET_KEY"] = "hjshjhdjah kjshkjdhjs"
SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(username="19roberl", password="Highover1", hostname="19roberl.mysql.eu.pythonanywhere-services.com", databasename="19roberl$data")
app.config["SQLALCHEMY_DATABASE_URI"] = SQLALCHEMY_DATABASE_URI
app.config["SQLALCHEMY_POOL_RECYCLE"] = 299
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False
db.init_app(app)
from views import views
from auth import auth
app.register_blueprint(views, url_prefix="/")
app.register_blueprint(auth, url_prefix="/")
import models
if __name__ == '__main__':
db.create_all()
if 'liveconsole' not in gethostname():
app.run()
login_manager = LoginManager()
login_manager.login_view = "auth.login"
login_manager.init_app(app)
@login_manager.user_loader
def load_user(id):
return models.User.query.get(int(id))
return app
app = create_app()
If you need any other files to help diagnose please ask and I can provide them.
Thanks in advance