Function TestChange_SQLBase64Encoded

backend/api/mcp/tool_change_test.go:263–288

(t *testing.T)

}

func TestChange_SQLBase64Encoded(t *testing.T) {
	mock := newChangeMock(employeeDB())
	s := newChangeTestServer(t, mock)

	sql := "ALTER TABLE users ADD COLUMN status VARCHAR(20)"
	_, _, err := s.handleChange(testContext(), nil, ChangeInput{
		Database: "employee_db",
		SQL:      sql,
		Title:    "Test",
	})
	require.NoError(t, err)

	sheet := mock.getCapturedSheet()
	sheetObj, ok := sheet["sheet"].(map[string]any)
	require.True(t, ok)
	encoded, ok := sheetObj["content"].(string)
	require.True(t, ok)
	decoded, decodeErr := base64.StdEncoding.DecodeString(encoded)
	require.NoError(t, decodeErr)
	require.Equal(t, sql, string(decoded))
	// Sheet should not contain dead fields (title, engine removed from proto).
	_, hasTitle := sheetObj["title"]
	require.False(t, hasTitle)
	_, hasEngine := sheetObj["engine"]
	require.False(t, hasEngine)
}

// --- Defaults tests ---