Ваша первая
мастерская.

py -3 -m venv .venv
.venv\Scripts\python.exe -m pip install -r requirements.txt
.venv\Scripts\python.exe app.py

"""Request storage and business rules: usable from a website, CLI or tests."""
from contextlib import contextmanager
from pathlib import Path
import sqlite3
from yeti3_core import Module, ModuleManifest


class RequestsModule(Module):
    manifest = ModuleManifest(
        id="workshop.requests", name="Заявки мастерской", version="1.0.0",
        provides=("workshop.requests",),
    )

    def __init__(self, database: Path):
        self.database = Path(database)

    @contextmanager
    def connect(self):
        connection = sqlite3.connect(self.database, timeout=5)
        connection.row_factory = sqlite3.Row
        try:
            with connection:
                yield connection
        finally:
            connection.close()

    def boot(self, engine):
        self.engine = engine
        self.database.parent.mkdir(parents=True, exist_ok=True)
        with self.connect() as connection:
            connection.execute("""CREATE TABLE IF NOT EXISTS requests (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                title TEXT NOT NULL,
                status TEXT NOT NULL DEFAULT 'new' CHECK(status IN ('new','done')),
                created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
            )""")
        engine.provide("workshop.requests", self, module_id=self.manifest.id)

    def list(self, status="all"):
        if status not in {"all", "new", "done"}:
            raise ValueError("Неизвестный фильтр")
        with self.connect() as connection:
            if status == "all":
                rows = connection.execute("SELECT * FROM requests ORDER BY id DESC")
            else:
                rows = connection.execute(
                    "SELECT * FROM requests WHERE status=? ORDER BY id DESC", (status,))
            return [dict(row) for row in rows]

    def create(self, title):
        title = title.strip()
        if not 3 <= len(title) <= 120:
            raise ValueError("Название должно содержать от 3 до 120 символов")
        with self.connect() as connection:
            cursor = connection.execute("INSERT INTO requests(title) VALUES (?)", (title,))
            request_id = cursor.lastrowid
        # Publish only after the transaction has committed.
        self.engine.events.emit("workshop.request.created", request_id)
        return request_id

    def set_status(self, request_id, status):
        if status not in {"new", "done"}:
            raise ValueError("Неизвестный статус")
        with self.connect() as connection:
            result = connection.execute(
                "UPDATE requests SET status=? WHERE id=?", (status, request_id))
            if result.rowcount != 1:
                raise LookupError("Заявка не найдена")

"""A second module shows dependencies and event subscriptions."""
from yeti3_core import Module, ModuleManifest


class ActivityModule(Module):
    manifest = ModuleManifest(
        id="workshop.activity", name="События мастерской", version="1.0.0",
        requires=("workshop.requests",),
    )

    def boot(self, engine):
        engine.events.subscribe("workshop.request.created", self.on_created)

    def on_created(self, request_id):
        print(f"Создана заявка №{request_id}", flush=True)

    def shutdown(self, engine):
        engine.events.unsubscribe("workshop.request.created", self.on_created)

<!doctype html>
<html lang="ru"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1">
<title>$title · YETI³</title><link rel="icon" href="/static/mark.svg"><link rel="stylesheet" href="/static/workshop.css"></head>
<body><header><a class="brand" href="/"><img src="/static/mark.svg" alt="" width="30" height="30"> $title</a><span>НА ОСНОВЕ YETI³ CORE</span></header>
<main><div class="eyebrow">ВАШЕ ДЕЛО. ВСЁ ПОД РУКОЙ.</div><h1>От первой заявки<br>до <em>готовой работы.</em></h1><p class="intro">Маленькая мастерская с понятным порядком: добавляйте задачи, отмечайте результат и возвращайтесь к работе.</p>
<div class="stats"><div><b>$total</b><span>Всего заявок</span></div><div><b>$pending</b><span>В работе</span></div><div><b>$completed</b><span>Завершено</span></div></div>
<div class="workspace"><section class="create"><div class="eyebrow">01 / НОВАЯ ЗАЯВКА</div><h2>Что нужно сделать?</h2>$message
<form method="post" action="/requests"><input type="hidden" name="csrf" value="$csrf">
<label for="title">Название заявки</label><input id="title" name="title" minlength="3" maxlength="120" required placeholder="Например, отремонтировать светильник">
<small>От 3 до 120 символов. Данные сохранятся после перезапуска.</small><button>Добавить заявку ↗</button></form>
</section><section class="board"><div class="eyebrow">02 / РАБОЧИЙ СПИСОК</div><h2>Заявки мастерской</h2>
<nav aria-label="Фильтр заявок"><a class="$all_active" href="/">Все</a><a class="$new_active" href="/?status=new">В работе</a><a class="$done_active" href="/?status=done">Готово</a></nav>$cards</section></div>
<footer>Учебный проект · Python + YETI³ Core + SQLite · Данные хранятся на вашем компьютере</footer></main></body></html>

"""Install files through the SDK adapter into a separate demo directory."""
from pathlib import Path
from yeti3_assets import FilesystemAssetAdapter
from yeti3.sdk.manifest import load_manifest, validate_manifest
from yeti3.sdk.installer.registry import InstalledModule

root = Path(__file__).resolve().parent
manifest = load_manifest(root / 'asset_pack/yeti3-module.toml')
validate_manifest(manifest)
module = InstalledModule(manifest=manifest, source=str(root / 'asset_pack'))
adapter = FilesystemAssetAdapter(root / 'installed-assets')
try:
    adapter.install(module)
except Exception as error:
    raise SystemExit(f'Установка не выполнена: {error}. Для повторного опыта выберите новую пустую папку.')
print('Готово: installed-assets/static/workshop.css и mark.svg')
print('SDK записал владельца файлов в installed-assets/.yeti3/ownership/')