*/ class OpenLocalEditorMapper extends QBMapper { public function __construct(IDBConnection $db) { parent::__construct($db, 'open_local_editor', OpenLocalEditor::class); } /** * @throws DoesNotExistException * @throws MultipleObjectsReturnedException * @throws Exception */ public function verifyToken(string $userId, string $pathHash, string $token): OpenLocalEditor { $qb = $this->db->getQueryBuilder(); $qb->select('*') ->from($this->getTableName()) ->where($qb->expr()->eq('user_id', $qb->createNamedParameter($userId))) ->andWhere($qb->expr()->eq('path_hash', $qb->createNamedParameter($pathHash))) ->andWhere($qb->expr()->eq('token', $qb->createNamedParameter($token))); return $this->findEntity($qb); } public function deleteExpiredTokens(int $time): void { $qb = $this->db->getQueryBuilder(); $qb->delete($this->getTableName()) ->where($qb->expr()->lt('expiration_time', $qb->createNamedParameter($time))); $qb->executeStatement(); } }