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

Name	Size	Permission	Date
QueryBuilder	[ DIR ]	drwxr-xr-x	2018-04-19 18:15
Adapter.php	6.45 KB	-rw-r--r--	2018-04-19 18:15
AdapterMySQL.php	1.39 KB	-rw-r--r--	2018-04-19 18:15
AdapterOCI8.php	1.83 KB	-rw-r--r--	2018-04-19 18:15
AdapterPgSql.php	1.23 KB	-rw-r--r--	2018-04-19 18:15
AdapterSqlite.php	2.97 KB	-rw-r--r--	2018-04-19 18:15
Connection.php	14.32 KB	-rw-r--r--	2018-04-19 18:15
ConnectionFactory.php	7.06 KB	-rw-r--r--	2018-04-19 18:15
MDB2SchemaManager.php	5.44 KB	-rw-r--r--	2018-04-19 18:15
MDB2SchemaReader.php	8.49 KB	-rw-r--r--	2018-04-19 18:15
MDB2SchemaWriter.php	5.36 KB	-rw-r--r--	2018-04-19 18:15
MigrationException.php	1.05 KB	-rw-r--r--	2018-04-19 18:15
MigrationService.php	10.27 KB	-rw-r--r--	2018-04-19 18:15
Migrator.php	7.57 KB	-rw-r--r--	2018-04-19 18:15
MySQLMigrator.php	2.8 KB	-rw-r--r--	2018-04-19 18:15
MySqlSchemaColumnDefinitionListener.php	7.53 KB	-rw-r--r--	2018-04-19 18:15
MySqlTools.php	1.37 KB	-rw-r--r--	2018-04-19 18:15
OCPostgreSqlPlatform.php	2.97 KB	-rw-r--r--	2018-04-19 18:15
OCSqlitePlatform.php	1.49 KB	-rw-r--r--	2018-04-19 18:15
OracleConnection.php	3.09 KB	-rw-r--r--	2018-04-19 18:15
OracleMigrator.php	6.21 KB	-rw-r--r--	2018-04-19 18:15
PgSqlTools.php	2.23 KB	-rw-r--r--	2018-04-19 18:15
PostgreSqlMigrator.php	1.81 KB	-rw-r--r--	2018-04-19 18:15
SQLiteMigrator.php	2.21 KB	-rw-r--r--	2018-04-19 18:15
SQLiteSessionInit.php	1.82 KB	-rw-r--r--	2018-04-19 18:15

Rename

<?php
/**
 * @author Bart Visscher <bartv@thisnet.nl>
 * @author Lukas Reschke <lukas@statuscode.ch>
 * @author Morris Jobke <hey@morrisjobke.de>
 * @author Robin Appelman <icewind@owncloud.com>
 * @author Thomas Müller <thomas.mueller@tmit.eu>
 *
 * @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\DB;

class OracleConnection extends Connection {
	/**
	 * Quote the keys of the array
	 */
	private function quoteKeys(array $data) {
		$return = [];
		$c = $this->getDatabasePlatform()->getIdentifierQuoteCharacter();
		foreach($data as $key => $value) {
			if ($key[0] !== $c) {
				$return[$this->quoteIdentifier($key)] = $value;
			} else {
				$return[$key] = $value;
			}
		}
		return $return;
	}

/**
	 * {@inheritDoc}
	 */
	public function insert($tableName, array $data, array $types = []) {
		if ($tableName[0] !== $this->getDatabasePlatform()->getIdentifierQuoteCharacter()) {
			$tableName = $this->quoteIdentifier($tableName);
		}
		$data = $this->quoteKeys($data);
		return parent::insert($tableName, $data, $types);
	}

/**
	 * {@inheritDoc}
	 */
	public function update($tableName, array $data, array $identifier, array $types = []) {
		if ($tableName[0] !== $this->getDatabasePlatform()->getIdentifierQuoteCharacter()) {
			$tableName = $this->quoteIdentifier($tableName);
		}
		$data = $this->quoteKeys($data);
		$identifier = $this->quoteKeys($identifier);
		return parent::update($tableName, $data, $identifier, $types);
	}

/**
	 * {@inheritDoc}
	 */
	public function delete($tableExpression, array $identifier, array $types = []) {
		if ($tableExpression[0] !== $this->getDatabasePlatform()->getIdentifierQuoteCharacter()) {
			$tableExpression = $this->quoteIdentifier($tableExpression);
		}
		$identifier = $this->quoteKeys($identifier);
		return parent::delete($tableExpression, $identifier);
	}

/**
	 * Drop a table from the database if it exists
	 *
	 * @param string $table table name without the prefix
	 */
	public function dropTable($table) {
		$table = $this->tablePrefix . trim($table);
		$table = $this->quoteIdentifier($table);
		$schema = $this->getSchemaManager();
		if($schema->tablesExist([$table])) {
			$schema->dropTable($table);
		}
	}

/**
	 * Check if a table exists
	 *
	 * @param string $table table name without the prefix
	 * @return bool
	 */
	public function tableExists($table){
		$table = $this->tablePrefix . trim($table);
		$table = $this->quoteIdentifier($table);
		$schema = $this->getSchemaManager();
		return $schema->tablesExist([$table]);
	}
}