diff options
Diffstat (limited to 'lib/Db/OptionMapper.php')
-rw-r--r-- | lib/Db/OptionMapper.php | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/lib/Db/OptionMapper.php b/lib/Db/OptionMapper.php index 07f024d9..3044c90c 100644 --- a/lib/Db/OptionMapper.php +++ b/lib/Db/OptionMapper.php @@ -76,6 +76,28 @@ class OptionMapper extends QBMapper { } /** + * @param int $pollId + * @throws \OCP\AppFramework\Db\DoesNotExistException if not found + * @return array + */ + + public function findByPollAndText($pollId, $pollOptionText) { + $qb = $this->db->getQueryBuilder(); + + $qb->select('*') + ->from($this->getTableName()) + ->where( + $qb->expr()->eq('poll_id', $qb->createNamedParameter($pollId, IQueryBuilder::PARAM_INT)) + ) + ->andWhere( + $qb->expr()->eq('poll_option_text', $qb->createNamedParameter($pollOptionText, IQueryBuilder::PARAM_STR)) + ) + ->orderBy('order', 'ASC'); + + return $this->findEntity($qb); + } + + /** * @param int $optionId */ public function remove($optionId) { |