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 Joas Schilling <coding@schilljs.com>
 * @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 AdapterSqlite extends Adapter {

/**
	 * @param string $tableName
	 */
	public function lockTable($tableName) {
		$this->conn->executeUpdate('BEGIN EXCLUSIVE TRANSACTION');
	}

public function unlockTable() {
		$this->conn->executeUpdate('COMMIT TRANSACTION');
	}

public function fixupStatement($statement) {
		$statement = preg_replace('( I?LIKE \?)', '$0 ESCAPE \'\\\'', $statement);
		$statement = preg_replace('/`(\w+)` ILIKE \?/', 'LOWER($1) LIKE LOWER(?)', $statement);
		$statement = str_replace( '`', '"', $statement );
		$statement = str_ireplace( 'NOW()', 'datetime(\'now\')', $statement );
		$statement = str_ireplace('GREATEST(', 'MAX(', $statement);
		$statement = str_ireplace( 'UNIX_TIMESTAMP()', 'strftime(\'%s\',\'now\')', $statement );
		return $statement;
	}

/**
	 * Insert a row if the matching row does not exists.
	 *
	 * @param string $table The table name (will replace *PREFIX* with the actual prefix)
	 * @param array $input data that should be inserted into the table  (column name => value)
	 * @param array|null $compare List of values that should be checked for "if not exists"
	 *				If this is null or an empty array, all keys of $input will be compared
	 *				Please note: text fields (clob) must not be used in the compare array
	 * @return int number of inserted rows
	 * @throws \Doctrine\DBAL\DBALException
	 */
	public function insertIfNotExist($table, $input, array $compare = null) {
		if (empty($compare)) {
			$compare = array_keys($input);
		}
		$fieldList = '`' . implode('`,`', array_keys($input)) . '`';
		$query = "INSERT INTO `$table` ($fieldList) SELECT "
			. str_repeat('?,', count($input)-1).'? '
			. " WHERE NOT EXISTS (SELECT 1 FROM `$table` WHERE ";

$inserts = array_values($input);
		foreach($compare as $key) {
			$query .= '`' . $key . '`';
			if (is_null($input[$key])) {
				$query .= ' IS NULL AND ';
			} else {
				$inserts[] = $input[$key];
				$query .= ' = ? AND ';
			}
		}
		$query = substr($query, 0, strlen($query) - 5);
		$query .= ')';

return $this->conn->executeUpdate($query, $inserts);
	}
}