Skip to content

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

1.2 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 apicontract

import (
	"encoding/json"
	"strings"
	"testing"
)

func TestSQLResponseScalarsAndMetadata(t *testing.T) {
	var rows SQLRows
	if err := json.Unmarshal([]byte(`[{"integer":9223372036854775807,"binary":"AP8=","null":null,"boolean":true,"real":1.25}]`), &rows); err != nil {
		t.Fatal(err)
	}
	data, err := json.Marshal(SuccessSQL(rows, 2, false))
	if err != nil || !strings.Contains(string(data), `9223372036854775807`) || !strings.Contains(string(data), `"truncated":false`) {
		t.Fatalf("SQL scalar precision or metadata changed: %s, %v", data, err)
	}
	bundle, err := BuildBundle()
	if err != nil {
		t.Fatal(err)
	}
	if err = bundle.ValidateResponse("POST", "/api/query/sql", data); err != nil {
		t.Fatal(err)
	}
	if err = bundle.ValidateResponse("POST", "/api/query/sql", []byte(`{"code":0,"msg":"","data":[]}`)); err == nil {
		t.Fatal("query success requires limit metadata")
	}
	for _, invalid := range []string{`[{"value":[]}]`, `[{"value":{}}]`} {
		if err := json.Unmarshal([]byte(invalid), &rows); err == nil {
			t.Fatal("SQL scalar accepted a composite value")
		}
	}
}