27 lines
1.4 KiB
SQL
27 lines
1.4 KiB
SQL
BEGIN TRANSACTION;
|
|
-- Scalar table upsert with LWW timestamp check
|
|
INSERT INTO docs_symbols (id, filepath, symbol_name, signature, content_hash, is_deleted, last_updated)
|
|
VALUES ('01a075cf-ec02-7cd2-9aba-a1453275e4b4', 'stub/path/docs.ts', 'Stubdocs', 'function Stubdocs() {}', 'hash-01a075cf-ec02-7cd2-9aba-a1453275e4b4', 0, '2026-09-06T08:22:35.778Z')
|
|
ON CONFLICT(id) DO UPDATE SET
|
|
filepath = excluded.filepath,
|
|
symbol_name = excluded.symbol_name,
|
|
signature = excluded.signature,
|
|
content_hash = excluded.content_hash,
|
|
is_deleted = 0,
|
|
last_updated = excluded.last_updated
|
|
WHERE excluded.last_updated > docs_symbols.last_updated;
|
|
|
|
-- Vector upsert using deterministic rowid (DELETE + INSERT for vec0 virtual table compatibility)
|
|
DELETE FROM vec_docs WHERE rowid = 1926029109225710772;
|
|
INSERT INTO vec_docs (rowid, embedding)
|
|
VALUES (1926029109225710772, '[0.10000000149011612,0.20000000298023224,0.30000001192092896]');
|
|
|
|
-- Provenance record
|
|
INSERT INTO applied_deltas (delta_id, domain, author, commit_msg, action_summary, applied_at)
|
|
VALUES ('01a075cf-ec02-7cd2-9aba-a1453275e4b4', 'docs', 'Tyler Gillispie <mrteye@gmail.com>', 'forum(fix): add --no-verify to prevent push hook loops', 'Updated .forum/hooks/post-checkout, .forum/hooks/post-commit (+192 more)', '2026-09-06T08:22:35.778Z')
|
|
ON CONFLICT(delta_id) DO UPDATE SET
|
|
author = excluded.author,
|
|
commit_msg = excluded.commit_msg,
|
|
action_summary = excluded.action_summary;
|
|
COMMIT;
|