Function TestGetSchema_TableImpliesDetails

backend/api/mcp/tool_schema_test.go:355–393

(t *testing.T)

}

func TestGetSchema_TableImpliesDetails(t *testing.T) {
	ordersTable := map[string]any{
		"name":     "orders",
		"rowCount": "182394",
		"comment":  "Customer orders",
		"columns": []map[string]any{
			makeColumnWithDefault("id", "int8", "", "Order ID"),
		},
		"indexes": []map[string]any{makePrimaryKeyIndex("orders_pkey", []string{"id"})},
		"foreignKeys": []map[string]any{
			{
				"name":              "orders_user_id_fkey",
				"columns":           []string{"user_id"},
				"referencedTable":   "users",
				"referencedColumns": []string{"id"},
			},
		},
	}
	resp := makeMetadataResponse(makeSchema("public", ordersTable))

	s, _ := mockMetadataServer(t, employeeDB(), resp)

	result, structured, err := s.handleGetSchema(testContext(), nil, SchemaInput{
		Database: "employee_db",
		Table:    "orders",
		// Include not set → should default to details.
	})
	require.NoError(t, err)
	require.False(t, result.IsError)

	output, ok := structured.(*SchemaOutput)
	require.True(t, ok)
	require.NotNil(t, output.Table)
	// Details level: indexes and FKs are populated.
	require.NotEmpty(t, output.Table.Indexes)
	require.NotEmpty(t, output.Table.ForeignKeys)
	// Column comment (details-only field) populated.
	require.Equal(t, "Order ID", output.Table.Columns[0].Comment)
}

func TestGetSchema_TableNotFound_RefetchesForCandidates(t *testing.T) {
	// First call: server-side filter returns nothing.