Forums

Database Connection Unavailable

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

What, exactly, is the error?