Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

3.6 KB
Raw Blame
package main

import (
	"context"
	"database/sql"
	"database/sql/driver"
	"errors"
	"strings"
	"testing"
	"time"

	"gitea.com/kingbase/gokb"
)

type routineDeadlineConnector struct {
	query func(context.Context, string) (driver.Rows, error)
}

func (connector routineDeadlineConnector) Connect(context.Context) (driver.Conn, error) {
	return &routineDeadlineConn{query: connector.query}, nil
}

func (routineDeadlineConnector) Driver() driver.Driver { return routineDeadlineDriver{} }

type routineDeadlineDriver struct{}

func (routineDeadlineDriver) Open(string) (driver.Conn, error) { return nil, driver.ErrSkip }

type routineDeadlineConn struct {
	query func(context.Context, string) (driver.Rows, error)
}

func (*routineDeadlineConn) Prepare(string) (driver.Stmt, error) { return nil, driver.ErrSkip }
func (*routineDeadlineConn) Close() error                        { return nil }
func (*routineDeadlineConn) Begin() (driver.Tx, error)           { return nil, driver.ErrSkip }
func (connection *routineDeadlineConn) QueryContext(ctx context.Context, query string, _ []driver.NamedValue) (driver.Rows, error) {
	return connection.query(ctx, query)
}

func TestRoutineSourceSharesDeadlineAcrossCapabilityAndLegacyFallbacks(t *testing.T) {
	contexts := []context.Context{}
	queries := []string{}
	db := sql.OpenDB(routineDeadlineConnector{query: func(ctx context.Context, query string) (driver.Rows, error) {
		contexts = append(contexts, ctx)
		queries = append(queries, query)
		if strings.Contains(query, "p.prokind") {
			return nil, &gokb.Error{Code: gokb.ErrorCode("42703"), Message: "column p.prokind does not exist"}
		}
		for _, function := range []string{"sys_get_function_identity_arguments", "pg_get_function_identity_arguments", "sys_get_functiondef", "pg_get_functiondef"} {
			if strings.Contains(query, function+"(") {
				return nil, &gokb.Error{Code: gokb.ErrorCode("42883"), Message: "function " + function + "(oid) does not exist"}
			}
		}
		if strings.Contains(query, "SELECT COUNT(*)") {
			return &valueRows{columns: []string{"count"}, rows: [][]driver.Value{{int64(1)}}}, nil
		}
		if strings.Contains(query, "DBMS_METADATA.GET_PROCEDURE_DDL") {
			return &valueRows{columns: []string{"source"}, rows: [][]driver.Value{{"CREATE PROCEDURE recovered_source"}}}, nil
		}
		return nil, errors.New("unexpected routine deadline probe query: " + query)
	}})
	db.SetMaxOpenConns(1)
	t.Cleanup(func() { _ = db.Close() })
	s := newServer()
	s.db = db
	started := time.Now()
	source, err := s.getObjectSourceWithSignature("public", "unique_name", "PROCEDURE", "", stringPtr("value integer"))
	finished := time.Now()
	if err != nil || source["source"] != "CREATE PROCEDURE recovered_source" {
		t.Fatalf("fallback chain failed before deadline verification: source=%v err=%v", source, err)
	}
	if len(queries) != 8 || !strings.Contains(queries[len(queries)-1], "DBMS_METADATA.GET_PROCEDURE_DDL") {
		t.Fatalf("expected kind, identity and source fallbacks followed by legacy validation: %v", queries)
	}
	deadline, ok := contexts[0].Deadline()
	if !ok || deadline.Before(started.Add(metadataTimeout)) || deadline.After(finished.Add(metadataTimeout)) {
		t.Fatalf("routine source did not forward the metadata timeout to the driver: deadline=%v present=%v", deadline, ok)
	}
	for index, ctx := range contexts {
		got, ok := ctx.Deadline()
		if !ok || !got.Equal(deadline) || ctx.Done() != contexts[0].Done() {
			t.Fatalf("fallback %d reset or lost the shared deadline: want=%v got=%v present=%v", index, deadline, got, ok)
		}
		if !errors.Is(ctx.Err(), context.Canceled) {
			t.Fatalf("source completion did not cancel the driver context for query %d: %v", index, ctx.Err())
		}
	}
}