Method ListSettings

backend/store/setting.go:259–319

ListSettings returns a list of settings.

(ctx context.Context, find *FindSettingMessage)

// ListSettings returns a list of settings.
func (s *Store) ListSettings(ctx context.Context, find *FindSettingMessage) ([]*SettingMessage, error) {
	q := qb.Q().Space(`
		SELECT
			name,
			workspace,
			value
		FROM setting
		WHERE workspace = ?
	`, find.Workspace)

	if find.Name != nil {
		q.And("name = ?", find.Name.String())
	}
	query, args, err := q.ToSQL()
	if err != nil {
		return nil, errors.Wrapf(err, "failed to build sql")
	}
	rows, err := s.GetDB().QueryContext(ctx, query, args...)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var settingMessages []*SettingMessage
	for rows.Next() {
		var settingMessage SettingMessage
		var nameString string
		var valueString string
		if err := rows.Scan(
			&nameString,
			&settingMessage.Workspace,
			&valueString,
		); err != nil {
			return nil, err
		}
		value, ok := storepb.SettingName_value[nameString]
		if !ok {
			return nil, errors.Errorf("invalid setting name string: %s", nameString)
		}
		settingMessage.Name = storepb.SettingName(value)

		msg, err := getSettingMessage(settingMessage.Name)
		if err != nil {
			return nil, err
		}
		if err := common.ProtojsonUnmarshaler.Unmarshal([]byte(valueString), msg); err != nil {
			return nil, err
		}
		settingMessage.Value = msg

		settingMessages = append(settingMessages, &settingMessage)
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}

	for _, setting := range settingMessages {
		s.settingCache.Add(getSettingCacheKey(setting.Workspace, setting.Name), setting)