Make sqlite LIKE case sensitive on default

1 files changed, 42 insertions, 0 deletions

diff --git a/lib/private/db/sqlitesessioninit.php b/lib/private/db/sqlitesessioninit.php
new file mode 100644
index 00000000000..7e1166be95b
--- /dev/null
+++ b/lib/private/db/sqlitesessioninit.php
@@ -0,0 +1,42 @@
+<?php
+/**
+ * Copyright (c) 2014 Robin Appelman <icewind@owncloud.com>
+ * This file is licensed under the Affero General Public License version 3 or
+ * later.
+ * See the COPYING-README file.
+ */
+
+namespace OC\DB;
+
+use Doctrine\DBAL\Event\ConnectionEventArgs;
+use Doctrine\DBAL\Events;
+use Doctrine\Common\EventSubscriber;
+
+class SQLiteSessionInit implements EventSubscriber {
+	/**
+	 * @var bool
+	 */
+	private $caseSensitiveLike;
+
+	/**
+	 * Configure case sensitive like for each connection
+	 *
+	 * @param bool $caseSensitiveLike
+	 */
+	public function __construct($caseSensitiveLike = true) {
+		$this->caseSensitiveLike = $caseSensitiveLike;
+	}
+
+	/**
+	 * @param ConnectionEventArgs $args
+	 * @return void
+	 */
+	public function postConnect(ConnectionEventArgs $args) {
+		$sensitive = ($this->caseSensitiveLike) ? 'true' : 'false';
+		$args->getConnection()->executeUpdate('PRAGMA case_sensitive_like = ' . $sensitive);
+	}
+
+	public function getSubscribedEvents() {
+		return array(Events::postConnect);
+	}
+}