]> Raphaël G. Git Repositories - airbundle/commitdiff
Add created field to findAllIndexed results
authorRaphaël Gertz <git@rapsys.eu>
Tue, 9 Apr 2024 04:11:36 +0000 (06:11 +0200)
committerRaphaël Gertz <git@rapsys.eu>
Tue, 9 Apr 2024 04:11:36 +0000 (06:11 +0200)
Repository/GoogleTokenRepository.php

index 7c96e7284af8454da8455a7e7d3d5284925248d4..29b96d28ca8381647f7b16ad04a8f70513f1054e 100644 (file)
@@ -34,6 +34,7 @@ SELECT
        b.uid,
        b.access,
        b.refresh,
        b.uid,
        b.access,
        b.refresh,
+       b.created,
        b.expired,
        b.cids,
        b.cmails,
        b.expired,
        b.cids,
        b.cmails,
@@ -48,6 +49,7 @@ FROM (
                a.uid,
                a.access,
                a.refresh,
                a.uid,
                a.access,
                a.refresh,
+               a.created,
                a.expired,
                a.cids,
                a.cmails,
                a.expired,
                a.cids,
                a.cmails,
@@ -61,6 +63,7 @@ FROM (
                        t.user_id AS uid,
                        t.access,
                        t.refresh,
                        t.user_id AS uid,
                        t.access,
                        t.refresh,
+                       t.created,
                        t.expired,
                        GROUP_CONCAT(c.id ORDER BY c.id SEPARATOR "\\n") AS cids,
                        GROUP_CONCAT(c.mail ORDER BY c.id SEPARATOR "\\n") AS cmails,
                        t.expired,
                        GROUP_CONCAT(c.id ORDER BY c.id SEPARATOR "\\n") AS cids,
                        GROUP_CONCAT(c.mail ORDER BY c.id SEPARATOR "\\n") AS cmails,
@@ -92,6 +95,7 @@ SQL;
                        ->addScalarResult('uid', 'uid', 'integer')
                        ->addScalarResult('access', 'access', 'string')
                        ->addScalarResult('refresh', 'refresh', 'string')
                        ->addScalarResult('uid', 'uid', 'integer')
                        ->addScalarResult('access', 'access', 'string')
                        ->addScalarResult('refresh', 'refresh', 'string')
+                       ->addScalarResult('created', 'created', 'datetime')
                        ->addScalarResult('expired', 'expired', 'datetime')
                        ->addScalarResult('cids', 'cids', 'string')
                        ->addScalarResult('cmails', 'cmails', 'string')
                        ->addScalarResult('expired', 'expired', 'datetime')
                        ->addScalarResult('cids', 'cids', 'string')
                        ->addScalarResult('cmails', 'cmails', 'string')
@@ -130,6 +134,7 @@ SQL;
                                'uid' => $token['uid'],
                                'access' => $token['access'],
                                'refresh' => $token['refresh'],
                                'uid' => $token['uid'],
                                'access' => $token['access'],
                                'refresh' => $token['refresh'],
+                               'created' => $token['created'],
                                'expired' => $token['expired'],
                                'calendars' => [],
                                'dances' => [],
                                'expired' => $token['expired'],
                                'calendars' => [],
                                'dances' => [],