diff options
author | Joas Schilling <coding@schilljs.com> | 2020-12-11 13:14:38 +0300 |
---|---|---|
committer | Joas Schilling <coding@schilljs.com> | 2020-12-15 17:30:11 +0300 |
commit | 70679077ca966f48e5dd710b75613b090742e915 (patch) | |
tree | 0ecc7d7c2b77804dae8f0304af96b5b08de66737 /lib/Model | |
parent | f5f4a87471ce6640b9335f2f70febe0c3f5b2121 (diff) |
Do not select multiple "id" columns so oracle doesn't break with LIMIT
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib/Model')
-rw-r--r-- | lib/Model/SelectHelper.php | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/lib/Model/SelectHelper.php b/lib/Model/SelectHelper.php new file mode 100644 index 000000000..48973cacc --- /dev/null +++ b/lib/Model/SelectHelper.php @@ -0,0 +1,85 @@ +<?php + +declare(strict_types=1); +/** + * @copyright Copyright (c) 2020 Joas Schilling <coding@schilljs.com> + * + * @license GNU AGPL version 3 or any later version + * + * This program is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License as + * published by the Free Software Foundation, either version 3 of the + * License, or (at your option) any later version. + * + * 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 + * along with this program. If not, see <http://www.gnu.org/licenses/>. + * + */ + +namespace OCA\Talk\Model; + +use OCP\DB\QueryBuilder\IQueryBuilder; + +class SelectHelper { + public function selectRoomsTable(IQueryBuilder $query, string $alias = 'r'): void { + if ($alias !== '') { + $alias .= '.'; + } + + $query->addSelect($alias . 'type') + ->addSelect($alias . 'read_only') + ->addSelect($alias . 'lobby_state') + ->addSelect($alias . 'sip_enabled') + ->addSelect($alias . 'assigned_hpb') + ->addSelect($alias . 'token') + ->addSelect($alias . 'name') + ->addSelect($alias . 'description') + ->addSelect($alias . 'password') + ->addSelect($alias . 'active_guests') + ->addSelect($alias . 'active_since') + ->addSelect($alias . 'last_activity') + ->addSelect($alias . 'last_message') + ->addSelect($alias . 'lobby_timer') + ->addSelect($alias . 'object_type') + ->addSelect($alias . 'object_id') + ->addSelect($alias . 'listable') + ->selectAlias($alias . 'id', 'r_id'); + } + + public function selectAttendeesTable(IQueryBuilder $query, string $alias = 'a'): void { + if ($alias !== '') { + $alias .= '.'; + } + + $query->addSelect($alias . 'room_id') + ->addSelect($alias . 'actor_type') + ->addSelect($alias . 'actor_id') + ->addSelect($alias . 'display_name') + ->addSelect($alias . 'pin') + ->addSelect($alias . 'participant_type') + ->addSelect($alias . 'favorite') + ->addSelect($alias . 'notification_level') + ->addSelect($alias . 'last_joined_call') + ->addSelect($alias . 'last_read_message') + ->addSelect($alias . 'last_mention_message') + ->addSelect($alias . 'read_privacy') + ->selectAlias($alias . 'id', 'a_id'); + } + + public function selectSessionsTable(IQueryBuilder $query, string $alias = 's'): void { + if ($alias !== '') { + $alias .= '.'; + } + + $query->addSelect($alias . 'attendee_id') + ->addSelect($alias . 'session_id') + ->addSelect($alias . 'in_call') + ->addSelect($alias . 'last_ping') + ->selectAlias($alias . 'id', 's_id'); + } +} |