Health and Readiness

On a server, the shop usually runs as several copies behind a load balancer, which shares the visitors' requests between them. Every few seconds, the load balancer and the platform that starts the copies ask each copy two questions over HTTP.

Health: are you alive? If a copy doesn't answer 200, the platform restarts it, so keep this check simple: a restart can't fix a database problem. Readiness: can you serve requests right now? If a copy doesn't answer 200, the load balancer sends it no requests until it does. Here you really try what the app needs, and answer 503 Service Unavailable when it fails.

For example, an app that keeps uploads in a folder could check that the folder is there:

@app.get("/uploads-ok")
def uploads_ok():
    try:
        os.listdir("uploads")
    except OSError:
        return jsonify({"uploads": "missing"}), 503
    return jsonify({"uploads": "ok"})

The check plays the load balancer: it asks /health and /ready, takes away the disk with shop.db, asks again, then brings the disk back. When your code is done, it prints:

Every few seconds, each copy of the shop is asked:
GET /health -> 200 {"status": "ok"} -> alive, keep it running
GET /ready -> 200 {"status": "ready"} -> ready, the load balancer sends it requests
The disk with shop.db is gone:
GET /health -> 200 {"status": "ok"} -> alive, keep it running
GET /ready -> 503 {"status": "not ready"} -> not ready, the load balancer sends it no requests for now
The disk is back:
GET /ready -> 200 {"status": "ready"} -> ready, the load balancer sends it requests

Your task: add GET /health, which answers {"status": "ok"}, and GET /ready, which runs SELECT COUNT(*) FROM products on shop.db and answers {"status": "ready"}, or {"status": "not ready"} with status 503 when sqlite3 raises an error.

Assignment
Follow the Coding Tutorial to add the /health and /ready routes.

Hint
Don't check the database in /health. In /ready, run a query, not just a connection: when shop.db is missing, sqlite3.connect quietly makes a new, empty file. All of sqlite3's errors are kinds of sqlite3.Error.