Skip to content

An open-source, privacy-first, self-hosted knowledge workspace where humans and AI agents work together 开源、隐私优先、自托管的知识工作空间,让人与智能体在此协作

2.0 KB
Raw Blame
// SiYuan - https://github.com/siyuan-note/siyuan
// Copyright (c) 2020-present, b3log.org
// SPDX-License-Identifier: AGPL-3.0-or-later

package api

import (
	"encoding/json"

	"github.com/gin-gonic/gin"
	"github.com/siyuan-note/siyuan/kernel/apicontract"
	"github.com/siyuan-note/siyuan/kernel/model"
	"github.com/siyuan-note/siyuan/kernel/sql"
)

var flushTransaction = contractHandler(apicontract.FlushTransaction, func(c *gin.Context, request apicontract.EmptyRequest) apicontract.Response[apicontract.Null] {
	// Add internal kernel API `/api/sqlite/flushTransaction` https://github.com/siyuan-note/siyuan/issues/10005

	model.FlushTxQueue()
	sql.FlushQueue()

	return apicontract.Success(apicontract.Null{})
})

var SQL = contractHandler(apicontract.QuerySQL, func(c *gin.Context, request apicontract.SQLQueryRequest) apicontract.Response[apicontract.SQLRows] {
	stmt, mode := request.Stmt, request.Mode
	switch mode {
	case "":
		// 默认模式,允许单条语句
		if err := sql.CheckSingleStatement(stmt); err != nil {
			return apicontract.Failure[apicontract.SQLRows](-1, err.Error())
		}
	case "readonly":
		// 只读模式,允许单条语句
		if err := sql.CheckSingleStatement(stmt); err != nil {
			return apicontract.Failure[apicontract.SQLRows](-1, err.Error())
		}
		if err := sql.CheckReadonlyStatement(stmt); err != nil {
			return apicontract.Failure[apicontract.SQLRows](-1, err.Error())
		}
	case "multiple":
		// 多语句模式,不做校验
	default:
		// 未知模式
		return apicontract.Failure[apicontract.SQLRows](-1, "unknown [mode]")
	}

	result, info, err := sql.QueryWithLimitInfo(stmt, model.Conf.Search.Load().Limit)
	if err != nil {
		return apicontract.Failure[apicontract.SQLRows](1, err.Error())
	}

	data, err := json.Marshal(result)
	if err != nil {
		return apicontract.Failure[apicontract.SQLRows](1, err.Error())
	}
	var rows apicontract.SQLRows
	if err = json.Unmarshal(data, &rows); err != nil {
		return apicontract.Failure[apicontract.SQLRows](1, err.Error())
	}
	return apicontract.SuccessSQL(rows, info.Limit, info.Truncated)
})