creating_database

app.py

import os
from flask import Flask
from config import Config
from flask_utils import page_bp
from db_creation import db


def create_app():
    appname = "IOT - PROJECT NASTIS"
    app = Flask(appname)
    myconfig = Config
    app.config.from_object(myconfig)
    app.register_blueprint(page_bp, url_prefix='')
    db.init_app(app)
    return app


def setup_database(app):
    with app.app_context():
        db.create_all()


if __name__ == "__main__":
    app = create_app()
    setup_database(app)
    port = 8000
    interface = '0.0.0.0'
    app.run(host=interface, port=port, debug=True)

config.py

class Config():
    SQLALCHEMY_DATABASE_URI = "sqlite:///example.sqlite"
    SQLALCHEMY_ECHO = True

db_creation.py

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

flask_utils.py

from db_creation import db
from User import User
from flask import Blueprint

page_bp = Blueprint("page_bp", __name__)


@page_bp.route('/')
def register():
    return 'foo'

Pipfile

[[source]]
name = "pypi"
url = "https://pypi.org/simple"
verify_ssl = true

[dev-packages]

[packages]
flask = "*"
flask-sqlalchemy = "*"

[requires]
python_version = "3.8"

User.py

from db_creation import db


class User(db.Model):
    username = db.Column(db.String(100), primary_key=True)
    email = db.Column(db.String(100))
    password = db.Column(db.String(100))

    def __init__(self, username, email, password):
        self.username = username
        self.email = email
        self.password = password