Spaces:
Sleeping
Sleeping
File size: 3,236 Bytes
caf8059 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | """Local persistence adapter. Replace this port for the selected domestic DB."""
import json
import sqlite3
import time
from contextlib import contextmanager
from pathlib import Path
from src.modules.skill.domain.models import SkillError, canonical, digest
class SqliteTransaction:
def __init__(self, db):
self.db = db
@staticmethod
def document(row):
return {"key": row["doc_key"], "revision": row["revision"], "digest": row["digest"], "body": json.loads(row["body"])} if row else None
def get(self, tenant, kind, key):
return self.document(self.db.execute("SELECT * FROM skill_documents WHERE tenant=? AND kind=? AND doc_key=?", (tenant, kind, key)).fetchone())
def listing(self, tenant, kind):
return [self.document(r) for r in self.db.execute("SELECT * FROM skill_documents WHERE tenant=? AND kind=? ORDER BY doc_key", (tenant, kind))]
def create(self, tenant, kind, key, body):
try:
self.db.execute("INSERT INTO skill_documents VALUES(?,?,?,?,?,?)", (tenant, kind, key, 1, canonical(body), digest(body)))
except sqlite3.IntegrityError:
raise SkillError("VERSION_EXISTS", "对象或不可变版本已存在。", 409) from None
return self.get(tenant, kind, key)
def update(self, tenant, kind, key, body, expected_revision):
if kind != "draft":
raise SkillError("IMMUTABLE_VERSION", "版本对象不能原地更新。", 409)
changed = self.db.execute("UPDATE skill_documents SET body=?,digest=?,revision=revision+1 WHERE tenant=? AND kind=? AND doc_key=? AND revision=?",
(canonical(body), digest(body), tenant, kind, key, expected_revision)).rowcount
if changed != 1:
raise SkillError("REVISION_CONFLICT", "草稿已改变,请重新读取后编辑。", 409)
return self.get(tenant, kind, key)
def audit(self, tenant, user, action, target, target_digest):
self.db.execute("INSERT INTO skill_audit(timestamp,tenant,user_id,action,target,digest) VALUES(?,?,?,?,?,?)", (time.time(), tenant, user, action, target, target_digest))
class SqliteSkillRepository:
def __init__(self, path):
self.path = Path(path)
self.path.parent.mkdir(parents=True, exist_ok=True)
with self.transaction(write=True) as tx:
tx.db.execute("CREATE TABLE IF NOT EXISTS skill_documents(tenant TEXT NOT NULL,kind TEXT NOT NULL,doc_key TEXT NOT NULL,revision INTEGER NOT NULL,body TEXT NOT NULL,digest TEXT NOT NULL,PRIMARY KEY(tenant,kind,doc_key))")
tx.db.execute("CREATE TABLE IF NOT EXISTS skill_audit(id INTEGER PRIMARY KEY,timestamp REAL NOT NULL,tenant TEXT NOT NULL,user_id TEXT NOT NULL,action TEXT NOT NULL,target TEXT NOT NULL,digest TEXT NOT NULL)")
@contextmanager
def transaction(self, *, write=False):
db = sqlite3.connect(self.path, timeout=30, isolation_level=None)
db.row_factory = sqlite3.Row
try:
db.execute("BEGIN IMMEDIATE" if write else "BEGIN")
yield SqliteTransaction(db)
db.commit()
except BaseException:
db.rollback()
raise
finally:
db.close()
|