from flask import Flask

from flask_user import UserManager, UserMixin, SQLAlchemyAdapter

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SECRET_KEY'] = 'thisisasecretkey'

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.db'

db = SQLAlchemy(app)

class User(db.Model, UserMixin):

id = db.Column(db.Integer, primary_key=True)

username = db.Column(db.String(50), nullable=False, unique=True)

password = db.Column(db.String(255), nullable=False, server_default='')

active = db.Column('is_active', db.Boolean(), nullable=False, server_default='0')

role = db.Column(db.String(20), nullable=False, default='user')

db_adapter = SQLAlchemyAdapter(db, User)

user_manager = UserManager(db_adapter, app)

if __name__ == '__main__':

db.create_all()

]]>