Independent synthetic SQLite workflow lab / 독립 합성 업무 실험실
Original teaching code, no client records, external dependencies, network, real accounts or messages.
Python standard library only. Extract and run python test_lab.py and python run_examples.py.
Tests create their own temporary database. Do not point this example at company databases. An existing unrelated database is rejected before writes. This is not a production schema migration tool.
Actor is trusted test context, not authentication. Never derive it from a browser role field. A production service needs actual identity, per-request authorization, server patch validation and protected storage.
Documents have a write version and a separate content revision. Approval is tied to the content revision and approval round. Editing invalidates the active target; self-approval is denied. Owners are read-only in this example. Final execution is a local simulation marker, never a real dispatch or financial action.
BEGIN IMMEDIATE serializes this local SQLite example. Document update, approval change, append-through-API event, notification queue and completed request result commit together. Results are replayed for the same user/company/key and identical command fingerprint. Different content with the same key is rejected. Request results are retained without automatic expiry. Completed results only; no durable in-flight remote-operation protocol or distributed exactly-once guarantee.
History is append-only through this API, not tamper-proof against database administrators. Outbox delivery is simulated. Unknown delivery is not blindly retried; provider reconciliation is not implemented. SQLite busy/lock errors are not automatically retried.
Recorded scenarios are actual local run_examples.py output. A browser viewer of records displays saved evidence and does not run Python or a live database. No browser/device security audit is claimed.
수정·재배포·상업적 사용을 허용하며 무보증으로 제공합니다. You may use, modify and redistribute these original synthetic files, including commercially, as-is without warranty.
