Gecko [ paroquia-rio-de-mouro.pt ]

Name	Size	Permission	Date
Activity	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
App	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
AppFramework	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Archive	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Authentication	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
BackgroundJob	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Cache	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Command	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Comments	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Console	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
DB	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Diagnostics	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Encryption	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Files	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Group	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Hooks	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Http	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Image	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
IntegrityCheck	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
L10N	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Lock	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Log	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Mail	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Memcache	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Migration	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Notification	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
OCS	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Preview	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Repair	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Route	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Search	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Security	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Session	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Settings	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Setup	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Share	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Share20	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
SystemTag	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Tagging	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Template	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Theme	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Updater	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
User	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
legacy	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
AllConfig.php	13.67 KB	-rw-r--r--	2018-04-19 18:15
AppConfig.php	8.29 KB	-rw-r--r--	2018-04-19 18:15
AppHelper.php	1.41 KB	-rw-r--r--	2018-04-19 18:15
Avatar.php	4.73 KB	-rw-r--r--	2018-04-19 18:15
AvatarManager.php	3.24 KB	-rw-r--r--	2018-04-19 18:15
CapabilitiesManager.php	1.85 KB	-rw-r--r--	2018-04-19 18:15
Config.php	9.76 KB	-rw-r--r--	2018-04-19 18:15
ContactsManager.php	5.5 KB	-rw-r--r--	2018-04-19 18:15
DatabaseException.php	1.13 KB	-rw-r--r--	2018-04-19 18:15
DatabaseSetupException.php	867 B	-rw-r--r--	2018-04-19 18:15
DateTimeFormatter.php	10.2 KB	-rw-r--r--	2018-04-19 18:15
DateTimeZone.php	3.52 KB	-rw-r--r--	2018-04-19 18:15
ForbiddenException.php	981 B	-rw-r--r--	2018-04-19 18:15
HTTPHelper.php	3.11 KB	-rw-r--r--	2018-04-19 18:15
HintException.php	1.38 KB	-rw-r--r--	2018-04-19 18:15
Installer.php	19.03 KB	-rw-r--r--	2018-04-19 18:15
LargeFileHelper.php	5.48 KB	-rw-r--r--	2018-04-19 18:15
Log.php	11.18 KB	-rw-r--r--	2018-04-19 18:15
NaturalSort.php	3.98 KB	-rw-r--r--	2018-04-19 18:15
NaturalSort_DefaultCollator.php	1.06 KB	-rw-r--r--	2018-04-19 18:15
NavigationManager.php	5.04 KB	-rw-r--r--	2018-04-19 18:15
NeedsUpdateException.php	880 B	-rw-r--r--	2018-04-19 18:15
NotSquareException.php	865 B	-rw-r--r--	2018-04-19 18:15
Preview.php	35.2 KB	-rw-r--r--	2018-04-19 18:15
PreviewManager.php	11.99 KB	-rw-r--r--	2018-04-19 18:15
RedisFactory.php	2.89 KB	-rw-r--r--	2018-04-19 18:15
Repair.php	7.62 KB	-rw-r--r--	2018-04-19 18:15
RepairException.php	945 B	-rw-r--r--	2018-04-19 18:15
Search.php	3.85 KB	-rw-r--r--	2018-04-19 18:15
Server.php	45.65 KB	-rw-r--r--	2018-04-19 18:15
ServerContainer.php	2.38 KB	-rw-r--r--	2018-04-19 18:15
ServerNotAvailableException.php	823 B	-rw-r--r--	2018-04-19 18:15
ServiceUnavailableException.php	870 B	-rw-r--r--	2018-04-19 18:15
Setup.php	14.89 KB	-rw-r--r--	2018-04-19 18:15
Streamer.php	3.64 KB	-rw-r--r--	2018-04-19 18:15
SubAdmin.php	7.71 KB	-rw-r--r--	2018-04-19 18:15
SystemConfig.php	4.28 KB	-rw-r--r--	2018-04-19 18:15
TagManager.php	2.72 KB	-rw-r--r--	2018-04-19 18:15
Tags.php	21.39 KB	-rw-r--r--	2018-04-19 18:15
TempManager.php	7.31 KB	-rw-r--r--	2018-04-19 18:15
TemplateLayout.php	6.48 KB	-rw-r--r--	2018-04-19 18:15
URLGenerator.php	6.8 KB	-rw-r--r--	2018-04-19 18:15
Updater.php	10.74 KB	-rw-r--r--	2018-04-19 18:15

Rename

<?php
/**
 * @author Bart Visscher <bartv@thisnet.nl>
 * @author Joas Schilling <coding@schilljs.com>
 * @author Jörn Friedrich Dreyer <jfd@butonic.de>
 * @author Lukas Reschke <lukas@statuscode.ch>
 * @author Morris Jobke <hey@morrisjobke.de>
 * @author Robin Appelman <icewind@owncloud.com>
 * @author Robin McCorkell <robin@mccorkell.me.uk>
 * @author Thomas Müller <thomas.mueller@tmit.eu>
 * @author Vincent Petry <pvince81@owncloud.com>
 *
 * @copyright Copyright (c) 2018, ownCloud GmbH
 * @license AGPL-3.0
 *
 * This code is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License, version 3,
 * as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License, version 3,
 * along with this program.  If not, see <http://www.gnu.org/licenses/>
 *
 */

namespace OC;
use Doctrine\DBAL\Platforms\OraclePlatform;
use OC\Cache\CappedMemoryCache;
use OCP\IDBConnection;

/**
 * Class to combine all the configuration options ownCloud offers
 */
class AllConfig implements \OCP\IConfig {
	/** @var SystemConfig */
	private $systemConfig;

/** @var IDBConnection */
	private $connection;

/**
	 * 3 dimensional array with the following structure:
	 * [ $userId =>
	 *     [ $appId =>
	 *         [ $key => $value ]
	 *     ]
	 * ]
	 *
	 * database table: preferences
	 *
	 * methods that use this:
	 *   - setUserValue
	 *   - getUserValue
	 *   - getUserKeys
	 *   - deleteUserValue
	 *   - deleteAllUserValues
	 *   - deleteAppFromAllUsers
	 *
	 * @var CappedMemoryCache $userCache
	 */
	private $userCache;

/**
	 * @param SystemConfig $systemConfig
	 */
	function __construct(SystemConfig $systemConfig) {
		$this->userCache = new CappedMemoryCache();
		$this->systemConfig = $systemConfig;
	}

/**
	 * TODO - FIXME This fixes an issue with base.php that cause cyclic
	 * dependencies, especially with autoconfig setup
	 *
	 * Replace this by properly injected database connection. Currently the
	 * base.php triggers the getDatabaseConnection too early which causes in
	 * autoconfig setup case a too early distributed database connection and
	 * the autoconfig then needs to reinit all already initialized dependencies
	 * that use the database connection.
	 *
	 * otherwise a SQLite database is created in the wrong directory
	 * because the database connection was created with an uninitialized config
	 */
	private function fixDIInit() {
		if($this->connection === null) {
			$this->connection = \OC::$server->getDatabaseConnection();
		}
	}

/**
	 * Sets and deletes system wide values
	 *
	 * @param array $configs Associative array with `key => value` pairs
	 *                       If value is null, the config key will be deleted
	 */
	public function setSystemValues(array $configs) {
		$this->systemConfig->setValues($configs);
	}

/**
	 * 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 setSystemValue($key, $value) {
		$this->systemConfig->setValue($key, $value);
	}

/**
	 * 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 getSystemValue($key, $default = '') {
		return $this->systemConfig->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 getFilteredSystemValue($key, $default = '') {
		return $this->systemConfig->getFilteredValue($key, $default);
	}

/**
	 * Delete a system wide defined value
	 *
	 * @param string $key the key of the value, under which it was saved
	 */
	public function deleteSystemValue($key) {
		$this->systemConfig->deleteValue($key);
	}

/**
	 * Get all keys stored for an app
	 *
	 * @param string $appName the appName that we stored the value under
	 * @return string[] the keys stored for the app
	 */
	public function getAppKeys($appName) {
		return \OC::$server->getAppConfig()->getKeys($appName);
	}

/**
	 * Writes a new app wide value
	 *
	 * @param string $appName the appName that we want to store the value under
	 * @param string $key the key of the value, under which will be saved
	 * @param string|float|int $value the value that should be stored
	 */
	public function setAppValue($appName, $key, $value) {
		\OC::$server->getAppConfig()->setValue($appName, $key, $value);
	}

/**
	 * Looks up an app wide defined value
	 *
	 * @param string $appName the appName that we stored the value under
	 * @param string $key the key of the value, under which it was saved
	 * @param string $default the default value to be returned if the value isn't set
	 * @return string the saved value
	 */
	public function getAppValue($appName, $key, $default = '') {
		return \OC::$server->getAppConfig()->getValue($appName, $key, $default);
	}

/**
	 * Delete an app wide defined value
	 *
	 * @param string $appName the appName that we stored the value under
	 * @param string $key the key of the value, under which it was saved
	 */
	public function deleteAppValue($appName, $key) {
		\OC::$server->getAppConfig()->deleteKey($appName, $key);
	}

/**
	 * Removes all keys in appconfig belonging to the app
	 *
	 * @param string $appName the appName the configs are stored under
	 */
	public function deleteAppValues($appName) {
		\OC::$server->getAppConfig()->deleteApp($appName);
	}

/**
	 * Set a user defined value
	 *
	 * @param string $userId the userId of the user that we want to store the value under
	 * @param string $appName the appName that we want to store the value under
	 * @param string $key the key under which the value is being stored
	 * @param string|float|int $value the value that you want to store
	 * @param string $preCondition only update if the config value was previously the value passed as $preCondition
	 * @throws \OCP\PreConditionNotMetException if a precondition is specified and is not met
	 * @throws \UnexpectedValueException when trying to store an unexpected value
	 */
	public function setUserValue($userId, $appName, $key, $value, $preCondition = null) {
		if (!is_int($value) && !is_float($value) && !is_string($value)) {
			throw new \UnexpectedValueException('Only integers, floats and strings are allowed as value');
		}

// TODO - FIXME
		$this->fixDIInit();

$preconditionArray = [];
		if (isset($preCondition)) {
			$preconditionArray = [
				'configvalue' => $preCondition,
			];
		}

$this->connection->setValues('preferences', [
			'userid' => $userId,
			'appid' => $appName,
			'configkey' => $key,
		], [
			'configvalue' => $value,
		], $preconditionArray);

// only add to the cache if we already loaded data for the user
		if (isset($this->userCache[$userId])) {
			if (!isset($this->userCache[$userId][$appName])) {
				$this->userCache[$userId][$appName] = [];
			}
			$this->userCache[$userId][$appName][$key] = $value;
		}
	}

/**
	 * Getting a user defined value
	 *
	 * @param string $userId the userId of the user that we want to store the value under
	 * @param string $appName the appName that we stored the value under
	 * @param string $key the key under which the value is being stored
	 * @param mixed $default the default value to be returned if the value isn't set
	 * @return string
	 */
	public function getUserValue($userId, $appName, $key, $default = '') {
		$data = $this->getUserValues($userId);
		if (isset($data[$appName]) and isset($data[$appName][$key])) {
			return $data[$appName][$key];
		} else {
			return $default;
		}
	}

/**
	 * Get the keys of all stored by an app for the user
	 *
	 * @param string $userId the userId of the user that we want to store the value under
	 * @param string $appName the appName that we stored the value under
	 * @return string[]
	 */
	public function getUserKeys($userId, $appName) {
		$data = $this->getUserValues($userId);
		if (isset($data[$appName])) {
			return array_keys($data[$appName]);
		} else {
			return [];
		}
	}

/**
	 * Delete a user value
	 *
	 * @param string $userId the userId of the user that we want to store the value under
	 * @param string $appName the appName that we stored the value under
	 * @param string $key the key under which the value is being stored
	 */
	public function deleteUserValue($userId, $appName, $key) {
		// TODO - FIXME
		$this->fixDIInit();

$sql  = 'DELETE FROM `*PREFIX*preferences` '.
				'WHERE `userid` = ? AND `appid` = ? AND `configkey` = ?';
		$this->connection->executeUpdate($sql, [$userId, $appName, $key]);

if (isset($this->userCache[$userId]) and isset($this->userCache[$userId][$appName])) {
			unset($this->userCache[$userId][$appName][$key]);
		}
	}

/**
	 * Delete all user values
	 *
	 * @param string $userId the userId of the user that we want to remove all values from
	 */
	public function deleteAllUserValues($userId) {
		// TODO - FIXME
		$this->fixDIInit();

$sql  = 'DELETE FROM `*PREFIX*preferences` '.
			'WHERE `userid` = ?';
		$this->connection->executeUpdate($sql, [$userId]);

unset($this->userCache[$userId]);
	}

/**
	 * Delete all user related values of one app
	 *
	 * @param string $appName the appName of the app that we want to remove all values from
	 */
	public function deleteAppFromAllUsers($appName) {
		// TODO - FIXME
		$this->fixDIInit();

$sql  = 'DELETE FROM `*PREFIX*preferences` '.
				'WHERE `appid` = ?';
		$this->connection->executeUpdate($sql, [$appName]);

foreach ($this->userCache as &$userCache) {
			unset($userCache[$appName]);
		}
	}

/**
	 * Returns all user configs sorted by app of one user
	 *
	 * @param string $userId the user ID to get the app configs from
	 * @return array[] - 2 dimensional array with the following structure:
	 *     [ $appId =>
	 *         [ $key => $value ]
	 *     ]
	 */
	private function getUserValues($userId) {
		// TODO - FIXME
		$this->fixDIInit();

if (isset($this->userCache[$userId])) {
			return $this->userCache[$userId];
		}
		$data = [];
		$query = 'SELECT `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?';
		$result = $this->connection->executeQuery($query, [$userId]);
		while ($row = $result->fetch()) {
			$appId = $row['appid'];
			if (!isset($data[$appId])) {
				$data[$appId] = [];
			}
			$data[$appId][$row['configkey']] = $row['configvalue'];
		}
		$this->userCache[$userId] = $data;
		return $data;
	}

/**
	 * Fetches a mapped list of userId -> value, for a specified app and key and a list of user IDs.
	 *
	 * @param string $appName app to get the value for
	 * @param string $key the key to get the value for
	 * @param array $userIds the user IDs to fetch the values for
	 * @return array Mapped values: userId => value
	 */
	public function getUserValueForUsers($appName, $key, $userIds) {
		// TODO - FIXME
		$this->fixDIInit();

if (empty($userIds) || !is_array($userIds)) {
			return [];
		}

$chunkedUsers = array_chunk($userIds, 50, true);
		$placeholders50 = implode(',', array_fill(0, 50, '?'));

$userValues = [];
		foreach ($chunkedUsers as $chunk) {
			$queryParams = $chunk;
			// create [$app, $key, $chunkedUsers]
			array_unshift($queryParams, $key);
			array_unshift($queryParams, $appName);

$placeholders = (sizeof($chunk) == 50) ? $placeholders50 :  implode(',', array_fill(0, sizeof($chunk), '?'));

$query    = 'SELECT `userid`, `configvalue` ' .
						'FROM `*PREFIX*preferences` ' .
						'WHERE `appid` = ? AND `configkey` = ? ' .
						'AND `userid` IN (' . $placeholders . ')';
			$result = $this->connection->executeQuery($query, $queryParams);

while ($row = $result->fetch()) {
				$userValues[$row['userid']] = $row['configvalue'];
			}
		}

return $userValues;
	}

/**
	 * Determines the users that have the given value set for a specific app-key-pair
	 *
	 * @param string $appName the app to get the user for
	 * @param string $key the key to get the user for
	 * @param string $value the value to get the user for
	 * @return array of user IDs
	 */
	public function getUsersForUserValue($appName, $key, $value) {
		// TODO - FIXME
		$this->fixDIInit();

$queryBuilder = $this->connection->getQueryBuilder();
		$queryBuilder->select('userid')
			->from('preferences')
			->where($queryBuilder->expr()->eq(
				'appid', $queryBuilder->createNamedParameter($appName))
			)
			->andWhere($queryBuilder->expr()->eq(
				'configkey', $queryBuilder->createNamedParameter($key))
			)
			->andWhere($queryBuilder->expr()->isNotNull('configvalue'));

if ($this->connection->getDatabasePlatform() instanceof OraclePlatform) {
			//oracle can only compare the first 4000 bytes of a CLOB column
			$queryBuilder->andWhere($queryBuilder->expr()->eq(
				$queryBuilder->createFunction('dbms_lob.substr(`configvalue`, 4000, 1)'),
				$queryBuilder->createNamedParameter($value))
			);
		} else {
			$queryBuilder->andWhere($queryBuilder->expr()->eq(
				'configvalue', $queryBuilder->createNamedParameter($value))
			);
		}
		$query = $queryBuilder->execute();

$userIDs = [];
		while ($row = $query->fetch()) {
			$userIDs[] = $row['userid'];
		}

$query->closeCursor();

return $userIDs;
	}

/**
	 * In some environments the system config file is readonly. Find out if this
	 * is the case.
	 *
	 * @return boolean
	 * @since 10.0.3
	 */
	public function isSystemConfigReadOnly() {
		return $this->systemConfig->isReadOnly();
	}
}