1 files changed, 18 insertions, 0 deletions

diff --git a/src/Wallabag/ApiBundle/Repository/AccessTokenRepository.php b/src/Wallabag/ApiBundle/Repository/AccessTokenRepository.php
new file mode 100644
index 00000000..2b8d24df
--- /dev/null
+++ b/src/Wallabag/ApiBundle/Repository/AccessTokenRepository.php
@@ -0,0 +1,18 @@
+<?php
+
+namespace Wallabag\ApiBundle\Repository;
+
+use Doctrine\ORM\EntityRepository;
+
+
+class AccessTokenRepository extends EntityRepository
+{
+    public function findAppsByUser($userId)
+    {
+        $qb = $this->createQueryBuilder('a')
+            ->innerJoin('a.client', 'c')
+            ->addSelect('c')
+            ->where('a.user =:userId')->setParameter('userId', $userId);
+        return $qb->getQuery()->getResult();
+    }
+}