Flask RESTful API项目 #

GET    /api/users           # 用户列表
POST   /api/users           # 创建用户
GET    /api/users/<id>      # 用户详情
PUT    /api/users/<id>      # 更新用户
DELETE /api/users/<id>      # 删除用户

from flask import Flask, jsonify, request
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///api.db'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80))
    email = db.Column(db.String(120))
    
    def to_dict(self):
        return {'id': self.id, 'username': self.username, 'email': self.email}

@app.route('/api/users', methods=['GET'])
def get_users():
    users = User.query.all()
    return jsonify([u.to_dict() for u in users])

@app.route('/api/users', methods=['POST'])
def create_user():
    data = request.get_json()
    user = User(username=data['username'], email=data['email'])
    db.session.add(user)
    db.session.commit()
    return jsonify(user.to_dict()), 201