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 (
"database/sql"
"fmt"
"strings"
"github.com/siyuan-note/eventbus"
)
type AssetContent struct {
ID string
Name string
Ext string
Path string
Size int64
Updated int64
Content string
}
const (
AssetContentsFTSCaseInsensitiveInsert = "INSERT INTO asset_contents_fts_case_insensitive (id, name, ext, path, size, updated, content) VALUES %s"
AssetContentsPlaceholder = "(?, ?, ?, ?, ?, ?, ?)"
)
func insertAssetContents(tx *sql.Tx, assetContents []*AssetContent, context map[string]any) (err error) {
if 1 > len(assetContents) {
return
}
var bulk []*AssetContent
for _, assetContent := range assetContents {
bulk = append(bulk, assetContent)
if 512 > len(bulk) {
continue
}
if err = insertAssetContents0(tx, bulk, context); err != nil {
return
}
bulk = []*AssetContent{}
}
if 0 < len(bulk) {
if err = insertAssetContents0(tx, bulk, context); err != nil {
return
}
}
return
}
func insertAssetContents0(tx *sql.Tx, bulk []*AssetContent, context map[string]any) (err error) {
valueStrings := make([]string, 0, len(bulk))
valueArgs := make([]any, 0, len(bulk)*strings.Count(AssetContentsPlaceholder, "?"))
for _, b := range bulk {
valueStrings = append(valueStrings, AssetContentsPlaceholder)
valueArgs = append(valueArgs, b.ID)
valueArgs = append(valueArgs, b.Name)
valueArgs = append(valueArgs, b.Ext)
valueArgs = append(valueArgs, b.Path)
valueArgs = append(valueArgs, b.Size)
valueArgs = append(valueArgs, b.Updated)
valueArgs = append(valueArgs, b.Content)
}
stmt := fmt.Sprintf(AssetContentsFTSCaseInsensitiveInsert, strings.Join(valueStrings, ","))
if err = prepareExecInsertTx(tx, stmt, valueArgs); err != nil {
return
}
eventbus.Publish(eventbus.EvtSQLInsertAssetContent, context)
return
}
func deleteAssetContentsByPath(tx *sql.Tx, path string) (err error) {
stmt := "DELETE FROM asset_contents_fts_case_insensitive WHERE path = ?"
if err = execStmtTx(tx, stmt, path); err != nil {
return
}
return
}