Flask API开发指南：RESTful API、JWT认证、SQLAlchemy ORM与蓝图模块化设计

flask-api-development by aj-geddes/useful-ai-prompts

397 周安装量

151 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill flask-api-development

Python Web框架开发 API

🇨🇳中文介绍

Flask API 开发

概述

使用蓝图实现模块化组织，SQLAlchemy 作为 ORM，JWT 身份验证，全面的错误处理，以及遵循 REST 原则的正确请求验证，来创建高效的 Flask API。

使用场景

使用 Flask 构建 RESTful API
创建开销最小的微服务
实现轻量级身份验证系统
设计具有正确验证功能的 API 端点
与关系型数据库集成
构建请求/响应处理系统

快速开始

最小工作示例：

# app.py
from flask import Flask, request, jsonify
from flask_cors import CORS
from flask_sqlalchemy import SQLAlchemy
from flask_jwt_extended import JWTManager
import os

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = os.getenv('DATABASE_URL', 'sqlite:///app.db')
app.config['JWT_SECRET_KEY'] = os.getenv('JWT_SECRET_KEY', 'dev-secret')
app.config['JSON_SORT_KEYS'] = False

db = SQLAlchemy(app)
jwt = JWTManager(app)
CORS(app)

# 请求 ID 中间件
@app.before_request
def assign_request_id():
    import uuid
    request.request_id = str(uuid.uuid4())

# 错误处理器
@app.errorhandler(400)
def bad_request(error):
// ... (完整实现请参阅参考指南)

参考指南

目录下的详细实现：

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
Flask 应用设置	Flask 应用设置
使用 SQLAlchemy 的数据库模型	使用 SQLAlchemy 的数据库模型
身份验证与 JWT	身份验证与 JWT
用于模块化 API 设计的蓝图	用于模块化 API 设计的蓝图
请求验证	请求验证
应用工厂与配置	应用工厂与配置

🇺🇸English

Flask API Development

Overview
When to Use
Quick Start
Reference Guides
Best Practices

Overview

Create efficient Flask APIs with blueprints for modular organization, SQLAlchemy for ORM, JWT authentication, comprehensive error handling, and proper request validation following REST principles.

When to Use

Building RESTful APIs with Flask
Creating microservices with minimal overhead
Implementing lightweight authentication systems
Designing API endpoints with proper validation
Integrating with relational databases
Building request/response handling systems

Quick Start

Minimal working example:

# app.py
from flask import Flask, request, jsonify
from flask_cors import CORS
from flask_sqlalchemy import SQLAlchemy
from flask_jwt_extended import JWTManager
import os

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = os.getenv('DATABASE_URL', 'sqlite:///app.db')
app.config['JWT_SECRET_KEY'] = os.getenv('JWT_SECRET_KEY', 'dev-secret')
app.config['JSON_SORT_KEYS'] = False

db = SQLAlchemy(app)
jwt = JWTManager(app)
CORS(app)

# Request ID middleware
@app.before_request
def assign_request_id():
    import uuid
    request.request_id = str(uuid.uuid4())

# Error handlers
@app.errorhandler(400)
def bad_request(error):
// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
Flask Application Setup	Flask Application Setup
Database Models with SQLAlchemy	Database Models with SQLAlchemy
Authentication and JWT	Authentication and JWT
Blueprints for Modular API Design	Blueprints for Modular API Design
Request Validation	Request Validation
Application Factory and Configuration	Application Factory and Configuration

Best Practices

✅ DO

Use blueprints for modular organization
Implement proper authentication with JWT
Validate all user input
Use SQLAlchemy ORM for database operations
Implement comprehensive error handling
Use pagination for collection endpoints
Log errors and important events
Return appropriate HTTP status codes
Implement CORS properly
Use environment variables for configuration

❌ DON'T

Store secrets in code
Use global variables for shared state
Ignore database transactions
Trust user input without validation
Return stack traces in production
Use mutable default arguments
Forget to handle database connection errors
Implement authentication in route handlers

Weekly Installs

224

Repository

aj-geddes/usefu…-prompts

GitHub Stars

126

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode191

codex180

gemini-cli179

cursor165

github-copilot157

claude-code155