diff options
author | Julius Härtl <jus@bitgrid.net> | 2022-08-15 19:43:43 +0300 |
---|---|---|
committer | Julius Härtl <jus@bitgrid.net> | 2022-08-15 19:43:43 +0300 |
commit | ba47efcec3fcc3c99bc4d430b49f74605fec2a78 (patch) | |
tree | 817184d76c83189be67316e3b5f22d8ddf97100d /lib | |
parent | d20e01586ad5a189e5081d4c5ba5bf2e16dcc3e6 (diff) |
Avoid duplicate queries that were caused by running execute and the mapper find method
Signed-off-by: Julius Härtl <jus@bitgrid.net>
Diffstat (limited to 'lib')
-rw-r--r-- | lib/Db/SessionMapper.php | 9 | ||||
-rw-r--r-- | lib/Db/StepMapper.php | 3 |
2 files changed, 4 insertions, 8 deletions
diff --git a/lib/Db/SessionMapper.php b/lib/Db/SessionMapper.php index c5ad44391..1f7c896eb 100644 --- a/lib/Db/SessionMapper.php +++ b/lib/Db/SessionMapper.php @@ -64,8 +64,7 @@ class SessionMapper extends QBMapper { $qb = $this->db->getQueryBuilder(); $qb->select('id', 'color', 'document_id', 'last_contact', 'user_id', 'guest_name') ->from($this->getTableName()) - ->where($qb->expr()->eq('document_id', $qb->createNamedParameter($documentId))) - ->execute(); + ->where($qb->expr()->eq('document_id', $qb->createNamedParameter($documentId))); return $this->findEntities($qb); } @@ -75,8 +74,7 @@ class SessionMapper extends QBMapper { $qb->select('id', 'color', 'document_id', 'last_contact', 'user_id', 'guest_name') ->from($this->getTableName()) ->where($qb->expr()->eq('document_id', $qb->createNamedParameter($documentId))) - ->andWhere($qb->expr()->gt('last_contact', $qb->createNamedParameter(time() - SessionService::SESSION_VALID_TIME))) - ->execute(); + ->andWhere($qb->expr()->gt('last_contact', $qb->createNamedParameter(time() - SessionService::SESSION_VALID_TIME))); return $this->findEntities($qb); } @@ -85,8 +83,7 @@ class SessionMapper extends QBMapper { $qb = $this->db->getQueryBuilder(); $qb->select('id', 'color', 'document_id', 'last_contact', 'user_id', 'guest_name') ->from($this->getTableName()) - ->where($qb->expr()->lt('last_contact', $qb->createNamedParameter(time() - SessionService::SESSION_VALID_TIME))) - ->execute(); + ->where($qb->expr()->lt('last_contact', $qb->createNamedParameter(time() - SessionService::SESSION_VALID_TIME))); return $this->findEntities($qb); } diff --git a/lib/Db/StepMapper.php b/lib/Db/StepMapper.php index a977c1629..472f28183 100644 --- a/lib/Db/StepMapper.php +++ b/lib/Db/StepMapper.php @@ -46,8 +46,7 @@ class StepMapper extends QBMapper { $qb ->setMaxResults(100) ->orderBy('version') - ->orderBy('id') - ->execute(); + ->orderBy('id'); return $this->findEntities($qb); } |