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 sql
import "strings"
// QueryOCRAssetDocuments 返回普通笔记本中引用资源的文档,用于刷新包含 OCR 文本的块索引。
func QueryOCRAssetDocuments(path string) ([]Asset, error) {
// 资源索引不保存查询参数,由调用方继续按完整 OCR 资源身份筛选文档中的图片。
path = strings.SplitN(path, "?", 2)[0]
rows, err := query("SELECT DISTINCT root_id, box FROM assets WHERE path = ? OR instr(path, ?) = 1 OR instr(path, ?) = 1", path, path+"?", path+"#")
if err != nil {
return nil, err
}
defer rows.Close()
var result []Asset
for rows.Next() {
var asset Asset
if err = rows.Scan(&asset.RootID, &asset.Box); err != nil {
return nil, err
}
result = append(result, asset)
}
return result, rows.Err()
}