owncloud/core

<?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]);
    }
}