app/lib/search/replace.server.ts

Functions

Imports

It imports app/lib/search/records.mjs. Imported by app/lib/cv/save.server.ts, app/lib/pages/save.server.ts.

Source

1// The statements that replace one document's search records and rebuild both indexes: what a save of a page, and
2// the CV, write beside their own row. One owner, so the column list and the rebuild cannot differ between them.
3
4import { recordsForPages } from "./records.mjs";
5
6export type SearchRecords = ReturnType<typeof recordsForPages>;
7
8/**
9 * Deletes the records whose doc_uid is `uid`, inserts `records`, and rebuilds the two FTS indexes, as one batch
10 * with whatever statements the caller puts in front of it.
11 */
12export function replaceSearchRecords(db: D1Database, uid: string, records: SearchRecords): D1PreparedStatement[] {
13  return [
14    db.prepare(`DELETE FROM search_docs WHERE doc_uid = ?1`).bind(uid),
15    ...records.map((s) =>
16      db
17        .prepare(
18          `INSERT INTO search_docs (uid, url, type, title, body, tags, doc_tags, doc_uid,
19             doc_title, doc_url, anchor, ordinal, status, publish_at)
20           VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14)`,
21        )
22        .bind(s.uid, s.url, s.type, s.title, s.body, s.tags, s.docTags, s.docUid, s.docTitle, s.docUrl, s.anchor, s.ordinal, s.status, null),
23    ),
24    db.prepare(`INSERT INTO search_identity (search_identity) VALUES ('rebuild')`),
25    db.prepare(`INSERT INTO search_prose (search_prose) VALUES ('rebuild')`),
26  ];
27}