nextcloud / server

lib/private/SystemConfig.php

Indentation +174 added lines, -174 removed lines

@@ -35,178 +35,178 @@
  */
 class SystemConfig {
 
-	/** @var array */
-	protected $sensitiveValues = [
-		'instanceid' => true,
-		'datadirectory' => true,
-		'dbname' => true,
-		'dbhost' => true,
-		'dbpassword' => true,
-		'dbuser' => true,
-		'activity_dbname' => true,
-		'activity_dbhost' => true,
-		'activity_dbpassword' => true,
-		'activity_dbuser' => true,
-		'mail_from_address' => true,
-		'mail_domain' => true,
-		'mail_smtphost' => true,
-		'mail_smtpname' => true,
-		'mail_smtppassword' => true,
-		'passwordsalt' => true,
-		'secret' => true,
-		'updater.secret' => true,
-		'trusted_proxies' => true,
-		'proxyuserpwd' => true,
-		'sentry.dsn' => true,
-		'sentry.public-dsn' => true,
-		'zammad.download.secret' => true,
-		'zammad.portal.secret' => true,
-		'zammad.secret' => true,
-		'github.client_id' => true,
-		'github.client_secret' => true,
-		'log.condition' => [
-			'shared_secret' => true,
-		],
-		'license-key' => true,
-		'redis' => [
-			'host' => true,
-			'password' => true,
-		],
-		'objectstore' => [
-			'arguments' => [
-				// Legacy Swift (https://github.com/nextcloud/server/pull/17696#discussion_r341302207)
-				'options' => [
-					'credentials' => [
-						'key' => true,
-						'secret' => true,
-					]
-				],
-				// S3
-				'key' => true,
-				'secret' => true,
-				// Swift v2
-				'username' => true,
-				'password' => true,
-				// Swift v3
-				'user' => [
-					'name' => true,
-					'password' => true,
-				],
-			],
-		],
-		'objectstore_multibucket' => [
-			'arguments' => [
-				'options' => [
-					'credentials' => [
-						'key' => true,
-						'secret' => true,
-					]
-				],
-				// S3
-				'key' => true,
-				'secret' => true,
-				// Swift v2
-				'username' => true,
-				'password' => true,
-				// Swift v3
-				'user' => [
-					'name' => true,
-					'password' => true,
-				],
-			],
-		],
-	];
-
-	/** @var Config */
-	private $config;
-
-	public function __construct(Config $config) {
-		$this->config = $config;
-	}
-
-	/**
-	 * Lists all available config keys
-	 * @return array an array of key names
-	 */
-	public function getKeys() {
-		return $this->config->getKeys();
-	}
-
-	/**
-	 * Sets a new system wide value
-	 *
-	 * @param string $key the key of the value, under which will be saved
-	 * @param mixed $value the value that should be stored
-	 */
-	public function setValue($key, $value) {
-		$this->config->setValue($key, $value);
-	}
-
-	/**
-	 * Sets and deletes values and writes the config.php
-	 *
-	 * @param array $configs Associative array with `key => value` pairs
-	 *                       If value is null, the config key will be deleted
-	 */
-	public function setValues(array $configs) {
-		$this->config->setValues($configs);
-	}
-
-	/**
-	 * Looks up a system wide defined value
-	 *
-	 * @param string $key the key of the value, under which it was saved
-	 * @param mixed $default the default value to be returned if the value isn't set
-	 * @return mixed the value or $default
-	 */
-	public function getValue($key, $default = '') {
-		return $this->config->getValue($key, $default);
-	}
-
-	/**
-	 * Looks up a system wide defined value and filters out sensitive data
-	 *
-	 * @param string $key the key of the value, under which it was saved
-	 * @param mixed $default the default value to be returned if the value isn't set
-	 * @return mixed the value or $default
-	 */
-	public function getFilteredValue($key, $default = '') {
-		$value = $this->getValue($key, $default);
-
-		if (isset($this->sensitiveValues[$key])) {
-			$value = $this->removeSensitiveValue($this->sensitiveValues[$key], $value);
-		}
-
-		return $value;
-	}
-
-	/**
-	 * Delete a system wide defined value
-	 *
-	 * @param string $key the key of the value, under which it was saved
-	 */
-	public function deleteValue($key) {
-		$this->config->deleteKey($key);
-	}
-
-	/**
-	 * @param bool|array $keysToRemove
-	 * @param mixed $value
-	 * @return mixed
-	 */
-	protected function removeSensitiveValue($keysToRemove, $value) {
-		if ($keysToRemove === true) {
-			return IConfig::SENSITIVE_VALUE;
-		}
-
-		if (is_array($value)) {
-			foreach ($keysToRemove as $keyToRemove => $valueToRemove) {
-				if (isset($value[$keyToRemove])) {
-					$value[$keyToRemove] = $this->removeSensitiveValue($valueToRemove, $value[$keyToRemove]);
-				}
-			}
-		}
-
-		return $value;
-	}
+    /** @var array */
+    protected $sensitiveValues = [
+        'instanceid' => true,
+        'datadirectory' => true,
+        'dbname' => true,
+        'dbhost' => true,
+        'dbpassword' => true,
+        'dbuser' => true,
+        'activity_dbname' => true,
+        'activity_dbhost' => true,
+        'activity_dbpassword' => true,
+        'activity_dbuser' => true,
+        'mail_from_address' => true,
+        'mail_domain' => true,
+        'mail_smtphost' => true,
+        'mail_smtpname' => true,
+        'mail_smtppassword' => true,
+        'passwordsalt' => true,
+        'secret' => true,
+        'updater.secret' => true,
+        'trusted_proxies' => true,
+        'proxyuserpwd' => true,
+        'sentry.dsn' => true,
+        'sentry.public-dsn' => true,
+        'zammad.download.secret' => true,
+        'zammad.portal.secret' => true,
+        'zammad.secret' => true,
+        'github.client_id' => true,
+        'github.client_secret' => true,
+        'log.condition' => [
+            'shared_secret' => true,
+        ],
+        'license-key' => true,
+        'redis' => [
+            'host' => true,
+            'password' => true,
+        ],
+        'objectstore' => [
+            'arguments' => [
+                // Legacy Swift (https://github.com/nextcloud/server/pull/17696#discussion_r341302207)
+                'options' => [
+                    'credentials' => [
+                        'key' => true,
+                        'secret' => true,
+                    ]
+                ],
+                // S3
+                'key' => true,
+                'secret' => true,
+                // Swift v2
+                'username' => true,
+                'password' => true,
+                // Swift v3
+                'user' => [
+                    'name' => true,
+                    'password' => true,
+                ],
+            ],
+        ],
+        'objectstore_multibucket' => [
+            'arguments' => [
+                'options' => [
+                    'credentials' => [
+                        'key' => true,
+                        'secret' => true,
+                    ]
+                ],
+                // S3
+                'key' => true,
+                'secret' => true,
+                // Swift v2
+                'username' => true,
+                'password' => true,
+                // Swift v3
+                'user' => [
+                    'name' => true,
+                    'password' => true,
+                ],
+            ],
+        ],
+    ];
+
+    /** @var Config */
+    private $config;
+
+    public function __construct(Config $config) {
+        $this->config = $config;
+    }
+
+    /**
+     * Lists all available config keys
+     * @return array an array of key names
+     */
+    public function getKeys() {
+        return $this->config->getKeys();
+    }
+
+    /**
+     * Sets a new system wide value
+     *
+     * @param string $key the key of the value, under which will be saved
+     * @param mixed $value the value that should be stored
+     */
+    public function setValue($key, $value) {
+        $this->config->setValue($key, $value);
+    }
+
+    /**
+     * Sets and deletes values and writes the config.php
+     *
+     * @param array $configs Associative array with `key => value` pairs
+     *                       If value is null, the config key will be deleted
+     */
+    public function setValues(array $configs) {
+        $this->config->setValues($configs);
+    }
+
+    /**
+     * Looks up a system wide defined value
+     *
+     * @param string $key the key of the value, under which it was saved
+     * @param mixed $default the default value to be returned if the value isn't set
+     * @return mixed the value or $default
+     */
+    public function getValue($key, $default = '') {
+        return $this->config->getValue($key, $default);
+    }
+
+    /**
+     * Looks up a system wide defined value and filters out sensitive data
+     *
+     * @param string $key the key of the value, under which it was saved
+     * @param mixed $default the default value to be returned if the value isn't set
+     * @return mixed the value or $default
+     */
+    public function getFilteredValue($key, $default = '') {
+        $value = $this->getValue($key, $default);
+
+        if (isset($this->sensitiveValues[$key])) {
+            $value = $this->removeSensitiveValue($this->sensitiveValues[$key], $value);
+        }
+
+        return $value;
+    }
+
+    /**
+     * Delete a system wide defined value
+     *
+     * @param string $key the key of the value, under which it was saved
+     */
+    public function deleteValue($key) {
+        $this->config->deleteKey($key);
+    }
+
+    /**
+     * @param bool|array $keysToRemove
+     * @param mixed $value
+     * @return mixed
+     */
+    protected function removeSensitiveValue($keysToRemove, $value) {
+        if ($keysToRemove === true) {
+            return IConfig::SENSITIVE_VALUE;
+        }
+
+        if (is_array($value)) {
+            foreach ($keysToRemove as $keyToRemove => $valueToRemove) {
+                if (isset($value[$keyToRemove])) {
+                    $value[$keyToRemove] = $this->removeSensitiveValue($valueToRemove, $value[$keyToRemove]);
+                }
+            }
+        }
+
+        return $value;
+    }
 }

lib/private/AppConfig.php

Indentation +330 added lines, -330 removed lines

@@ -43,344 +43,344 @@
  */
 class AppConfig implements IAppConfig {
 
-	/** @var array[] */
-	protected $sensitiveValues = [
-		'circles' => [
-			'/^local_gskey$/',
-		],
-		'external' => [
-			'/^sites$/',
-		],
-		'integration_discourse' => [
-			'/^private_key$/',
-			'/^public_key$/',
-		],
-		'notify_push' => [
-			'/^cookie$/',
-		],
-		'spreed' => [
-			'/^bridge_bot_password/',
-			'/^signaling_servers$/',
-			'/^signaling_ticket_secret$/',
-			'/^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$/',
-		],
-		'user_ldap' => [
-			'/^(s..)?ldap_agent_password$/',
-		],
-	];
-
-	/** @var Connection */
-	protected $conn;
-
-	/** @var array[] */
-	private $cache = [];
-
-	/** @var bool */
-	private $configLoaded = false;
-
-	/**
-	 * @param Connection $conn
-	 */
-	public function __construct(Connection $conn) {
-		$this->conn = $conn;
-	}
-
-	/**
-	 * @param string $app
-	 * @return array
-	 */
-	private function getAppValues($app) {
-		$this->loadConfigValues();
-
-		if (isset($this->cache[$app])) {
-			return $this->cache[$app];
-		}
-
-		return [];
-	}
-
-	/**
-	 * Get all apps using the config
-	 *
-	 * @return array an array of app ids
-	 *
-	 * This function returns a list of all apps that have at least one
-	 * entry in the appconfig table.
-	 */
-	public function getApps() {
-		$this->loadConfigValues();
-
-		return $this->getSortedKeys($this->cache);
-	}
-
-	/**
-	 * Get the available keys for an app
-	 *
-	 * @param string $app the app we are looking for
-	 * @return array an array of key names
-	 *
-	 * This function gets all keys of an app. Please note that the values are
-	 * not returned.
-	 */
-	public function getKeys($app) {
-		$this->loadConfigValues();
-
-		if (isset($this->cache[$app])) {
-			return $this->getSortedKeys($this->cache[$app]);
-		}
-
-		return [];
-	}
-
-	public function getSortedKeys($data) {
-		$keys = array_keys($data);
-		sort($keys);
-		return $keys;
-	}
-
-	/**
-	 * Gets the config value
-	 *
-	 * @param string $app app
-	 * @param string $key key
-	 * @param string $default = null, default value if the key does not exist
-	 * @return string the value or $default
-	 *
-	 * 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 = null) {
-		$this->loadConfigValues();
-
-		if ($this->hasKey($app, $key)) {
-			return $this->cache[$app][$key];
-		}
-
-		return $default;
-	}
-
-	/**
-	 * check if a key is set in the appconfig
-	 *
-	 * @param string $app
-	 * @param string $key
-	 * @return bool
-	 */
-	public function hasKey($app, $key) {
-		$this->loadConfigValues();
-
-		return isset($this->cache[$app][$key]);
-	}
-
-	/**
-	 * 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
-	 */
-	public function setValue($app, $key, $value) {
-		if (!$this->hasKey($app, $key)) {
-			$inserted = (bool) $this->conn->insertIfNotExist('*PREFIX*appconfig', [
-				'appid' => $app,
-				'configkey' => $key,
-				'configvalue' => $value,
-			], [
-				'appid',
-				'configkey',
-			]);
-
-			if ($inserted) {
-				if (!isset($this->cache[$app])) {
-					$this->cache[$app] = [];
-				}
-
-				$this->cache[$app][$key] = $value;
-				return true;
-			}
-		}
-
-		$sql = $this->conn->getQueryBuilder();
-		$sql->update('appconfig')
-			->set('configvalue', $sql->createNamedParameter($value))
-			->where($sql->expr()->eq('appid', $sql->createNamedParameter($app)))
-			->andWhere($sql->expr()->eq('configkey', $sql->createNamedParameter($key)));
-
-		/*
+    /** @var array[] */
+    protected $sensitiveValues = [
+        'circles' => [
+            '/^local_gskey$/',
+        ],
+        'external' => [
+            '/^sites$/',
+        ],
+        'integration_discourse' => [
+            '/^private_key$/',
+            '/^public_key$/',
+        ],
+        'notify_push' => [
+            '/^cookie$/',
+        ],
+        'spreed' => [
+            '/^bridge_bot_password/',
+            '/^signaling_servers$/',
+            '/^signaling_ticket_secret$/',
+            '/^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$/',
+        ],
+        'user_ldap' => [
+            '/^(s..)?ldap_agent_password$/',
+        ],
+    ];
+
+    /** @var Connection */
+    protected $conn;
+
+    /** @var array[] */
+    private $cache = [];
+
+    /** @var bool */
+    private $configLoaded = false;
+
+    /**
+     * @param Connection $conn
+     */
+    public function __construct(Connection $conn) {
+        $this->conn = $conn;
+    }
+
+    /**
+     * @param string $app
+     * @return array
+     */
+    private function getAppValues($app) {
+        $this->loadConfigValues();
+
+        if (isset($this->cache[$app])) {
+            return $this->cache[$app];
+        }
+
+        return [];
+    }
+
+    /**
+     * Get all apps using the config
+     *
+     * @return array an array of app ids
+     *
+     * This function returns a list of all apps that have at least one
+     * entry in the appconfig table.
+     */
+    public function getApps() {
+        $this->loadConfigValues();
+
+        return $this->getSortedKeys($this->cache);
+    }
+
+    /**
+     * Get the available keys for an app
+     *
+     * @param string $app the app we are looking for
+     * @return array an array of key names
+     *
+     * This function gets all keys of an app. Please note that the values are
+     * not returned.
+     */
+    public function getKeys($app) {
+        $this->loadConfigValues();
+
+        if (isset($this->cache[$app])) {
+            return $this->getSortedKeys($this->cache[$app]);
+        }
+
+        return [];
+    }
+
+    public function getSortedKeys($data) {
+        $keys = array_keys($data);
+        sort($keys);
+        return $keys;
+    }
+
+    /**
+     * Gets the config value
+     *
+     * @param string $app app
+     * @param string $key key
+     * @param string $default = null, default value if the key does not exist
+     * @return string the value or $default
+     *
+     * 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 = null) {
+        $this->loadConfigValues();
+
+        if ($this->hasKey($app, $key)) {
+            return $this->cache[$app][$key];
+        }
+
+        return $default;
+    }
+
+    /**
+     * check if a key is set in the appconfig
+     *
+     * @param string $app
+     * @param string $key
+     * @return bool
+     */
+    public function hasKey($app, $key) {
+        $this->loadConfigValues();
+
+        return isset($this->cache[$app][$key]);
+    }
+
+    /**
+     * 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
+     */
+    public function setValue($app, $key, $value) {
+        if (!$this->hasKey($app, $key)) {
+            $inserted = (bool) $this->conn->insertIfNotExist('*PREFIX*appconfig', [
+                'appid' => $app,
+                'configkey' => $key,
+                'configvalue' => $value,
+            ], [
+                'appid',
+                'configkey',
+            ]);
+
+            if ($inserted) {
+                if (!isset($this->cache[$app])) {
+                    $this->cache[$app] = [];
+                }
+
+                $this->cache[$app][$key] = $value;
+                return true;
+            }
+        }
+
+        $sql = $this->conn->getQueryBuilder();
+        $sql->update('appconfig')
+            ->set('configvalue', $sql->createNamedParameter($value))
+            ->where($sql->expr()->eq('appid', $sql->createNamedParameter($app)))
+            ->andWhere($sql->expr()->eq('configkey', $sql->createNamedParameter($key)));
+
+        /*
 		 * Only limit to the existing value for non-Oracle DBs:
 		 * http://docs.oracle.com/cd/E11882_01/server.112/e26088/conditions002.htm#i1033286
 		 * > Large objects (LOBs) are not supported in comparison conditions.
 		 */
-		if (!($this->conn instanceof OracleConnection)) {
+        if (!($this->conn instanceof OracleConnection)) {
 
-			/*
+            /*
 			 * Only update the value when it is not the same
 			 * Note that NULL requires some special handling. Since comparing
 			 * against null can have special results.
 			 */
 
-			if ($value === null) {
-				$sql->andWhere(
-					$sql->expr()->isNotNull('configvalue')
-				);
-			} else {
-				$sql->andWhere(
-					$sql->expr()->orX(
-						$sql->expr()->isNull('configvalue'),
-						$sql->expr()->neq('configvalue', $sql->createNamedParameter($value))
-					)
-				);
-			}
-		}
-
-		$changedRow = (bool) $sql->execute();
-
-		$this->cache[$app][$key] = $value;
-
-		return $changedRow;
-	}
-
-	/**
-	 * Deletes a key
-	 *
-	 * @param string $app app
-	 * @param string $key key
-	 * @return boolean
-	 */
-	public function deleteKey($app, $key) {
-		$this->loadConfigValues();
-
-		$sql = $this->conn->getQueryBuilder();
-		$sql->delete('appconfig')
-			->where($sql->expr()->eq('appid', $sql->createParameter('app')))
-			->andWhere($sql->expr()->eq('configkey', $sql->createParameter('configkey')))
-			->setParameter('app', $app)
-			->setParameter('configkey', $key);
-		$sql->execute();
-
-		unset($this->cache[$app][$key]);
-		return false;
-	}
-
-	/**
-	 * Remove app from appconfig
-	 *
-	 * @param string $app app
-	 * @return boolean
-	 *
-	 * Removes all keys in appconfig belonging to the app.
-	 */
-	public function deleteApp($app) {
-		$this->loadConfigValues();
-
-		$sql = $this->conn->getQueryBuilder();
-		$sql->delete('appconfig')
-			->where($sql->expr()->eq('appid', $sql->createParameter('app')))
-			->setParameter('app', $app);
-		$sql->execute();
-
-		unset($this->cache[$app]);
-		return false;
-	}
-
-	/**
-	 * 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
-	 */
-	public function getValues($app, $key) {
-		if (($app !== false) === ($key !== false)) {
-			return false;
-		}
-
-		if ($key === false) {
-			return $this->getAppValues($app);
-		} else {
-			$appIds = $this->getApps();
-			$values = array_map(function ($appId) use ($key) {
-				return isset($this->cache[$appId][$key]) ? $this->cache[$appId][$key] : null;
-			}, $appIds);
-			$result = array_combine($appIds, $values);
-
-			return array_filter($result);
-		}
-	}
-
-	/**
-	 * get all values of the app or and filters out sensitive data
-	 *
-	 * @param string $app
-	 * @return array
-	 */
-	public function getFilteredValues($app) {
-		$values = $this->getValues($app, false);
-
-		if (isset($this->sensitiveValues[$app])) {
-			foreach ($this->sensitiveValues[$app] as $sensitiveKeyExp) {
-				$sensitiveKeys = preg_grep($sensitiveKeyExp, array_keys($values));
-				foreach ($sensitiveKeys as $sensitiveKey) {
-					$values[$sensitiveKey] = IConfig::SENSITIVE_VALUE;
-				}
-			}
-		}
-
-		return $values;
-	}
-
-	/**
-	 * Load all the app config values
-	 */
-	protected function loadConfigValues() {
-		if ($this->configLoaded) {
-			return;
-		}
-
-		$this->cache = [];
-
-		$sql = $this->conn->getQueryBuilder();
-		$sql->select('*')
-			->from('appconfig');
-		$result = $sql->execute();
-
-		// we are going to store the result in memory anyway
-		$rows = $result->fetchAll();
-		foreach ($rows as $row) {
-			if (!isset($this->cache[$row['appid']])) {
-				$this->cache[(string)$row['appid']] = [];
-			}
-
-			$this->cache[(string)$row['appid']][(string)$row['configkey']] = (string)$row['configvalue'];
-		}
-		$result->closeCursor();
-
-		$this->configLoaded = true;
-	}
-
-	/**
-	 * Clear all the cached app config values
-	 *
-	 * WARNING: do not use this - this is only for usage with the SCSSCacher to
-	 * clear the memory cache of the app config
-	 */
-	public function clearCachedConfig() {
-		$this->configLoaded = false;
-	}
+            if ($value === null) {
+                $sql->andWhere(
+                    $sql->expr()->isNotNull('configvalue')
+                );
+            } else {
+                $sql->andWhere(
+                    $sql->expr()->orX(
+                        $sql->expr()->isNull('configvalue'),
+                        $sql->expr()->neq('configvalue', $sql->createNamedParameter($value))
+                    )
+                );
+            }
+        }
+
+        $changedRow = (bool) $sql->execute();
+
+        $this->cache[$app][$key] = $value;
+
+        return $changedRow;
+    }
+
+    /**
+     * Deletes a key
+     *
+     * @param string $app app
+     * @param string $key key
+     * @return boolean
+     */
+    public function deleteKey($app, $key) {
+        $this->loadConfigValues();
+
+        $sql = $this->conn->getQueryBuilder();
+        $sql->delete('appconfig')
+            ->where($sql->expr()->eq('appid', $sql->createParameter('app')))
+            ->andWhere($sql->expr()->eq('configkey', $sql->createParameter('configkey')))
+            ->setParameter('app', $app)
+            ->setParameter('configkey', $key);
+        $sql->execute();
+
+        unset($this->cache[$app][$key]);
+        return false;
+    }
+
+    /**
+     * Remove app from appconfig
+     *
+     * @param string $app app
+     * @return boolean
+     *
+     * Removes all keys in appconfig belonging to the app.
+     */
+    public function deleteApp($app) {
+        $this->loadConfigValues();
+
+        $sql = $this->conn->getQueryBuilder();
+        $sql->delete('appconfig')
+            ->where($sql->expr()->eq('appid', $sql->createParameter('app')))
+            ->setParameter('app', $app);
+        $sql->execute();
+
+        unset($this->cache[$app]);
+        return false;
+    }
+
+    /**
+     * 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
+     */
+    public function getValues($app, $key) {
+        if (($app !== false) === ($key !== false)) {
+            return false;
+        }
+
+        if ($key === false) {
+            return $this->getAppValues($app);
+        } else {
+            $appIds = $this->getApps();
+            $values = array_map(function ($appId) use ($key) {
+                return isset($this->cache[$appId][$key]) ? $this->cache[$appId][$key] : null;
+            }, $appIds);
+            $result = array_combine($appIds, $values);
+
+            return array_filter($result);
+        }
+    }
+
+    /**
+     * get all values of the app or and filters out sensitive data
+     *
+     * @param string $app
+     * @return array
+     */
+    public function getFilteredValues($app) {
+        $values = $this->getValues($app, false);
+
+        if (isset($this->sensitiveValues[$app])) {
+            foreach ($this->sensitiveValues[$app] as $sensitiveKeyExp) {
+                $sensitiveKeys = preg_grep($sensitiveKeyExp, array_keys($values));
+                foreach ($sensitiveKeys as $sensitiveKey) {
+                    $values[$sensitiveKey] = IConfig::SENSITIVE_VALUE;
+                }
+            }
+        }
+
+        return $values;
+    }
+
+    /**
+     * Load all the app config values
+     */
+    protected function loadConfigValues() {
+        if ($this->configLoaded) {
+            return;
+        }
+
+        $this->cache = [];
+
+        $sql = $this->conn->getQueryBuilder();
+        $sql->select('*')
+            ->from('appconfig');
+        $result = $sql->execute();
+
+        // we are going to store the result in memory anyway
+        $rows = $result->fetchAll();
+        foreach ($rows as $row) {
+            if (!isset($this->cache[$row['appid']])) {
+                $this->cache[(string)$row['appid']] = [];
+            }
+
+            $this->cache[(string)$row['appid']][(string)$row['configkey']] = (string)$row['configvalue'];
+        }
+        $result->closeCursor();
+
+        $this->configLoaded = true;
+    }
+
+    /**
+     * Clear all the cached app config values
+     *
+     * WARNING: do not use this - this is only for usage with the SCSSCacher to
+     * clear the memory cache of the app config
+     */
+    public function clearCachedConfig() {
+        $this->configLoaded = false;
+    }
 }