nextcloud / server

lib/private/Config/UserConfig.php

Indentation +2003 added lines, -2003 removed lines

@@ -46,2007 +46,2007 @@
  * @since 31.0.0
  */
 class UserConfig implements IUserConfig {
-	private const USER_MAX_LENGTH = 64;
-	private const APP_MAX_LENGTH = 32;
-	private const KEY_MAX_LENGTH = 64;
-	private const INDEX_MAX_LENGTH = 64;
-	private const ENCRYPTION_PREFIX = '$UserConfigEncryption$';
-	private const ENCRYPTION_PREFIX_LENGTH = 22; // strlen(self::ENCRYPTION_PREFIX)
-
-	/** @var array<string, array<string, array<string, mixed>>> [ass'user_id' => ['app_id' => ['key' => 'value']]] */
-	private array $fastCache = [];   // cache for normal config keys
-	/** @var array<string, array<string, array<string, mixed>>> ['user_id' => ['app_id' => ['key' => 'value']]] */
-	private array $lazyCache = [];   // cache for lazy config keys
-	/** @var array<string, array<string, array<string, array<string, mixed>>>> ['user_id' => ['app_id' => ['key' => ['type' => ValueType, 'flags' => bitflag]]]] */
-	private array $valueDetails = [];  // type for all config values
-	/** @var array<string, boolean> ['user_id' => bool] */
-	private array $fastLoaded = [];
-	/** @var array<string, boolean> ['user_id' => bool] */
-	private array $lazyLoaded = [];
-	/** @var array<string, array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}> ['app_id' => ['strictness' => ConfigLexiconStrictness, 'entries' => ['config_key' => ConfigLexiconEntry[]]] */
-	private array $configLexiconDetails = [];
-	private bool $ignoreLexiconAliases = false;
-	private array $strictnessApplied = [];
-
-	public function __construct(
-		protected IDBConnection $connection,
-		protected IConfig $config,
-		private readonly ConfigManager $configManager,
-		private readonly PresetManager $presetManager,
-		protected LoggerInterface $logger,
-		protected ICrypto $crypto,
-	) {
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $appId optional id of app
-	 *
-	 * @return list<string> list of userIds
-	 * @since 31.0.0
-	 */
-	public function getUserIds(string $appId = ''): array {
-		$this->assertParams(app: $appId, allowEmptyUser: true, allowEmptyApp: true);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->from('preferences');
-		$qb->select('userid');
-		$qb->groupBy('userid');
-		if ($appId !== '') {
-			$qb->where($qb->expr()->eq('appid', $qb->createNamedParameter($appId)));
-		}
-
-		$result = $qb->executeQuery();
-		$rows = $result->fetchAll();
-		$userIds = [];
-		foreach ($rows as $row) {
-			$userIds[] = $row['userid'];
-		}
-
-		return $userIds;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @return list<string> list of app ids
-	 * @since 31.0.0
-	 */
-	public function getApps(string $userId): array {
-		$this->assertParams($userId, allowEmptyApp: true);
-		$this->loadConfigAll($userId);
-		$apps = array_merge(array_keys($this->fastCache[$userId] ?? []), array_keys($this->lazyCache[$userId] ?? []));
-		sort($apps);
-
-		return array_values(array_unique($apps));
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 *
-	 * @return list<string> list of stored config keys
-	 * @since 31.0.0
-	 */
-	public function getKeys(string $userId, string $app): array {
-		$this->assertParams($userId, $app);
-		$this->loadConfigAll($userId);
-		// array_merge() will remove numeric keys (here config keys), so addition arrays instead
-		$keys = array_map('strval', array_keys(($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? [])));
-		sort($keys);
-
-		return array_values(array_unique($keys));
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
-	 *
-	 * @return bool TRUE if key exists
-	 * @since 31.0.0
-	 */
-	public function hasKey(string $userId, string $app, string $key, ?bool $lazy = false): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfig($userId, $lazy);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		if ($lazy === null) {
-			$appCache = $this->getValues($userId, $app);
-			return isset($appCache[$key]);
-		}
-
-		if ($lazy) {
-			return isset($this->lazyCache[$userId][$app][$key]);
-		}
-
-		return isset($this->fastCache[$userId][$app][$key]);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
-	 *
-	 * @return bool
-	 * @throws UnknownKeyException if config key is not known
-	 * @since 31.0.0
-	 */
-	public function isSensitive(string $userId, string $app, string $key, ?bool $lazy = false): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfig($userId, $lazy);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		if (!isset($this->valueDetails[$userId][$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		return $this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags']);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
-	 *
-	 * @return bool
-	 * @throws UnknownKeyException if config key is not known
-	 * @since 31.0.0
-	 */
-	public function isIndexed(string $userId, string $app, string $key, ?bool $lazy = false): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfig($userId, $lazy);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		if (!isset($this->valueDetails[$userId][$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		return $this->isFlagged(self::FLAG_INDEXED, $this->valueDetails[$userId][$app][$key]['flags']);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app if of the app
-	 * @param string $key config key
-	 *
-	 * @return bool TRUE if config is lazy loaded
-	 * @throws UnknownKeyException if config key is not known
-	 * @see IUserConfig for details about lazy loading
-	 * @since 31.0.0
-	 */
-	public function isLazy(string $userId, string $app, string $key): bool {
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		// there is a huge probability the non-lazy config are already loaded
-		// meaning that we can start by only checking if a current non-lazy key exists
-		if ($this->hasKey($userId, $app, $key, false)) {
-			// meaning key is not lazy.
-			return false;
-		}
-
-		// as key is not found as non-lazy, we load and search in the lazy config
-		if ($this->hasKey($userId, $app, $key, true)) {
-			return true;
-		}
-
-		throw new UnknownKeyException('unknown config key');
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $prefix config keys prefix to search
-	 * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
-	 *
-	 * @return array<string, string|int|float|bool|array> [key => value]
-	 * @since 31.0.0
-	 */
-	public function getValues(
-		string $userId,
-		string $app,
-		string $prefix = '',
-		bool $filtered = false,
-	): array {
-		$this->assertParams($userId, $app, $prefix);
-		// if we want to filter values, we need to get sensitivity
-		$this->loadConfigAll($userId);
-		// array_merge() will remove numeric keys (here config keys), so addition arrays instead
-		$values = array_filter(
-			$this->formatAppValues($userId, $app, ($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? []), $filtered),
-			function (string $key) use ($prefix): bool {
-				// filter values based on $prefix
-				return str_starts_with($key, $prefix);
-			}, ARRAY_FILTER_USE_KEY
-		);
-
-		return $values;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
-	 *
-	 * @return array<string, array<string, string|int|float|bool|array>> [appId => [key => value]]
-	 * @since 31.0.0
-	 */
-	public function getAllValues(string $userId, bool $filtered = false): array {
-		$this->assertParams($userId, allowEmptyApp: true);
-		$this->loadConfigAll($userId);
-
-		$result = [];
-		foreach ($this->getApps($userId) as $app) {
-			// array_merge() will remove numeric keys (here config keys), so addition arrays instead
-			$cached = ($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? []);
-			$result[$app] = $this->formatAppValues($userId, $app, $cached, $filtered);
-		}
-
-		return $result;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $key config key
-	 * @param bool $lazy search within lazy loaded config
-	 * @param ValueType|null $typedAs enforce type for the returned values
-	 *
-	 * @return array<string, string|int|float|bool|array> [appId => value]
-	 * @since 31.0.0
-	 */
-	public function getValuesByApps(string $userId, string $key, bool $lazy = false, ?ValueType $typedAs = null): array {
-		$this->assertParams($userId, '', $key, allowEmptyApp: true);
-		$this->loadConfig($userId, $lazy);
-
-		/** @var array<array-key, array<array-key, mixed>> $cache */
-		if ($lazy) {
-			$cache = $this->lazyCache[$userId];
-		} else {
-			$cache = $this->fastCache[$userId];
-		}
-
-		$values = [];
-		foreach (array_keys($cache) as $app) {
-			if (isset($cache[$app][$key])) {
-				$value = $cache[$app][$key];
-				try {
-					$this->decryptSensitiveValue($userId, $app, $key, $value);
-					$value = $this->convertTypedValue($value, $typedAs ?? $this->getValueType($userId, $app, $key, $lazy));
-				} catch (IncorrectTypeException|UnknownKeyException) {
-				}
-				$values[$app] = $value;
-			}
-		}
-
-		return $values;
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param ValueType|null $typedAs enforce type for the returned values
-	 * @param array|null $userIds limit to a list of user ids
-	 *
-	 * @return array<string, string|int|float|bool|array> [userId => value]
-	 * @since 31.0.0
-	 */
-	public function getValuesByUsers(
-		string $app,
-		string $key,
-		?ValueType $typedAs = null,
-		?array $userIds = null,
-	): array {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->select('userid', 'configvalue', 'type')
-			->from('preferences')
-			->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
-			->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
-
-		$values = [];
-		// this nested function will execute current Query and store result within $values.
-		$executeAndStoreValue = function (IQueryBuilder $qb) use (&$values, $typedAs): IResult {
-			$result = $qb->executeQuery();
-			while ($row = $result->fetch()) {
-				$value = $row['configvalue'];
-				try {
-					$value = $this->convertTypedValue($value, $typedAs ?? ValueType::from((int)$row['type']));
-				} catch (IncorrectTypeException) {
-				}
-				$values[$row['userid']] = $value;
-			}
-			return $result;
-		};
-
-		// if no userIds to filter, we execute query as it is and returns all values ...
-		if ($userIds === null) {
-			$result = $executeAndStoreValue($qb);
-			$result->closeCursor();
-			return $values;
-		}
-
-		// if userIds to filter, we chunk the list and execute the same query multiple times until we get all values
-		$result = null;
-		$qb->andWhere($qb->expr()->in('userid', $qb->createParameter('userIds')));
-		foreach (array_chunk($userIds, 50, true) as $chunk) {
-			$qb->setParameter('userIds', $chunk, IQueryBuilder::PARAM_STR_ARRAY);
-			$result = $executeAndStoreValue($qb);
-		}
-		$result?->closeCursor();
-
-		return $values;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $caseInsensitive non-case-sensitive search, only works if $value is a string
-	 *
-	 * @return Generator<string>
-	 * @since 31.0.0
-	 */
-	public function searchUsersByValueString(string $app, string $key, string $value, bool $caseInsensitive = false): Generator {
-		return $this->searchUsersByTypedValue($app, $key, $value, $caseInsensitive);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $value config value
-	 *
-	 * @return Generator<string>
-	 * @since 31.0.0
-	 */
-	public function searchUsersByValueInt(string $app, string $key, int $value): Generator {
-		return $this->searchUsersByValueString($app, $key, (string)$value);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param array $values list of config values
-	 *
-	 * @return Generator<string>
-	 * @since 31.0.0
-	 */
-	public function searchUsersByValues(string $app, string $key, array $values): Generator {
-		return $this->searchUsersByTypedValue($app, $key, $values);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $value config value
-	 *
-	 * @return Generator<string>
-	 * @since 31.0.0
-	 */
-	public function searchUsersByValueBool(string $app, string $key, bool $value): Generator {
-		$values = ['0', 'off', 'false', 'no'];
-		if ($value) {
-			$values = ['1', 'on', 'true', 'yes'];
-		}
-		return $this->searchUsersByValues($app, $key, $values);
-	}
-
-	/**
-	 * returns a list of users with config key set to a specific value, or within the list of
-	 * possible values
-	 *
-	 * @param string $app
-	 * @param string $key
-	 * @param string|array $value
-	 * @param bool $caseInsensitive
-	 *
-	 * @return Generator<string>
-	 */
-	private function searchUsersByTypedValue(string $app, string $key, string|array $value, bool $caseInsensitive = false): Generator {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->from('preferences');
-		$qb->select('userid');
-		$qb->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
-		$qb->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
-
-		// search within 'indexed' OR 'configvalue' only if 'flags' is set as not indexed
-		// TODO: when implementing config lexicon remove the searches on 'configvalue' if value is set as indexed
-		$configValueColumn = ($this->connection->getDatabaseProvider() === IDBConnection::PLATFORM_ORACLE) ? $qb->expr()->castColumn('configvalue', IQueryBuilder::PARAM_STR) : 'configvalue';
-		if (is_array($value)) {
-			$where = $qb->expr()->orX(
-				$qb->expr()->in('indexed', $qb->createNamedParameter($value, IQueryBuilder::PARAM_STR_ARRAY)),
-				$qb->expr()->andX(
-					$qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
-					$qb->expr()->in($configValueColumn, $qb->createNamedParameter($value, IQueryBuilder::PARAM_STR_ARRAY))
-				)
-			);
-		} else {
-			if ($caseInsensitive) {
-				$where = $qb->expr()->orX(
-					$qb->expr()->eq($qb->func()->lower('indexed'), $qb->createNamedParameter(strtolower($value))),
-					$qb->expr()->andX(
-						$qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
-						$qb->expr()->eq($qb->func()->lower($configValueColumn), $qb->createNamedParameter(strtolower($value)))
-					)
-				);
-			} else {
-				$where = $qb->expr()->orX(
-					$qb->expr()->eq('indexed', $qb->createNamedParameter($value)),
-					$qb->expr()->andX(
-						$qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
-						$qb->expr()->eq($configValueColumn, $qb->createNamedParameter($value))
-					)
-				);
-			}
-		}
-
-		$qb->andWhere($where);
-		$result = $qb->executeQuery();
-		while ($row = $result->fetch()) {
-			yield $row['userid'];
-		}
-	}
-
-	/**
-	 * Get the config value as string.
-	 * If the value does not exist the given default will be returned.
-	 *
-	 * Set lazy to `null` to ignore it and get the value from either source.
-	 *
-	 * **WARNING:** Method is internal and **SHOULD** not be used, as it is better to get the value with a type.
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default config value
-	 * @param null|bool $lazy get config as lazy loaded or not. can be NULL
-	 *
-	 * @return string the value or $default
-	 * @throws TypeConflictException
-	 * @internal
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 * @see getValueString()
-	 * @see getValueInt()
-	 * @see getValueFloat()
-	 * @see getValueBool()
-	 * @see getValueArray()
-	 */
-	public function getValueMixed(
-		string $userId,
-		string $app,
-		string $key,
-		string $default = '',
-		?bool $lazy = false,
-	): string {
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-		try {
-			$lazy ??= $this->isLazy($userId, $app, $key);
-		} catch (UnknownKeyException) {
-			return $default;
-		}
-
-		return $this->getTypedValue(
-			$userId,
-			$app,
-			$key,
-			$default,
-			$lazy,
-			ValueType::MIXED
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return string stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws TypeConflictException in case of conflict with the value type set in database
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function getValueString(
-		string $userId,
-		string $app,
-		string $key,
-		string $default = '',
-		bool $lazy = false,
-	): string {
-		return $this->getTypedValue($userId, $app, $key, $default, $lazy, ValueType::STRING);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return int stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws TypeConflictException in case of conflict with the value type set in database
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function getValueInt(
-		string $userId,
-		string $app,
-		string $key,
-		int $default = 0,
-		bool $lazy = false,
-	): int {
-		return (int)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::INT);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param float $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return float stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws TypeConflictException in case of conflict with the value type set in database
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function getValueFloat(
-		string $userId,
-		string $app,
-		string $key,
-		float $default = 0,
-		bool $lazy = false,
-	): float {
-		return (float)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::FLOAT);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return bool stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws TypeConflictException in case of conflict with the value type set in database
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function getValueBool(
-		string $userId,
-		string $app,
-		string $key,
-		bool $default = false,
-		bool $lazy = false,
-	): bool {
-		$b = strtolower($this->getTypedValue($userId, $app, $key, $default ? 'true' : 'false', $lazy, ValueType::BOOL));
-		return in_array($b, ['1', 'true', 'yes', 'on']);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param array $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return array stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws TypeConflictException in case of conflict with the value type set in database
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function getValueArray(
-		string $userId,
-		string $app,
-		string $key,
-		array $default = [],
-		bool $lazy = false,
-	): array {
-		try {
-			$defaultJson = json_encode($default, JSON_THROW_ON_ERROR);
-			$value = json_decode($this->getTypedValue($userId, $app, $key, $defaultJson, $lazy, ValueType::ARRAY), true, flags: JSON_THROW_ON_ERROR);
-
-			return is_array($value) ? $value : [];
-		} catch (JsonException) {
-			return [];
-		}
-	}
-
-	/**
-	 * @param string $userId
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 * @param ValueType $type value type
-	 *
-	 * @return string
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 */
-	private function getTypedValue(
-		string $userId,
-		string $app,
-		string $key,
-		string $default,
-		bool $lazy,
-		ValueType $type,
-	): string {
-		$this->assertParams($userId, $app, $key);
-		$origKey = $key;
-		$matched = $this->matchAndApplyLexiconDefinition($userId, $app, $key, $lazy, $type, default: $default);
-		if ($default === null) {
-			// there is no logical reason for it to be null
-			throw new \Exception('default cannot be null');
-		}
-
-		// returns default if strictness of lexicon is set to WARNING (block and report)
-		if (!$matched) {
-			return $default;
-		}
-
-		$this->loadConfig($userId, $lazy);
-
-		/**
-		 * We ignore check if mixed type is requested.
-		 * If type of stored value is set as mixed, we don't filter.
-		 * If type of stored value is defined, we compare with the one requested.
-		 */
-		$knownType = $this->valueDetails[$userId][$app][$key]['type'] ?? null;
-		if ($type !== ValueType::MIXED
-			&& $knownType !== null
-			&& $knownType !== ValueType::MIXED
-			&& $type !== $knownType) {
-			$this->logger->warning('conflict with value type from database', ['app' => $app, 'key' => $key, 'type' => $type, 'knownType' => $knownType]);
-			throw new TypeConflictException('conflict with value type from database');
-		}
-
-		/**
-		 * - the pair $app/$key cannot exist in both array,
-		 * - we should still return an existing non-lazy value even if current method
-		 *   is called with $lazy is true
-		 *
-		 * This way, lazyCache will be empty until the load for lazy config value is requested.
-		 */
-		if (isset($this->lazyCache[$userId][$app][$key])) {
-			$value = $this->lazyCache[$userId][$app][$key];
-		} elseif (isset($this->fastCache[$userId][$app][$key])) {
-			$value = $this->fastCache[$userId][$app][$key];
-		} else {
-			return $default;
-		}
-
-		$this->decryptSensitiveValue($userId, $app, $key, $value);
-
-		// in case the key was modified while running matchAndApplyLexiconDefinition() we are
-		// interested to check options in case a modification of the value is needed
-		// ie inverting value from previous key when using lexicon option RENAME_INVERT_BOOLEAN
-		if ($origKey !== $key && $type === ValueType::BOOL) {
-			$value = ($this->configManager->convertToBool($value, $this->getLexiconEntry($app, $key))) ? '1' : '0';
-		}
-
-		return $value;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @return ValueType type of the value
-	 * @throws UnknownKeyException if config key is not known
-	 * @throws IncorrectTypeException if config value type is not known
-	 * @since 31.0.0
-	 */
-	public function getValueType(string $userId, string $app, string $key, ?bool $lazy = null): ValueType {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfig($userId, $lazy);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		if (!isset($this->valueDetails[$userId][$app][$key]['type'])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		return $this->valueDetails[$userId][$app][$key]['type'];
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $lazy lazy loading
-	 *
-	 * @return int flags applied to value
-	 * @throws UnknownKeyException if config key is not known
-	 * @throws IncorrectTypeException if config value type is not known
-	 * @since 31.0.0
-	 */
-	public function getValueFlags(string $userId, string $app, string $key, bool $lazy = false): int {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfig($userId, $lazy);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		if (!isset($this->valueDetails[$userId][$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		return $this->valueDetails[$userId][$app][$key]['flags'];
-	}
-
-	/**
-	 * Store a config key and its value in database as VALUE_MIXED
-	 *
-	 * **WARNING:** Method is internal and **MUST** not be used as it is best to set a real value type
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED
-	 * @internal
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 * @see setValueString()
-	 * @see setValueInt()
-	 * @see setValueFloat()
-	 * @see setValueBool()
-	 * @see setValueArray()
-	 */
-	public function setValueMixed(
-		string $userId,
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		return $this->setTypedValue(
-			$userId,
-			$app,
-			$key,
-			$value,
-			$lazy,
-			$flags,
-			ValueType::MIXED
-		);
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function setValueString(
-		string $userId,
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		return $this->setTypedValue(
-			$userId,
-			$app,
-			$key,
-			$value,
-			$lazy,
-			$flags,
-			ValueType::STRING
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function setValueInt(
-		string $userId,
-		string $app,
-		string $key,
-		int $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		if ($value > 2000000000) {
-			$this->logger->debug('You are trying to store an integer value around/above 2,147,483,647. This is a reminder that reaching this theoretical limit on 32 bits system will throw an exception.');
-		}
-
-		return $this->setTypedValue(
-			$userId,
-			$app,
-			$key,
-			(string)$value,
-			$lazy,
-			$flags,
-			ValueType::INT
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param float $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function setValueFloat(
-		string $userId,
-		string $app,
-		string $key,
-		float $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		return $this->setTypedValue(
-			$userId,
-			$app,
-			$key,
-			(string)$value,
-			$lazy,
-			$flags,
-			ValueType::FLOAT
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function setValueBool(
-		string $userId,
-		string $app,
-		string $key,
-		bool $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		return $this->setTypedValue(
-			$userId,
-			$app,
-			$key,
-			($value) ? '1' : '0',
-			$lazy,
-			$flags,
-			ValueType::BOOL
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param array $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @throws JsonException
-	 * @since 31.0.0
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	public function setValueArray(
-		string $userId,
-		string $app,
-		string $key,
-		array $value,
-		bool $lazy = false,
-		int $flags = 0,
-	): bool {
-		try {
-			return $this->setTypedValue(
-				$userId,
-				$app,
-				$key,
-				json_encode($value, JSON_THROW_ON_ERROR),
-				$lazy,
-				$flags,
-				ValueType::ARRAY
-			);
-		} catch (JsonException $e) {
-			$this->logger->warning('could not setValueArray', ['app' => $app, 'key' => $key, 'exception' => $e]);
-			throw $e;
-		}
-	}
-
-	/**
-	 * Store a config key and its value in database
-	 *
-	 * If config key is already known with the exact same config value and same sensitive/lazy status, the
-	 * database is not updated. If config value was previously stored as sensitive, status will not be
-	 * altered.
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy config set as lazy loaded
-	 * @param ValueType $type value type
-	 *
-	 * @return bool TRUE if value was updated in database
-	 * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @see IUserConfig for explanation about lazy loading
-	 */
-	private function setTypedValue(
-		string $userId,
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy,
-		int $flags,
-		ValueType $type,
-	): bool {
-		// Primary email addresses are always(!) expected to be lowercase
-		if ($app === 'settings' && $key === 'email') {
-			$value = strtolower($value);
-		}
-
-		$this->assertParams($userId, $app, $key);
-		if (!$this->matchAndApplyLexiconDefinition($userId, $app, $key, $lazy, $type, $flags)) {
-			// returns false as database is not updated
-			return false;
-		}
-		$this->loadConfig($userId, $lazy);
-
-		$inserted = $refreshCache = false;
-		$origValue = $value;
-		$sensitive = $this->isFlagged(self::FLAG_SENSITIVE, $flags);
-		if ($sensitive || ($this->hasKey($userId, $app, $key, $lazy) && $this->isSensitive($userId, $app, $key, $lazy))) {
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
-			$flags |= self::FLAG_SENSITIVE;
-		}
-
-		// if requested, we fill the 'indexed' field with current value
-		$indexed = '';
-		if ($type !== ValueType::ARRAY && $this->isFlagged(self::FLAG_INDEXED, $flags)) {
-			if ($this->isFlagged(self::FLAG_SENSITIVE, $flags)) {
-				$this->logger->warning('sensitive value are not to be indexed');
-			} elseif (strlen($value) > self::USER_MAX_LENGTH) {
-				$this->logger->warning('value is too lengthy to be indexed');
-			} else {
-				$indexed = $value;
-			}
-		}
-
-		if ($this->hasKey($userId, $app, $key, $lazy)) {
-			/**
-			 * no update if key is already known with set lazy status and value is
-			 * not different, unless sensitivity is switched from false to true.
-			 */
-			if ($origValue === $this->getTypedValue($userId, $app, $key, $value, $lazy, $type)
-				&& (!$sensitive || $this->isSensitive($userId, $app, $key, $lazy))) {
-				return false;
-			}
-		} else {
-			/**
-			 * if key is not known yet, we try to insert.
-			 * It might fail if the key exists with a different lazy flag.
-			 */
-			try {
-				$insert = $this->connection->getQueryBuilder();
-				$insert->insert('preferences')
-					->setValue('userid', $insert->createNamedParameter($userId))
-					->setValue('appid', $insert->createNamedParameter($app))
-					->setValue('lazy', $insert->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
-					->setValue('type', $insert->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
-					->setValue('flags', $insert->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
-					->setValue('indexed', $insert->createNamedParameter($indexed))
-					->setValue('configkey', $insert->createNamedParameter($key))
-					->setValue('configvalue', $insert->createNamedParameter($value));
-				$insert->executeStatement();
-				$inserted = true;
-			} catch (DBException $e) {
-				if ($e->getReason() !== DBException::REASON_UNIQUE_CONSTRAINT_VIOLATION) {
-					// TODO: throw exception or just log and returns false !?
-					throw $e;
-				}
-			}
-		}
-
-		/**
-		 * We cannot insert a new row, meaning we need to update an already existing one
-		 */
-		if (!$inserted) {
-			$currType = $this->valueDetails[$userId][$app][$key]['type'] ?? null;
-			if ($currType === null) { // this might happen when switching lazy loading status
-				$this->loadConfigAll($userId);
-				$currType = $this->valueDetails[$userId][$app][$key]['type'];
-			}
-
-			/**
-			 * We only log a warning and set it to VALUE_MIXED.
-			 */
-			if ($currType === null) {
-				$this->logger->warning('Value type is set to zero (0) in database. This is not supposed to happens', ['app' => $app, 'key' => $key]);
-				$currType = ValueType::MIXED;
-			}
-
-			/**
-			 * we only accept a different type from the one stored in database
-			 * if the one stored in database is not-defined (VALUE_MIXED)
-			 */
-			if ($currType !== ValueType::MIXED
-				&& $currType !== $type) {
-				try {
-					$currTypeDef = $currType->getDefinition();
-					$typeDef = $type->getDefinition();
-				} catch (IncorrectTypeException) {
-					$currTypeDef = $currType->value;
-					$typeDef = $type->value;
-				}
-				throw new TypeConflictException('conflict between new type (' . $typeDef . ') and old type (' . $currTypeDef . ')');
-			}
-
-			if ($lazy !== $this->isLazy($userId, $app, $key)) {
-				$refreshCache = true;
-			}
-
-			$update = $this->connection->getQueryBuilder();
-			$update->update('preferences')
-				->set('configvalue', $update->createNamedParameter($value))
-				->set('lazy', $update->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
-				->set('type', $update->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
-				->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
-				->set('indexed', $update->createNamedParameter($indexed))
-				->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
-				->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
-				->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-
-			$update->executeStatement();
-		}
-
-		if ($refreshCache) {
-			$this->clearCache($userId);
-			return true;
-		}
-
-		// update local cache
-		if ($lazy) {
-			$this->lazyCache[$userId][$app][$key] = $value;
-		} else {
-			$this->fastCache[$userId][$app][$key] = $value;
-		}
-		$this->valueDetails[$userId][$app][$key] = [
-			'type' => $type,
-			'flags' => $flags
-		];
-
-		return true;
-	}
-
-	/**
-	 * Change the type of config value.
-	 *
-	 * **WARNING:** Method is internal and **MUST** not be used as it may break things.
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param ValueType $type value type
-	 *
-	 * @return bool TRUE if database update were necessary
-	 * @throws UnknownKeyException if $key is now known in database
-	 * @throws IncorrectTypeException if $type is not valid
-	 * @internal
-	 * @since 31.0.0
-	 */
-	public function updateType(string $userId, string $app, string $key, ValueType $type = ValueType::MIXED): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfigAll($userId);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-		$this->isLazy($userId, $app, $key); // confirm key exists
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('preferences')
-			->set('type', $update->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
-			->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
-			->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		$this->valueDetails[$userId][$app][$key]['type'] = $type;
-
-		return true;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $sensitive TRUE to set as sensitive, FALSE to unset
-	 *
-	 * @return bool TRUE if entry was found in database and an update was necessary
-	 * @since 31.0.0
-	 */
-	public function updateSensitive(string $userId, string $app, string $key, bool $sensitive): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfigAll($userId);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		try {
-			if ($sensitive === $this->isSensitive($userId, $app, $key, null)) {
-				return false;
-			}
-		} catch (UnknownKeyException) {
-			return false;
-		}
-
-		$lazy = $this->isLazy($userId, $app, $key);
-		if ($lazy) {
-			$cache = $this->lazyCache;
-		} else {
-			$cache = $this->fastCache;
-		}
-
-		if (!isset($cache[$userId][$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		$value = $cache[$userId][$app][$key];
-		$flags = $this->getValueFlags($userId, $app, $key);
-		if ($sensitive) {
-			$flags |= self::FLAG_SENSITIVE;
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
-		} else {
-			$flags &= ~self::FLAG_SENSITIVE;
-			$this->decryptSensitiveValue($userId, $app, $key, $value);
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('preferences')
-			->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
-			->set('configvalue', $update->createNamedParameter($value))
-			->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
-			->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		$this->valueDetails[$userId][$app][$key]['flags'] = $flags;
-
-		return true;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app
-	 * @param string $key
-	 * @param bool $sensitive
-	 *
-	 * @since 31.0.0
-	 */
-	public function updateGlobalSensitive(string $app, string $key, bool $sensitive): void {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		foreach (array_keys($this->getValuesByUsers($app, $key)) as $userId) {
-			try {
-				$this->updateSensitive($userId, $app, $key, $sensitive);
-			} catch (UnknownKeyException) {
-				// should not happen and can be ignored
-			}
-		}
-
-		// we clear all cache
-		$this->clearCacheAll();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId
-	 * @param string $app
-	 * @param string $key
-	 * @param bool $indexed
-	 *
-	 * @return bool
-	 * @throws DBException
-	 * @throws IncorrectTypeException
-	 * @throws UnknownKeyException
-	 * @since 31.0.0
-	 */
-	public function updateIndexed(string $userId, string $app, string $key, bool $indexed): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfigAll($userId);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		try {
-			if ($indexed === $this->isIndexed($userId, $app, $key, null)) {
-				return false;
-			}
-		} catch (UnknownKeyException) {
-			return false;
-		}
-
-		$lazy = $this->isLazy($userId, $app, $key);
-		if ($lazy) {
-			$cache = $this->lazyCache;
-		} else {
-			$cache = $this->fastCache;
-		}
-
-		if (!isset($cache[$userId][$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		$value = $cache[$userId][$app][$key];
-		$flags = $this->getValueFlags($userId, $app, $key);
-		if ($indexed) {
-			$indexed = $value;
-		} else {
-			$flags &= ~self::FLAG_INDEXED;
-			$indexed = '';
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('preferences')
-			->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
-			->set('indexed', $update->createNamedParameter($indexed))
-			->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
-			->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		$this->valueDetails[$userId][$app][$key]['flags'] = $flags;
-
-		return true;
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app
-	 * @param string $key
-	 * @param bool $indexed
-	 *
-	 * @since 31.0.0
-	 */
-	public function updateGlobalIndexed(string $app, string $key, bool $indexed): void {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		foreach (array_keys($this->getValuesByUsers($app, $key)) as $userId) {
-			try {
-				$this->updateIndexed($userId, $app, $key, $indexed);
-			} catch (UnknownKeyException) {
-				// should not happen and can be ignored
-			}
-		}
-
-		// we clear all cache
-		$this->clearCacheAll();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
-	 *
-	 * @return bool TRUE if entry was found in database and an update was necessary
-	 * @since 31.0.0
-	 */
-	public function updateLazy(string $userId, string $app, string $key, bool $lazy): bool {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfigAll($userId);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		try {
-			if ($lazy === $this->isLazy($userId, $app, $key)) {
-				return false;
-			}
-		} catch (UnknownKeyException) {
-			return false;
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('preferences')
-			->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
-			->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
-			->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		// At this point, it is a lot safer to clean cache
-		$this->clearCache($userId);
-
-		return true;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
-	 *
-	 * @since 31.0.0
-	 */
-	public function updateGlobalLazy(string $app, string $key, bool $lazy): void {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('preferences')
-			->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
-			->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		$this->clearCacheAll();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @return array
-	 * @throws UnknownKeyException if config key is not known in database
-	 * @since 31.0.0
-	 */
-	public function getDetails(string $userId, string $app, string $key): array {
-		$this->assertParams($userId, $app, $key);
-		$this->loadConfigAll($userId);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		$lazy = $this->isLazy($userId, $app, $key);
-
-		if ($lazy) {
-			$cache = $this->lazyCache[$userId];
-		} else {
-			$cache = $this->fastCache[$userId];
-		}
-
-		$type = $this->getValueType($userId, $app, $key);
-		try {
-			$typeString = $type->getDefinition();
-		} catch (IncorrectTypeException $e) {
-			$this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
-			$typeString = (string)$type->value;
-		}
-
-		if (!isset($cache[$app][$key])) {
-			throw new UnknownKeyException('unknown config key');
-		}
-
-		$value = $cache[$app][$key];
-		$sensitive = $this->isSensitive($userId, $app, $key, null);
-		$this->decryptSensitiveValue($userId, $app, $key, $value);
-
-		return [
-			'userId' => $userId,
-			'app' => $app,
-			'key' => $key,
-			'value' => $value,
-			'type' => $type->value,
-			'lazy' => $lazy,
-			'typeString' => $typeString,
-			'sensitive' => $sensitive
-		];
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @since 31.0.0
-	 */
-	public function deleteUserConfig(string $userId, string $app, string $key): void {
-		$this->assertParams($userId, $app, $key);
-		$this->matchAndApplyLexiconDefinition($userId, $app, $key);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('preferences')
-			->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)))
-			->andWhere($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
-			->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
-		$qb->executeStatement();
-
-		unset($this->lazyCache[$userId][$app][$key]);
-		unset($this->fastCache[$userId][$app][$key]);
-		unset($this->valueDetails[$userId][$app][$key]);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @since 31.0.0
-	 */
-	public function deleteKey(string $app, string $key): void {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
-		$this->matchAndApplyLexiconDefinition('', $app, $key);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('preferences')
-			->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
-			->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
-		$qb->executeStatement();
-
-		$this->clearCacheAll();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 *
-	 * @since 31.0.0
-	 */
-	public function deleteApp(string $app): void {
-		$this->assertParams('', $app, allowEmptyUser: true);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('preferences')
-			->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
-		$qb->executeStatement();
-
-		$this->clearCacheAll();
-	}
-
-	public function deleteAllUserConfig(string $userId): void {
-		$this->assertParams($userId, '', allowEmptyApp: true);
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('preferences')
-			->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)));
-		$qb->executeStatement();
-
-		$this->clearCache($userId);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $userId id of the user
-	 * @param bool $reload set to TRUE to refill cache instantly after clearing it.
-	 *
-	 * @since 31.0.0
-	 */
-	public function clearCache(string $userId, bool $reload = false): void {
-		$this->assertParams($userId, allowEmptyApp: true);
-		$this->lazyLoaded[$userId] = $this->fastLoaded[$userId] = false;
-		$this->lazyCache[$userId] = $this->fastCache[$userId] = $this->valueDetails[$userId] = [];
-
-		if (!$reload) {
-			return;
-		}
-
-		$this->loadConfigAll($userId);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @since 31.0.0
-	 */
-	public function clearCacheAll(): void {
-		$this->lazyLoaded = $this->fastLoaded = [];
-		$this->lazyCache = $this->fastCache = $this->valueDetails = $this->configLexiconDetails = [];
-	}
-
-	/**
-	 * For debug purpose.
-	 * Returns the cached data.
-	 *
-	 * @return array
-	 * @since 31.0.0
-	 * @internal
-	 */
-	public function statusCache(): array {
-		return [
-			'fastLoaded' => $this->fastLoaded,
-			'fastCache' => $this->fastCache,
-			'lazyLoaded' => $this->lazyLoaded,
-			'lazyCache' => $this->lazyCache,
-			'valueDetails' => $this->valueDetails,
-		];
-	}
-
-	/**
-	 * @param int $needle bitflag to search
-	 * @param int $flags all flags
-	 *
-	 * @return bool TRUE if bitflag $needle is set in $flags
-	 */
-	private function isFlagged(int $needle, int $flags): bool {
-		return (($needle & $flags) !== 0);
-	}
-
-	/**
-	 * Confirm the string set for app and key fit the database description
-	 *
-	 * @param string $userId
-	 * @param string $app assert $app fit in database
-	 * @param string $prefKey assert config key fit in database
-	 * @param bool $allowEmptyUser
-	 * @param bool $allowEmptyApp $app can be empty string
-	 * @param ValueType|null $valueType assert value type is only one type
-	 */
-	private function assertParams(
-		string $userId = '',
-		string $app = '',
-		string $prefKey = '',
-		bool $allowEmptyUser = false,
-		bool $allowEmptyApp = false,
-	): void {
-		if (!$allowEmptyUser && $userId === '') {
-			throw new InvalidArgumentException('userId cannot be an empty string');
-		}
-		if (!$allowEmptyApp && $app === '') {
-			throw new InvalidArgumentException('app cannot be an empty string');
-		}
-		if (strlen($userId) > self::USER_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $userId . ') for userId is too long (' . self::USER_MAX_LENGTH . ')');
-		}
-		if (strlen($app) > self::APP_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')');
-		}
-		if (strlen($prefKey) > self::KEY_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $prefKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
-		}
-	}
-
-	private function loadConfigAll(string $userId): void {
-		$this->loadConfig($userId, null);
-	}
-
-	/**
-	 * Load normal config or config set as lazy loaded
-	 *
-	 * @param bool|null $lazy set to TRUE to load config set as lazy loaded, set to NULL to load all config
-	 */
-	private function loadConfig(string $userId, ?bool $lazy = false): void {
-		if ($this->isLoaded($userId, $lazy)) {
-			return;
-		}
-
-		if (($lazy ?? true) !== false) { // if lazy is null or true, we debug log
-			$this->logger->debug('The loading of lazy UserConfig values have been requested', ['exception' => new \RuntimeException('ignorable exception')]);
-		}
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->from('preferences');
-		$qb->select('appid', 'configkey', 'configvalue', 'type', 'flags');
-		$qb->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)));
-
-		// we only need value from lazy when loadConfig does not specify it
-		if ($lazy !== null) {
-			$qb->andWhere($qb->expr()->eq('lazy', $qb->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT)));
-		} else {
-			$qb->addSelect('lazy');
-		}
-
-		$result = $qb->executeQuery();
-		$rows = $result->fetchAll();
-		foreach ($rows as $row) {
-			if (($row['lazy'] ?? ($lazy ?? 0) ? 1 : 0) === 1) {
-				$this->lazyCache[$userId][$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
-			} else {
-				$this->fastCache[$userId][$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
-			}
-			$this->valueDetails[$userId][$row['appid']][$row['configkey']] = ['type' => ValueType::from((int)($row['type'] ?? 0)), 'flags' => (int)$row['flags']];
-		}
-		$result->closeCursor();
-		$this->setAsLoaded($userId, $lazy);
-	}
-
-	/**
-	 * if $lazy is:
-	 *  - false: will returns true if fast config are loaded
-	 *  - true : will returns true if lazy config are loaded
-	 *  - null : will returns true if both config are loaded
-	 *
-	 * @param string $userId
-	 * @param bool $lazy
-	 *
-	 * @return bool
-	 */
-	private function isLoaded(string $userId, ?bool $lazy): bool {
-		if ($lazy === null) {
-			return ($this->lazyLoaded[$userId] ?? false) && ($this->fastLoaded[$userId] ?? false);
-		}
-
-		return $lazy ? $this->lazyLoaded[$userId] ?? false : $this->fastLoaded[$userId] ?? false;
-	}
-
-	/**
-	 * if $lazy is:
-	 * - false: set fast config as loaded
-	 * - true : set lazy config as loaded
-	 * - null : set both config as loaded
-	 *
-	 * @param string $userId
-	 * @param bool $lazy
-	 */
-	private function setAsLoaded(string $userId, ?bool $lazy): void {
-		if ($lazy === null) {
-			$this->fastLoaded[$userId] = $this->lazyLoaded[$userId] = true;
-			return;
-		}
-
-		// We also create empty entry to keep both fastLoaded/lazyLoaded synced
-		if ($lazy) {
-			$this->lazyLoaded[$userId] = true;
-			$this->fastLoaded[$userId] = $this->fastLoaded[$userId] ?? false;
-			$this->fastCache[$userId] = $this->fastCache[$userId] ?? [];
-		} else {
-			$this->fastLoaded[$userId] = true;
-			$this->lazyLoaded[$userId] = $this->lazyLoaded[$userId] ?? false;
-			$this->lazyCache[$userId] = $this->lazyCache[$userId] ?? [];
-		}
-	}
-
-	/**
-	 * **Warning:** this will load all lazy values from the database
-	 *
-	 * @param string $userId id of the user
-	 * @param string $app id of the app
-	 * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
-	 *
-	 * @return array<string, string|int|float|bool|array>
-	 */
-	private function formatAppValues(string $userId, string $app, array $values, bool $filtered = false): array {
-		foreach ($values as $key => $value) {
-			//$key = (string)$key;
-			try {
-				$type = $this->getValueType($userId, $app, (string)$key);
-			} catch (UnknownKeyException) {
-				continue;
-			}
-
-			if ($this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags'] ?? 0)) {
-				if ($filtered) {
-					$value = IConfig::SENSITIVE_VALUE;
-					$type = ValueType::STRING;
-				} else {
-					$this->decryptSensitiveValue($userId, $app, (string)$key, $value);
-				}
-			}
-
-			$values[$key] = $this->convertTypedValue($value, $type);
-		}
-
-		return $values;
-	}
-
-	/**
-	 * convert string value to the expected type
-	 *
-	 * @param string $value
-	 * @param ValueType $type
-	 *
-	 * @return string|int|float|bool|array
-	 */
-	private function convertTypedValue(string $value, ValueType $type): string|int|float|bool|array {
-		switch ($type) {
-			case ValueType::INT:
-				return (int)$value;
-			case ValueType::FLOAT:
-				return (float)$value;
-			case ValueType::BOOL:
-				return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
-			case ValueType::ARRAY:
-				try {
-					return json_decode($value, true, flags: JSON_THROW_ON_ERROR);
-				} catch (JsonException) {
-					// ignoreable
-				}
-				break;
-		}
-		return $value;
-	}
-
-
-	/**
-	 * will change referenced $value with the decrypted value in case of encrypted (sensitive value)
-	 *
-	 * @param string $userId
-	 * @param string $app
-	 * @param string $key
-	 * @param string $value
-	 */
-	private function decryptSensitiveValue(string $userId, string $app, string $key, string &$value): void {
-		if (!$this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags'] ?? 0)) {
-			return;
-		}
-
-		if (!str_starts_with($value, self::ENCRYPTION_PREFIX)) {
-			return;
-		}
-
-		try {
-			$value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
-		} catch (\Exception $e) {
-			$this->logger->warning('could not decrypt sensitive value', [
-				'userId' => $userId,
-				'app' => $app,
-				'key' => $key,
-				'value' => $value,
-				'exception' => $e
-			]);
-		}
-	}
-
-	/**
-	 * Match and apply current use of config values with defined lexicon.
-	 * Set $lazy to NULL only if only interested into checking that $key is alias.
-	 *
-	 * @throws UnknownKeyException
-	 * @throws TypeConflictException
-	 * @return bool FALSE if conflict with defined lexicon were observed in the process
-	 */
-	private function matchAndApplyLexiconDefinition(
-		string $userId,
-		string $app,
-		string &$key,
-		?bool &$lazy = null,
-		ValueType &$type = ValueType::MIXED,
-		int &$flags = 0,
-		?string &$default = null,
-	): bool {
-		$configDetails = $this->getConfigDetailsFromLexicon($app);
-		if (array_key_exists($key, $configDetails['aliases']) && !$this->ignoreLexiconAliases) {
-			// in case '$rename' is set in ConfigLexiconEntry, we use the new config key
-			$key = $configDetails['aliases'][$key];
-		}
-
-		if (!array_key_exists($key, $configDetails['entries'])) {
-			return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
-		}
-
-		// if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
-		if ($lazy === null) {
-			return true;
-		}
-
-		/** @var Entry $configValue */
-		$configValue = $configDetails['entries'][$key];
-		if ($type === ValueType::MIXED) {
-			// we overwrite if value was requested as mixed
-			$type = $configValue->getValueType();
-		} elseif ($configValue->getValueType() !== $type) {
-			throw new TypeConflictException('The user config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
-		}
-
-		$lazy = $configValue->isLazy();
-		$flags = $configValue->getFlags();
-		if ($configValue->isDeprecated()) {
-			$this->logger->notice('User config key ' . $app . '/' . $key . ' is set as deprecated.');
-		}
-
-		$enforcedValue = $this->config->getSystemValue('lexicon.default.userconfig.enforced', [])[$app][$key] ?? false;
-		if (!$enforcedValue && $this->hasKey($userId, $app, $key, $lazy)) {
-			// if key exists there should be no need to extract default
-			return true;
-		}
-
-		// only look for default if needed, default from Lexicon got priority if not overwritten by admin
-		if ($default !== null) {
-			$default = $this->getSystemDefault($app, $configValue) ?? $configValue->getDefault($this->presetManager->getLexiconPreset()) ?? $default;
-		}
-
-		// returning false will make get() returning $default and set() not changing value in database
-		return !$enforcedValue;
-	}
-
-	/**
-	 * get default value set in config/config.php if stored in key:
-	 *
-	 * 'lexicon.default.userconfig' => [
-	 *        <appId> => [
-	 *           <configKey> => 'my value',
-	 *        ]
-	 *     ],
-	 *
-	 * The entry is converted to string to fit the expected type when managing default value
-	 */
-	private function getSystemDefault(string $appId, Entry $configValue): ?string {
-		$default = $this->config->getSystemValue('lexicon.default.userconfig', [])[$appId][$configValue->getKey()] ?? null;
-		if ($default === null) {
-			// no system default, using default default.
-			return null;
-		}
-
-		return $configValue->convertToString($default);
-	}
-
-	/**
-	 * manage ConfigLexicon behavior based on strictness set in IConfigLexicon
-	 *
-	 * @param Strictness|null $strictness
-	 * @param string $line
-	 *
-	 * @return bool TRUE if conflict can be fully ignored
-	 * @throws UnknownKeyException
-	 * @see ILexicon::getStrictness()
-	 */
-	private function applyLexiconStrictness(?Strictness $strictness, string $configAppKey): bool {
-		if ($strictness === null) {
-			return true;
-		}
-
-		$line = 'The user config key ' . $configAppKey . ' is not defined in the config lexicon';
-		switch ($strictness) {
-			case Strictness::IGNORE:
-				return true;
-			case Strictness::NOTICE:
-				if (!in_array($configAppKey, $this->strictnessApplied, true)) {
-					$this->strictnessApplied[] = $configAppKey;
-					$this->logger->notice($line);
-				}
-				return true;
-			case Strictness::WARNING:
-				if (!in_array($configAppKey, $this->strictnessApplied, true)) {
-					$this->strictnessApplied[] = $configAppKey;
-					$this->logger->warning($line);
-				}
-				return false;
-			case Strictness::EXCEPTION:
-				throw new UnknownKeyException($line);
-		}
-
-		throw new UnknownKeyException($line);
-	}
-
-	/**
-	 * extract details from registered $appId's config lexicon
-	 *
-	 * @param string $appId
-	 *
-	 * @return array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}
-	 * @internal
-	 */
-	public function getConfigDetailsFromLexicon(string $appId): array {
-		if (!array_key_exists($appId, $this->configLexiconDetails)) {
-			$entries = $aliases = [];
-			$bootstrapCoordinator = \OCP\Server::get(Coordinator::class);
-			$configLexicon = $bootstrapCoordinator->getRegistrationContext()?->getConfigLexicon($appId);
-			foreach ($configLexicon?->getUserConfigs() ?? [] as $configEntry) {
-				$entries[$configEntry->getKey()] = $configEntry;
-				if ($configEntry->getRename() !== null) {
-					$aliases[$configEntry->getRename()] = $configEntry->getKey();
-				}
-			}
-
-			$this->configLexiconDetails[$appId] = [
-				'entries' => $entries,
-				'aliases' => $aliases,
-				'strictness' => $configLexicon?->getStrictness() ?? Strictness::IGNORE
-			];
-		}
-
-		return $this->configLexiconDetails[$appId];
-	}
-
-	/**
-	 * get Lexicon Entry using appId and config key entry
-	 *
-	 * @return Entry|null NULL if entry does not exist in user's Lexicon
-	 * @internal
-	 */
-	public function getLexiconEntry(string $appId, string $key): ?Entry {
-		return $this->getConfigDetailsFromLexicon($appId)['entries'][$key] ?? null;
-	}
-
-	/**
-	 * if set to TRUE, ignore aliases defined in Config Lexicon during the use of the methods of this class
-	 *
-	 * @internal
-	 */
-	public function ignoreLexiconAliases(bool $ignore): void {
-		$this->ignoreLexiconAliases = $ignore;
-	}
+    private const USER_MAX_LENGTH = 64;
+    private const APP_MAX_LENGTH = 32;
+    private const KEY_MAX_LENGTH = 64;
+    private const INDEX_MAX_LENGTH = 64;
+    private const ENCRYPTION_PREFIX = '$UserConfigEncryption$';
+    private const ENCRYPTION_PREFIX_LENGTH = 22; // strlen(self::ENCRYPTION_PREFIX)
+
+    /** @var array<string, array<string, array<string, mixed>>> [ass'user_id' => ['app_id' => ['key' => 'value']]] */
+    private array $fastCache = [];   // cache for normal config keys
+    /** @var array<string, array<string, array<string, mixed>>> ['user_id' => ['app_id' => ['key' => 'value']]] */
+    private array $lazyCache = [];   // cache for lazy config keys
+    /** @var array<string, array<string, array<string, array<string, mixed>>>> ['user_id' => ['app_id' => ['key' => ['type' => ValueType, 'flags' => bitflag]]]] */
+    private array $valueDetails = [];  // type for all config values
+    /** @var array<string, boolean> ['user_id' => bool] */
+    private array $fastLoaded = [];
+    /** @var array<string, boolean> ['user_id' => bool] */
+    private array $lazyLoaded = [];
+    /** @var array<string, array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}> ['app_id' => ['strictness' => ConfigLexiconStrictness, 'entries' => ['config_key' => ConfigLexiconEntry[]]] */
+    private array $configLexiconDetails = [];
+    private bool $ignoreLexiconAliases = false;
+    private array $strictnessApplied = [];
+
+    public function __construct(
+        protected IDBConnection $connection,
+        protected IConfig $config,
+        private readonly ConfigManager $configManager,
+        private readonly PresetManager $presetManager,
+        protected LoggerInterface $logger,
+        protected ICrypto $crypto,
+    ) {
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $appId optional id of app
+     *
+     * @return list<string> list of userIds
+     * @since 31.0.0
+     */
+    public function getUserIds(string $appId = ''): array {
+        $this->assertParams(app: $appId, allowEmptyUser: true, allowEmptyApp: true);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->from('preferences');
+        $qb->select('userid');
+        $qb->groupBy('userid');
+        if ($appId !== '') {
+            $qb->where($qb->expr()->eq('appid', $qb->createNamedParameter($appId)));
+        }
+
+        $result = $qb->executeQuery();
+        $rows = $result->fetchAll();
+        $userIds = [];
+        foreach ($rows as $row) {
+            $userIds[] = $row['userid'];
+        }
+
+        return $userIds;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @return list<string> list of app ids
+     * @since 31.0.0
+     */
+    public function getApps(string $userId): array {
+        $this->assertParams($userId, allowEmptyApp: true);
+        $this->loadConfigAll($userId);
+        $apps = array_merge(array_keys($this->fastCache[$userId] ?? []), array_keys($this->lazyCache[$userId] ?? []));
+        sort($apps);
+
+        return array_values(array_unique($apps));
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     *
+     * @return list<string> list of stored config keys
+     * @since 31.0.0
+     */
+    public function getKeys(string $userId, string $app): array {
+        $this->assertParams($userId, $app);
+        $this->loadConfigAll($userId);
+        // array_merge() will remove numeric keys (here config keys), so addition arrays instead
+        $keys = array_map('strval', array_keys(($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? [])));
+        sort($keys);
+
+        return array_values(array_unique($keys));
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
+     *
+     * @return bool TRUE if key exists
+     * @since 31.0.0
+     */
+    public function hasKey(string $userId, string $app, string $key, ?bool $lazy = false): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfig($userId, $lazy);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        if ($lazy === null) {
+            $appCache = $this->getValues($userId, $app);
+            return isset($appCache[$key]);
+        }
+
+        if ($lazy) {
+            return isset($this->lazyCache[$userId][$app][$key]);
+        }
+
+        return isset($this->fastCache[$userId][$app][$key]);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
+     *
+     * @return bool
+     * @throws UnknownKeyException if config key is not known
+     * @since 31.0.0
+     */
+    public function isSensitive(string $userId, string $app, string $key, ?bool $lazy = false): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfig($userId, $lazy);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        if (!isset($this->valueDetails[$userId][$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        return $this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags']);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
+     *
+     * @return bool
+     * @throws UnknownKeyException if config key is not known
+     * @since 31.0.0
+     */
+    public function isIndexed(string $userId, string $app, string $key, ?bool $lazy = false): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfig($userId, $lazy);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        if (!isset($this->valueDetails[$userId][$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        return $this->isFlagged(self::FLAG_INDEXED, $this->valueDetails[$userId][$app][$key]['flags']);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app if of the app
+     * @param string $key config key
+     *
+     * @return bool TRUE if config is lazy loaded
+     * @throws UnknownKeyException if config key is not known
+     * @see IUserConfig for details about lazy loading
+     * @since 31.0.0
+     */
+    public function isLazy(string $userId, string $app, string $key): bool {
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        // there is a huge probability the non-lazy config are already loaded
+        // meaning that we can start by only checking if a current non-lazy key exists
+        if ($this->hasKey($userId, $app, $key, false)) {
+            // meaning key is not lazy.
+            return false;
+        }
+
+        // as key is not found as non-lazy, we load and search in the lazy config
+        if ($this->hasKey($userId, $app, $key, true)) {
+            return true;
+        }
+
+        throw new UnknownKeyException('unknown config key');
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $prefix config keys prefix to search
+     * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
+     *
+     * @return array<string, string|int|float|bool|array> [key => value]
+     * @since 31.0.0
+     */
+    public function getValues(
+        string $userId,
+        string $app,
+        string $prefix = '',
+        bool $filtered = false,
+    ): array {
+        $this->assertParams($userId, $app, $prefix);
+        // if we want to filter values, we need to get sensitivity
+        $this->loadConfigAll($userId);
+        // array_merge() will remove numeric keys (here config keys), so addition arrays instead
+        $values = array_filter(
+            $this->formatAppValues($userId, $app, ($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? []), $filtered),
+            function (string $key) use ($prefix): bool {
+                // filter values based on $prefix
+                return str_starts_with($key, $prefix);
+            }, ARRAY_FILTER_USE_KEY
+        );
+
+        return $values;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
+     *
+     * @return array<string, array<string, string|int|float|bool|array>> [appId => [key => value]]
+     * @since 31.0.0
+     */
+    public function getAllValues(string $userId, bool $filtered = false): array {
+        $this->assertParams($userId, allowEmptyApp: true);
+        $this->loadConfigAll($userId);
+
+        $result = [];
+        foreach ($this->getApps($userId) as $app) {
+            // array_merge() will remove numeric keys (here config keys), so addition arrays instead
+            $cached = ($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? []);
+            $result[$app] = $this->formatAppValues($userId, $app, $cached, $filtered);
+        }
+
+        return $result;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $key config key
+     * @param bool $lazy search within lazy loaded config
+     * @param ValueType|null $typedAs enforce type for the returned values
+     *
+     * @return array<string, string|int|float|bool|array> [appId => value]
+     * @since 31.0.0
+     */
+    public function getValuesByApps(string $userId, string $key, bool $lazy = false, ?ValueType $typedAs = null): array {
+        $this->assertParams($userId, '', $key, allowEmptyApp: true);
+        $this->loadConfig($userId, $lazy);
+
+        /** @var array<array-key, array<array-key, mixed>> $cache */
+        if ($lazy) {
+            $cache = $this->lazyCache[$userId];
+        } else {
+            $cache = $this->fastCache[$userId];
+        }
+
+        $values = [];
+        foreach (array_keys($cache) as $app) {
+            if (isset($cache[$app][$key])) {
+                $value = $cache[$app][$key];
+                try {
+                    $this->decryptSensitiveValue($userId, $app, $key, $value);
+                    $value = $this->convertTypedValue($value, $typedAs ?? $this->getValueType($userId, $app, $key, $lazy));
+                } catch (IncorrectTypeException|UnknownKeyException) {
+                }
+                $values[$app] = $value;
+            }
+        }
+
+        return $values;
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param ValueType|null $typedAs enforce type for the returned values
+     * @param array|null $userIds limit to a list of user ids
+     *
+     * @return array<string, string|int|float|bool|array> [userId => value]
+     * @since 31.0.0
+     */
+    public function getValuesByUsers(
+        string $app,
+        string $key,
+        ?ValueType $typedAs = null,
+        ?array $userIds = null,
+    ): array {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->select('userid', 'configvalue', 'type')
+            ->from('preferences')
+            ->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
+            ->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
+
+        $values = [];
+        // this nested function will execute current Query and store result within $values.
+        $executeAndStoreValue = function (IQueryBuilder $qb) use (&$values, $typedAs): IResult {
+            $result = $qb->executeQuery();
+            while ($row = $result->fetch()) {
+                $value = $row['configvalue'];
+                try {
+                    $value = $this->convertTypedValue($value, $typedAs ?? ValueType::from((int)$row['type']));
+                } catch (IncorrectTypeException) {
+                }
+                $values[$row['userid']] = $value;
+            }
+            return $result;
+        };
+
+        // if no userIds to filter, we execute query as it is and returns all values ...
+        if ($userIds === null) {
+            $result = $executeAndStoreValue($qb);
+            $result->closeCursor();
+            return $values;
+        }
+
+        // if userIds to filter, we chunk the list and execute the same query multiple times until we get all values
+        $result = null;
+        $qb->andWhere($qb->expr()->in('userid', $qb->createParameter('userIds')));
+        foreach (array_chunk($userIds, 50, true) as $chunk) {
+            $qb->setParameter('userIds', $chunk, IQueryBuilder::PARAM_STR_ARRAY);
+            $result = $executeAndStoreValue($qb);
+        }
+        $result?->closeCursor();
+
+        return $values;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $caseInsensitive non-case-sensitive search, only works if $value is a string
+     *
+     * @return Generator<string>
+     * @since 31.0.0
+     */
+    public function searchUsersByValueString(string $app, string $key, string $value, bool $caseInsensitive = false): Generator {
+        return $this->searchUsersByTypedValue($app, $key, $value, $caseInsensitive);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $value config value
+     *
+     * @return Generator<string>
+     * @since 31.0.0
+     */
+    public function searchUsersByValueInt(string $app, string $key, int $value): Generator {
+        return $this->searchUsersByValueString($app, $key, (string)$value);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param array $values list of config values
+     *
+     * @return Generator<string>
+     * @since 31.0.0
+     */
+    public function searchUsersByValues(string $app, string $key, array $values): Generator {
+        return $this->searchUsersByTypedValue($app, $key, $values);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $value config value
+     *
+     * @return Generator<string>
+     * @since 31.0.0
+     */
+    public function searchUsersByValueBool(string $app, string $key, bool $value): Generator {
+        $values = ['0', 'off', 'false', 'no'];
+        if ($value) {
+            $values = ['1', 'on', 'true', 'yes'];
+        }
+        return $this->searchUsersByValues($app, $key, $values);
+    }
+
+    /**
+     * returns a list of users with config key set to a specific value, or within the list of
+     * possible values
+     *
+     * @param string $app
+     * @param string $key
+     * @param string|array $value
+     * @param bool $caseInsensitive
+     *
+     * @return Generator<string>
+     */
+    private function searchUsersByTypedValue(string $app, string $key, string|array $value, bool $caseInsensitive = false): Generator {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->from('preferences');
+        $qb->select('userid');
+        $qb->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
+        $qb->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
+
+        // search within 'indexed' OR 'configvalue' only if 'flags' is set as not indexed
+        // TODO: when implementing config lexicon remove the searches on 'configvalue' if value is set as indexed
+        $configValueColumn = ($this->connection->getDatabaseProvider() === IDBConnection::PLATFORM_ORACLE) ? $qb->expr()->castColumn('configvalue', IQueryBuilder::PARAM_STR) : 'configvalue';
+        if (is_array($value)) {
+            $where = $qb->expr()->orX(
+                $qb->expr()->in('indexed', $qb->createNamedParameter($value, IQueryBuilder::PARAM_STR_ARRAY)),
+                $qb->expr()->andX(
+                    $qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
+                    $qb->expr()->in($configValueColumn, $qb->createNamedParameter($value, IQueryBuilder::PARAM_STR_ARRAY))
+                )
+            );
+        } else {
+            if ($caseInsensitive) {
+                $where = $qb->expr()->orX(
+                    $qb->expr()->eq($qb->func()->lower('indexed'), $qb->createNamedParameter(strtolower($value))),
+                    $qb->expr()->andX(
+                        $qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
+                        $qb->expr()->eq($qb->func()->lower($configValueColumn), $qb->createNamedParameter(strtolower($value)))
+                    )
+                );
+            } else {
+                $where = $qb->expr()->orX(
+                    $qb->expr()->eq('indexed', $qb->createNamedParameter($value)),
+                    $qb->expr()->andX(
+                        $qb->expr()->neq($qb->expr()->bitwiseAnd('flags', self::FLAG_INDEXED), $qb->createNamedParameter(self::FLAG_INDEXED, IQueryBuilder::PARAM_INT)),
+                        $qb->expr()->eq($configValueColumn, $qb->createNamedParameter($value))
+                    )
+                );
+            }
+        }
+
+        $qb->andWhere($where);
+        $result = $qb->executeQuery();
+        while ($row = $result->fetch()) {
+            yield $row['userid'];
+        }
+    }
+
+    /**
+     * Get the config value as string.
+     * If the value does not exist the given default will be returned.
+     *
+     * Set lazy to `null` to ignore it and get the value from either source.
+     *
+     * **WARNING:** Method is internal and **SHOULD** not be used, as it is better to get the value with a type.
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default config value
+     * @param null|bool $lazy get config as lazy loaded or not. can be NULL
+     *
+     * @return string the value or $default
+     * @throws TypeConflictException
+     * @internal
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     * @see getValueString()
+     * @see getValueInt()
+     * @see getValueFloat()
+     * @see getValueBool()
+     * @see getValueArray()
+     */
+    public function getValueMixed(
+        string $userId,
+        string $app,
+        string $key,
+        string $default = '',
+        ?bool $lazy = false,
+    ): string {
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+        try {
+            $lazy ??= $this->isLazy($userId, $app, $key);
+        } catch (UnknownKeyException) {
+            return $default;
+        }
+
+        return $this->getTypedValue(
+            $userId,
+            $app,
+            $key,
+            $default,
+            $lazy,
+            ValueType::MIXED
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return string stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws TypeConflictException in case of conflict with the value type set in database
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function getValueString(
+        string $userId,
+        string $app,
+        string $key,
+        string $default = '',
+        bool $lazy = false,
+    ): string {
+        return $this->getTypedValue($userId, $app, $key, $default, $lazy, ValueType::STRING);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return int stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws TypeConflictException in case of conflict with the value type set in database
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function getValueInt(
+        string $userId,
+        string $app,
+        string $key,
+        int $default = 0,
+        bool $lazy = false,
+    ): int {
+        return (int)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::INT);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param float $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return float stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws TypeConflictException in case of conflict with the value type set in database
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function getValueFloat(
+        string $userId,
+        string $app,
+        string $key,
+        float $default = 0,
+        bool $lazy = false,
+    ): float {
+        return (float)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::FLOAT);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return bool stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws TypeConflictException in case of conflict with the value type set in database
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function getValueBool(
+        string $userId,
+        string $app,
+        string $key,
+        bool $default = false,
+        bool $lazy = false,
+    ): bool {
+        $b = strtolower($this->getTypedValue($userId, $app, $key, $default ? 'true' : 'false', $lazy, ValueType::BOOL));
+        return in_array($b, ['1', 'true', 'yes', 'on']);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param array $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return array stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws TypeConflictException in case of conflict with the value type set in database
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function getValueArray(
+        string $userId,
+        string $app,
+        string $key,
+        array $default = [],
+        bool $lazy = false,
+    ): array {
+        try {
+            $defaultJson = json_encode($default, JSON_THROW_ON_ERROR);
+            $value = json_decode($this->getTypedValue($userId, $app, $key, $defaultJson, $lazy, ValueType::ARRAY), true, flags: JSON_THROW_ON_ERROR);
+
+            return is_array($value) ? $value : [];
+        } catch (JsonException) {
+            return [];
+        }
+    }
+
+    /**
+     * @param string $userId
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default default value
+     * @param bool $lazy search within lazy loaded config
+     * @param ValueType $type value type
+     *
+     * @return string
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     */
+    private function getTypedValue(
+        string $userId,
+        string $app,
+        string $key,
+        string $default,
+        bool $lazy,
+        ValueType $type,
+    ): string {
+        $this->assertParams($userId, $app, $key);
+        $origKey = $key;
+        $matched = $this->matchAndApplyLexiconDefinition($userId, $app, $key, $lazy, $type, default: $default);
+        if ($default === null) {
+            // there is no logical reason for it to be null
+            throw new \Exception('default cannot be null');
+        }
+
+        // returns default if strictness of lexicon is set to WARNING (block and report)
+        if (!$matched) {
+            return $default;
+        }
+
+        $this->loadConfig($userId, $lazy);
+
+        /**
+         * We ignore check if mixed type is requested.
+         * If type of stored value is set as mixed, we don't filter.
+         * If type of stored value is defined, we compare with the one requested.
+         */
+        $knownType = $this->valueDetails[$userId][$app][$key]['type'] ?? null;
+        if ($type !== ValueType::MIXED
+            && $knownType !== null
+            && $knownType !== ValueType::MIXED
+            && $type !== $knownType) {
+            $this->logger->warning('conflict with value type from database', ['app' => $app, 'key' => $key, 'type' => $type, 'knownType' => $knownType]);
+            throw new TypeConflictException('conflict with value type from database');
+        }
+
+        /**
+         * - the pair $app/$key cannot exist in both array,
+         * - we should still return an existing non-lazy value even if current method
+         *   is called with $lazy is true
+         *
+         * This way, lazyCache will be empty until the load for lazy config value is requested.
+         */
+        if (isset($this->lazyCache[$userId][$app][$key])) {
+            $value = $this->lazyCache[$userId][$app][$key];
+        } elseif (isset($this->fastCache[$userId][$app][$key])) {
+            $value = $this->fastCache[$userId][$app][$key];
+        } else {
+            return $default;
+        }
+
+        $this->decryptSensitiveValue($userId, $app, $key, $value);
+
+        // in case the key was modified while running matchAndApplyLexiconDefinition() we are
+        // interested to check options in case a modification of the value is needed
+        // ie inverting value from previous key when using lexicon option RENAME_INVERT_BOOLEAN
+        if ($origKey !== $key && $type === ValueType::BOOL) {
+            $value = ($this->configManager->convertToBool($value, $this->getLexiconEntry($app, $key))) ? '1' : '0';
+        }
+
+        return $value;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @return ValueType type of the value
+     * @throws UnknownKeyException if config key is not known
+     * @throws IncorrectTypeException if config value type is not known
+     * @since 31.0.0
+     */
+    public function getValueType(string $userId, string $app, string $key, ?bool $lazy = null): ValueType {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfig($userId, $lazy);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        if (!isset($this->valueDetails[$userId][$app][$key]['type'])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        return $this->valueDetails[$userId][$app][$key]['type'];
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $lazy lazy loading
+     *
+     * @return int flags applied to value
+     * @throws UnknownKeyException if config key is not known
+     * @throws IncorrectTypeException if config value type is not known
+     * @since 31.0.0
+     */
+    public function getValueFlags(string $userId, string $app, string $key, bool $lazy = false): int {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfig($userId, $lazy);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        if (!isset($this->valueDetails[$userId][$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        return $this->valueDetails[$userId][$app][$key]['flags'];
+    }
+
+    /**
+     * Store a config key and its value in database as VALUE_MIXED
+     *
+     * **WARNING:** Method is internal and **MUST** not be used as it is best to set a real value type
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED
+     * @internal
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     * @see setValueString()
+     * @see setValueInt()
+     * @see setValueFloat()
+     * @see setValueBool()
+     * @see setValueArray()
+     */
+    public function setValueMixed(
+        string $userId,
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        return $this->setTypedValue(
+            $userId,
+            $app,
+            $key,
+            $value,
+            $lazy,
+            $flags,
+            ValueType::MIXED
+        );
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function setValueString(
+        string $userId,
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        return $this->setTypedValue(
+            $userId,
+            $app,
+            $key,
+            $value,
+            $lazy,
+            $flags,
+            ValueType::STRING
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function setValueInt(
+        string $userId,
+        string $app,
+        string $key,
+        int $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        if ($value > 2000000000) {
+            $this->logger->debug('You are trying to store an integer value around/above 2,147,483,647. This is a reminder that reaching this theoretical limit on 32 bits system will throw an exception.');
+        }
+
+        return $this->setTypedValue(
+            $userId,
+            $app,
+            $key,
+            (string)$value,
+            $lazy,
+            $flags,
+            ValueType::INT
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param float $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function setValueFloat(
+        string $userId,
+        string $app,
+        string $key,
+        float $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        return $this->setTypedValue(
+            $userId,
+            $app,
+            $key,
+            (string)$value,
+            $lazy,
+            $flags,
+            ValueType::FLOAT
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $value config value
+     * @param bool $lazy set config as lazy loaded
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function setValueBool(
+        string $userId,
+        string $app,
+        string $key,
+        bool $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        return $this->setTypedValue(
+            $userId,
+            $app,
+            $key,
+            ($value) ? '1' : '0',
+            $lazy,
+            $flags,
+            ValueType::BOOL
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param array $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @throws JsonException
+     * @since 31.0.0
+     * @see IUserConfig for explanation about lazy loading
+     */
+    public function setValueArray(
+        string $userId,
+        string $app,
+        string $key,
+        array $value,
+        bool $lazy = false,
+        int $flags = 0,
+    ): bool {
+        try {
+            return $this->setTypedValue(
+                $userId,
+                $app,
+                $key,
+                json_encode($value, JSON_THROW_ON_ERROR),
+                $lazy,
+                $flags,
+                ValueType::ARRAY
+            );
+        } catch (JsonException $e) {
+            $this->logger->warning('could not setValueArray', ['app' => $app, 'key' => $key, 'exception' => $e]);
+            throw $e;
+        }
+    }
+
+    /**
+     * Store a config key and its value in database
+     *
+     * If config key is already known with the exact same config value and same sensitive/lazy status, the
+     * database is not updated. If config value was previously stored as sensitive, status will not be
+     * altered.
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy config set as lazy loaded
+     * @param ValueType $type value type
+     *
+     * @return bool TRUE if value was updated in database
+     * @throws TypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @see IUserConfig for explanation about lazy loading
+     */
+    private function setTypedValue(
+        string $userId,
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy,
+        int $flags,
+        ValueType $type,
+    ): bool {
+        // Primary email addresses are always(!) expected to be lowercase
+        if ($app === 'settings' && $key === 'email') {
+            $value = strtolower($value);
+        }
+
+        $this->assertParams($userId, $app, $key);
+        if (!$this->matchAndApplyLexiconDefinition($userId, $app, $key, $lazy, $type, $flags)) {
+            // returns false as database is not updated
+            return false;
+        }
+        $this->loadConfig($userId, $lazy);
+
+        $inserted = $refreshCache = false;
+        $origValue = $value;
+        $sensitive = $this->isFlagged(self::FLAG_SENSITIVE, $flags);
+        if ($sensitive || ($this->hasKey($userId, $app, $key, $lazy) && $this->isSensitive($userId, $app, $key, $lazy))) {
+            $value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+            $flags |= self::FLAG_SENSITIVE;
+        }
+
+        // if requested, we fill the 'indexed' field with current value
+        $indexed = '';
+        if ($type !== ValueType::ARRAY && $this->isFlagged(self::FLAG_INDEXED, $flags)) {
+            if ($this->isFlagged(self::FLAG_SENSITIVE, $flags)) {
+                $this->logger->warning('sensitive value are not to be indexed');
+            } elseif (strlen($value) > self::USER_MAX_LENGTH) {
+                $this->logger->warning('value is too lengthy to be indexed');
+            } else {
+                $indexed = $value;
+            }
+        }
+
+        if ($this->hasKey($userId, $app, $key, $lazy)) {
+            /**
+             * no update if key is already known with set lazy status and value is
+             * not different, unless sensitivity is switched from false to true.
+             */
+            if ($origValue === $this->getTypedValue($userId, $app, $key, $value, $lazy, $type)
+                && (!$sensitive || $this->isSensitive($userId, $app, $key, $lazy))) {
+                return false;
+            }
+        } else {
+            /**
+             * if key is not known yet, we try to insert.
+             * It might fail if the key exists with a different lazy flag.
+             */
+            try {
+                $insert = $this->connection->getQueryBuilder();
+                $insert->insert('preferences')
+                    ->setValue('userid', $insert->createNamedParameter($userId))
+                    ->setValue('appid', $insert->createNamedParameter($app))
+                    ->setValue('lazy', $insert->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
+                    ->setValue('type', $insert->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
+                    ->setValue('flags', $insert->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
+                    ->setValue('indexed', $insert->createNamedParameter($indexed))
+                    ->setValue('configkey', $insert->createNamedParameter($key))
+                    ->setValue('configvalue', $insert->createNamedParameter($value));
+                $insert->executeStatement();
+                $inserted = true;
+            } catch (DBException $e) {
+                if ($e->getReason() !== DBException::REASON_UNIQUE_CONSTRAINT_VIOLATION) {
+                    // TODO: throw exception or just log and returns false !?
+                    throw $e;
+                }
+            }
+        }
+
+        /**
+         * We cannot insert a new row, meaning we need to update an already existing one
+         */
+        if (!$inserted) {
+            $currType = $this->valueDetails[$userId][$app][$key]['type'] ?? null;
+            if ($currType === null) { // this might happen when switching lazy loading status
+                $this->loadConfigAll($userId);
+                $currType = $this->valueDetails[$userId][$app][$key]['type'];
+            }
+
+            /**
+             * We only log a warning and set it to VALUE_MIXED.
+             */
+            if ($currType === null) {
+                $this->logger->warning('Value type is set to zero (0) in database. This is not supposed to happens', ['app' => $app, 'key' => $key]);
+                $currType = ValueType::MIXED;
+            }
+
+            /**
+             * we only accept a different type from the one stored in database
+             * if the one stored in database is not-defined (VALUE_MIXED)
+             */
+            if ($currType !== ValueType::MIXED
+                && $currType !== $type) {
+                try {
+                    $currTypeDef = $currType->getDefinition();
+                    $typeDef = $type->getDefinition();
+                } catch (IncorrectTypeException) {
+                    $currTypeDef = $currType->value;
+                    $typeDef = $type->value;
+                }
+                throw new TypeConflictException('conflict between new type (' . $typeDef . ') and old type (' . $currTypeDef . ')');
+            }
+
+            if ($lazy !== $this->isLazy($userId, $app, $key)) {
+                $refreshCache = true;
+            }
+
+            $update = $this->connection->getQueryBuilder();
+            $update->update('preferences')
+                ->set('configvalue', $update->createNamedParameter($value))
+                ->set('lazy', $update->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
+                ->set('type', $update->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
+                ->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
+                ->set('indexed', $update->createNamedParameter($indexed))
+                ->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
+                ->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
+                ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+
+            $update->executeStatement();
+        }
+
+        if ($refreshCache) {
+            $this->clearCache($userId);
+            return true;
+        }
+
+        // update local cache
+        if ($lazy) {
+            $this->lazyCache[$userId][$app][$key] = $value;
+        } else {
+            $this->fastCache[$userId][$app][$key] = $value;
+        }
+        $this->valueDetails[$userId][$app][$key] = [
+            'type' => $type,
+            'flags' => $flags
+        ];
+
+        return true;
+    }
+
+    /**
+     * Change the type of config value.
+     *
+     * **WARNING:** Method is internal and **MUST** not be used as it may break things.
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param ValueType $type value type
+     *
+     * @return bool TRUE if database update were necessary
+     * @throws UnknownKeyException if $key is now known in database
+     * @throws IncorrectTypeException if $type is not valid
+     * @internal
+     * @since 31.0.0
+     */
+    public function updateType(string $userId, string $app, string $key, ValueType $type = ValueType::MIXED): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfigAll($userId);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+        $this->isLazy($userId, $app, $key); // confirm key exists
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('preferences')
+            ->set('type', $update->createNamedParameter($type->value, IQueryBuilder::PARAM_INT))
+            ->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
+            ->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        $this->valueDetails[$userId][$app][$key]['type'] = $type;
+
+        return true;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $sensitive TRUE to set as sensitive, FALSE to unset
+     *
+     * @return bool TRUE if entry was found in database and an update was necessary
+     * @since 31.0.0
+     */
+    public function updateSensitive(string $userId, string $app, string $key, bool $sensitive): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfigAll($userId);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        try {
+            if ($sensitive === $this->isSensitive($userId, $app, $key, null)) {
+                return false;
+            }
+        } catch (UnknownKeyException) {
+            return false;
+        }
+
+        $lazy = $this->isLazy($userId, $app, $key);
+        if ($lazy) {
+            $cache = $this->lazyCache;
+        } else {
+            $cache = $this->fastCache;
+        }
+
+        if (!isset($cache[$userId][$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        $value = $cache[$userId][$app][$key];
+        $flags = $this->getValueFlags($userId, $app, $key);
+        if ($sensitive) {
+            $flags |= self::FLAG_SENSITIVE;
+            $value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+        } else {
+            $flags &= ~self::FLAG_SENSITIVE;
+            $this->decryptSensitiveValue($userId, $app, $key, $value);
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('preferences')
+            ->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
+            ->set('configvalue', $update->createNamedParameter($value))
+            ->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
+            ->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        $this->valueDetails[$userId][$app][$key]['flags'] = $flags;
+
+        return true;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app
+     * @param string $key
+     * @param bool $sensitive
+     *
+     * @since 31.0.0
+     */
+    public function updateGlobalSensitive(string $app, string $key, bool $sensitive): void {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        foreach (array_keys($this->getValuesByUsers($app, $key)) as $userId) {
+            try {
+                $this->updateSensitive($userId, $app, $key, $sensitive);
+            } catch (UnknownKeyException) {
+                // should not happen and can be ignored
+            }
+        }
+
+        // we clear all cache
+        $this->clearCacheAll();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId
+     * @param string $app
+     * @param string $key
+     * @param bool $indexed
+     *
+     * @return bool
+     * @throws DBException
+     * @throws IncorrectTypeException
+     * @throws UnknownKeyException
+     * @since 31.0.0
+     */
+    public function updateIndexed(string $userId, string $app, string $key, bool $indexed): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfigAll($userId);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        try {
+            if ($indexed === $this->isIndexed($userId, $app, $key, null)) {
+                return false;
+            }
+        } catch (UnknownKeyException) {
+            return false;
+        }
+
+        $lazy = $this->isLazy($userId, $app, $key);
+        if ($lazy) {
+            $cache = $this->lazyCache;
+        } else {
+            $cache = $this->fastCache;
+        }
+
+        if (!isset($cache[$userId][$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        $value = $cache[$userId][$app][$key];
+        $flags = $this->getValueFlags($userId, $app, $key);
+        if ($indexed) {
+            $indexed = $value;
+        } else {
+            $flags &= ~self::FLAG_INDEXED;
+            $indexed = '';
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('preferences')
+            ->set('flags', $update->createNamedParameter($flags, IQueryBuilder::PARAM_INT))
+            ->set('indexed', $update->createNamedParameter($indexed))
+            ->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
+            ->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        $this->valueDetails[$userId][$app][$key]['flags'] = $flags;
+
+        return true;
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app
+     * @param string $key
+     * @param bool $indexed
+     *
+     * @since 31.0.0
+     */
+    public function updateGlobalIndexed(string $app, string $key, bool $indexed): void {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        foreach (array_keys($this->getValuesByUsers($app, $key)) as $userId) {
+            try {
+                $this->updateIndexed($userId, $app, $key, $indexed);
+            } catch (UnknownKeyException) {
+                // should not happen and can be ignored
+            }
+        }
+
+        // we clear all cache
+        $this->clearCacheAll();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
+     *
+     * @return bool TRUE if entry was found in database and an update was necessary
+     * @since 31.0.0
+     */
+    public function updateLazy(string $userId, string $app, string $key, bool $lazy): bool {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfigAll($userId);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        try {
+            if ($lazy === $this->isLazy($userId, $app, $key)) {
+                return false;
+            }
+        } catch (UnknownKeyException) {
+            return false;
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('preferences')
+            ->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
+            ->where($update->expr()->eq('userid', $update->createNamedParameter($userId)))
+            ->andWhere($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        // At this point, it is a lot safer to clean cache
+        $this->clearCache($userId);
+
+        return true;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
+     *
+     * @since 31.0.0
+     */
+    public function updateGlobalLazy(string $app, string $key, bool $lazy): void {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('preferences')
+            ->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
+            ->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        $this->clearCacheAll();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @return array
+     * @throws UnknownKeyException if config key is not known in database
+     * @since 31.0.0
+     */
+    public function getDetails(string $userId, string $app, string $key): array {
+        $this->assertParams($userId, $app, $key);
+        $this->loadConfigAll($userId);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        $lazy = $this->isLazy($userId, $app, $key);
+
+        if ($lazy) {
+            $cache = $this->lazyCache[$userId];
+        } else {
+            $cache = $this->fastCache[$userId];
+        }
+
+        $type = $this->getValueType($userId, $app, $key);
+        try {
+            $typeString = $type->getDefinition();
+        } catch (IncorrectTypeException $e) {
+            $this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
+            $typeString = (string)$type->value;
+        }
+
+        if (!isset($cache[$app][$key])) {
+            throw new UnknownKeyException('unknown config key');
+        }
+
+        $value = $cache[$app][$key];
+        $sensitive = $this->isSensitive($userId, $app, $key, null);
+        $this->decryptSensitiveValue($userId, $app, $key, $value);
+
+        return [
+            'userId' => $userId,
+            'app' => $app,
+            'key' => $key,
+            'value' => $value,
+            'type' => $type->value,
+            'lazy' => $lazy,
+            'typeString' => $typeString,
+            'sensitive' => $sensitive
+        ];
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @since 31.0.0
+     */
+    public function deleteUserConfig(string $userId, string $app, string $key): void {
+        $this->assertParams($userId, $app, $key);
+        $this->matchAndApplyLexiconDefinition($userId, $app, $key);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('preferences')
+            ->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)))
+            ->andWhere($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
+            ->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
+        $qb->executeStatement();
+
+        unset($this->lazyCache[$userId][$app][$key]);
+        unset($this->fastCache[$userId][$app][$key]);
+        unset($this->valueDetails[$userId][$app][$key]);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @since 31.0.0
+     */
+    public function deleteKey(string $app, string $key): void {
+        $this->assertParams('', $app, $key, allowEmptyUser: true);
+        $this->matchAndApplyLexiconDefinition('', $app, $key);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('preferences')
+            ->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
+            ->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
+        $qb->executeStatement();
+
+        $this->clearCacheAll();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     *
+     * @since 31.0.0
+     */
+    public function deleteApp(string $app): void {
+        $this->assertParams('', $app, allowEmptyUser: true);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('preferences')
+            ->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
+        $qb->executeStatement();
+
+        $this->clearCacheAll();
+    }
+
+    public function deleteAllUserConfig(string $userId): void {
+        $this->assertParams($userId, '', allowEmptyApp: true);
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('preferences')
+            ->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)));
+        $qb->executeStatement();
+
+        $this->clearCache($userId);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $userId id of the user
+     * @param bool $reload set to TRUE to refill cache instantly after clearing it.
+     *
+     * @since 31.0.0
+     */
+    public function clearCache(string $userId, bool $reload = false): void {
+        $this->assertParams($userId, allowEmptyApp: true);
+        $this->lazyLoaded[$userId] = $this->fastLoaded[$userId] = false;
+        $this->lazyCache[$userId] = $this->fastCache[$userId] = $this->valueDetails[$userId] = [];
+
+        if (!$reload) {
+            return;
+        }
+
+        $this->loadConfigAll($userId);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @since 31.0.0
+     */
+    public function clearCacheAll(): void {
+        $this->lazyLoaded = $this->fastLoaded = [];
+        $this->lazyCache = $this->fastCache = $this->valueDetails = $this->configLexiconDetails = [];
+    }
+
+    /**
+     * For debug purpose.
+     * Returns the cached data.
+     *
+     * @return array
+     * @since 31.0.0
+     * @internal
+     */
+    public function statusCache(): array {
+        return [
+            'fastLoaded' => $this->fastLoaded,
+            'fastCache' => $this->fastCache,
+            'lazyLoaded' => $this->lazyLoaded,
+            'lazyCache' => $this->lazyCache,
+            'valueDetails' => $this->valueDetails,
+        ];
+    }
+
+    /**
+     * @param int $needle bitflag to search
+     * @param int $flags all flags
+     *
+     * @return bool TRUE if bitflag $needle is set in $flags
+     */
+    private function isFlagged(int $needle, int $flags): bool {
+        return (($needle & $flags) !== 0);
+    }
+
+    /**
+     * Confirm the string set for app and key fit the database description
+     *
+     * @param string $userId
+     * @param string $app assert $app fit in database
+     * @param string $prefKey assert config key fit in database
+     * @param bool $allowEmptyUser
+     * @param bool $allowEmptyApp $app can be empty string
+     * @param ValueType|null $valueType assert value type is only one type
+     */
+    private function assertParams(
+        string $userId = '',
+        string $app = '',
+        string $prefKey = '',
+        bool $allowEmptyUser = false,
+        bool $allowEmptyApp = false,
+    ): void {
+        if (!$allowEmptyUser && $userId === '') {
+            throw new InvalidArgumentException('userId cannot be an empty string');
+        }
+        if (!$allowEmptyApp && $app === '') {
+            throw new InvalidArgumentException('app cannot be an empty string');
+        }
+        if (strlen($userId) > self::USER_MAX_LENGTH) {
+            throw new InvalidArgumentException('Value (' . $userId . ') for userId is too long (' . self::USER_MAX_LENGTH . ')');
+        }
+        if (strlen($app) > self::APP_MAX_LENGTH) {
+            throw new InvalidArgumentException('Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')');
+        }
+        if (strlen($prefKey) > self::KEY_MAX_LENGTH) {
+            throw new InvalidArgumentException('Value (' . $prefKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
+        }
+    }
+
+    private function loadConfigAll(string $userId): void {
+        $this->loadConfig($userId, null);
+    }
+
+    /**
+     * Load normal config or config set as lazy loaded
+     *
+     * @param bool|null $lazy set to TRUE to load config set as lazy loaded, set to NULL to load all config
+     */
+    private function loadConfig(string $userId, ?bool $lazy = false): void {
+        if ($this->isLoaded($userId, $lazy)) {
+            return;
+        }
+
+        if (($lazy ?? true) !== false) { // if lazy is null or true, we debug log
+            $this->logger->debug('The loading of lazy UserConfig values have been requested', ['exception' => new \RuntimeException('ignorable exception')]);
+        }
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->from('preferences');
+        $qb->select('appid', 'configkey', 'configvalue', 'type', 'flags');
+        $qb->where($qb->expr()->eq('userid', $qb->createNamedParameter($userId)));
+
+        // we only need value from lazy when loadConfig does not specify it
+        if ($lazy !== null) {
+            $qb->andWhere($qb->expr()->eq('lazy', $qb->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT)));
+        } else {
+            $qb->addSelect('lazy');
+        }
+
+        $result = $qb->executeQuery();
+        $rows = $result->fetchAll();
+        foreach ($rows as $row) {
+            if (($row['lazy'] ?? ($lazy ?? 0) ? 1 : 0) === 1) {
+                $this->lazyCache[$userId][$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
+            } else {
+                $this->fastCache[$userId][$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
+            }
+            $this->valueDetails[$userId][$row['appid']][$row['configkey']] = ['type' => ValueType::from((int)($row['type'] ?? 0)), 'flags' => (int)$row['flags']];
+        }
+        $result->closeCursor();
+        $this->setAsLoaded($userId, $lazy);
+    }
+
+    /**
+     * if $lazy is:
+     *  - false: will returns true if fast config are loaded
+     *  - true : will returns true if lazy config are loaded
+     *  - null : will returns true if both config are loaded
+     *
+     * @param string $userId
+     * @param bool $lazy
+     *
+     * @return bool
+     */
+    private function isLoaded(string $userId, ?bool $lazy): bool {
+        if ($lazy === null) {
+            return ($this->lazyLoaded[$userId] ?? false) && ($this->fastLoaded[$userId] ?? false);
+        }
+
+        return $lazy ? $this->lazyLoaded[$userId] ?? false : $this->fastLoaded[$userId] ?? false;
+    }
+
+    /**
+     * if $lazy is:
+     * - false: set fast config as loaded
+     * - true : set lazy config as loaded
+     * - null : set both config as loaded
+     *
+     * @param string $userId
+     * @param bool $lazy
+     */
+    private function setAsLoaded(string $userId, ?bool $lazy): void {
+        if ($lazy === null) {
+            $this->fastLoaded[$userId] = $this->lazyLoaded[$userId] = true;
+            return;
+        }
+
+        // We also create empty entry to keep both fastLoaded/lazyLoaded synced
+        if ($lazy) {
+            $this->lazyLoaded[$userId] = true;
+            $this->fastLoaded[$userId] = $this->fastLoaded[$userId] ?? false;
+            $this->fastCache[$userId] = $this->fastCache[$userId] ?? [];
+        } else {
+            $this->fastLoaded[$userId] = true;
+            $this->lazyLoaded[$userId] = $this->lazyLoaded[$userId] ?? false;
+            $this->lazyCache[$userId] = $this->lazyCache[$userId] ?? [];
+        }
+    }
+
+    /**
+     * **Warning:** this will load all lazy values from the database
+     *
+     * @param string $userId id of the user
+     * @param string $app id of the app
+     * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
+     *
+     * @return array<string, string|int|float|bool|array>
+     */
+    private function formatAppValues(string $userId, string $app, array $values, bool $filtered = false): array {
+        foreach ($values as $key => $value) {
+            //$key = (string)$key;
+            try {
+                $type = $this->getValueType($userId, $app, (string)$key);
+            } catch (UnknownKeyException) {
+                continue;
+            }
+
+            if ($this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags'] ?? 0)) {
+                if ($filtered) {
+                    $value = IConfig::SENSITIVE_VALUE;
+                    $type = ValueType::STRING;
+                } else {
+                    $this->decryptSensitiveValue($userId, $app, (string)$key, $value);
+                }
+            }
+
+            $values[$key] = $this->convertTypedValue($value, $type);
+        }
+
+        return $values;
+    }
+
+    /**
+     * convert string value to the expected type
+     *
+     * @param string $value
+     * @param ValueType $type
+     *
+     * @return string|int|float|bool|array
+     */
+    private function convertTypedValue(string $value, ValueType $type): string|int|float|bool|array {
+        switch ($type) {
+            case ValueType::INT:
+                return (int)$value;
+            case ValueType::FLOAT:
+                return (float)$value;
+            case ValueType::BOOL:
+                return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
+            case ValueType::ARRAY:
+                try {
+                    return json_decode($value, true, flags: JSON_THROW_ON_ERROR);
+                } catch (JsonException) {
+                    // ignoreable
+                }
+                break;
+        }
+        return $value;
+    }
+
+
+    /**
+     * will change referenced $value with the decrypted value in case of encrypted (sensitive value)
+     *
+     * @param string $userId
+     * @param string $app
+     * @param string $key
+     * @param string $value
+     */
+    private function decryptSensitiveValue(string $userId, string $app, string $key, string &$value): void {
+        if (!$this->isFlagged(self::FLAG_SENSITIVE, $this->valueDetails[$userId][$app][$key]['flags'] ?? 0)) {
+            return;
+        }
+
+        if (!str_starts_with($value, self::ENCRYPTION_PREFIX)) {
+            return;
+        }
+
+        try {
+            $value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
+        } catch (\Exception $e) {
+            $this->logger->warning('could not decrypt sensitive value', [
+                'userId' => $userId,
+                'app' => $app,
+                'key' => $key,
+                'value' => $value,
+                'exception' => $e
+            ]);
+        }
+    }
+
+    /**
+     * Match and apply current use of config values with defined lexicon.
+     * Set $lazy to NULL only if only interested into checking that $key is alias.
+     *
+     * @throws UnknownKeyException
+     * @throws TypeConflictException
+     * @return bool FALSE if conflict with defined lexicon were observed in the process
+     */
+    private function matchAndApplyLexiconDefinition(
+        string $userId,
+        string $app,
+        string &$key,
+        ?bool &$lazy = null,
+        ValueType &$type = ValueType::MIXED,
+        int &$flags = 0,
+        ?string &$default = null,
+    ): bool {
+        $configDetails = $this->getConfigDetailsFromLexicon($app);
+        if (array_key_exists($key, $configDetails['aliases']) && !$this->ignoreLexiconAliases) {
+            // in case '$rename' is set in ConfigLexiconEntry, we use the new config key
+            $key = $configDetails['aliases'][$key];
+        }
+
+        if (!array_key_exists($key, $configDetails['entries'])) {
+            return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
+        }
+
+        // if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
+        if ($lazy === null) {
+            return true;
+        }
+
+        /** @var Entry $configValue */
+        $configValue = $configDetails['entries'][$key];
+        if ($type === ValueType::MIXED) {
+            // we overwrite if value was requested as mixed
+            $type = $configValue->getValueType();
+        } elseif ($configValue->getValueType() !== $type) {
+            throw new TypeConflictException('The user config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
+        }
+
+        $lazy = $configValue->isLazy();
+        $flags = $configValue->getFlags();
+        if ($configValue->isDeprecated()) {
+            $this->logger->notice('User config key ' . $app . '/' . $key . ' is set as deprecated.');
+        }
+
+        $enforcedValue = $this->config->getSystemValue('lexicon.default.userconfig.enforced', [])[$app][$key] ?? false;
+        if (!$enforcedValue && $this->hasKey($userId, $app, $key, $lazy)) {
+            // if key exists there should be no need to extract default
+            return true;
+        }
+
+        // only look for default if needed, default from Lexicon got priority if not overwritten by admin
+        if ($default !== null) {
+            $default = $this->getSystemDefault($app, $configValue) ?? $configValue->getDefault($this->presetManager->getLexiconPreset()) ?? $default;
+        }
+
+        // returning false will make get() returning $default and set() not changing value in database
+        return !$enforcedValue;
+    }
+
+    /**
+     * get default value set in config/config.php if stored in key:
+     *
+     * 'lexicon.default.userconfig' => [
+     *        <appId> => [
+     *           <configKey> => 'my value',
+     *        ]
+     *     ],
+     *
+     * The entry is converted to string to fit the expected type when managing default value
+     */
+    private function getSystemDefault(string $appId, Entry $configValue): ?string {
+        $default = $this->config->getSystemValue('lexicon.default.userconfig', [])[$appId][$configValue->getKey()] ?? null;
+        if ($default === null) {
+            // no system default, using default default.
+            return null;
+        }
+
+        return $configValue->convertToString($default);
+    }
+
+    /**
+     * manage ConfigLexicon behavior based on strictness set in IConfigLexicon
+     *
+     * @param Strictness|null $strictness
+     * @param string $line
+     *
+     * @return bool TRUE if conflict can be fully ignored
+     * @throws UnknownKeyException
+     * @see ILexicon::getStrictness()
+     */
+    private function applyLexiconStrictness(?Strictness $strictness, string $configAppKey): bool {
+        if ($strictness === null) {
+            return true;
+        }
+
+        $line = 'The user config key ' . $configAppKey . ' is not defined in the config lexicon';
+        switch ($strictness) {
+            case Strictness::IGNORE:
+                return true;
+            case Strictness::NOTICE:
+                if (!in_array($configAppKey, $this->strictnessApplied, true)) {
+                    $this->strictnessApplied[] = $configAppKey;
+                    $this->logger->notice($line);
+                }
+                return true;
+            case Strictness::WARNING:
+                if (!in_array($configAppKey, $this->strictnessApplied, true)) {
+                    $this->strictnessApplied[] = $configAppKey;
+                    $this->logger->warning($line);
+                }
+                return false;
+            case Strictness::EXCEPTION:
+                throw new UnknownKeyException($line);
+        }
+
+        throw new UnknownKeyException($line);
+    }
+
+    /**
+     * extract details from registered $appId's config lexicon
+     *
+     * @param string $appId
+     *
+     * @return array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}
+     * @internal
+     */
+    public function getConfigDetailsFromLexicon(string $appId): array {
+        if (!array_key_exists($appId, $this->configLexiconDetails)) {
+            $entries = $aliases = [];
+            $bootstrapCoordinator = \OCP\Server::get(Coordinator::class);
+            $configLexicon = $bootstrapCoordinator->getRegistrationContext()?->getConfigLexicon($appId);
+            foreach ($configLexicon?->getUserConfigs() ?? [] as $configEntry) {
+                $entries[$configEntry->getKey()] = $configEntry;
+                if ($configEntry->getRename() !== null) {
+                    $aliases[$configEntry->getRename()] = $configEntry->getKey();
+                }
+            }
+
+            $this->configLexiconDetails[$appId] = [
+                'entries' => $entries,
+                'aliases' => $aliases,
+                'strictness' => $configLexicon?->getStrictness() ?? Strictness::IGNORE
+            ];
+        }
+
+        return $this->configLexiconDetails[$appId];
+    }
+
+    /**
+     * get Lexicon Entry using appId and config key entry
+     *
+     * @return Entry|null NULL if entry does not exist in user's Lexicon
+     * @internal
+     */
+    public function getLexiconEntry(string $appId, string $key): ?Entry {
+        return $this->getConfigDetailsFromLexicon($appId)['entries'][$key] ?? null;
+    }
+
+    /**
+     * if set to TRUE, ignore aliases defined in Config Lexicon during the use of the methods of this class
+     *
+     * @internal
+     */
+    public function ignoreLexiconAliases(bool $ignore): void {
+        $this->ignoreLexiconAliases = $ignore;
+    }
 }

Spacing +33 added lines, -33 removed lines

@@ -54,11 +54,11 @@ 
 	private const ENCRYPTION_PREFIX_LENGTH = 22; // strlen(self::ENCRYPTION_PREFIX)
 
 	/** @var array<string, array<string, array<string, mixed>>> [ass'user_id' => ['app_id' => ['key' => 'value']]] */
-	private array $fastCache = [];   // cache for normal config keys
+	private array $fastCache = []; // cache for normal config keys
 	/** @var array<string, array<string, array<string, mixed>>> ['user_id' => ['app_id' => ['key' => 'value']]] */
-	private array $lazyCache = [];   // cache for lazy config keys
+	private array $lazyCache = []; // cache for lazy config keys
 	/** @var array<string, array<string, array<string, array<string, mixed>>>> ['user_id' => ['app_id' => ['key' => ['type' => ValueType, 'flags' => bitflag]]]] */
-	private array $valueDetails = [];  // type for all config values
+	private array $valueDetails = []; // type for all config values
 	/** @var array<string, boolean> ['user_id' => bool] */
 	private array $fastLoaded = [];
 	/** @var array<string, boolean> ['user_id' => bool] */
@@ -270,7 +270,7 @@ 
 		// array_merge() will remove numeric keys (here config keys), so addition arrays instead
 		$values = array_filter(
 			$this->formatAppValues($userId, $app, ($this->fastCache[$userId][$app] ?? []) + ($this->lazyCache[$userId][$app] ?? []), $filtered),
-			function (string $key) use ($prefix): bool {
+			function(string $key) use ($prefix): bool {
 				// filter values based on $prefix
 				return str_starts_with($key, $prefix);
 			}, ARRAY_FILTER_USE_KEY
@@ -314,7 +314,7 @@ 
 	 * @since 31.0.0
 	 */
 	public function getValuesByApps(string $userId, string $key, bool $lazy = false, ?ValueType $typedAs = null): array {
-		$this->assertParams($userId, '', $key, allowEmptyApp: true);
+		$this->assertParams($userId, '', $key, allowEmptyApp : true);
 		$this->loadConfig($userId, $lazy);
 
 		/** @var array<array-key, array<array-key, mixed>> $cache */
@@ -331,7 +331,7 @@ 
 				try {
 					$this->decryptSensitiveValue($userId, $app, $key, $value);
 					$value = $this->convertTypedValue($value, $typedAs ?? $this->getValueType($userId, $app, $key, $lazy));
-				} catch (IncorrectTypeException|UnknownKeyException) {
+				} catch (IncorrectTypeException | UnknownKeyException) {
 				}
 				$values[$app] = $value;
 			}
@@ -358,7 +358,7 @@ 
 		?ValueType $typedAs = null,
 		?array $userIds = null,
 	): array {
-		$this->assertParams('', $app, $key, allowEmptyUser: true);
+		$this->assertParams('', $app, $key, allowEmptyUser : true);
 		$this->matchAndApplyLexiconDefinition('', $app, $key);
 
 		$qb = $this->connection->getQueryBuilder();
@@ -369,12 +369,12 @@ 
 
 		$values = [];
 		// this nested function will execute current Query and store result within $values.
-		$executeAndStoreValue = function (IQueryBuilder $qb) use (&$values, $typedAs): IResult {
+		$executeAndStoreValue = function(IQueryBuilder $qb) use (&$values, $typedAs): IResult {
 			$result = $qb->executeQuery();
 			while ($row = $result->fetch()) {
 				$value = $row['configvalue'];
 				try {
-					$value = $this->convertTypedValue($value, $typedAs ?? ValueType::from((int)$row['type']));
+					$value = $this->convertTypedValue($value, $typedAs ?? ValueType::from((int) $row['type']));
 				} catch (IncorrectTypeException) {
 				}
 				$values[$row['userid']] = $value;
@@ -427,7 +427,7 @@ 
 	 * @since 31.0.0
 	 */
 	public function searchUsersByValueInt(string $app, string $key, int $value): Generator {
-		return $this->searchUsersByValueString($app, $key, (string)$value);
+		return $this->searchUsersByValueString($app, $key, (string) $value);
 	}
 
 	/**
@@ -473,7 +473,7 @@ 
 	 *
 	 * @return Generator<string>
 	 */
-	private function searchUsersByTypedValue(string $app, string $key, string|array $value, bool $caseInsensitive = false): Generator {
+	private function searchUsersByTypedValue(string $app, string $key, string | array $value, bool $caseInsensitive = false): Generator {
 		$this->assertParams('', $app, $key, allowEmptyUser: true);
 		$this->matchAndApplyLexiconDefinition('', $app, $key);
 
@@ -617,7 +617,7 @@ 
 		int $default = 0,
 		bool $lazy = false,
 	): int {
-		return (int)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::INT);
+		return (int) $this->getTypedValue($userId, $app, $key, (string) $default, $lazy, ValueType::INT);
 	}
 
 	/**
@@ -642,7 +642,7 @@ 
 		float $default = 0,
 		bool $lazy = false,
 	): float {
-		return (float)$this->getTypedValue($userId, $app, $key, (string)$default, $lazy, ValueType::FLOAT);
+		return (float) $this->getTypedValue($userId, $app, $key, (string) $default, $lazy, ValueType::FLOAT);
 	}
 
 	/**
@@ -935,7 +935,7 @@ 
 			$userId,
 			$app,
 			$key,
-			(string)$value,
+			(string) $value,
 			$lazy,
 			$flags,
 			ValueType::INT
@@ -969,7 +969,7 @@ 
 			$userId,
 			$app,
 			$key,
-			(string)$value,
+			(string) $value,
 			$lazy,
 			$flags,
 			ValueType::FLOAT
@@ -1092,7 +1092,7 @@ 
 		$origValue = $value;
 		$sensitive = $this->isFlagged(self::FLAG_SENSITIVE, $flags);
 		if ($sensitive || ($this->hasKey($userId, $app, $key, $lazy) && $this->isSensitive($userId, $app, $key, $lazy))) {
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+			$value = self::ENCRYPTION_PREFIX.$this->crypto->encrypt($value);
 			$flags |= self::FLAG_SENSITIVE;
 		}
 
@@ -1174,7 +1174,7 @@ 
 					$currTypeDef = $currType->value;
 					$typeDef = $type->value;
 				}
-				throw new TypeConflictException('conflict between new type (' . $typeDef . ') and old type (' . $currTypeDef . ')');
+				throw new TypeConflictException('conflict between new type ('.$typeDef.') and old type ('.$currTypeDef.')');
 			}
 
 			if ($lazy !== $this->isLazy($userId, $app, $key)) {
@@ -1288,7 +1288,7 @@ 
 		$flags = $this->getValueFlags($userId, $app, $key);
 		if ($sensitive) {
 			$flags |= self::FLAG_SENSITIVE;
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+			$value = self::ENCRYPTION_PREFIX.$this->crypto->encrypt($value);
 		} else {
 			$flags &= ~self::FLAG_SENSITIVE;
 			$this->decryptSensitiveValue($userId, $app, $key, $value);
@@ -1510,7 +1510,7 @@ 
 			$typeString = $type->getDefinition();
 		} catch (IncorrectTypeException $e) {
 			$this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
-			$typeString = (string)$type->value;
+			$typeString = (string) $type->value;
 		}
 
 		if (!isset($cache[$app][$key])) {
@@ -1689,13 +1689,13 @@ 
 			throw new InvalidArgumentException('app cannot be an empty string');
 		}
 		if (strlen($userId) > self::USER_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $userId . ') for userId is too long (' . self::USER_MAX_LENGTH . ')');
+			throw new InvalidArgumentException('Value ('.$userId.') for userId is too long ('.self::USER_MAX_LENGTH.')');
 		}
 		if (strlen($app) > self::APP_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')');
+			throw new InvalidArgumentException('Value ('.$app.') for app is too long ('.self::APP_MAX_LENGTH.')');
 		}
 		if (strlen($prefKey) > self::KEY_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $prefKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
+			throw new InvalidArgumentException('Value ('.$prefKey.') for key is too long ('.self::KEY_MAX_LENGTH.')');
 		}
 	}
 
@@ -1737,7 +1737,7 @@ 
 			} else {
 				$this->fastCache[$userId][$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
 			}
-			$this->valueDetails[$userId][$row['appid']][$row['configkey']] = ['type' => ValueType::from((int)($row['type'] ?? 0)), 'flags' => (int)$row['flags']];
+			$this->valueDetails[$userId][$row['appid']][$row['configkey']] = ['type' => ValueType::from((int) ($row['type'] ?? 0)), 'flags' => (int) $row['flags']];
 		}
 		$result->closeCursor();
 		$this->setAsLoaded($userId, $lazy);
@@ -1802,7 +1802,7 @@ 
 		foreach ($values as $key => $value) {
 			//$key = (string)$key;
 			try {
-				$type = $this->getValueType($userId, $app, (string)$key);
+				$type = $this->getValueType($userId, $app, (string) $key);
 			} catch (UnknownKeyException) {
 				continue;
 			}
@@ -1812,7 +1812,7 @@ 
 					$value = IConfig::SENSITIVE_VALUE;
 					$type = ValueType::STRING;
 				} else {
-					$this->decryptSensitiveValue($userId, $app, (string)$key, $value);
+					$this->decryptSensitiveValue($userId, $app, (string) $key, $value);
 				}
 			}
 
@@ -1830,12 +1830,12 @@ 
 	 *
 	 * @return string|int|float|bool|array
 	 */
-	private function convertTypedValue(string $value, ValueType $type): string|int|float|bool|array {
+	private function convertTypedValue(string $value, ValueType $type): string | int | float | bool | array {
 		switch ($type) {
 			case ValueType::INT:
-				return (int)$value;
+				return (int) $value;
 			case ValueType::FLOAT:
-				return (float)$value;
+				return (float) $value;
 			case ValueType::BOOL:
 				return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
 			case ValueType::ARRAY:
@@ -1893,7 +1893,7 @@ 
 		string $app,
 		string &$key,
 		?bool &$lazy = null,
-		ValueType &$type = ValueType::MIXED,
+		ValueType & $type = ValueType::MIXED,
 		int &$flags = 0,
 		?string &$default = null,
 	): bool {
@@ -1904,7 +1904,7 @@ 
 		}
 
 		if (!array_key_exists($key, $configDetails['entries'])) {
-			return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
+			return $this->applyLexiconStrictness($configDetails['strictness'], $app.'/'.$key);
 		}
 
 		// if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
@@ -1918,13 +1918,13 @@ 
 			// we overwrite if value was requested as mixed
 			$type = $configValue->getValueType();
 		} elseif ($configValue->getValueType() !== $type) {
-			throw new TypeConflictException('The user config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
+			throw new TypeConflictException('The user config key '.$app.'/'.$key.' is typed incorrectly in relation to the config lexicon');
 		}
 
 		$lazy = $configValue->isLazy();
 		$flags = $configValue->getFlags();
 		if ($configValue->isDeprecated()) {
-			$this->logger->notice('User config key ' . $app . '/' . $key . ' is set as deprecated.');
+			$this->logger->notice('User config key '.$app.'/'.$key.' is set as deprecated.');
 		}
 
 		$enforcedValue = $this->config->getSystemValue('lexicon.default.userconfig.enforced', [])[$app][$key] ?? false;
@@ -1978,7 +1978,7 @@ 
 			return true;
 		}
 
-		$line = 'The user config key ' . $configAppKey . ' is not defined in the config lexicon';
+		$line = 'The user config key '.$configAppKey.' is not defined in the config lexicon';
 		switch ($strictness) {
 			case Strictness::IGNORE:
 				return true;

lib/private/AppConfig.php

Indentation +1793 added lines, -1793 removed lines

@@ -51,1797 +51,1797 @@
  * @since 29.0.0 - Supporting types and lazy loading
  */
 class AppConfig implements IAppConfig {
-	private const APP_MAX_LENGTH = 32;
-	private const KEY_MAX_LENGTH = 64;
-	private const ENCRYPTION_PREFIX = '$AppConfigEncryption$';
-	private const ENCRYPTION_PREFIX_LENGTH = 21; // strlen(self::ENCRYPTION_PREFIX)
-	private const LOCAL_CACHE_KEY = 'OC\\AppConfig';
-	private const LOCAL_CACHE_TTL = 3;
-
-	/** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
-	private array $fastCache = [];   // cache for normal config keys
-	/** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
-	private array $lazyCache = [];   // cache for lazy config keys
-	/** @var array<string, array<string, int>> ['app_id' => ['config_key' => bitflag]] */
-	private array $valueTypes = [];  // type for all config values
-	private bool $fastLoaded = false;
-	private bool $lazyLoaded = false;
-	/** @var array<string, array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}> ['app_id' => ['strictness' => ConfigLexiconStrictness, 'entries' => ['config_key' => ConfigLexiconEntry[]]] */
-	private array $configLexiconDetails = [];
-	private bool $ignoreLexiconAliases = false;
-	private array $strictnessApplied = [];
-
-	/** @var ?array<string, string> */
-	private ?array $appVersionsCache = null;
-	private ?ICache $localCache = null;
-
-	public function __construct(
-		protected IDBConnection $connection,
-		protected IConfig $config,
-		private readonly ConfigManager $configManager,
-		private readonly PresetManager $presetManager,
-		protected LoggerInterface $logger,
-		protected ICrypto $crypto,
-		readonly CacheFactory $cacheFactory,
-	) {
-		if ($config->getSystemValueBool('cache_app_config', true) && $cacheFactory->isLocalCacheAvailable()) {
-			$cacheFactory->withServerVersionPrefix(function (ICacheFactory $factory) {
-				$this->localCache = $factory->createLocal();
-			});
-		}
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @return list<string> list of app ids
-	 * @since 7.0.0
-	 */
-	public function getApps(): array {
-		$this->loadConfig(lazy: true);
-		$apps = array_merge(array_keys($this->fastCache), array_keys($this->lazyCache));
-		sort($apps);
-
-		return array_values(array_unique($apps));
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @return list<string> list of stored config keys
-	 * @see searchKeys to not load lazy config keys
-	 *
-	 * @since 29.0.0
-	 */
-	public function getKeys(string $app): array {
-		$this->assertParams($app);
-		$this->loadConfig($app, true);
-		$keys = array_merge(array_keys($this->fastCache[$app] ?? []), array_keys($this->lazyCache[$app] ?? []));
-		sort($keys);
-
-		return array_values(array_unique($keys));
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $prefix returns only keys starting with this value
-	 * @param bool $lazy TRUE to search in lazy config keys
-	 * @return list<string> list of stored config keys
-	 * @since 32.0.0
-	 */
-	public function searchKeys(string $app, string $prefix = '', bool $lazy = false): array {
-		$this->assertParams($app);
-		$this->loadConfig($app, $lazy);
-		if ($lazy) {
-			$keys = array_keys($this->lazyCache[$app] ?? []);
-		} else {
-			$keys = array_keys($this->fastCache[$app] ?? []);
-		}
-
-		if ($prefix !== '') {
-			$keys = array_filter($keys, static fn (string $key): bool => str_starts_with($key, $prefix));
-		}
-
-		sort($keys);
-		return array_values(array_unique($keys));
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
-	 *
-	 * @return bool TRUE if key exists
-	 * @since 7.0.0
-	 * @since 29.0.0 Added the $lazy argument
-	 */
-	public function hasKey(string $app, string $key, ?bool $lazy = false): bool {
-		$this->assertParams($app, $key);
-		$this->loadConfig($app, $lazy ?? true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		$hasLazy = isset($this->lazyCache[$app][$key]);
-		$hasFast = isset($this->fastCache[$app][$key]);
-		if ($lazy === null) {
-			return $hasLazy || $hasFast;
-		} else {
-			return $lazy ? $hasLazy : $hasFast;
-		}
-	}
-
-	/**
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
-	 *
-	 * @return bool
-	 * @throws AppConfigUnknownKeyException if config key is not known
-	 * @since 29.0.0
-	 */
-	public function isSensitive(string $app, string $key, ?bool $lazy = false): bool {
-		$this->assertParams($app, $key);
-		$this->loadConfig(null, $lazy ?? true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		if (!isset($this->valueTypes[$app][$key])) {
-			throw new AppConfigUnknownKeyException('unknown config key');
-		}
-
-		return $this->isTyped(self::VALUE_SENSITIVE, $this->valueTypes[$app][$key]);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app if of the app
-	 * @param string $key config key
-	 *
-	 * @return bool TRUE if config is lazy loaded
-	 * @throws AppConfigUnknownKeyException if config key is not known
-	 * @see IAppConfig for details about lazy loading
-	 * @since 29.0.0
-	 */
-	public function isLazy(string $app, string $key): bool {
-		$this->assertParams($app, $key);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		// there is a huge probability the non-lazy config are already loaded
-		if ($this->hasKey($app, $key, false)) {
-			return false;
-		}
-
-		// key not found, we search in the lazy config
-		if ($this->hasKey($app, $key, true)) {
-			return true;
-		}
-
-		throw new AppConfigUnknownKeyException('unknown config key');
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $prefix config keys prefix to search
-	 * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
-	 *
-	 * @return array<string, string|int|float|bool|array> [configKey => configValue]
-	 * @since 29.0.0
-	 */
-	public function getAllValues(string $app, string $prefix = '', bool $filtered = false): array {
-		$this->assertParams($app, $prefix);
-		// if we want to filter values, we need to get sensitivity
-		$this->loadConfig($app, true);
-		// array_merge() will remove numeric keys (here config keys), so addition arrays instead
-		$values = $this->formatAppValues($app, ($this->fastCache[$app] ?? []) + ($this->lazyCache[$app] ?? []));
-		$values = array_filter(
-			$values,
-			function (string $key) use ($prefix): bool {
-				return str_starts_with($key, $prefix); // filter values based on $prefix
-			}, ARRAY_FILTER_USE_KEY
-		);
-
-		if (!$filtered) {
-			return $values;
-		}
-
-		/**
-		 * Using the old (deprecated) list of sensitive values.
-		 */
-		foreach ($this->getSensitiveKeys($app) as $sensitiveKeyExp) {
-			$sensitiveKeys = preg_grep($sensitiveKeyExp, array_keys($values));
-			foreach ($sensitiveKeys as $sensitiveKey) {
-				$this->valueTypes[$app][$sensitiveKey] = ($this->valueTypes[$app][$sensitiveKey] ?? 0) | self::VALUE_SENSITIVE;
-			}
-		}
-
-		$result = [];
-		foreach ($values as $key => $value) {
-			$result[$key] = $this->isTyped(self::VALUE_SENSITIVE, $this->valueTypes[$app][$key] ?? 0) ? IConfig::SENSITIVE_VALUE : $value;
-		}
-
-		return $result;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $key config key
-	 * @param bool $lazy search within lazy loaded config
-	 * @param int|null $typedAs enforce type for the returned values ({@see self::VALUE_STRING} and others)
-	 *
-	 * @return array<string, string|int|float|bool|array> [appId => configValue]
-	 * @since 29.0.0
-	 */
-	public function searchValues(string $key, bool $lazy = false, ?int $typedAs = null): array {
-		$this->assertParams('', $key, true);
-		$this->loadConfig(null, $lazy);
-
-		/** @var array<array-key, array<array-key, mixed>> $cache */
-		if ($lazy) {
-			$cache = $this->lazyCache;
-		} else {
-			$cache = $this->fastCache;
-		}
-
-		$values = [];
-		foreach (array_keys($cache) as $app) {
-			if (isset($cache[$app][$key])) {
-				$values[$app] = $this->convertTypedValue($cache[$app][$key], $typedAs ?? $this->getValueType((string)$app, $key, $lazy));
-			}
-		}
-
-		return $values;
-	}
-
-
-	/**
-	 * Get the config value as string.
-	 * If the value does not exist the given default will be returned.
-	 *
-	 * Set lazy to `null` to ignore it and get the value from either source.
-	 *
-	 * **WARNING:** Method is internal and **SHOULD** not be used, as it is better to get the value with a type.
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default config value
-	 * @param null|bool $lazy get config as lazy loaded or not. can be NULL
-	 *
-	 * @return string the value or $default
-	 * @internal
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 * @see getValueString()
-	 * @see getValueInt()
-	 * @see getValueFloat()
-	 * @see getValueBool()
-	 * @see getValueArray()
-	 */
-	public function getValueMixed(
-		string $app,
-		string $key,
-		string $default = '',
-		?bool $lazy = false,
-	): string {
-		try {
-			$lazy = ($lazy === null) ? $this->isLazy($app, $key) : $lazy;
-		} catch (AppConfigUnknownKeyException) {
-			return $default;
-		}
-
-		return $this->getTypedValue(
-			$app,
-			$key,
-			$default,
-			$lazy,
-			self::VALUE_MIXED
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return string stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function getValueString(
-		string $app,
-		string $key,
-		string $default = '',
-		bool $lazy = false,
-	): string {
-		return $this->getTypedValue($app, $key, $default, $lazy, self::VALUE_STRING);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return int stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function getValueInt(
-		string $app,
-		string $key,
-		int $default = 0,
-		bool $lazy = false,
-	): int {
-		return (int)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_INT);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param float $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return float stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function getValueFloat(string $app, string $key, float $default = 0, bool $lazy = false): float {
-		return (float)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_FLOAT);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return bool stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function getValueBool(string $app, string $key, bool $default = false, bool $lazy = false): bool {
-		$b = strtolower($this->getTypedValue($app, $key, $default ? 'true' : 'false', $lazy, self::VALUE_BOOL));
-		return in_array($b, ['1', 'true', 'yes', 'on']);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param array $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 *
-	 * @return array stored config value or $default if not set in database
-	 * @throws InvalidArgumentException if one of the argument format is invalid
-	 * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function getValueArray(
-		string $app,
-		string $key,
-		array $default = [],
-		bool $lazy = false,
-	): array {
-		try {
-			$defaultJson = json_encode($default, JSON_THROW_ON_ERROR);
-			$value = json_decode($this->getTypedValue($app, $key, $defaultJson, $lazy, self::VALUE_ARRAY), true, flags: JSON_THROW_ON_ERROR);
-
-			return is_array($value) ? $value : [];
-		} catch (JsonException) {
-			return [];
-		}
-	}
-
-	/**
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $default default value
-	 * @param bool $lazy search within lazy loaded config
-	 * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT}{@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
-	 *
-	 * @return string
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @throws InvalidArgumentException
-	 */
-	private function getTypedValue(
-		string $app,
-		string $key,
-		string $default,
-		bool $lazy,
-		int $type,
-	): string {
-		$this->assertParams($app, $key, valueType: $type);
-		$origKey = $key;
-		$matched = $this->matchAndApplyLexiconDefinition($app, $key, $lazy, $type, $default);
-		if ($default === null) {
-			// there is no logical reason for it to be null
-			throw new \Exception('default cannot be null');
-		}
-
-		// returns default if strictness of lexicon is set to WARNING (block and report)
-		if (!$matched) {
-			return $default;
-		}
-
-		$this->loadConfig($app, $lazy ?? true);
-
-		/**
-		 * We ignore check if mixed type is requested.
-		 * If type of stored value is set as mixed, we don't filter.
-		 * If type of stored value is defined, we compare with the one requested.
-		 */
-		$knownType = $this->valueTypes[$app][$key] ?? 0;
-		if (!$this->isTyped(self::VALUE_MIXED, $type)
-			&& $knownType > 0
-			&& !$this->isTyped(self::VALUE_MIXED, $knownType)
-			&& !$this->isTyped($type, $knownType)) {
-			$this->logger->warning('conflict with value type from database', ['app' => $app, 'key' => $key, 'type' => $type, 'knownType' => $knownType]);
-			throw new AppConfigTypeConflictException('conflict with value type from database');
-		}
-
-		/**
-		 * - the pair $app/$key cannot exist in both array,
-		 * - we should still return an existing non-lazy value even if current method
-		 *   is called with $lazy is true
-		 *
-		 * This way, lazyCache will be empty until the load for lazy config value is requested.
-		 */
-		if (isset($this->lazyCache[$app][$key])) {
-			$value = $this->lazyCache[$app][$key];
-		} elseif (isset($this->fastCache[$app][$key])) {
-			$value = $this->fastCache[$app][$key];
-		} else {
-			return $default;
-		}
-
-		$sensitive = $this->isTyped(self::VALUE_SENSITIVE, $knownType);
-		if ($sensitive && str_starts_with($value, self::ENCRYPTION_PREFIX)) {
-			// Only decrypt values that are stored encrypted
-			$value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
-		}
-
-		// in case the key was modified while running matchAndApplyLexiconDefinition() we are
-		// interested to check options in case a modification of the value is needed
-		// ie inverting value from previous key when using lexicon option RENAME_INVERT_BOOLEAN
-		if ($origKey !== $key && $type === self::VALUE_BOOL) {
-			$value = ($this->configManager->convertToBool($value, $this->getLexiconEntry($app, $key))) ? '1' : '0';
-		}
-
-		return $value;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @return int type of the value
-	 * @throws AppConfigUnknownKeyException if config key is not known
-	 * @since 29.0.0
-	 * @see VALUE_STRING
-	 * @see VALUE_INT
-	 * @see VALUE_FLOAT
-	 * @see VALUE_BOOL
-	 * @see VALUE_ARRAY
-	 */
-	public function getValueType(string $app, string $key, ?bool $lazy = null): int {
-		$type = self::VALUE_MIXED;
-		$ignorable = $lazy ?? false;
-		$this->matchAndApplyLexiconDefinition($app, $key, $ignorable, $type);
-		if ($type !== self::VALUE_MIXED) {
-			// a modified $type means config key is set in Lexicon
-			return $type;
-		}
-
-		$this->assertParams($app, $key);
-		$this->loadConfig($app, $lazy ?? true);
-
-		if (!isset($this->valueTypes[$app][$key])) {
-			throw new AppConfigUnknownKeyException('unknown config key');
-		}
-
-		$type = $this->valueTypes[$app][$key];
-		$type &= ~self::VALUE_SENSITIVE;
-		return $type;
-	}
-
-
-	/**
-	 * Store a config key and its value in database as VALUE_MIXED
-	 *
-	 * **WARNING:** Method is internal and **MUST** not be used as it is best to set a real value type
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED
-	 * @internal
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 * @see setValueString()
-	 * @see setValueInt()
-	 * @see setValueFloat()
-	 * @see setValueBool()
-	 * @see setValueArray()
-	 */
-	public function setValueMixed(
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy = false,
-		bool $sensitive = false,
-	): bool {
-		return $this->setTypedValue(
-			$app,
-			$key,
-			$value,
-			$lazy,
-			self::VALUE_MIXED | ($sensitive ? self::VALUE_SENSITIVE : 0)
-		);
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function setValueString(
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy = false,
-		bool $sensitive = false,
-	): bool {
-		return $this->setTypedValue(
-			$app,
-			$key,
-			$value,
-			$lazy,
-			self::VALUE_STRING | ($sensitive ? self::VALUE_SENSITIVE : 0)
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function setValueInt(
-		string $app,
-		string $key,
-		int $value,
-		bool $lazy = false,
-		bool $sensitive = false,
-	): bool {
-		if ($value > 2000000000) {
-			$this->logger->debug('You are trying to store an integer value around/above 2,147,483,647. This is a reminder that reaching this theoretical limit on 32 bits system will throw an exception.');
-		}
-
-		return $this->setTypedValue(
-			$app,
-			$key,
-			(string)$value,
-			$lazy,
-			self::VALUE_INT | ($sensitive ? self::VALUE_SENSITIVE : 0)
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param float $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function setValueFloat(
-		string $app,
-		string $key,
-		float $value,
-		bool $lazy = false,
-		bool $sensitive = false,
-	): bool {
-		return $this->setTypedValue(
-			$app,
-			$key,
-			(string)$value,
-			$lazy,
-			self::VALUE_FLOAT | ($sensitive ? self::VALUE_SENSITIVE : 0)
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function setValueBool(
-		string $app,
-		string $key,
-		bool $value,
-		bool $lazy = false,
-	): bool {
-		return $this->setTypedValue(
-			$app,
-			$key,
-			($value) ? '1' : '0',
-			$lazy,
-			self::VALUE_BOOL
-		);
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param array $value config value
-	 * @param bool $lazy set config as lazy loaded
-	 * @param bool $sensitive if TRUE value will be hidden when listing config values.
-	 *
-	 * @return bool TRUE if value was different, therefor updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @throws JsonException
-	 * @since 29.0.0
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	public function setValueArray(
-		string $app,
-		string $key,
-		array $value,
-		bool $lazy = false,
-		bool $sensitive = false,
-	): bool {
-		try {
-			return $this->setTypedValue(
-				$app,
-				$key,
-				json_encode($value, JSON_THROW_ON_ERROR),
-				$lazy,
-				self::VALUE_ARRAY | ($sensitive ? self::VALUE_SENSITIVE : 0)
-			);
-		} catch (JsonException $e) {
-			$this->logger->warning('could not setValueArray', ['app' => $app, 'key' => $key, 'exception' => $e]);
-			throw $e;
-		}
-	}
-
-	/**
-	 * Store a config key and its value in database
-	 *
-	 * If config key is already known with the exact same config value and same sensitive/lazy status, the
-	 * database is not updated. If config value was previously stored as sensitive, status will not be
-	 * altered.
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param string $value config value
-	 * @param bool $lazy config set as lazy loaded
-	 * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT} {@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
-	 *
-	 * @return bool TRUE if value was updated in database
-	 * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
-	 * @see IAppConfig for explanation about lazy loading
-	 */
-	private function setTypedValue(
-		string $app,
-		string $key,
-		string $value,
-		bool $lazy,
-		int $type,
-	): bool {
-		$this->assertParams($app, $key);
-		if (!$this->matchAndApplyLexiconDefinition($app, $key, $lazy, $type)) {
-			return false; // returns false as database is not updated
-		}
-		$this->loadConfig(null, $lazy ?? true);
-
-		$sensitive = $this->isTyped(self::VALUE_SENSITIVE, $type);
-		$inserted = $refreshCache = false;
-
-		$origValue = $value;
-		if ($sensitive || ($this->hasKey($app, $key, $lazy) && $this->isSensitive($app, $key, $lazy))) {
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
-		}
-
-		if ($this->hasKey($app, $key, $lazy)) {
-			/**
-			 * no update if key is already known with set lazy status and value is
-			 * not different, unless sensitivity is switched from false to true.
-			 */
-			if ($origValue === $this->getTypedValue($app, $key, $value, $lazy ?? true, $type)
-				&& (!$sensitive || $this->isSensitive($app, $key, $lazy))) {
-				return false;
-			}
-		} else {
-			/**
-			 * if key is not known yet, we try to insert.
-			 * It might fail if the key exists with a different lazy flag.
-			 */
-			try {
-				$insert = $this->connection->getQueryBuilder();
-				$insert->insert('appconfig')
-					->setValue('appid', $insert->createNamedParameter($app))
-					->setValue('lazy', $insert->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
-					->setValue('type', $insert->createNamedParameter($type, IQueryBuilder::PARAM_INT))
-					->setValue('configkey', $insert->createNamedParameter($key))
-					->setValue('configvalue', $insert->createNamedParameter($value));
-				$insert->executeStatement();
-				$inserted = true;
-			} catch (DBException $e) {
-				if ($e->getReason() !== DBException::REASON_UNIQUE_CONSTRAINT_VIOLATION) {
-					throw $e; // TODO: throw exception or just log and returns false !?
-				}
-			}
-		}
-
-		/**
-		 * We cannot insert a new row, meaning we need to update an already existing one
-		 */
-		if (!$inserted) {
-			$currType = $this->valueTypes[$app][$key] ?? 0;
-			if ($currType === 0) { // this might happen when switching lazy loading status
-				$this->loadConfig(lazy: true);
-				$currType = $this->valueTypes[$app][$key] ?? 0;
-			}
-
-			/**
-			 * This should only happen during the upgrade process from 28 to 29.
-			 * We only log a warning and set it to VALUE_MIXED.
-			 */
-			if ($currType === 0) {
-				$this->logger->warning('Value type is set to zero (0) in database. This is fine only during the upgrade process from 28 to 29.', ['app' => $app, 'key' => $key]);
-				$currType = self::VALUE_MIXED;
-			}
-
-			/**
-			 * we only accept a different type from the one stored in database
-			 * if the one stored in database is not-defined (VALUE_MIXED)
-			 */
-			if (!$this->isTyped(self::VALUE_MIXED, $currType)
-				&& ($type | self::VALUE_SENSITIVE) !== ($currType | self::VALUE_SENSITIVE)) {
-				try {
-					$currType = $this->convertTypeToString($currType);
-					$type = $this->convertTypeToString($type);
-				} catch (AppConfigIncorrectTypeException) {
-					// can be ignored, this was just needed for a better exception message.
-				}
-				throw new AppConfigTypeConflictException('conflict between new type (' . $type . ') and old type (' . $currType . ')');
-			}
-
-			// we fix $type if the stored value, or the new value as it might be changed, is set as sensitive
-			if ($sensitive || $this->isTyped(self::VALUE_SENSITIVE, $currType)) {
-				$type |= self::VALUE_SENSITIVE;
-			}
-
-			try {
-				if ($lazy !== $this->isLazy($app, $key)) {
-					$refreshCache = true;
-				}
-			} catch (AppConfigUnknownKeyException) {
-				// pass
-			}
-
-			$update = $this->connection->getQueryBuilder();
-			$update->update('appconfig')
-				->set('configvalue', $update->createNamedParameter($value))
-				->set('lazy', $update->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
-				->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
-				->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
-				->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-
-			$update->executeStatement();
-		}
-
-		if ($refreshCache) {
-			$this->clearCache();
-			return true;
-		}
-
-		// update local cache
-		if ($lazy) {
-			$this->lazyCache[$app][$key] = $value;
-		} else {
-			$this->fastCache[$app][$key] = $value;
-		}
-		$this->valueTypes[$app][$key] = $type;
-		$this->clearLocalCache();
-
-		return true;
-	}
-
-	/**
-	 * Change the type of config value.
-	 *
-	 * **WARNING:** Method is internal and **MUST** not be used as it may break things.
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT} {@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
-	 *
-	 * @return bool TRUE if database update were necessary
-	 * @throws AppConfigUnknownKeyException if $key is now known in database
-	 * @throws AppConfigIncorrectTypeException if $type is not valid
-	 * @internal
-	 * @since 29.0.0
-	 */
-	public function updateType(string $app, string $key, int $type = self::VALUE_MIXED): bool {
-		$this->assertParams($app, $key);
-		$this->loadConfig(lazy: true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-		$this->isLazy($app, $key); // confirm key exists
-
-		// type can only be one type
-		if (!in_array($type, [self::VALUE_MIXED, self::VALUE_STRING, self::VALUE_INT, self::VALUE_FLOAT, self::VALUE_BOOL, self::VALUE_ARRAY])) {
-			throw new AppConfigIncorrectTypeException('Unknown value type');
-		}
-
-		$currType = $this->valueTypes[$app][$key];
-		if (($type | self::VALUE_SENSITIVE) === ($currType | self::VALUE_SENSITIVE)) {
-			return false;
-		}
-
-		// we complete with sensitive flag if the stored value is set as sensitive
-		if ($this->isTyped(self::VALUE_SENSITIVE, $currType)) {
-			$type = $type | self::VALUE_SENSITIVE;
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('appconfig')
-			->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
-			->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-		$this->valueTypes[$app][$key] = $type;
-
-		return true;
-	}
-
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $sensitive TRUE to set as sensitive, FALSE to unset
-	 *
-	 * @return bool TRUE if entry was found in database and an update was necessary
-	 * @since 29.0.0
-	 */
-	public function updateSensitive(string $app, string $key, bool $sensitive): bool {
-		$this->assertParams($app, $key);
-		$this->loadConfig(lazy: true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		try {
-			if ($sensitive === $this->isSensitive($app, $key, null)) {
-				return false;
-			}
-		} catch (AppConfigUnknownKeyException $e) {
-			return false;
-		}
-
-		$lazy = $this->isLazy($app, $key);
-		if ($lazy) {
-			$cache = $this->lazyCache;
-		} else {
-			$cache = $this->fastCache;
-		}
-
-		if (!isset($cache[$app][$key])) {
-			throw new AppConfigUnknownKeyException('unknown config key');
-		}
-
-		/**
-		 * type returned by getValueType() is already cleaned from sensitive flag
-		 * we just need to update it based on $sensitive and store it in database
-		 */
-		$type = $this->getValueType($app, $key);
-		$value = $cache[$app][$key];
-		if ($sensitive) {
-			$type |= self::VALUE_SENSITIVE;
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
-		} else {
-			$value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('appconfig')
-			->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
-			->set('configvalue', $update->createNamedParameter($value))
-			->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		$this->valueTypes[$app][$key] = $type;
-
-		return true;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
-	 *
-	 * @return bool TRUE if entry was found in database and an update was necessary
-	 * @since 29.0.0
-	 */
-	public function updateLazy(string $app, string $key, bool $lazy): bool {
-		$this->assertParams($app, $key);
-		$this->loadConfig(lazy: true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		try {
-			if ($lazy === $this->isLazy($app, $key)) {
-				return false;
-			}
-		} catch (AppConfigUnknownKeyException $e) {
-			return false;
-		}
-
-		$update = $this->connection->getQueryBuilder();
-		$update->update('appconfig')
-			->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
-			->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
-			->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
-		$update->executeStatement();
-
-		// At this point, it is a lot safer to clean cache
-		$this->clearCache();
-
-		return true;
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @return array
-	 * @throws AppConfigUnknownKeyException if config key is not known in database
-	 * @since 29.0.0
-	 */
-	public function getDetails(string $app, string $key): array {
-		$this->assertParams($app, $key);
-		$this->loadConfig(lazy: true);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-		$lazy = $this->isLazy($app, $key);
-
-		if ($lazy) {
-			$cache = $this->lazyCache;
-		} else {
-			$cache = $this->fastCache;
-		}
-
-		$type = $this->getValueType($app, $key);
-		try {
-			$typeString = $this->convertTypeToString($type);
-		} catch (AppConfigIncorrectTypeException $e) {
-			$this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
-			$typeString = (string)$type;
-		}
-
-		if (!isset($cache[$app][$key])) {
-			throw new AppConfigUnknownKeyException('unknown config key');
-		}
-
-		$value = $cache[$app][$key];
-		$sensitive = $this->isSensitive($app, $key, null);
-		if ($sensitive && str_starts_with($value, self::ENCRYPTION_PREFIX)) {
-			$value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
-		}
-
-		return [
-			'app' => $app,
-			'key' => $key,
-			'value' => $value,
-			'type' => $type,
-			'lazy' => $lazy,
-			'typeString' => $typeString,
-			'sensitive' => $sensitive
-		];
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @return array{app: string, key: string, lazy?: bool, valueType?: ValueType, valueTypeName?: string, sensitive?: bool, default?: string, definition?: string, note?: string}
-	 * @since 32.0.0
-	 */
-	public function getKeyDetails(string $app, string $key): array {
-		$this->assertParams($app, $key);
-		try {
-			$details = $this->getDetails($app, $key);
-		} catch (AppConfigUnknownKeyException) {
-			$details = [
-				'app' => $app,
-				'key' => $key
-			];
-		}
-
-		/** @var Entry $lexiconEntry */
-		try {
-			$lazy = false;
-			$this->matchAndApplyLexiconDefinition($app, $key, $lazy, lexiconEntry: $lexiconEntry);
-		} catch (AppConfigTypeConflictException|AppConfigUnknownKeyException) {
-			// can be ignored
-		}
-
-		if ($lexiconEntry !== null) {
-			$details = array_merge($details, [
-				'lazy' => $lexiconEntry->isLazy(),
-				'valueType' => $lexiconEntry->getValueType(),
-				'valueTypeName' => $lexiconEntry->getValueType()->name,
-				'sensitive' => $lexiconEntry->isFlagged(self::FLAG_SENSITIVE),
-				'default' => $lexiconEntry->getDefault($this->presetManager->getLexiconPreset()),
-				'definition' => $lexiconEntry->getDefinition(),
-				'note' => $lexiconEntry->getNote(),
-			]);
-		}
-
-		return array_filter($details, static fn ($v): bool => ($v !== null));
-	}
-
-	/**
-	 * @param string $type
-	 *
-	 * @return int
-	 * @throws AppConfigIncorrectTypeException
-	 * @since 29.0.0
-	 */
-	public function convertTypeToInt(string $type): int {
-		return match (strtolower($type)) {
-			'mixed' => IAppConfig::VALUE_MIXED,
-			'string' => IAppConfig::VALUE_STRING,
-			'integer' => IAppConfig::VALUE_INT,
-			'float' => IAppConfig::VALUE_FLOAT,
-			'boolean' => IAppConfig::VALUE_BOOL,
-			'array' => IAppConfig::VALUE_ARRAY,
-			default => throw new AppConfigIncorrectTypeException('Unknown type ' . $type)
-		};
-	}
-
-	/**
-	 * @param int $type
-	 *
-	 * @return string
-	 * @throws AppConfigIncorrectTypeException
-	 * @since 29.0.0
-	 */
-	public function convertTypeToString(int $type): string {
-		$type &= ~self::VALUE_SENSITIVE;
-
-		return match ($type) {
-			IAppConfig::VALUE_MIXED => 'mixed',
-			IAppConfig::VALUE_STRING => 'string',
-			IAppConfig::VALUE_INT => 'integer',
-			IAppConfig::VALUE_FLOAT => 'float',
-			IAppConfig::VALUE_BOOL => 'boolean',
-			IAppConfig::VALUE_ARRAY => 'array',
-			default => throw new AppConfigIncorrectTypeException('Unknown numeric type ' . $type)
-		};
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 * @param string $key config key
-	 *
-	 * @since 29.0.0
-	 */
-	public function deleteKey(string $app, string $key): void {
-		$this->assertParams($app, $key);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('appconfig')
-			->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
-			->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
-		$qb->executeStatement();
-
-		unset($this->lazyCache[$app][$key]);
-		unset($this->fastCache[$app][$key]);
-		unset($this->valueTypes[$app][$key]);
-		$this->clearLocalCache();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param string $app id of the app
-	 *
-	 * @since 29.0.0
-	 */
-	public function deleteApp(string $app): void {
-		$this->assertParams($app);
-		$qb = $this->connection->getQueryBuilder();
-		$qb->delete('appconfig')
-			->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
-		$qb->executeStatement();
-
-		$this->clearCache();
-	}
-
-	/**
-	 * @inheritDoc
-	 *
-	 * @param bool $reload set to TRUE to refill cache instantly after clearing it
-	 *
-	 * @internal
-	 * @since 29.0.0
-	 */
-	public function clearCache(bool $reload = false): void {
-		$this->lazyLoaded = $this->fastLoaded = false;
-		$this->lazyCache = $this->fastCache = $this->valueTypes = $this->configLexiconDetails = [];
-		$this->localCache?->remove(self::LOCAL_CACHE_KEY);
-
-		if (!$reload) {
-			return;
-		}
-
-		$this->loadConfig(lazy: true);
-	}
-
-
-	/**
-	 * For debug purpose.
-	 * Returns the cached data.
-	 *
-	 * @return array
-	 * @since 29.0.0
-	 * @internal
-	 */
-	public function statusCache(): array {
-		return [
-			'fastLoaded' => $this->fastLoaded,
-			'fastCache' => $this->fastCache,
-			'lazyLoaded' => $this->lazyLoaded,
-			'lazyCache' => $this->lazyCache,
-		];
-	}
-
-	/**
-	 * @param int $needle bitflag to search
-	 * @param int $type known value
-	 *
-	 * @return bool TRUE if bitflag $needle is set in $type
-	 */
-	private function isTyped(int $needle, int $type): bool {
-		return (($needle & $type) !== 0);
-	}
-
-	/**
-	 * Confirm the string set for app and key fit the database description
-	 *
-	 * @param string $app assert $app fit in database
-	 * @param string $configKey assert config key fit in database
-	 * @param bool $allowEmptyApp $app can be empty string
-	 * @param int $valueType assert value type is only one type
-	 *
-	 * @throws InvalidArgumentException
-	 */
-	private function assertParams(string $app = '', string $configKey = '', bool $allowEmptyApp = false, int $valueType = -1): void {
-		if (!$allowEmptyApp && $app === '') {
-			throw new InvalidArgumentException('app cannot be an empty string');
-		}
-		if (strlen($app) > self::APP_MAX_LENGTH) {
-			throw new InvalidArgumentException(
-				'Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')'
-			);
-		}
-		if (strlen($configKey) > self::KEY_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $configKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
-		}
-		if ($valueType > -1) {
-			$valueType &= ~self::VALUE_SENSITIVE;
-			if (!in_array($valueType, [self::VALUE_MIXED, self::VALUE_STRING, self::VALUE_INT, self::VALUE_FLOAT, self::VALUE_BOOL, self::VALUE_ARRAY])) {
-				throw new InvalidArgumentException('Unknown value type');
-			}
-		}
-	}
-
-	/**
-	 * Load normal config or config set as lazy loaded
-	 *
-	 * @param bool $lazy set to TRUE to also load config values set as lazy loaded
-	 */
-	private function loadConfig(?string $app = null, bool $lazy = false): void {
-		if ($this->isLoaded($lazy)) {
-			return;
-		}
-
-		// if lazy is null or true, we debug log
-		if ($lazy === true && $app !== null) {
-			$exception = new \RuntimeException('The loading of lazy AppConfig values have been triggered by app "' . $app . '"');
-			$this->logger->debug($exception->getMessage(), ['exception' => $exception, 'app' => $app]);
-		}
-
-		$loadLazyOnly = $lazy && $this->isLoaded();
-
-		/** @var array<mixed> */
-		$cacheContent = $this->localCache?->get(self::LOCAL_CACHE_KEY) ?? [];
-		$includesLazyValues = !empty($cacheContent) && !empty($cacheContent['lazyCache']);
-		if (!empty($cacheContent) && (!$lazy || $includesLazyValues)) {
-			$this->valueTypes = $cacheContent['valueTypes'];
-			$this->fastCache = $cacheContent['fastCache'];
-			$this->fastLoaded = !empty($this->fastCache);
-			if ($includesLazyValues) {
-				$this->lazyCache = $cacheContent['lazyCache'];
-				$this->lazyLoaded = !empty($this->lazyCache);
-			}
-			return;
-		}
-
-		// Otherwise no cache available and we need to fetch from database
-		$qb = $this->connection->getQueryBuilder();
-		$qb->from('appconfig')
-			->select('appid', 'configkey', 'configvalue', 'type');
-
-		if ($lazy === false) {
-			$qb->where($qb->expr()->eq('lazy', $qb->createNamedParameter(0, IQueryBuilder::PARAM_INT)));
-		} else {
-			if ($loadLazyOnly) {
-				$qb->where($qb->expr()->eq('lazy', $qb->createNamedParameter(1, IQueryBuilder::PARAM_INT)));
-			}
-			$qb->addSelect('lazy');
-		}
-
-		$result = $qb->executeQuery();
-		$rows = $result->fetchAll();
-		foreach ($rows as $row) {
-			// most of the time, 'lazy' is not in the select because its value is already known
-			if ($lazy && ((int)$row['lazy']) === 1) {
-				$this->lazyCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
-			} else {
-				$this->fastCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
-			}
-			$this->valueTypes[$row['appid']][$row['configkey']] = (int)($row['type'] ?? 0);
-		}
-
-		$result->closeCursor();
-		$this->localCache?->set(
-			self::LOCAL_CACHE_KEY,
-			[
-				'fastCache' => $this->fastCache,
-				'lazyCache' => $this->lazyCache,
-				'valueTypes' => $this->valueTypes,
-			],
-			self::LOCAL_CACHE_TTL,
-		);
-
-		$this->fastLoaded = true;
-		$this->lazyLoaded = $lazy;
-	}
-
-	/**
-	 * @param bool $lazy - If set to true then also check if lazy values are loaded
-	 */
-	private function isLoaded(bool $lazy = false): bool {
-		return $this->fastLoaded && (!$lazy || $this->lazyLoaded);
-	}
-
-	/**
-	 * Gets the config value
-	 *
-	 * @param string $app app
-	 * @param string $key key
-	 * @param string $default - Default value if the key does not exist
-	 *
-	 * @return string the value or $default
-	 * @deprecated 29.0.0 use getValue*()
-	 *
-	 * This function gets a value from the appconfig table. If the key does
-	 * not exist the default value will be returned
-	 */
-	public function getValue($app, $key, $default = '') {
-		$this->loadConfig($app);
-		$this->matchAndApplyLexiconDefinition($app, $key);
-
-		return $this->fastCache[$app][$key] ?? $default;
-	}
-
-	/**
-	 * Sets a value. If the key did not exist before it will be created.
-	 *
-	 * @param string $app app
-	 * @param string $key key
-	 * @param string|float|int $value value
-	 *
-	 * @return bool True if the value was inserted or updated, false if the value was the same
-	 * @throws AppConfigTypeConflictException
-	 * @throws AppConfigUnknownKeyException
-	 * @deprecated 29.0.0
-	 */
-	public function setValue($app, $key, $value) {
-		/**
-		 * TODO: would it be overkill, or decently improve performance, to catch
-		 * call to this method with $key='enabled' and 'hide' config value related
-		 * to $app when the app is disabled (by modifying entry in database: lazy=lazy+2)
-		 * or enabled (lazy=lazy-2)
-		 *
-		 * this solution would remove the loading of config values from disabled app
-		 * unless calling the method.
-		 */
-		return $this->setTypedValue($app, $key, (string)$value, false, self::VALUE_MIXED);
-	}
-
-
-	/**
-	 * get multiple values, either the app or key can be used as wildcard by setting it to false
-	 *
-	 * @param string|false $app
-	 * @param string|false $key
-	 *
-	 * @return array|false
-	 * @deprecated 29.0.0 use {@see getAllValues()}
-	 */
-	public function getValues($app, $key) {
-		if (($app !== false) === ($key !== false)) {
-			return false;
-		}
-
-		$key = ($key === false) ? '' : $key;
-		if (!$app) {
-			return $this->searchValues($key, false, self::VALUE_MIXED);
-		} else {
-			return $this->getAllValues($app, $key);
-		}
-	}
-
-	/**
-	 * get all values of the app or and filters out sensitive data
-	 *
-	 * @param string $app
-	 *
-	 * @return array
-	 * @deprecated 29.0.0 use {@see getAllValues()}
-	 */
-	public function getFilteredValues($app) {
-		return $this->getAllValues($app, filtered: true);
-	}
-
-
-	/**
-	 * **Warning:** avoid default NULL value for $lazy as this will
-	 * load all lazy values from the database
-	 *
-	 * @param string $app
-	 * @param array<string, string> $values ['key' => 'value']
-	 * @param bool|null $lazy
-	 *
-	 * @return array<string, string|int|float|bool|array>
-	 */
-	private function formatAppValues(string $app, array $values, ?bool $lazy = null): array {
-		foreach ($values as $key => $value) {
-			try {
-				$type = $this->getValueType($app, $key, $lazy);
-			} catch (AppConfigUnknownKeyException) {
-				continue;
-			}
-
-			$values[$key] = $this->convertTypedValue($value, $type);
-		}
-
-		return $values;
-	}
-
-	/**
-	 * convert string value to the expected type
-	 *
-	 * @param string $value
-	 * @param int $type
-	 *
-	 * @return string|int|float|bool|array
-	 */
-	private function convertTypedValue(string $value, int $type): string|int|float|bool|array {
-		switch ($type) {
-			case self::VALUE_INT:
-				return (int)$value;
-			case self::VALUE_FLOAT:
-				return (float)$value;
-			case self::VALUE_BOOL:
-				return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
-			case self::VALUE_ARRAY:
-				try {
-					return json_decode($value, true, flags: JSON_THROW_ON_ERROR);
-				} catch (JsonException $e) {
-					// ignoreable
-				}
-				break;
-		}
-		return $value;
-	}
-
-	/**
-	 * @param string $app
-	 *
-	 * @return string[]
-	 * @deprecated 29.0.0 data sensitivity should be set when calling setValue*()
-	 */
-	private function getSensitiveKeys(string $app): array {
-		$sensitiveValues = [
-			'circles' => [
-				'/^key_pairs$/',
-				'/^local_gskey$/',
-			],
-			'call_summary_bot' => [
-				'/^secret_(.*)$/',
-			],
-			'external' => [
-				'/^sites$/',
-				'/^jwt_token_privkey_(.*)$/',
-			],
-			'globalsiteselector' => [
-				'/^gss\.jwt\.key$/',
-			],
-			'gpgmailer' => [
-				'/^GpgServerKey$/',
-			],
-			'integration_discourse' => [
-				'/^private_key$/',
-				'/^public_key$/',
-			],
-			'integration_dropbox' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-			],
-			'integration_github' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-			],
-			'integration_gitlab' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-				'/^oauth_instance_url$/',
-			],
-			'integration_google' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-			],
-			'integration_jira' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-				'/^forced_instance_url$/',
-			],
-			'integration_onedrive' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-			],
-			'integration_openproject' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-				'/^oauth_instance_url$/',
-			],
-			'integration_reddit' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-			],
-			'integration_suitecrm' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-				'/^oauth_instance_url$/',
-			],
-			'integration_twitter' => [
-				'/^consumer_key$/',
-				'/^consumer_secret$/',
-				'/^followed_user$/',
-			],
-			'integration_zammad' => [
-				'/^client_id$/',
-				'/^client_secret$/',
-				'/^oauth_instance_url$/',
-			],
-			'maps' => [
-				'/^mapboxAPIKEY$/',
-			],
-			'notify_push' => [
-				'/^cookie$/',
-			],
-			'onlyoffice' => [
-				'/^jwt_secret$/',
-			],
-			'passwords' => [
-				'/^SSEv1ServerKey$/',
-			],
-			'serverinfo' => [
-				'/^token$/',
-			],
-			'spreed' => [
-				'/^bridge_bot_password$/',
-				'/^hosted-signaling-server-(.*)$/',
-				'/^recording_servers$/',
-				'/^signaling_servers$/',
-				'/^signaling_ticket_secret$/',
-				'/^signaling_token_privkey_(.*)$/',
-				'/^signaling_token_pubkey_(.*)$/',
-				'/^sip_bridge_dialin_info$/',
-				'/^sip_bridge_shared_secret$/',
-				'/^stun_servers$/',
-				'/^turn_servers$/',
-				'/^turn_server_secret$/',
-			],
-			'support' => [
-				'/^last_response$/',
-				'/^potential_subscription_key$/',
-				'/^subscription_key$/',
-			],
-			'theming' => [
-				'/^imprintUrl$/',
-				'/^privacyUrl$/',
-				'/^slogan$/',
-				'/^url$/',
-			],
-			'twofactor_gateway' => [
-				'/^.*token$/',
-			],
-			'user_ldap' => [
-				'/^(s..)?ldap_agent_password$/',
-			],
-			'user_saml' => [
-				'/^idp-x509cert$/',
-			],
-			'whiteboard' => [
-				'/^jwt_secret_key$/',
-			],
-		];
-
-		return $sensitiveValues[$app] ?? [];
-	}
-
-	/**
-	 * Clear all the cached app config values
-	 * New cache will be generated next time a config value is retrieved
-	 *
-	 * @deprecated 29.0.0 use {@see clearCache()}
-	 */
-	public function clearCachedConfig(): void {
-		$this->clearCache();
-	}
-
-	/**
-	 * Match and apply current use of config values with defined lexicon.
-	 * Set $lazy to NULL only if only interested into checking that $key is alias.
-	 *
-	 * @throws AppConfigUnknownKeyException
-	 * @throws AppConfigTypeConflictException
-	 * @return bool TRUE if everything is fine compared to lexicon or lexicon does not exist
-	 */
-	private function matchAndApplyLexiconDefinition(
-		string $app,
-		string &$key,
-		?bool &$lazy = null,
-		int &$type = self::VALUE_MIXED,
-		?string &$default = null,
-		?Entry &$lexiconEntry = null,
-	): bool {
-		if (in_array($key,
-			[
-				'enabled',
-				'installed_version',
-				'types',
-			])) {
-			return true; // we don't break stuff for this list of config keys.
-		}
-		$configDetails = $this->getConfigDetailsFromLexicon($app);
-		if (array_key_exists($key, $configDetails['aliases']) && !$this->ignoreLexiconAliases) {
-			// in case '$rename' is set in ConfigLexiconEntry, we use the new config key
-			$key = $configDetails['aliases'][$key];
-		}
-
-		if (!array_key_exists($key, $configDetails['entries'])) {
-			return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
-		}
-
-		// if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
-		if ($lazy === null) {
-			return true;
-		}
-
-		/** @var Entry $lexiconEntry */
-		$lexiconEntry = $configDetails['entries'][$key];
-		$type &= ~self::VALUE_SENSITIVE;
-
-		$appConfigValueType = $lexiconEntry->getValueType()->toAppConfigFlag();
-		if ($type === self::VALUE_MIXED) {
-			$type = $appConfigValueType; // we overwrite if value was requested as mixed
-		} elseif ($appConfigValueType !== $type) {
-			throw new AppConfigTypeConflictException('The app config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
-		}
-
-		$lazy = $lexiconEntry->isLazy();
-		// only look for default if needed, default from Lexicon got priority
-		if ($default !== null) {
-			$default = $lexiconEntry->getDefault($this->presetManager->getLexiconPreset()) ?? $default;
-		}
-
-		if ($lexiconEntry->isFlagged(self::FLAG_SENSITIVE)) {
-			$type |= self::VALUE_SENSITIVE;
-		}
-		if ($lexiconEntry->isDeprecated()) {
-			$this->logger->notice('App config key ' . $app . '/' . $key . ' is set as deprecated.');
-		}
-
-		return true;
-	}
-
-	/**
-	 * manage ConfigLexicon behavior based on strictness set in IConfigLexicon
-	 *
-	 * @param Strictness|null $strictness
-	 * @param string $line
-	 *
-	 * @return bool TRUE if conflict can be fully ignored, FALSE if action should be not performed
-	 * @throws AppConfigUnknownKeyException if strictness implies exception
-	 * @see \OCP\Config\Lexicon\ILexicon::getStrictness()
-	 */
-	private function applyLexiconStrictness(?Strictness $strictness, string $configAppKey): bool {
-		if ($strictness === null) {
-			return true;
-		}
-
-		$line = 'The app config key ' . $configAppKey . ' is not defined in the config lexicon';
-		switch ($strictness) {
-			case Strictness::IGNORE:
-				return true;
-			case Strictness::NOTICE:
-				if (!in_array($configAppKey, $this->strictnessApplied, true)) {
-					$this->strictnessApplied[] = $configAppKey;
-					$this->logger->notice($line);
-				}
-				return true;
-			case Strictness::WARNING:
-				if (!in_array($configAppKey, $this->strictnessApplied, true)) {
-					$this->strictnessApplied[] = $configAppKey;
-					$this->logger->warning($line);
-				}
-				return false;
-		}
-
-		throw new AppConfigUnknownKeyException($line);
-	}
-
-	/**
-	 * extract details from registered $appId's config lexicon
-	 *
-	 * @param string $appId
-	 * @internal
-	 *
-	 * @return array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}
-	 */
-	public function getConfigDetailsFromLexicon(string $appId): array {
-		if (!array_key_exists($appId, $this->configLexiconDetails)) {
-			$entries = $aliases = [];
-			$bootstrapCoordinator = \OCP\Server::get(Coordinator::class);
-			$configLexicon = $bootstrapCoordinator->getRegistrationContext()?->getConfigLexicon($appId);
-			foreach ($configLexicon?->getAppConfigs() ?? [] as $configEntry) {
-				$entries[$configEntry->getKey()] = $configEntry;
-				$newName = $configEntry->getRename();
-				if ($newName !== null) {
-					$aliases[$newName] = $configEntry->getKey();
-				}
-			}
-
-			$this->configLexiconDetails[$appId] = [
-				'entries' => $entries,
-				'aliases' => $aliases,
-				'strictness' => $configLexicon?->getStrictness() ?? Strictness::IGNORE
-			];
-		}
-
-		return $this->configLexiconDetails[$appId];
-	}
-
-	/**
-	 * get Lexicon Entry using appId and config key entry
-	 *
-	 * @return Entry|null NULL if entry does not exist in app's Lexicon
-	 * @internal
-	 */
-	public function getLexiconEntry(string $appId, string $key): ?Entry {
-		return $this->getConfigDetailsFromLexicon($appId)['entries'][$key] ?? null;
-	}
-
-	/**
-	 * if set to TRUE, ignore aliases defined in Config Lexicon during the use of the methods of this class
-	 *
-	 * @internal
-	 */
-	public function ignoreLexiconAliases(bool $ignore): void {
-		$this->ignoreLexiconAliases = $ignore;
-	}
-
-	/**
-	 * Returns the installed versions of all apps
-	 *
-	 * @return array<string, string>
-	 */
-	public function getAppInstalledVersions(bool $onlyEnabled = false): array {
-		if ($this->appVersionsCache === null) {
-			/** @var array<string, string> */
-			$this->appVersionsCache = $this->searchValues('installed_version', false, IAppConfig::VALUE_STRING);
-		}
-		if ($onlyEnabled) {
-			return array_filter(
-				$this->appVersionsCache,
-				fn (string $app): bool => $this->getValueString($app, 'enabled', 'no') !== 'no',
-				ARRAY_FILTER_USE_KEY
-			);
-		}
-		return $this->appVersionsCache;
-	}
-
-	private function clearLocalCache(): void {
-		$this->localCache?->remove(self::LOCAL_CACHE_KEY);
-	}
+    private const APP_MAX_LENGTH = 32;
+    private const KEY_MAX_LENGTH = 64;
+    private const ENCRYPTION_PREFIX = '$AppConfigEncryption$';
+    private const ENCRYPTION_PREFIX_LENGTH = 21; // strlen(self::ENCRYPTION_PREFIX)
+    private const LOCAL_CACHE_KEY = 'OC\\AppConfig';
+    private const LOCAL_CACHE_TTL = 3;
+
+    /** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
+    private array $fastCache = [];   // cache for normal config keys
+    /** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
+    private array $lazyCache = [];   // cache for lazy config keys
+    /** @var array<string, array<string, int>> ['app_id' => ['config_key' => bitflag]] */
+    private array $valueTypes = [];  // type for all config values
+    private bool $fastLoaded = false;
+    private bool $lazyLoaded = false;
+    /** @var array<string, array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}> ['app_id' => ['strictness' => ConfigLexiconStrictness, 'entries' => ['config_key' => ConfigLexiconEntry[]]] */
+    private array $configLexiconDetails = [];
+    private bool $ignoreLexiconAliases = false;
+    private array $strictnessApplied = [];
+
+    /** @var ?array<string, string> */
+    private ?array $appVersionsCache = null;
+    private ?ICache $localCache = null;
+
+    public function __construct(
+        protected IDBConnection $connection,
+        protected IConfig $config,
+        private readonly ConfigManager $configManager,
+        private readonly PresetManager $presetManager,
+        protected LoggerInterface $logger,
+        protected ICrypto $crypto,
+        readonly CacheFactory $cacheFactory,
+    ) {
+        if ($config->getSystemValueBool('cache_app_config', true) && $cacheFactory->isLocalCacheAvailable()) {
+            $cacheFactory->withServerVersionPrefix(function (ICacheFactory $factory) {
+                $this->localCache = $factory->createLocal();
+            });
+        }
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @return list<string> list of app ids
+     * @since 7.0.0
+     */
+    public function getApps(): array {
+        $this->loadConfig(lazy: true);
+        $apps = array_merge(array_keys($this->fastCache), array_keys($this->lazyCache));
+        sort($apps);
+
+        return array_values(array_unique($apps));
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @return list<string> list of stored config keys
+     * @see searchKeys to not load lazy config keys
+     *
+     * @since 29.0.0
+     */
+    public function getKeys(string $app): array {
+        $this->assertParams($app);
+        $this->loadConfig($app, true);
+        $keys = array_merge(array_keys($this->fastCache[$app] ?? []), array_keys($this->lazyCache[$app] ?? []));
+        sort($keys);
+
+        return array_values(array_unique($keys));
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $prefix returns only keys starting with this value
+     * @param bool $lazy TRUE to search in lazy config keys
+     * @return list<string> list of stored config keys
+     * @since 32.0.0
+     */
+    public function searchKeys(string $app, string $prefix = '', bool $lazy = false): array {
+        $this->assertParams($app);
+        $this->loadConfig($app, $lazy);
+        if ($lazy) {
+            $keys = array_keys($this->lazyCache[$app] ?? []);
+        } else {
+            $keys = array_keys($this->fastCache[$app] ?? []);
+        }
+
+        if ($prefix !== '') {
+            $keys = array_filter($keys, static fn (string $key): bool => str_starts_with($key, $prefix));
+        }
+
+        sort($keys);
+        return array_values(array_unique($keys));
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
+     *
+     * @return bool TRUE if key exists
+     * @since 7.0.0
+     * @since 29.0.0 Added the $lazy argument
+     */
+    public function hasKey(string $app, string $key, ?bool $lazy = false): bool {
+        $this->assertParams($app, $key);
+        $this->loadConfig($app, $lazy ?? true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        $hasLazy = isset($this->lazyCache[$app][$key]);
+        $hasFast = isset($this->fastCache[$app][$key]);
+        if ($lazy === null) {
+            return $hasLazy || $hasFast;
+        } else {
+            return $lazy ? $hasLazy : $hasFast;
+        }
+    }
+
+    /**
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool|null $lazy TRUE to search within lazy loaded config, NULL to search within all config
+     *
+     * @return bool
+     * @throws AppConfigUnknownKeyException if config key is not known
+     * @since 29.0.0
+     */
+    public function isSensitive(string $app, string $key, ?bool $lazy = false): bool {
+        $this->assertParams($app, $key);
+        $this->loadConfig(null, $lazy ?? true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        if (!isset($this->valueTypes[$app][$key])) {
+            throw new AppConfigUnknownKeyException('unknown config key');
+        }
+
+        return $this->isTyped(self::VALUE_SENSITIVE, $this->valueTypes[$app][$key]);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app if of the app
+     * @param string $key config key
+     *
+     * @return bool TRUE if config is lazy loaded
+     * @throws AppConfigUnknownKeyException if config key is not known
+     * @see IAppConfig for details about lazy loading
+     * @since 29.0.0
+     */
+    public function isLazy(string $app, string $key): bool {
+        $this->assertParams($app, $key);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        // there is a huge probability the non-lazy config are already loaded
+        if ($this->hasKey($app, $key, false)) {
+            return false;
+        }
+
+        // key not found, we search in the lazy config
+        if ($this->hasKey($app, $key, true)) {
+            return true;
+        }
+
+        throw new AppConfigUnknownKeyException('unknown config key');
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $prefix config keys prefix to search
+     * @param bool $filtered TRUE to hide sensitive config values. Value are replaced by {@see IConfig::SENSITIVE_VALUE}
+     *
+     * @return array<string, string|int|float|bool|array> [configKey => configValue]
+     * @since 29.0.0
+     */
+    public function getAllValues(string $app, string $prefix = '', bool $filtered = false): array {
+        $this->assertParams($app, $prefix);
+        // if we want to filter values, we need to get sensitivity
+        $this->loadConfig($app, true);
+        // array_merge() will remove numeric keys (here config keys), so addition arrays instead
+        $values = $this->formatAppValues($app, ($this->fastCache[$app] ?? []) + ($this->lazyCache[$app] ?? []));
+        $values = array_filter(
+            $values,
+            function (string $key) use ($prefix): bool {
+                return str_starts_with($key, $prefix); // filter values based on $prefix
+            }, ARRAY_FILTER_USE_KEY
+        );
+
+        if (!$filtered) {
+            return $values;
+        }
+
+        /**
+         * Using the old (deprecated) list of sensitive values.
+         */
+        foreach ($this->getSensitiveKeys($app) as $sensitiveKeyExp) {
+            $sensitiveKeys = preg_grep($sensitiveKeyExp, array_keys($values));
+            foreach ($sensitiveKeys as $sensitiveKey) {
+                $this->valueTypes[$app][$sensitiveKey] = ($this->valueTypes[$app][$sensitiveKey] ?? 0) | self::VALUE_SENSITIVE;
+            }
+        }
+
+        $result = [];
+        foreach ($values as $key => $value) {
+            $result[$key] = $this->isTyped(self::VALUE_SENSITIVE, $this->valueTypes[$app][$key] ?? 0) ? IConfig::SENSITIVE_VALUE : $value;
+        }
+
+        return $result;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $key config key
+     * @param bool $lazy search within lazy loaded config
+     * @param int|null $typedAs enforce type for the returned values ({@see self::VALUE_STRING} and others)
+     *
+     * @return array<string, string|int|float|bool|array> [appId => configValue]
+     * @since 29.0.0
+     */
+    public function searchValues(string $key, bool $lazy = false, ?int $typedAs = null): array {
+        $this->assertParams('', $key, true);
+        $this->loadConfig(null, $lazy);
+
+        /** @var array<array-key, array<array-key, mixed>> $cache */
+        if ($lazy) {
+            $cache = $this->lazyCache;
+        } else {
+            $cache = $this->fastCache;
+        }
+
+        $values = [];
+        foreach (array_keys($cache) as $app) {
+            if (isset($cache[$app][$key])) {
+                $values[$app] = $this->convertTypedValue($cache[$app][$key], $typedAs ?? $this->getValueType((string)$app, $key, $lazy));
+            }
+        }
+
+        return $values;
+    }
+
+
+    /**
+     * Get the config value as string.
+     * If the value does not exist the given default will be returned.
+     *
+     * Set lazy to `null` to ignore it and get the value from either source.
+     *
+     * **WARNING:** Method is internal and **SHOULD** not be used, as it is better to get the value with a type.
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default config value
+     * @param null|bool $lazy get config as lazy loaded or not. can be NULL
+     *
+     * @return string the value or $default
+     * @internal
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     * @see getValueString()
+     * @see getValueInt()
+     * @see getValueFloat()
+     * @see getValueBool()
+     * @see getValueArray()
+     */
+    public function getValueMixed(
+        string $app,
+        string $key,
+        string $default = '',
+        ?bool $lazy = false,
+    ): string {
+        try {
+            $lazy = ($lazy === null) ? $this->isLazy($app, $key) : $lazy;
+        } catch (AppConfigUnknownKeyException) {
+            return $default;
+        }
+
+        return $this->getTypedValue(
+            $app,
+            $key,
+            $default,
+            $lazy,
+            self::VALUE_MIXED
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return string stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function getValueString(
+        string $app,
+        string $key,
+        string $default = '',
+        bool $lazy = false,
+    ): string {
+        return $this->getTypedValue($app, $key, $default, $lazy, self::VALUE_STRING);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return int stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function getValueInt(
+        string $app,
+        string $key,
+        int $default = 0,
+        bool $lazy = false,
+    ): int {
+        return (int)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_INT);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param float $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return float stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function getValueFloat(string $app, string $key, float $default = 0, bool $lazy = false): float {
+        return (float)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_FLOAT);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return bool stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function getValueBool(string $app, string $key, bool $default = false, bool $lazy = false): bool {
+        $b = strtolower($this->getTypedValue($app, $key, $default ? 'true' : 'false', $lazy, self::VALUE_BOOL));
+        return in_array($b, ['1', 'true', 'yes', 'on']);
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param array $default default value
+     * @param bool $lazy search within lazy loaded config
+     *
+     * @return array stored config value or $default if not set in database
+     * @throws InvalidArgumentException if one of the argument format is invalid
+     * @throws AppConfigTypeConflictException in case of conflict with the value type set in database
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function getValueArray(
+        string $app,
+        string $key,
+        array $default = [],
+        bool $lazy = false,
+    ): array {
+        try {
+            $defaultJson = json_encode($default, JSON_THROW_ON_ERROR);
+            $value = json_decode($this->getTypedValue($app, $key, $defaultJson, $lazy, self::VALUE_ARRAY), true, flags: JSON_THROW_ON_ERROR);
+
+            return is_array($value) ? $value : [];
+        } catch (JsonException) {
+            return [];
+        }
+    }
+
+    /**
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $default default value
+     * @param bool $lazy search within lazy loaded config
+     * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT}{@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
+     *
+     * @return string
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @throws InvalidArgumentException
+     */
+    private function getTypedValue(
+        string $app,
+        string $key,
+        string $default,
+        bool $lazy,
+        int $type,
+    ): string {
+        $this->assertParams($app, $key, valueType: $type);
+        $origKey = $key;
+        $matched = $this->matchAndApplyLexiconDefinition($app, $key, $lazy, $type, $default);
+        if ($default === null) {
+            // there is no logical reason for it to be null
+            throw new \Exception('default cannot be null');
+        }
+
+        // returns default if strictness of lexicon is set to WARNING (block and report)
+        if (!$matched) {
+            return $default;
+        }
+
+        $this->loadConfig($app, $lazy ?? true);
+
+        /**
+         * We ignore check if mixed type is requested.
+         * If type of stored value is set as mixed, we don't filter.
+         * If type of stored value is defined, we compare with the one requested.
+         */
+        $knownType = $this->valueTypes[$app][$key] ?? 0;
+        if (!$this->isTyped(self::VALUE_MIXED, $type)
+            && $knownType > 0
+            && !$this->isTyped(self::VALUE_MIXED, $knownType)
+            && !$this->isTyped($type, $knownType)) {
+            $this->logger->warning('conflict with value type from database', ['app' => $app, 'key' => $key, 'type' => $type, 'knownType' => $knownType]);
+            throw new AppConfigTypeConflictException('conflict with value type from database');
+        }
+
+        /**
+         * - the pair $app/$key cannot exist in both array,
+         * - we should still return an existing non-lazy value even if current method
+         *   is called with $lazy is true
+         *
+         * This way, lazyCache will be empty until the load for lazy config value is requested.
+         */
+        if (isset($this->lazyCache[$app][$key])) {
+            $value = $this->lazyCache[$app][$key];
+        } elseif (isset($this->fastCache[$app][$key])) {
+            $value = $this->fastCache[$app][$key];
+        } else {
+            return $default;
+        }
+
+        $sensitive = $this->isTyped(self::VALUE_SENSITIVE, $knownType);
+        if ($sensitive && str_starts_with($value, self::ENCRYPTION_PREFIX)) {
+            // Only decrypt values that are stored encrypted
+            $value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
+        }
+
+        // in case the key was modified while running matchAndApplyLexiconDefinition() we are
+        // interested to check options in case a modification of the value is needed
+        // ie inverting value from previous key when using lexicon option RENAME_INVERT_BOOLEAN
+        if ($origKey !== $key && $type === self::VALUE_BOOL) {
+            $value = ($this->configManager->convertToBool($value, $this->getLexiconEntry($app, $key))) ? '1' : '0';
+        }
+
+        return $value;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @return int type of the value
+     * @throws AppConfigUnknownKeyException if config key is not known
+     * @since 29.0.0
+     * @see VALUE_STRING
+     * @see VALUE_INT
+     * @see VALUE_FLOAT
+     * @see VALUE_BOOL
+     * @see VALUE_ARRAY
+     */
+    public function getValueType(string $app, string $key, ?bool $lazy = null): int {
+        $type = self::VALUE_MIXED;
+        $ignorable = $lazy ?? false;
+        $this->matchAndApplyLexiconDefinition($app, $key, $ignorable, $type);
+        if ($type !== self::VALUE_MIXED) {
+            // a modified $type means config key is set in Lexicon
+            return $type;
+        }
+
+        $this->assertParams($app, $key);
+        $this->loadConfig($app, $lazy ?? true);
+
+        if (!isset($this->valueTypes[$app][$key])) {
+            throw new AppConfigUnknownKeyException('unknown config key');
+        }
+
+        $type = $this->valueTypes[$app][$key];
+        $type &= ~self::VALUE_SENSITIVE;
+        return $type;
+    }
+
+
+    /**
+     * Store a config key and its value in database as VALUE_MIXED
+     *
+     * **WARNING:** Method is internal and **MUST** not be used as it is best to set a real value type
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED
+     * @internal
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     * @see setValueString()
+     * @see setValueInt()
+     * @see setValueFloat()
+     * @see setValueBool()
+     * @see setValueArray()
+     */
+    public function setValueMixed(
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy = false,
+        bool $sensitive = false,
+    ): bool {
+        return $this->setTypedValue(
+            $app,
+            $key,
+            $value,
+            $lazy,
+            self::VALUE_MIXED | ($sensitive ? self::VALUE_SENSITIVE : 0)
+        );
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function setValueString(
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy = false,
+        bool $sensitive = false,
+    ): bool {
+        return $this->setTypedValue(
+            $app,
+            $key,
+            $value,
+            $lazy,
+            self::VALUE_STRING | ($sensitive ? self::VALUE_SENSITIVE : 0)
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function setValueInt(
+        string $app,
+        string $key,
+        int $value,
+        bool $lazy = false,
+        bool $sensitive = false,
+    ): bool {
+        if ($value > 2000000000) {
+            $this->logger->debug('You are trying to store an integer value around/above 2,147,483,647. This is a reminder that reaching this theoretical limit on 32 bits system will throw an exception.');
+        }
+
+        return $this->setTypedValue(
+            $app,
+            $key,
+            (string)$value,
+            $lazy,
+            self::VALUE_INT | ($sensitive ? self::VALUE_SENSITIVE : 0)
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param float $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function setValueFloat(
+        string $app,
+        string $key,
+        float $value,
+        bool $lazy = false,
+        bool $sensitive = false,
+    ): bool {
+        return $this->setTypedValue(
+            $app,
+            $key,
+            (string)$value,
+            $lazy,
+            self::VALUE_FLOAT | ($sensitive ? self::VALUE_SENSITIVE : 0)
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $value config value
+     * @param bool $lazy set config as lazy loaded
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function setValueBool(
+        string $app,
+        string $key,
+        bool $value,
+        bool $lazy = false,
+    ): bool {
+        return $this->setTypedValue(
+            $app,
+            $key,
+            ($value) ? '1' : '0',
+            $lazy,
+            self::VALUE_BOOL
+        );
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param array $value config value
+     * @param bool $lazy set config as lazy loaded
+     * @param bool $sensitive if TRUE value will be hidden when listing config values.
+     *
+     * @return bool TRUE if value was different, therefor updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @throws JsonException
+     * @since 29.0.0
+     * @see IAppConfig for explanation about lazy loading
+     */
+    public function setValueArray(
+        string $app,
+        string $key,
+        array $value,
+        bool $lazy = false,
+        bool $sensitive = false,
+    ): bool {
+        try {
+            return $this->setTypedValue(
+                $app,
+                $key,
+                json_encode($value, JSON_THROW_ON_ERROR),
+                $lazy,
+                self::VALUE_ARRAY | ($sensitive ? self::VALUE_SENSITIVE : 0)
+            );
+        } catch (JsonException $e) {
+            $this->logger->warning('could not setValueArray', ['app' => $app, 'key' => $key, 'exception' => $e]);
+            throw $e;
+        }
+    }
+
+    /**
+     * Store a config key and its value in database
+     *
+     * If config key is already known with the exact same config value and same sensitive/lazy status, the
+     * database is not updated. If config value was previously stored as sensitive, status will not be
+     * altered.
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param string $value config value
+     * @param bool $lazy config set as lazy loaded
+     * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT} {@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
+     *
+     * @return bool TRUE if value was updated in database
+     * @throws AppConfigTypeConflictException if type from database is not VALUE_MIXED and different from the requested one
+     * @see IAppConfig for explanation about lazy loading
+     */
+    private function setTypedValue(
+        string $app,
+        string $key,
+        string $value,
+        bool $lazy,
+        int $type,
+    ): bool {
+        $this->assertParams($app, $key);
+        if (!$this->matchAndApplyLexiconDefinition($app, $key, $lazy, $type)) {
+            return false; // returns false as database is not updated
+        }
+        $this->loadConfig(null, $lazy ?? true);
+
+        $sensitive = $this->isTyped(self::VALUE_SENSITIVE, $type);
+        $inserted = $refreshCache = false;
+
+        $origValue = $value;
+        if ($sensitive || ($this->hasKey($app, $key, $lazy) && $this->isSensitive($app, $key, $lazy))) {
+            $value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+        }
+
+        if ($this->hasKey($app, $key, $lazy)) {
+            /**
+             * no update if key is already known with set lazy status and value is
+             * not different, unless sensitivity is switched from false to true.
+             */
+            if ($origValue === $this->getTypedValue($app, $key, $value, $lazy ?? true, $type)
+                && (!$sensitive || $this->isSensitive($app, $key, $lazy))) {
+                return false;
+            }
+        } else {
+            /**
+             * if key is not known yet, we try to insert.
+             * It might fail if the key exists with a different lazy flag.
+             */
+            try {
+                $insert = $this->connection->getQueryBuilder();
+                $insert->insert('appconfig')
+                    ->setValue('appid', $insert->createNamedParameter($app))
+                    ->setValue('lazy', $insert->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
+                    ->setValue('type', $insert->createNamedParameter($type, IQueryBuilder::PARAM_INT))
+                    ->setValue('configkey', $insert->createNamedParameter($key))
+                    ->setValue('configvalue', $insert->createNamedParameter($value));
+                $insert->executeStatement();
+                $inserted = true;
+            } catch (DBException $e) {
+                if ($e->getReason() !== DBException::REASON_UNIQUE_CONSTRAINT_VIOLATION) {
+                    throw $e; // TODO: throw exception or just log and returns false !?
+                }
+            }
+        }
+
+        /**
+         * We cannot insert a new row, meaning we need to update an already existing one
+         */
+        if (!$inserted) {
+            $currType = $this->valueTypes[$app][$key] ?? 0;
+            if ($currType === 0) { // this might happen when switching lazy loading status
+                $this->loadConfig(lazy: true);
+                $currType = $this->valueTypes[$app][$key] ?? 0;
+            }
+
+            /**
+             * This should only happen during the upgrade process from 28 to 29.
+             * We only log a warning and set it to VALUE_MIXED.
+             */
+            if ($currType === 0) {
+                $this->logger->warning('Value type is set to zero (0) in database. This is fine only during the upgrade process from 28 to 29.', ['app' => $app, 'key' => $key]);
+                $currType = self::VALUE_MIXED;
+            }
+
+            /**
+             * we only accept a different type from the one stored in database
+             * if the one stored in database is not-defined (VALUE_MIXED)
+             */
+            if (!$this->isTyped(self::VALUE_MIXED, $currType)
+                && ($type | self::VALUE_SENSITIVE) !== ($currType | self::VALUE_SENSITIVE)) {
+                try {
+                    $currType = $this->convertTypeToString($currType);
+                    $type = $this->convertTypeToString($type);
+                } catch (AppConfigIncorrectTypeException) {
+                    // can be ignored, this was just needed for a better exception message.
+                }
+                throw new AppConfigTypeConflictException('conflict between new type (' . $type . ') and old type (' . $currType . ')');
+            }
+
+            // we fix $type if the stored value, or the new value as it might be changed, is set as sensitive
+            if ($sensitive || $this->isTyped(self::VALUE_SENSITIVE, $currType)) {
+                $type |= self::VALUE_SENSITIVE;
+            }
+
+            try {
+                if ($lazy !== $this->isLazy($app, $key)) {
+                    $refreshCache = true;
+                }
+            } catch (AppConfigUnknownKeyException) {
+                // pass
+            }
+
+            $update = $this->connection->getQueryBuilder();
+            $update->update('appconfig')
+                ->set('configvalue', $update->createNamedParameter($value))
+                ->set('lazy', $update->createNamedParameter(($lazy) ? 1 : 0, IQueryBuilder::PARAM_INT))
+                ->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
+                ->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
+                ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+
+            $update->executeStatement();
+        }
+
+        if ($refreshCache) {
+            $this->clearCache();
+            return true;
+        }
+
+        // update local cache
+        if ($lazy) {
+            $this->lazyCache[$app][$key] = $value;
+        } else {
+            $this->fastCache[$app][$key] = $value;
+        }
+        $this->valueTypes[$app][$key] = $type;
+        $this->clearLocalCache();
+
+        return true;
+    }
+
+    /**
+     * Change the type of config value.
+     *
+     * **WARNING:** Method is internal and **MUST** not be used as it may break things.
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param int $type value type {@see VALUE_STRING} {@see VALUE_INT} {@see VALUE_FLOAT} {@see VALUE_BOOL} {@see VALUE_ARRAY}
+     *
+     * @return bool TRUE if database update were necessary
+     * @throws AppConfigUnknownKeyException if $key is now known in database
+     * @throws AppConfigIncorrectTypeException if $type is not valid
+     * @internal
+     * @since 29.0.0
+     */
+    public function updateType(string $app, string $key, int $type = self::VALUE_MIXED): bool {
+        $this->assertParams($app, $key);
+        $this->loadConfig(lazy: true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+        $this->isLazy($app, $key); // confirm key exists
+
+        // type can only be one type
+        if (!in_array($type, [self::VALUE_MIXED, self::VALUE_STRING, self::VALUE_INT, self::VALUE_FLOAT, self::VALUE_BOOL, self::VALUE_ARRAY])) {
+            throw new AppConfigIncorrectTypeException('Unknown value type');
+        }
+
+        $currType = $this->valueTypes[$app][$key];
+        if (($type | self::VALUE_SENSITIVE) === ($currType | self::VALUE_SENSITIVE)) {
+            return false;
+        }
+
+        // we complete with sensitive flag if the stored value is set as sensitive
+        if ($this->isTyped(self::VALUE_SENSITIVE, $currType)) {
+            $type = $type | self::VALUE_SENSITIVE;
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('appconfig')
+            ->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
+            ->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+        $this->valueTypes[$app][$key] = $type;
+
+        return true;
+    }
+
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $sensitive TRUE to set as sensitive, FALSE to unset
+     *
+     * @return bool TRUE if entry was found in database and an update was necessary
+     * @since 29.0.0
+     */
+    public function updateSensitive(string $app, string $key, bool $sensitive): bool {
+        $this->assertParams($app, $key);
+        $this->loadConfig(lazy: true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        try {
+            if ($sensitive === $this->isSensitive($app, $key, null)) {
+                return false;
+            }
+        } catch (AppConfigUnknownKeyException $e) {
+            return false;
+        }
+
+        $lazy = $this->isLazy($app, $key);
+        if ($lazy) {
+            $cache = $this->lazyCache;
+        } else {
+            $cache = $this->fastCache;
+        }
+
+        if (!isset($cache[$app][$key])) {
+            throw new AppConfigUnknownKeyException('unknown config key');
+        }
+
+        /**
+         * type returned by getValueType() is already cleaned from sensitive flag
+         * we just need to update it based on $sensitive and store it in database
+         */
+        $type = $this->getValueType($app, $key);
+        $value = $cache[$app][$key];
+        if ($sensitive) {
+            $type |= self::VALUE_SENSITIVE;
+            $value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+        } else {
+            $value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('appconfig')
+            ->set('type', $update->createNamedParameter($type, IQueryBuilder::PARAM_INT))
+            ->set('configvalue', $update->createNamedParameter($value))
+            ->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        $this->valueTypes[$app][$key] = $type;
+
+        return true;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     * @param bool $lazy TRUE to set as lazy loaded, FALSE to unset
+     *
+     * @return bool TRUE if entry was found in database and an update was necessary
+     * @since 29.0.0
+     */
+    public function updateLazy(string $app, string $key, bool $lazy): bool {
+        $this->assertParams($app, $key);
+        $this->loadConfig(lazy: true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        try {
+            if ($lazy === $this->isLazy($app, $key)) {
+                return false;
+            }
+        } catch (AppConfigUnknownKeyException $e) {
+            return false;
+        }
+
+        $update = $this->connection->getQueryBuilder();
+        $update->update('appconfig')
+            ->set('lazy', $update->createNamedParameter($lazy ? 1 : 0, IQueryBuilder::PARAM_INT))
+            ->where($update->expr()->eq('appid', $update->createNamedParameter($app)))
+            ->andWhere($update->expr()->eq('configkey', $update->createNamedParameter($key)));
+        $update->executeStatement();
+
+        // At this point, it is a lot safer to clean cache
+        $this->clearCache();
+
+        return true;
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @return array
+     * @throws AppConfigUnknownKeyException if config key is not known in database
+     * @since 29.0.0
+     */
+    public function getDetails(string $app, string $key): array {
+        $this->assertParams($app, $key);
+        $this->loadConfig(lazy: true);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+        $lazy = $this->isLazy($app, $key);
+
+        if ($lazy) {
+            $cache = $this->lazyCache;
+        } else {
+            $cache = $this->fastCache;
+        }
+
+        $type = $this->getValueType($app, $key);
+        try {
+            $typeString = $this->convertTypeToString($type);
+        } catch (AppConfigIncorrectTypeException $e) {
+            $this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
+            $typeString = (string)$type;
+        }
+
+        if (!isset($cache[$app][$key])) {
+            throw new AppConfigUnknownKeyException('unknown config key');
+        }
+
+        $value = $cache[$app][$key];
+        $sensitive = $this->isSensitive($app, $key, null);
+        if ($sensitive && str_starts_with($value, self::ENCRYPTION_PREFIX)) {
+            $value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
+        }
+
+        return [
+            'app' => $app,
+            'key' => $key,
+            'value' => $value,
+            'type' => $type,
+            'lazy' => $lazy,
+            'typeString' => $typeString,
+            'sensitive' => $sensitive
+        ];
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @return array{app: string, key: string, lazy?: bool, valueType?: ValueType, valueTypeName?: string, sensitive?: bool, default?: string, definition?: string, note?: string}
+     * @since 32.0.0
+     */
+    public function getKeyDetails(string $app, string $key): array {
+        $this->assertParams($app, $key);
+        try {
+            $details = $this->getDetails($app, $key);
+        } catch (AppConfigUnknownKeyException) {
+            $details = [
+                'app' => $app,
+                'key' => $key
+            ];
+        }
+
+        /** @var Entry $lexiconEntry */
+        try {
+            $lazy = false;
+            $this->matchAndApplyLexiconDefinition($app, $key, $lazy, lexiconEntry: $lexiconEntry);
+        } catch (AppConfigTypeConflictException|AppConfigUnknownKeyException) {
+            // can be ignored
+        }
+
+        if ($lexiconEntry !== null) {
+            $details = array_merge($details, [
+                'lazy' => $lexiconEntry->isLazy(),
+                'valueType' => $lexiconEntry->getValueType(),
+                'valueTypeName' => $lexiconEntry->getValueType()->name,
+                'sensitive' => $lexiconEntry->isFlagged(self::FLAG_SENSITIVE),
+                'default' => $lexiconEntry->getDefault($this->presetManager->getLexiconPreset()),
+                'definition' => $lexiconEntry->getDefinition(),
+                'note' => $lexiconEntry->getNote(),
+            ]);
+        }
+
+        return array_filter($details, static fn ($v): bool => ($v !== null));
+    }
+
+    /**
+     * @param string $type
+     *
+     * @return int
+     * @throws AppConfigIncorrectTypeException
+     * @since 29.0.0
+     */
+    public function convertTypeToInt(string $type): int {
+        return match (strtolower($type)) {
+            'mixed' => IAppConfig::VALUE_MIXED,
+            'string' => IAppConfig::VALUE_STRING,
+            'integer' => IAppConfig::VALUE_INT,
+            'float' => IAppConfig::VALUE_FLOAT,
+            'boolean' => IAppConfig::VALUE_BOOL,
+            'array' => IAppConfig::VALUE_ARRAY,
+            default => throw new AppConfigIncorrectTypeException('Unknown type ' . $type)
+        };
+    }
+
+    /**
+     * @param int $type
+     *
+     * @return string
+     * @throws AppConfigIncorrectTypeException
+     * @since 29.0.0
+     */
+    public function convertTypeToString(int $type): string {
+        $type &= ~self::VALUE_SENSITIVE;
+
+        return match ($type) {
+            IAppConfig::VALUE_MIXED => 'mixed',
+            IAppConfig::VALUE_STRING => 'string',
+            IAppConfig::VALUE_INT => 'integer',
+            IAppConfig::VALUE_FLOAT => 'float',
+            IAppConfig::VALUE_BOOL => 'boolean',
+            IAppConfig::VALUE_ARRAY => 'array',
+            default => throw new AppConfigIncorrectTypeException('Unknown numeric type ' . $type)
+        };
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     * @param string $key config key
+     *
+     * @since 29.0.0
+     */
+    public function deleteKey(string $app, string $key): void {
+        $this->assertParams($app, $key);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('appconfig')
+            ->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)))
+            ->andWhere($qb->expr()->eq('configkey', $qb->createNamedParameter($key)));
+        $qb->executeStatement();
+
+        unset($this->lazyCache[$app][$key]);
+        unset($this->fastCache[$app][$key]);
+        unset($this->valueTypes[$app][$key]);
+        $this->clearLocalCache();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param string $app id of the app
+     *
+     * @since 29.0.0
+     */
+    public function deleteApp(string $app): void {
+        $this->assertParams($app);
+        $qb = $this->connection->getQueryBuilder();
+        $qb->delete('appconfig')
+            ->where($qb->expr()->eq('appid', $qb->createNamedParameter($app)));
+        $qb->executeStatement();
+
+        $this->clearCache();
+    }
+
+    /**
+     * @inheritDoc
+     *
+     * @param bool $reload set to TRUE to refill cache instantly after clearing it
+     *
+     * @internal
+     * @since 29.0.0
+     */
+    public function clearCache(bool $reload = false): void {
+        $this->lazyLoaded = $this->fastLoaded = false;
+        $this->lazyCache = $this->fastCache = $this->valueTypes = $this->configLexiconDetails = [];
+        $this->localCache?->remove(self::LOCAL_CACHE_KEY);
+
+        if (!$reload) {
+            return;
+        }
+
+        $this->loadConfig(lazy: true);
+    }
+
+
+    /**
+     * For debug purpose.
+     * Returns the cached data.
+     *
+     * @return array
+     * @since 29.0.0
+     * @internal
+     */
+    public function statusCache(): array {
+        return [
+            'fastLoaded' => $this->fastLoaded,
+            'fastCache' => $this->fastCache,
+            'lazyLoaded' => $this->lazyLoaded,
+            'lazyCache' => $this->lazyCache,
+        ];
+    }
+
+    /**
+     * @param int $needle bitflag to search
+     * @param int $type known value
+     *
+     * @return bool TRUE if bitflag $needle is set in $type
+     */
+    private function isTyped(int $needle, int $type): bool {
+        return (($needle & $type) !== 0);
+    }
+
+    /**
+     * Confirm the string set for app and key fit the database description
+     *
+     * @param string $app assert $app fit in database
+     * @param string $configKey assert config key fit in database
+     * @param bool $allowEmptyApp $app can be empty string
+     * @param int $valueType assert value type is only one type
+     *
+     * @throws InvalidArgumentException
+     */
+    private function assertParams(string $app = '', string $configKey = '', bool $allowEmptyApp = false, int $valueType = -1): void {
+        if (!$allowEmptyApp && $app === '') {
+            throw new InvalidArgumentException('app cannot be an empty string');
+        }
+        if (strlen($app) > self::APP_MAX_LENGTH) {
+            throw new InvalidArgumentException(
+                'Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')'
+            );
+        }
+        if (strlen($configKey) > self::KEY_MAX_LENGTH) {
+            throw new InvalidArgumentException('Value (' . $configKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
+        }
+        if ($valueType > -1) {
+            $valueType &= ~self::VALUE_SENSITIVE;
+            if (!in_array($valueType, [self::VALUE_MIXED, self::VALUE_STRING, self::VALUE_INT, self::VALUE_FLOAT, self::VALUE_BOOL, self::VALUE_ARRAY])) {
+                throw new InvalidArgumentException('Unknown value type');
+            }
+        }
+    }
+
+    /**
+     * Load normal config or config set as lazy loaded
+     *
+     * @param bool $lazy set to TRUE to also load config values set as lazy loaded
+     */
+    private function loadConfig(?string $app = null, bool $lazy = false): void {
+        if ($this->isLoaded($lazy)) {
+            return;
+        }
+
+        // if lazy is null or true, we debug log
+        if ($lazy === true && $app !== null) {
+            $exception = new \RuntimeException('The loading of lazy AppConfig values have been triggered by app "' . $app . '"');
+            $this->logger->debug($exception->getMessage(), ['exception' => $exception, 'app' => $app]);
+        }
+
+        $loadLazyOnly = $lazy && $this->isLoaded();
+
+        /** @var array<mixed> */
+        $cacheContent = $this->localCache?->get(self::LOCAL_CACHE_KEY) ?? [];
+        $includesLazyValues = !empty($cacheContent) && !empty($cacheContent['lazyCache']);
+        if (!empty($cacheContent) && (!$lazy || $includesLazyValues)) {
+            $this->valueTypes = $cacheContent['valueTypes'];
+            $this->fastCache = $cacheContent['fastCache'];
+            $this->fastLoaded = !empty($this->fastCache);
+            if ($includesLazyValues) {
+                $this->lazyCache = $cacheContent['lazyCache'];
+                $this->lazyLoaded = !empty($this->lazyCache);
+            }
+            return;
+        }
+
+        // Otherwise no cache available and we need to fetch from database
+        $qb = $this->connection->getQueryBuilder();
+        $qb->from('appconfig')
+            ->select('appid', 'configkey', 'configvalue', 'type');
+
+        if ($lazy === false) {
+            $qb->where($qb->expr()->eq('lazy', $qb->createNamedParameter(0, IQueryBuilder::PARAM_INT)));
+        } else {
+            if ($loadLazyOnly) {
+                $qb->where($qb->expr()->eq('lazy', $qb->createNamedParameter(1, IQueryBuilder::PARAM_INT)));
+            }
+            $qb->addSelect('lazy');
+        }
+
+        $result = $qb->executeQuery();
+        $rows = $result->fetchAll();
+        foreach ($rows as $row) {
+            // most of the time, 'lazy' is not in the select because its value is already known
+            if ($lazy && ((int)$row['lazy']) === 1) {
+                $this->lazyCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
+            } else {
+                $this->fastCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
+            }
+            $this->valueTypes[$row['appid']][$row['configkey']] = (int)($row['type'] ?? 0);
+        }
+
+        $result->closeCursor();
+        $this->localCache?->set(
+            self::LOCAL_CACHE_KEY,
+            [
+                'fastCache' => $this->fastCache,
+                'lazyCache' => $this->lazyCache,
+                'valueTypes' => $this->valueTypes,
+            ],
+            self::LOCAL_CACHE_TTL,
+        );
+
+        $this->fastLoaded = true;
+        $this->lazyLoaded = $lazy;
+    }
+
+    /**
+     * @param bool $lazy - If set to true then also check if lazy values are loaded
+     */
+    private function isLoaded(bool $lazy = false): bool {
+        return $this->fastLoaded && (!$lazy || $this->lazyLoaded);
+    }
+
+    /**
+     * Gets the config value
+     *
+     * @param string $app app
+     * @param string $key key
+     * @param string $default - Default value if the key does not exist
+     *
+     * @return string the value or $default
+     * @deprecated 29.0.0 use getValue*()
+     *
+     * This function gets a value from the appconfig table. If the key does
+     * not exist the default value will be returned
+     */
+    public function getValue($app, $key, $default = '') {
+        $this->loadConfig($app);
+        $this->matchAndApplyLexiconDefinition($app, $key);
+
+        return $this->fastCache[$app][$key] ?? $default;
+    }
+
+    /**
+     * Sets a value. If the key did not exist before it will be created.
+     *
+     * @param string $app app
+     * @param string $key key
+     * @param string|float|int $value value
+     *
+     * @return bool True if the value was inserted or updated, false if the value was the same
+     * @throws AppConfigTypeConflictException
+     * @throws AppConfigUnknownKeyException
+     * @deprecated 29.0.0
+     */
+    public function setValue($app, $key, $value) {
+        /**
+         * TODO: would it be overkill, or decently improve performance, to catch
+         * call to this method with $key='enabled' and 'hide' config value related
+         * to $app when the app is disabled (by modifying entry in database: lazy=lazy+2)
+         * or enabled (lazy=lazy-2)
+         *
+         * this solution would remove the loading of config values from disabled app
+         * unless calling the method.
+         */
+        return $this->setTypedValue($app, $key, (string)$value, false, self::VALUE_MIXED);
+    }
+
+
+    /**
+     * get multiple values, either the app or key can be used as wildcard by setting it to false
+     *
+     * @param string|false $app
+     * @param string|false $key
+     *
+     * @return array|false
+     * @deprecated 29.0.0 use {@see getAllValues()}
+     */
+    public function getValues($app, $key) {
+        if (($app !== false) === ($key !== false)) {
+            return false;
+        }
+
+        $key = ($key === false) ? '' : $key;
+        if (!$app) {
+            return $this->searchValues($key, false, self::VALUE_MIXED);
+        } else {
+            return $this->getAllValues($app, $key);
+        }
+    }
+
+    /**
+     * get all values of the app or and filters out sensitive data
+     *
+     * @param string $app
+     *
+     * @return array
+     * @deprecated 29.0.0 use {@see getAllValues()}
+     */
+    public function getFilteredValues($app) {
+        return $this->getAllValues($app, filtered: true);
+    }
+
+
+    /**
+     * **Warning:** avoid default NULL value for $lazy as this will
+     * load all lazy values from the database
+     *
+     * @param string $app
+     * @param array<string, string> $values ['key' => 'value']
+     * @param bool|null $lazy
+     *
+     * @return array<string, string|int|float|bool|array>
+     */
+    private function formatAppValues(string $app, array $values, ?bool $lazy = null): array {
+        foreach ($values as $key => $value) {
+            try {
+                $type = $this->getValueType($app, $key, $lazy);
+            } catch (AppConfigUnknownKeyException) {
+                continue;
+            }
+
+            $values[$key] = $this->convertTypedValue($value, $type);
+        }
+
+        return $values;
+    }
+
+    /**
+     * convert string value to the expected type
+     *
+     * @param string $value
+     * @param int $type
+     *
+     * @return string|int|float|bool|array
+     */
+    private function convertTypedValue(string $value, int $type): string|int|float|bool|array {
+        switch ($type) {
+            case self::VALUE_INT:
+                return (int)$value;
+            case self::VALUE_FLOAT:
+                return (float)$value;
+            case self::VALUE_BOOL:
+                return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
+            case self::VALUE_ARRAY:
+                try {
+                    return json_decode($value, true, flags: JSON_THROW_ON_ERROR);
+                } catch (JsonException $e) {
+                    // ignoreable
+                }
+                break;
+        }
+        return $value;
+    }
+
+    /**
+     * @param string $app
+     *
+     * @return string[]
+     * @deprecated 29.0.0 data sensitivity should be set when calling setValue*()
+     */
+    private function getSensitiveKeys(string $app): array {
+        $sensitiveValues = [
+            'circles' => [
+                '/^key_pairs$/',
+                '/^local_gskey$/',
+            ],
+            'call_summary_bot' => [
+                '/^secret_(.*)$/',
+            ],
+            'external' => [
+                '/^sites$/',
+                '/^jwt_token_privkey_(.*)$/',
+            ],
+            'globalsiteselector' => [
+                '/^gss\.jwt\.key$/',
+            ],
+            'gpgmailer' => [
+                '/^GpgServerKey$/',
+            ],
+            'integration_discourse' => [
+                '/^private_key$/',
+                '/^public_key$/',
+            ],
+            'integration_dropbox' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+            ],
+            'integration_github' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+            ],
+            'integration_gitlab' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+                '/^oauth_instance_url$/',
+            ],
+            'integration_google' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+            ],
+            'integration_jira' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+                '/^forced_instance_url$/',
+            ],
+            'integration_onedrive' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+            ],
+            'integration_openproject' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+                '/^oauth_instance_url$/',
+            ],
+            'integration_reddit' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+            ],
+            'integration_suitecrm' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+                '/^oauth_instance_url$/',
+            ],
+            'integration_twitter' => [
+                '/^consumer_key$/',
+                '/^consumer_secret$/',
+                '/^followed_user$/',
+            ],
+            'integration_zammad' => [
+                '/^client_id$/',
+                '/^client_secret$/',
+                '/^oauth_instance_url$/',
+            ],
+            'maps' => [
+                '/^mapboxAPIKEY$/',
+            ],
+            'notify_push' => [
+                '/^cookie$/',
+            ],
+            'onlyoffice' => [
+                '/^jwt_secret$/',
+            ],
+            'passwords' => [
+                '/^SSEv1ServerKey$/',
+            ],
+            'serverinfo' => [
+                '/^token$/',
+            ],
+            'spreed' => [
+                '/^bridge_bot_password$/',
+                '/^hosted-signaling-server-(.*)$/',
+                '/^recording_servers$/',
+                '/^signaling_servers$/',
+                '/^signaling_ticket_secret$/',
+                '/^signaling_token_privkey_(.*)$/',
+                '/^signaling_token_pubkey_(.*)$/',
+                '/^sip_bridge_dialin_info$/',
+                '/^sip_bridge_shared_secret$/',
+                '/^stun_servers$/',
+                '/^turn_servers$/',
+                '/^turn_server_secret$/',
+            ],
+            'support' => [
+                '/^last_response$/',
+                '/^potential_subscription_key$/',
+                '/^subscription_key$/',
+            ],
+            'theming' => [
+                '/^imprintUrl$/',
+                '/^privacyUrl$/',
+                '/^slogan$/',
+                '/^url$/',
+            ],
+            'twofactor_gateway' => [
+                '/^.*token$/',
+            ],
+            'user_ldap' => [
+                '/^(s..)?ldap_agent_password$/',
+            ],
+            'user_saml' => [
+                '/^idp-x509cert$/',
+            ],
+            'whiteboard' => [
+                '/^jwt_secret_key$/',
+            ],
+        ];
+
+        return $sensitiveValues[$app] ?? [];
+    }
+
+    /**
+     * Clear all the cached app config values
+     * New cache will be generated next time a config value is retrieved
+     *
+     * @deprecated 29.0.0 use {@see clearCache()}
+     */
+    public function clearCachedConfig(): void {
+        $this->clearCache();
+    }
+
+    /**
+     * Match and apply current use of config values with defined lexicon.
+     * Set $lazy to NULL only if only interested into checking that $key is alias.
+     *
+     * @throws AppConfigUnknownKeyException
+     * @throws AppConfigTypeConflictException
+     * @return bool TRUE if everything is fine compared to lexicon or lexicon does not exist
+     */
+    private function matchAndApplyLexiconDefinition(
+        string $app,
+        string &$key,
+        ?bool &$lazy = null,
+        int &$type = self::VALUE_MIXED,
+        ?string &$default = null,
+        ?Entry &$lexiconEntry = null,
+    ): bool {
+        if (in_array($key,
+            [
+                'enabled',
+                'installed_version',
+                'types',
+            ])) {
+            return true; // we don't break stuff for this list of config keys.
+        }
+        $configDetails = $this->getConfigDetailsFromLexicon($app);
+        if (array_key_exists($key, $configDetails['aliases']) && !$this->ignoreLexiconAliases) {
+            // in case '$rename' is set in ConfigLexiconEntry, we use the new config key
+            $key = $configDetails['aliases'][$key];
+        }
+
+        if (!array_key_exists($key, $configDetails['entries'])) {
+            return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
+        }
+
+        // if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
+        if ($lazy === null) {
+            return true;
+        }
+
+        /** @var Entry $lexiconEntry */
+        $lexiconEntry = $configDetails['entries'][$key];
+        $type &= ~self::VALUE_SENSITIVE;
+
+        $appConfigValueType = $lexiconEntry->getValueType()->toAppConfigFlag();
+        if ($type === self::VALUE_MIXED) {
+            $type = $appConfigValueType; // we overwrite if value was requested as mixed
+        } elseif ($appConfigValueType !== $type) {
+            throw new AppConfigTypeConflictException('The app config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
+        }
+
+        $lazy = $lexiconEntry->isLazy();
+        // only look for default if needed, default from Lexicon got priority
+        if ($default !== null) {
+            $default = $lexiconEntry->getDefault($this->presetManager->getLexiconPreset()) ?? $default;
+        }
+
+        if ($lexiconEntry->isFlagged(self::FLAG_SENSITIVE)) {
+            $type |= self::VALUE_SENSITIVE;
+        }
+        if ($lexiconEntry->isDeprecated()) {
+            $this->logger->notice('App config key ' . $app . '/' . $key . ' is set as deprecated.');
+        }
+
+        return true;
+    }
+
+    /**
+     * manage ConfigLexicon behavior based on strictness set in IConfigLexicon
+     *
+     * @param Strictness|null $strictness
+     * @param string $line
+     *
+     * @return bool TRUE if conflict can be fully ignored, FALSE if action should be not performed
+     * @throws AppConfigUnknownKeyException if strictness implies exception
+     * @see \OCP\Config\Lexicon\ILexicon::getStrictness()
+     */
+    private function applyLexiconStrictness(?Strictness $strictness, string $configAppKey): bool {
+        if ($strictness === null) {
+            return true;
+        }
+
+        $line = 'The app config key ' . $configAppKey . ' is not defined in the config lexicon';
+        switch ($strictness) {
+            case Strictness::IGNORE:
+                return true;
+            case Strictness::NOTICE:
+                if (!in_array($configAppKey, $this->strictnessApplied, true)) {
+                    $this->strictnessApplied[] = $configAppKey;
+                    $this->logger->notice($line);
+                }
+                return true;
+            case Strictness::WARNING:
+                if (!in_array($configAppKey, $this->strictnessApplied, true)) {
+                    $this->strictnessApplied[] = $configAppKey;
+                    $this->logger->warning($line);
+                }
+                return false;
+        }
+
+        throw new AppConfigUnknownKeyException($line);
+    }
+
+    /**
+     * extract details from registered $appId's config lexicon
+     *
+     * @param string $appId
+     * @internal
+     *
+     * @return array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}
+     */
+    public function getConfigDetailsFromLexicon(string $appId): array {
+        if (!array_key_exists($appId, $this->configLexiconDetails)) {
+            $entries = $aliases = [];
+            $bootstrapCoordinator = \OCP\Server::get(Coordinator::class);
+            $configLexicon = $bootstrapCoordinator->getRegistrationContext()?->getConfigLexicon($appId);
+            foreach ($configLexicon?->getAppConfigs() ?? [] as $configEntry) {
+                $entries[$configEntry->getKey()] = $configEntry;
+                $newName = $configEntry->getRename();
+                if ($newName !== null) {
+                    $aliases[$newName] = $configEntry->getKey();
+                }
+            }
+
+            $this->configLexiconDetails[$appId] = [
+                'entries' => $entries,
+                'aliases' => $aliases,
+                'strictness' => $configLexicon?->getStrictness() ?? Strictness::IGNORE
+            ];
+        }
+
+        return $this->configLexiconDetails[$appId];
+    }
+
+    /**
+     * get Lexicon Entry using appId and config key entry
+     *
+     * @return Entry|null NULL if entry does not exist in app's Lexicon
+     * @internal
+     */
+    public function getLexiconEntry(string $appId, string $key): ?Entry {
+        return $this->getConfigDetailsFromLexicon($appId)['entries'][$key] ?? null;
+    }
+
+    /**
+     * if set to TRUE, ignore aliases defined in Config Lexicon during the use of the methods of this class
+     *
+     * @internal
+     */
+    public function ignoreLexiconAliases(bool $ignore): void {
+        $this->ignoreLexiconAliases = $ignore;
+    }
+
+    /**
+     * Returns the installed versions of all apps
+     *
+     * @return array<string, string>
+     */
+    public function getAppInstalledVersions(bool $onlyEnabled = false): array {
+        if ($this->appVersionsCache === null) {
+            /** @var array<string, string> */
+            $this->appVersionsCache = $this->searchValues('installed_version', false, IAppConfig::VALUE_STRING);
+        }
+        if ($onlyEnabled) {
+            return array_filter(
+                $this->appVersionsCache,
+                fn (string $app): bool => $this->getValueString($app, 'enabled', 'no') !== 'no',
+                ARRAY_FILTER_USE_KEY
+            );
+        }
+        return $this->appVersionsCache;
+    }
+
+    private function clearLocalCache(): void {
+        $this->localCache?->remove(self::LOCAL_CACHE_KEY);
+    }
 }

Spacing +31 added lines, -31 removed lines

@@ -59,11 +59,11 @@ 
 	private const LOCAL_CACHE_TTL = 3;
 
 	/** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
-	private array $fastCache = [];   // cache for normal config keys
+	private array $fastCache = []; // cache for normal config keys
 	/** @var array<string, array<string, string>> ['app_id' => ['config_key' => 'config_value']] */
-	private array $lazyCache = [];   // cache for lazy config keys
+	private array $lazyCache = []; // cache for lazy config keys
 	/** @var array<string, array<string, int>> ['app_id' => ['config_key' => bitflag]] */
-	private array $valueTypes = [];  // type for all config values
+	private array $valueTypes = []; // type for all config values
 	private bool $fastLoaded = false;
 	private bool $lazyLoaded = false;
 	/** @var array<string, array{entries: array<string, Entry>, aliases: array<string, string>, strictness: Strictness}> ['app_id' => ['strictness' => ConfigLexiconStrictness, 'entries' => ['config_key' => ConfigLexiconEntry[]]] */
@@ -85,7 +85,7 @@ 
 		readonly CacheFactory $cacheFactory,
 	) {
 		if ($config->getSystemValueBool('cache_app_config', true) && $cacheFactory->isLocalCacheAvailable()) {
-			$cacheFactory->withServerVersionPrefix(function (ICacheFactory $factory) {
+			$cacheFactory->withServerVersionPrefix(function(ICacheFactory $factory) {
 				$this->localCache = $factory->createLocal();
 			});
 		}
@@ -242,7 +242,7 @@ 
 		$values = $this->formatAppValues($app, ($this->fastCache[$app] ?? []) + ($this->lazyCache[$app] ?? []));
 		$values = array_filter(
 			$values,
-			function (string $key) use ($prefix): bool {
+			function(string $key) use ($prefix): bool {
 				return str_starts_with($key, $prefix); // filter values based on $prefix
 			}, ARRAY_FILTER_USE_KEY
 		);
@@ -293,7 +293,7 @@ 
 		$values = [];
 		foreach (array_keys($cache) as $app) {
 			if (isset($cache[$app][$key])) {
-				$values[$app] = $this->convertTypedValue($cache[$app][$key], $typedAs ?? $this->getValueType((string)$app, $key, $lazy));
+				$values[$app] = $this->convertTypedValue($cache[$app][$key], $typedAs ?? $this->getValueType((string) $app, $key, $lazy));
 			}
 		}
 
@@ -388,7 +388,7 @@ 
 		int $default = 0,
 		bool $lazy = false,
 	): int {
-		return (int)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_INT);
+		return (int) $this->getTypedValue($app, $key, (string) $default, $lazy, self::VALUE_INT);
 	}
 
 	/**
@@ -406,7 +406,7 @@ 
 	 * @see IAppConfig for explanation about lazy loading
 	 */
 	public function getValueFloat(string $app, string $key, float $default = 0, bool $lazy = false): float {
-		return (float)$this->getTypedValue($app, $key, (string)$default, $lazy, self::VALUE_FLOAT);
+		return (float) $this->getTypedValue($app, $key, (string) $default, $lazy, self::VALUE_FLOAT);
 	}
 
 	/**
@@ -670,7 +670,7 @@ 
 		return $this->setTypedValue(
 			$app,
 			$key,
-			(string)$value,
+			(string) $value,
 			$lazy,
 			self::VALUE_INT | ($sensitive ? self::VALUE_SENSITIVE : 0)
 		);
@@ -700,7 +700,7 @@ 
 		return $this->setTypedValue(
 			$app,
 			$key,
-			(string)$value,
+			(string) $value,
 			$lazy,
 			self::VALUE_FLOAT | ($sensitive ? self::VALUE_SENSITIVE : 0)
 		);
@@ -805,7 +805,7 @@ 
 
 		$origValue = $value;
 		if ($sensitive || ($this->hasKey($app, $key, $lazy) && $this->isSensitive($app, $key, $lazy))) {
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+			$value = self::ENCRYPTION_PREFIX.$this->crypto->encrypt($value);
 		}
 
 		if ($this->hasKey($app, $key, $lazy)) {
@@ -870,7 +870,7 @@ 
 				} catch (AppConfigIncorrectTypeException) {
 					// can be ignored, this was just needed for a better exception message.
 				}
-				throw new AppConfigTypeConflictException('conflict between new type (' . $type . ') and old type (' . $currType . ')');
+				throw new AppConfigTypeConflictException('conflict between new type ('.$type.') and old type ('.$currType.')');
 			}
 
 			// we fix $type if the stored value, or the new value as it might be changed, is set as sensitive
@@ -1004,7 +1004,7 @@ 
 		$value = $cache[$app][$key];
 		if ($sensitive) {
 			$type |= self::VALUE_SENSITIVE;
-			$value = self::ENCRYPTION_PREFIX . $this->crypto->encrypt($value);
+			$value = self::ENCRYPTION_PREFIX.$this->crypto->encrypt($value);
 		} else {
 			$value = $this->crypto->decrypt(substr($value, self::ENCRYPTION_PREFIX_LENGTH));
 		}
@@ -1085,7 +1085,7 @@ 
 			$typeString = $this->convertTypeToString($type);
 		} catch (AppConfigIncorrectTypeException $e) {
 			$this->logger->warning('type stored in database is not correct', ['exception' => $e, 'type' => $type]);
-			$typeString = (string)$type;
+			$typeString = (string) $type;
 		}
 
 		if (!isset($cache[$app][$key])) {
@@ -1133,7 +1133,7 @@ 
 		try {
 			$lazy = false;
 			$this->matchAndApplyLexiconDefinition($app, $key, $lazy, lexiconEntry: $lexiconEntry);
-		} catch (AppConfigTypeConflictException|AppConfigUnknownKeyException) {
+		} catch (AppConfigTypeConflictException | AppConfigUnknownKeyException) {
 			// can be ignored
 		}
 
@@ -1167,7 +1167,7 @@ 
 			'float' => IAppConfig::VALUE_FLOAT,
 			'boolean' => IAppConfig::VALUE_BOOL,
 			'array' => IAppConfig::VALUE_ARRAY,
-			default => throw new AppConfigIncorrectTypeException('Unknown type ' . $type)
+			default => throw new AppConfigIncorrectTypeException('Unknown type '.$type)
 		};
 	}
 
@@ -1188,7 +1188,7 @@ 
 			IAppConfig::VALUE_FLOAT => 'float',
 			IAppConfig::VALUE_BOOL => 'boolean',
 			IAppConfig::VALUE_ARRAY => 'array',
-			default => throw new AppConfigIncorrectTypeException('Unknown numeric type ' . $type)
+			default => throw new AppConfigIncorrectTypeException('Unknown numeric type '.$type)
 		};
 	}
 
@@ -1297,11 +1297,11 @@ 
 		}
 		if (strlen($app) > self::APP_MAX_LENGTH) {
 			throw new InvalidArgumentException(
-				'Value (' . $app . ') for app is too long (' . self::APP_MAX_LENGTH . ')'
+				'Value ('.$app.') for app is too long ('.self::APP_MAX_LENGTH.')'
 			);
 		}
 		if (strlen($configKey) > self::KEY_MAX_LENGTH) {
-			throw new InvalidArgumentException('Value (' . $configKey . ') for key is too long (' . self::KEY_MAX_LENGTH . ')');
+			throw new InvalidArgumentException('Value ('.$configKey.') for key is too long ('.self::KEY_MAX_LENGTH.')');
 		}
 		if ($valueType > -1) {
 			$valueType &= ~self::VALUE_SENSITIVE;
@@ -1323,7 +1323,7 @@ 
 
 		// if lazy is null or true, we debug log
 		if ($lazy === true && $app !== null) {
-			$exception = new \RuntimeException('The loading of lazy AppConfig values have been triggered by app "' . $app . '"');
+			$exception = new \RuntimeException('The loading of lazy AppConfig values have been triggered by app "'.$app.'"');
 			$this->logger->debug($exception->getMessage(), ['exception' => $exception, 'app' => $app]);
 		}
 
@@ -1361,12 +1361,12 @@ 
 		$rows = $result->fetchAll();
 		foreach ($rows as $row) {
 			// most of the time, 'lazy' is not in the select because its value is already known
-			if ($lazy && ((int)$row['lazy']) === 1) {
+			if ($lazy && ((int) $row['lazy']) === 1) {
 				$this->lazyCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
 			} else {
 				$this->fastCache[$row['appid']][$row['configkey']] = $row['configvalue'] ?? '';
 			}
-			$this->valueTypes[$row['appid']][$row['configkey']] = (int)($row['type'] ?? 0);
+			$this->valueTypes[$row['appid']][$row['configkey']] = (int) ($row['type'] ?? 0);
 		}
 
 		$result->closeCursor();
@@ -1433,7 +1433,7 @@ 
 		 * this solution would remove the loading of config values from disabled app
 		 * unless calling the method.
 		 */
-		return $this->setTypedValue($app, $key, (string)$value, false, self::VALUE_MIXED);
+		return $this->setTypedValue($app, $key, (string) $value, false, self::VALUE_MIXED);
 	}
 
 
@@ -1504,12 +1504,12 @@ 
 	 *
 	 * @return string|int|float|bool|array
 	 */
-	private function convertTypedValue(string $value, int $type): string|int|float|bool|array {
+	private function convertTypedValue(string $value, int $type): string | int | float | bool | array {
 		switch ($type) {
 			case self::VALUE_INT:
-				return (int)$value;
+				return (int) $value;
 			case self::VALUE_FLOAT:
-				return (float)$value;
+				return (float) $value;
 			case self::VALUE_BOOL:
 				return in_array(strtolower($value), ['1', 'true', 'yes', 'on']);
 			case self::VALUE_ARRAY:
@@ -1683,7 +1683,7 @@ 
 		?bool &$lazy = null,
 		int &$type = self::VALUE_MIXED,
 		?string &$default = null,
-		?Entry &$lexiconEntry = null,
+		?Entry & $lexiconEntry = null,
 	): bool {
 		if (in_array($key,
 			[
@@ -1700,7 +1700,7 @@ 
 		}
 
 		if (!array_key_exists($key, $configDetails['entries'])) {
-			return $this->applyLexiconStrictness($configDetails['strictness'], $app . '/' . $key);
+			return $this->applyLexiconStrictness($configDetails['strictness'], $app.'/'.$key);
 		}
 
 		// if lazy is NULL, we ignore all check on the type/lazyness/default from Lexicon
@@ -1716,7 +1716,7 @@ 
 		if ($type === self::VALUE_MIXED) {
 			$type = $appConfigValueType; // we overwrite if value was requested as mixed
 		} elseif ($appConfigValueType !== $type) {
-			throw new AppConfigTypeConflictException('The app config key ' . $app . '/' . $key . ' is typed incorrectly in relation to the config lexicon');
+			throw new AppConfigTypeConflictException('The app config key '.$app.'/'.$key.' is typed incorrectly in relation to the config lexicon');
 		}
 
 		$lazy = $lexiconEntry->isLazy();
@@ -1729,7 +1729,7 @@ 
 			$type |= self::VALUE_SENSITIVE;
 		}
 		if ($lexiconEntry->isDeprecated()) {
-			$this->logger->notice('App config key ' . $app . '/' . $key . ' is set as deprecated.');
+			$this->logger->notice('App config key '.$app.'/'.$key.' is set as deprecated.');
 		}
 
 		return true;
@@ -1750,7 +1750,7 @@ 
 			return true;
 		}
 
-		$line = 'The app config key ' . $configAppKey . ' is not defined in the config lexicon';
+		$line = 'The app config key '.$configAppKey.' is not defined in the config lexicon';
 		switch ($strictness) {
 			case Strictness::IGNORE:
 				return true;