Method UpdateInstance

backend/store/instance.go:222–285

UpdateInstance updates an instance.

(ctx context.Context, patch *UpdateInstanceMessage)

// UpdateInstance updates an instance.
func (s *Store) UpdateInstance(ctx context.Context, patch *UpdateInstanceMessage) (*InstanceMessage, error) {
	set := qb.Q()

	if v := patch.EnvironmentID; v != nil {
		if *v == "" {
			// Unset the environment by setting it to NULL
			set.Comma("environment = ?", nil)
		} else {
			set.Comma("environment = ?", *v)
		}
	}
	if v := patch.Deleted; v != nil {
		set.Comma("deleted = ?", *v)
	}
	if v := patch.Metadata; v != nil {
		redacted, err := s.obfuscateInstance(ctx, v)
		if err != nil {
			return nil, err
		}
		metadata, err := protojson.Marshal(redacted)
		if err != nil {
			return nil, err
		}
		set.Comma("metadata = ?", metadata)
	}

	if set.Len() == 0 {
		return nil, errors.New("no update field specified")
	}

	where := qb.Q()
	if v := patch.ResourceID; v != nil {
		where.And("resource_id = ?", *v)
	}
	if v := patch.FindByEnvironmentID; v != nil {
		where.And("environment = ?", *v)
	}
	if patch.Workspace != "" {
		where.And("workspace = ?", patch.Workspace)
	}

	if where.Len() == 0 {
		return nil, errors.Errorf("empty where")
	}

	q := qb.Q().Space("UPDATE instance SET ?", set).
		Space("WHERE ?", where)

	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
	}

	if v := patch.ResourceID; v != nil {