Flask - User Management

Getting Started

Local Machine

pip install -r requirements.txt

• Set PostgreSQL username & password in db.env
• Start PostgreSQL server

flask --app project db init
flask --app project db migrate
flask --app project db upgrade

python create_database.py

# https://www.sqlite.org/download.html => sqlite-tools-*
sqlite3 .\instance\db.sqlite
sqlite> .tables
user
sqlite> .schema user
CREATE TABLE user (
        id INTEGER NOT NULL,
        email VARCHAR(100),
        password VARCHAR(100),
        name VARCHAR(1000),
        PRIMARY KEY (id),
        UNIQUE (email)
);

flask --app project run --debug

# https://stackoverflow.com/questions/1420719/powershell-setting-an-environment-variable-for-a-single-command-only

When you upgrade any of your database schema

flask --app project db migrate
flask --app project db upgrade

This will create new migrations/version and automatically upgrade your database

Docker Compose

docker compose up --build

Initialize PostgreSQL

$ docker exec -it flask-usermanagement-app-1 /bin/sh
flask --app project db init
flask --app project db migrate
flask --app project db upgrade

• Adminer: http://localhost:8080/
  • System: PostgreSQL
  • Server: pgsql
  • Username: postgres
  • Password: example
• App: http://localhost:5000/

Database

• Flask-UserManagement | DrawSQL

Todo

• Dockerize
• PostgreSQL
  • Using SQLAlchemy with Flask and PostgreSQL
    • ro6ley/cars_in_a_flask: A simple API built using Flask and SQLAlchemy.
  • docker-library/postgres: Docker Official Image packaging for Postgres
  • Container Password
  • flask + postgres + sqlalchemy migrations dockerized intro - DEV Community
• HTTPS
• Replace password plain hash All plain hashes are deprecated and will not be supported in Werkzeug 3.0.

Resources

Tutorial

• How To Add Authentication to Your App with Flask-Login | DigitalOcean

Flask

• Application Setup — Flask Documentation (2.3.x) - Application Factory

Python Database

• sqlalchemy/sqlalchemy: The Database Toolkit for Python
  • The Type Hierarchy — SQLAlchemy 2.0 Documentation
• pallets-eco/flask-sqlalchemy: Adds SQLAlchemy support to Flask
• miguelgrinberg/Flask-Migrate: SQLAlchemy database migrations for Flask applications using Alembic
  • Flask-Migrate — Flask-Migrate documentation
  • Welcome to Alembic’s documentation! — Alembic 1.11.1 documentation

Database Schema

• Database schema for Django User Sessions - DrawSQL
• Database schema for Django Oauth Toolkit - DrawSQL
• Database schema for Django Two Factor Auth - DrawSQL

Database

• PostgreSQL
  • PostgreSQL — SQLAlchemy 2.0 Documentation
  • How to Interact with Databases using SQLAlchemy with PostgreSQL - CoderPad
  • postgres - Official Image | Docker Hub
• SQLite
  • SQLite Download Page
  • Command Line Shell For SQLite
• adminer - Official Image | Docker Hub
• Multiple Databases with Binds — Flask-SQLAlchemy Documentation (2.x)

CSS Framework

• Bulma: Free, open source, and modern CSS framework based on Flexbox
  • jgthms/bulma: Modern CSS framework based on Flexbox

Docker

• Ways to set environment variables in Compose | Docker Documentation
• Services top-level element | Docker Documentation

Others

• Werkzeug — Werkzeug Documentation (2.3.x)