Method GetQueryHistory

backend/api/v1/sql_service.go:1469–1495

GetQueryHistory gets a single query history. Query histories are private to their creator, so only the creator may retrieve one.

(ctx context.Context, req *connect.Request[v1pb.GetQueryHistoryRequest])

// GetQueryHistory gets a single query history. Query histories are private to
// their creator, so only the creator may retrieve one.
func (s *SQLService) GetQueryHistory(ctx context.Context, req *connect.Request[v1pb.GetQueryHistoryRequest]) (*connect.Response[v1pb.QueryHistory], error) {
	user, ok := GetUserFromContext(ctx)
	if !ok {
		return nil, connect.NewError(connect.CodeInternal, errors.Errorf("user not found"))
	}

	projectID, historyID, err := common.GetProjectIDQueryHistoryID(req.Msg.Name)
	if err != nil {
		return nil, connect.NewError(connect.CodeInvalidArgument, err)
	}

	history, err := s.store.GetQueryHistory(ctx, historyID)
	if err != nil {
		return nil, connect.NewError(connect.CodeInternal, errors.Errorf("failed to get query history: %v", err.Error()))
	}
	// Hide existence from non-creators and project mismatches by returning the
	// same not-found error for all three cases.
	if history == nil || history.Project != projectID || history.Creator != user.Email {
		return nil, connect.NewError(connect.CodeNotFound, errors.Errorf("query history %q not found", req.Msg.Name))
	}

	queryHistory, err := s.convertToV1QueryHistory(ctx, history)
	if err != nil {
		return nil, connect.NewError(connect.CodeInternal, errors.Wrapf(err, "failed to convert query history"))
	}
	return connect.NewResponse(queryHistory), nil
}

// The Build*Func parser-context helpers moved to
// `backend/component/parsercontext` so the runner layer can use them