auth-integration

name	auth-integration
description	Use when the user asks about "Flask-Login with SQLAlchemy", "user authentication", "login registration flow", "password hashing", "protect routes", "current_user with database", "session management Flask", or needs patterns for integrating Flask-Login authentication with SQLAlchemy user models.

Flask-Login + SQLAlchemy Auth Integration

Patterns for wiring Flask-Login session authentication with SQLAlchemy user models.

User Model with UserMixin

# models.py
from flask_login import UserMixin

class User(UserMixin, db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password_hash = db.Column(db.String(256), nullable=False)

    # UserMixin provides: is_authenticated, is_active, is_anonymous, get_id()

Login Manager Setup

# In create_app()
from flask_login import LoginManager

login_manager = LoginManager()
login_manager.login_view = 'auth.login'          # Redirect target for @login_required
login_manager.login_message = 'Please sign in first'  
login_manager.init_app(app)


 ():
     db.session.get(User, (user_id))