27 lines
1.5 KiB
SQL
27 lines
1.5 KiB
SQL
BEGIN TRANSACTION;
|
|
-- Scalar table upsert with LWW timestamp check
|
|
INSERT INTO telemetry_symbols (id, filepath, symbol_name, signature, content_hash, is_deleted, last_updated)
|
|
VALUES ('01a075cf-ec03-7d5f-9186-51ff7c0513f8', 'stub/path/telemetry.ts', 'Stubtelemetry', 'function Stubtelemetry() {}', 'hash-01a075cf-ec03-7d5f-9186-51ff7c0513f8', 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 > telemetry_symbols.last_updated;
|
|
|
|
-- Vector upsert using deterministic rowid (DELETE + INSERT for vec0 virtual table compatibility)
|
|
DELETE FROM vec_telemetry WHERE rowid = 1262786903263220728;
|
|
INSERT INTO vec_telemetry (rowid, embedding)
|
|
VALUES (1262786903263220728, '[0.10000000149011612,0.20000000298023224,0.30000001192092896]');
|
|
|
|
-- Provenance record
|
|
INSERT INTO applied_deltas (delta_id, domain, author, commit_msg, action_summary, applied_at)
|
|
VALUES ('01a075cf-ec03-7d5f-9186-51ff7c0513f8', 'telemetry', '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;
|