diff options
Diffstat (limited to 'lib/Db')
| -rw-r--r-- | lib/Db/Watch.php | 63 | ||||
| -rw-r--r-- | lib/Db/WatchMapper.php | 75 |
2 files changed, 138 insertions, 0 deletions
diff --git a/lib/Db/Watch.php b/lib/Db/Watch.php new file mode 100644 index 00000000..ea6a518c --- /dev/null +++ b/lib/Db/Watch.php @@ -0,0 +1,63 @@ +<?php +/** + * @copyright Copyright (c) 2017 Vinzenz Rosenkranz <vinzenz.rosenkranz@gmail.com> + * + * @author René Gieling <githung@dartcafe.de> + * + * @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\Polls\Db; + +use JsonSerializable; + +use OCP\AppFramework\Db\Entity; + +/** + * @method int getId() + * @method void setId(integer $value) + * @method int getPollId() + * @method void setPollId(integer $value) + * @method string getTable() + * @method void setTable(string $value) + * @method string getUpdated() + * @method void setUpdated(string $value) + */ +class Watch extends Entity implements JsonSerializable { + public const OBJECT_POLLS = "polls"; + public const OBJECT_VOTES = "votes"; + public const OBJECT_OPTIONS = "options"; + public const OBJECT_COMMENTS = "comments"; + + /** @var int $pollId */ + protected $pollId; + + /** @var string $tableId */ + protected $table; + + /** @var string $updated */ + protected $updated; + + public function jsonSerialize() { + return [ + 'id' => intval($this->id), + 'pollId' => intval($this->pollId), + 'table' => $this->table, + 'updated' => $this->updated, + ]; + } +} diff --git a/lib/Db/WatchMapper.php b/lib/Db/WatchMapper.php new file mode 100644 index 00000000..38bf18b9 --- /dev/null +++ b/lib/Db/WatchMapper.php @@ -0,0 +1,75 @@ +<?php +/** + * @copyright Copyright (c) 2017 Vinzenz Rosenkranz <vinzenz.rosenkranz@gmail.com> + * + * @author Vinzenz Rosenkranz <vinzenz.rosenkranz@gmail.com> + * @author René Gieling <github@dartcafe.de> + * + * @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\Polls\Db; + +use OCP\IDBConnection; +use OCP\AppFramework\Db\QBMapper; + +/** + * @template-extends QBMapper<Watch> + */ +class WatchMapper extends QBMapper { + public function __construct(IDBConnection $db) { + parent::__construct($db, 'polls_watch', '\OCA\Polls\Db\Watch'); + } + + /** + * @throws \OCP\AppFramework\Db\DoesNotExistException if not found + * @return Watch[] + */ + public function findUpdatesForPollId(int $pollId, int $offset): array { + $qb = $this->db->getQueryBuilder(); + + $qb->select('*') + ->from($this->getTableName()) + ->where( + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId)) + ) + ->andWhere( + $qb->expr()->gt('updated', $qb->createNamedParameter($offset)) + ); + + return $this->findEntities($qb); + } + + /** + * @throws \OCP\AppFramework\Db\DoesNotExistException if not found + * @return Watch + */ + public function findForPollIdAndTable(int $pollId, string $table): Watch { + $qb = $this->db->getQueryBuilder(); + + $qb->select('*') + ->from($this->getTableName()) + ->where( + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId)) + ) + ->andWhere( + $qb->expr()->eq('table', $qb->createNamedParameter($table)) + ); + + return $this->findEntity($qb); + } +} |