An open-source, privacy-first, self-hosted knowledge workspace where humans and AI agents work together 开源、隐私优先、自托管的知识工作空间,让人与智能体在此协作
TypeScript agentic-aiai-agentknowledge-baselocal-firstmarkdownmcpmindmapnote-takingself-hostedsiyuanworkspace
// SiYuan - https://github.com/siyuan-note/siyuan
// Copyright (c) 2020-present, b3log.org
// SPDX-License-Identifier: AGPL-3.0-or-later
package model
// 写入时在同一 SQL 中验证内容及更新时间,避免查询与写入之间发生编辑而产生过期索引。
const stmtStoreEmbedding = "INSERT OR REPLACE INTO block_embeddings " +
"(id, root_id, box, path, embedding, model, space, content_len, updated, fail_count, last_tried, ignored_type) " +
"SELECT id, root_id, box, path, ?, ?, ?, ?, updated, 0, 0, 0 FROM blocks " +
"WHERE id = ? AND updated = ? AND content = ?"
// 失败仅累加空向量记录,成功结果不受迟到的失败影响。
const stmtFailedEmbedding = "INSERT INTO block_embeddings " +
"(id, root_id, box, path, embedding, model, content_len, updated, fail_count, last_tried, ignored_type) " +
"SELECT id, root_id, box, path, ?, ?, 0, updated, 1, ?, 0 FROM blocks " +
"WHERE id = ? AND updated = ? AND content = ? " +
"ON CONFLICT(id) DO UPDATE SET fail_count = block_embeddings.fail_count + 1, " +
"last_tried = excluded.last_tried, model = excluded.model, content_len = 0, ignored_type = 0 " +
"WHERE length(block_embeddings.embedding) = 0"
const stmtIgnoreEmbedding = "INSERT INTO block_embeddings " +
"(id, root_id, box, path, embedding, model, content_len, updated, fail_count, last_tried, ignored_type) " +
"SELECT id, root_id, box, path, ?, ?, 0, updated, 0, 0, ? FROM blocks " +
"WHERE id = ? AND updated = ? AND content = ? AND box = ? AND path = ? " +
"ON CONFLICT(id) DO UPDATE SET fail_count = 0, last_tried = 0, ignored_type = excluded.ignored_type, " +
"model = excluded.model, content_len = 0 WHERE length(block_embeddings.embedding) = 0"