*/ class ClientMapper extends QBMapper { /** * @param IDBConnection $db */ public function __construct(IDBConnection $db) { parent::__construct($db, 'oauth2_clients'); } /** * @param string $clientIdentifier * @return Client * @throws ClientNotFoundException */ public function getByIdentifier(string $clientIdentifier): Client { $qb = $this->db->getQueryBuilder(); $qb ->select('*') ->from($this->tableName) ->where($qb->expr()->eq('client_identifier', $qb->createNamedParameter($clientIdentifier))); try { $client = $this->findEntity($qb); } catch (IMapperException $e) { throw new ClientNotFoundException('could not find client ' . $clientIdentifier, 0, $e); } return $client; } /** * @param int $id internal id of the client * @return Client * @throws ClientNotFoundException */ public function getByUid(int $id): Client { $qb = $this->db->getQueryBuilder(); $qb ->select('*') ->from($this->tableName) ->where($qb->expr()->eq('id', $qb->createNamedParameter($id, IQueryBuilder::PARAM_INT))); try { $client = $this->findEntity($qb); } catch (IMapperException $e) { throw new ClientNotFoundException('could not find client with id ' . $id, 0, $e); } return $client; } /** * @return Client[] */ public function getClients(): array { $qb = $this->db->getQueryBuilder(); $qb ->select('*') ->from($this->tableName); return $this->findEntities($qb); } }