Method GetProjectByResourceID

backend/store/runner_queries.go:23–55

GetProjectByResourceID gets a project by its globally unique resource ID without workspace filter. For use by runners that resolve workspace from the loaded entity.

(ctx context.Context, resourceID string)

// GetProjectByResourceID gets a project by its globally unique resource ID without workspace filter.
// For use by runners that resolve workspace from the loaded entity.
func (s *Store) GetProjectByResourceID(ctx context.Context, resourceID string) (*ProjectMessage, error) {
	if v, ok := s.projectCache.Get(resourceID); ok && s.enableCache {
		return v, nil
	}

	q := qb.Q().Space("SELECT resource_id, workspace, name, setting, deleted FROM project WHERE resource_id = ?", resourceID)
	query, args, err := q.ToSQL()
	if err != nil {
		return nil, err
	}

	var project ProjectMessage
	var payload []byte
	if err := s.GetDB().QueryRowContext(ctx, query, args...).Scan(
		&project.ResourceID,
		&project.Workspace,
		&project.Title,
		&payload,
		&project.Deleted,
	); err != nil {
		if err == sql.ErrNoRows {
			return nil, nil
		}
		return nil, err
	}
	setting := &storepb.Project{}
	if err := common.ProtojsonUnmarshaler.Unmarshal(payload, setting); err != nil {
		return nil, err
	}
	project.Setting = setting
	s.storeProjectCache(&project)
	return &project, nil
}

// GetInstanceByResourceID gets an instance by its globally unique resource ID without workspace filter.
// For use by runners that resolve workspace from the loaded entity.