1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- <?php
- declare(strict_types=1);
- namespace OCA\DAV\Db;
- use OCP\AppFramework\Db\DoesNotExistException;
- use OCP\AppFramework\Db\QBMapper;
- use OCP\IDBConnection;
- class DirectMapper extends QBMapper {
- public function __construct(IDBConnection $db) {
- parent::__construct($db, 'directlink', Direct::class);
- }
-
- public function getByToken(string $token): Direct {
- $qb = $this->db->getQueryBuilder();
- $qb->select('*')
- ->from($this->getTableName())
- ->where(
- $qb->expr()->eq('token', $qb->createNamedParameter($token))
- );
- return parent::findEntity($qb);
- }
- public function deleteExpired(int $expiration) {
- $qb = $this->db->getQueryBuilder();
- $qb->delete($this->getTableName())
- ->where(
- $qb->expr()->lt('expiration', $qb->createNamedParameter($expiration))
- );
- $qb->execute();
- }
- }
|