Web apps, built to last

from flask import Blueprint, jsonify, request
from .auth import require_scope

bp = Blueprint("orders", __name__, url_prefix="/api/orders")

@bp.get("/<int:order_id>")
@require_scope("orders:read")
def get_order(order_id: int):
    order = Order.query.get_or_404(order_id)   # scoped, audited
    return jsonify(order.to_dict())

from sqlalchemy.orm import Mapped, mapped_column
from .extensions import db

class Order(db.Model):
    id: Mapped[int] = mapped_column(primary_key=True)
    total_cents: Mapped[int] = mapped_column(nullable=False)
    status: Mapped[str] = mapped_column(default="PENDING", index=True)

    def to_dict(self) -> dict:
        return {"id": self.id, "total": self.total_cents / 100}

from celery import Celery
import pandas as pd

celery = Celery("reports", broker=BROKER_URL)

@celery.task(autoretry_for=(IOError,), retry_backoff=True)
def weekly_report(account_id: int):
    df = pd.read_sql(SALES_SQL, engine, params={"id": account_id})
    email_report(account_id, df.to_html())   # observable, retried