From e404ce7096b9e4666f91cdca2e837d8ecd802357 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Julius=20H=C3=A4rtl?= <jus@bitgrid.net>
Date: Tue, 29 Jan 2019 12:23:14 +0100
Subject: Implement search and rename in backend
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Signed-off-by: Julius Härtl <jus@bitgrid.net>
---
 lib/private/Collaboration/Resources/Manager.php | 44 +++++++++++++++++++++++++
 lib/public/Collaboration/Resources/IManager.php |  8 +++++
 2 files changed, 52 insertions(+)

(limited to 'lib')

diff --git a/lib/private/Collaboration/Resources/Manager.php b/lib/private/Collaboration/Resources/Manager.php
index c11382c2f1d..9f083b3c676 100644
--- a/lib/private/Collaboration/Resources/Manager.php
+++ b/lib/private/Collaboration/Resources/Manager.php
@@ -67,6 +67,35 @@ class Manager implements IManager {
 		return new Collection($this, $this->connection, (int) $row['id'], (string) $row['name']);
 	}
 
+	/**
+	 * @param int $id
+	 * @return ICollection
+	 * @throws CollectionException when the collection could not be found
+	 * @since 15.0.0
+	 */
+	public function searchCollections(IUser $user, string $filter, int $limit = 50, int $start = 0): array {
+		$query = $this->connection->getQueryBuilder();
+		$query->select('*')
+			->from('collres_collections')
+			->where($query->expr()->iLike('name', $query->createNamedParameter($filter, IQueryBuilder::PARAM_STR)))
+			->setMaxResults($limit)
+			->setFirstResult($start);
+		$result = $query->execute();
+		$collections = [];
+		/** TODO: this is a huge performance bottleneck */
+		while ($row = $result->fetch()) {
+			$collection = new Collection($this, $this->connection, (int)$row['id'], (string)$row['name']);
+			if ($collection->canAccess($user)) {
+				$collections[] = $collection;
+			}
+		}
+		$result->closeCursor();
+
+		// TODO: call with increased first result if no matches found
+
+		return $collections;
+	}
+
 	/**
 	 * @param string $name
 	 * @return ICollection
@@ -199,4 +228,19 @@ class Manager implements IManager {
 
 		return '';
 	}
+
+	/**
+	 * @param string $name
+	 * @return ICollection
+	 * @since 15.0.0
+	 */
+	public function renameCollection(int $id, string $name): ICollection {
+		$query = $this->connection->getQueryBuilder();
+		$query->update('collres_collections')
+			->set('name', $query->createNamedParameter($name))
+			->where($query->expr()->eq('id', $query->createNamedParameter($id, IQueryBuilder::PARAM_INT)));
+		$query->execute();
+
+		return new Collection($this, $this->connection, $id, $name);
+	}
 }
diff --git a/lib/public/Collaboration/Resources/IManager.php b/lib/public/Collaboration/Resources/IManager.php
index eab101ff8e7..cac13812fee 100644
--- a/lib/public/Collaboration/Resources/IManager.php
+++ b/lib/public/Collaboration/Resources/IManager.php
@@ -42,6 +42,14 @@ interface IManager extends IProvider {
 	 */
 	public function newCollection(string $name): ICollection;
 
+
+	/**
+	 * @param string $name
+	 * @return ICollection
+	 * @since 15.0.0
+	 */
+	public function renameCollection(int $id, string $name): ICollection;
+
 	/**
 	 * @param string $type
 	 * @param string $id
-- 
cgit v1.2.3