Flask进阶之构建RESTful API和数据库交互操作

from flask import Flask, request, jsonify
app = Flask(__name__)
todos = []
@app.route('/todos', methods=['GET'])
def get_todos():
    return jsonify(todos)
@app.route('/todos', methods=['POST'])
def add_todo():
    todos.append(request.json.get('todo', ''))
    return '', 204
@app.route('/todos/<int:index>', methods=['PUT'])
def update_todo(index):
    todos[index] = request.json.get('todo', '')
    return '', 204
@app.route('/todos/<int:index>', methods=['DELETE'])
def delete_todo(index):
    del todos[index]
    return '', 204

pip install flask-sqlalchemy

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'
db = SQLAlchemy(app)
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
@app.route('/')
def index():
    user = User.query.filter_by(name='John').first()
    return 'Hello, {}!'.format(user.name)