From 579c6b1e5ac629760f049da3e555dad3173523ed Mon Sep 17 00:00:00 2001 From: Carl Schwan Date: Tue, 5 Apr 2022 16:50:49 +0200 Subject: Use querybuilder for share external mountpoint Signed-off-by: Carl Schwan --- apps/files_sharing/lib/External/MountProvider.php | 16 +++++++++------- 1 file changed, 9 insertions(+), 7 deletions(-) (limited to 'apps/files_sharing/lib') diff --git a/apps/files_sharing/lib/External/MountProvider.php b/apps/files_sharing/lib/External/MountProvider.php index 36015162530..5b315e81f69 100644 --- a/apps/files_sharing/lib/External/MountProvider.php +++ b/apps/files_sharing/lib/External/MountProvider.php @@ -28,6 +28,7 @@ use OCP\Federation\ICloudIdManager; use OCP\Files\Config\IMountProvider; use OCP\Files\Storage\IStorageFactory; use OCP\IDBConnection; +use OCP\DB\QueryBuilder\IQueryBuilder; use OCP\IUser; class MountProvider implements IMountProvider { @@ -72,18 +73,19 @@ class MountProvider implements IMountProvider { } public function getMountsForUser(IUser $user, IStorageFactory $loader) { - $query = $this->connection->prepare(' - SELECT `remote`, `share_token`, `password`, `mountpoint`, `owner` - FROM `*PREFIX*share_external` - WHERE `user` = ? AND `accepted` = ? - '); - $query->execute([$user->getUID(), 1]); + $qb = $this->connection->getQueryBuilder(); + $qb->select('remote', 'share_token', 'password', 'mountpoint', 'owner') + ->from('share_external') + ->where($qb->expr()->eq('user', $qb->createNamedParameter($user->getUID()))) + ->andWhere($qb->expr()->eq('accepted', $qb->createNamedParameter(1, IQueryBuilder::PARAM_INT))); + $result = $qb->executeQuery(); $mounts = []; - while ($row = $query->fetch()) { + while ($row = $result->fetch()) { $row['manager'] = $this; $row['token'] = $row['share_token']; $mounts[] = $this->getMount($user, $row, $loader); } + $result->closeCursor(); return $mounts; } } -- cgit v1.2.3