Pythonを使用してCMSシステムのアクセス制御機能を構築する方法

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    __tablename__ = 'users'
    
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), unique=True, nullable=False)
    password = db.Column(db.String(128), nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), nullable=False)
    permissions = db.Column(db.String(50))
    
    def __repr__(self):
        return f"<User {self.username}>"

from flask_login import LoginManager, login_user, login_required, logout_user
from werkzeug.security import check_password_hash, generate_password_hash

login_manager = LoginManager()

@login_manager.user_loader
def load_user(user_id):
    return User.query.get(user_id)

def register(username, password, email):
    user = User(username=username, password=generate_password_hash(password), email=email)
    db.session.add(user)
    db.session.commit()

def login(username, password):
    user = User.query.filter_by(username=username).first()
    if user and check_password_hash(user.password, password):
        login_user(user)

def logout():
    logout_user()

from flask import Flask, request, abort

app = Flask(__name__)

@app.before_request
def check_permission():
    # 获取当前登录用户
    user = current_user()
    
    # 检查用户是否有访问当前路由的权限
    route = request.path
    if not user.has_permission(route):
        abort(403)
        
def current_user():
    # 获取当前登录用户的逻辑
    # ...
    
@app.route('/admin/dashboard')
@login_required
def admin_dashboard():
    return "Admin Dashboard"
    
@app.route('/admin/users')
@login_required
def admin_users():
    return "User Management"