Method UpdateIssue

backend/store/issue.go:220–275

UpdateIssue updates an issue.

(ctx context.Context, projectID string, uid int64, patch *UpdateIssueMessage)

// UpdateIssue updates an issue.
func (s *Store) UpdateIssue(ctx context.Context, projectID string, uid int64, patch *UpdateIssueMessage) (*IssueMessage, error) {
	oldIssue, err := s.GetIssue(ctx, &FindIssueMessage{ProjectIDs: []string{projectID}, UID: &uid})
	if err != nil {
		return nil, err
	}

	set := qb.Q()
	set.Comma("updated_at = ?", time.Now())

	if v := patch.Title; v != nil {
		set.Comma("name = ?", *v)
	}
	if v := patch.Status; v != nil {
		set.Comma("status = ?", v.String())
	}
	if v := patch.Description; v != nil {
		set.Comma("description = ?", *v)
	}
	if v := patch.PayloadUpsert; v != nil {
		v.Labels = CanonicalizeIssueLabels(v.Labels)
		p, err := protojson.Marshal(v)
		if err != nil {
			return nil, errors.Wrapf(err, "failed to marshal patch.PayloadUpsert")
		}
		set.Comma("payload = payload || ?", p)
	} else if patch.RemoveLabels {
		set.Comma("payload = payload || jsonb_build_object('labels', ?::JSONB)", nil)
	}

	if patch.Title != nil || patch.Description != nil {
		title := oldIssue.Title
		if patch.Title != nil {
			title = *patch.Title
		}
		description := oldIssue.Description
		if patch.Description != nil {
			description = *patch.Description
		}

		tsVector := getTSVector(fmt.Sprintf("%s %s", title, description))
		set.Comma("ts_vector = ?", tsVector)
	}

	q := qb.Q().Space("UPDATE issue SET ? WHERE project = ? AND id = ?", set, projectID, uid)

	query, args, err := q.ToSQL()
	if err != nil {
		return nil, errors.Wrapf(err, "failed to build sql")
	}

	if _, err := s.GetDB().ExecContext(ctx, query, args...); err != nil {
		return nil, err
	}

	return s.GetIssue(ctx, &FindIssueMessage{ProjectIDs: []string{projectID}, UID: &uid})
}

// ListIssues returns the list of issues by find query.