Tag: Flask, SQLAlchemy, REST API

Flask and SQLAlchemy are used to create REST APIs. Flask is a web framework, while SQLAlchemy is an ORM for database operations.

Example:

from flask import Flask, jsonify
from flask_sqlalchemy import SQLAlchemy

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

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), unique=True, nullable=False)

@app.route('/users')
def get_users():
    users = User.query.all()
    return jsonify([user.name for user in users])

if __name__ == '__main__':
    app.run()