KnowForge 2026.0.5：把签到、排行榜与书籍版本纳入可扩展的知识平台

CREATE TABLE user_checkins (
    user_id       BIGINT NOT NULL,
    checkin_date  DATE NOT NULL,
    created_at    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (user_id, checkin_date)
);

CREATE TABLE point_ledger (
    id            BIGINT PRIMARY KEY,
    user_id       BIGINT NOT NULL,
    points        INTEGER NOT NULL,
    reason        VARCHAR(64) NOT NULL,
    reference_id  VARCHAR(128),
    created_at    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

id: daily-checkin
version: 1.0.0
navigation:
  label_key: features.checkin.navigation
  route: /checkin
permissions:
  - id: checkin.use
    description_key: features.checkin.permissions.use
locales:
  - zh-CN
  - en-US

python -m venv .venv
. .venv/bin/activate
pip install fastapi uvicorn

cat > app.py <<'PY'
from collections import defaultdict
from datetime import datetime, timezone

from fastapi import FastAPI, Header, HTTPException

app = FastAPI(title="Knowledge Platform Demo")

points = defaultdict(int)
checkins = set()
books = {
    "distributed-systems": {
        "work_id": "distributed-systems",
        "versions": [
            {"version_id": "zh-cn-v2", "language": "zh-CN", "edition": 2},
            {"version_id": "en-us-v3", "language": "en-US", "edition": 3},
        ],
    }
}

MESSAGES = {
    "zh-CN": {
        "checked_in": "签到成功",
        "already_checked_in": "今天已经签到",
    },
    "en-US": {
        "checked_in": "Check-in completed",
        "already_checked_in": "Already checked in today",
    },
}


def locale_of(header: str | None) -> str:
    if header and header.lower().startswith("en"):
        return "en-US"
    return "zh-CN"


@app.post("/users/{user_id}/check-in")
def check_in(user_id: int, accept_language: str | None = Header(default=None)):
    locale = locale_of(accept_language)
    today = datetime.now(timezone.utc).date().isoformat()
    key = (user_id, today)

    if key in checkins:
        raise HTTPException(
            status_code=409,
            detail={
                "code": "CHECKIN_ALREADY_EXISTS",
                "message": MESSAGES[locale]["already_checked_in"],
            },
        )

    checkins.add(key)
    points[user_id] += 10
    return {
        "message": MESSAGES[locale]["checked_in"],
        "date": today,
        "points": points[user_id],
    }


@app.get("/leaderboard")
def leaderboard():
    ranking = sorted(points.items(), key=lambda item: (-item[1], item[0]))
    return [
        {"rank": index, "user_id": user_id, "points": score}
        for index, (user_id, score) in enumerate(ranking, start=1)
    ]


@app.get("/works/{work_id}")
def get_work(work_id: str):
    work = books.get(work_id)
    if not work:
        raise HTTPException(status_code=404, detail={"code": "WORK_NOT_FOUND"})
    return work
PY

uvicorn app:app --reload

curl -X POST \
  -H 'Accept-Language: zh-CN' \
  http://127.0.0.1:8000/users/1001/check-in

curl -X POST \
  -H 'Accept-Language: en-US' \
  http://127.0.0.1:8000/users/1002/check-in

curl http://127.0.0.1:8000/leaderboard
curl http://127.0.0.1:8000/works/distributed-systems