View GitHub Repository admin

Schedule Inspection
Subscribe
Passed
Push — master ( 80fed1...32ef61 )
by Peter
09:46
created
Status
Category
Toggle Patches
tests/Databases/Queries/UserAuthLoaderTest.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -25,7 +25,7 @@  discard block
 
 block discarded – undo
25 25 
         $username            = 'foo';
26 26 
         $userGroupIdentifier = 'bar';
27 27
28 
-        $sql0          = 'SELECT u.username AS v0, ug.identifier AS v1 FROM users AS u INNER JOIN users_user_groups AS uug ON uug.user_id = u.id AND uug.deleted_at IS NULL INNER JOIN user_groups AS ug ON uug.user_group_id = ug.id AND ug.deleted_at IS NULL WHERE (u.deleted_at IS NULL)'; // phpcs:ignore
28 
+        $sql0 = 'SELECT u.username AS v0, ug.identifier AS v1 FROM users AS u INNER JOIN users_user_groups AS uug ON uug.user_id = u.id AND uug.deleted_at IS NULL INNER JOIN user_groups AS ug ON uug.user_group_id = ug.id AND ug.deleted_at IS NULL WHERE (u.deleted_at IS NULL)'; // phpcs:ignore
29 29 
         $valuesToBind = [];
30 30 
         $returnValues = [
31 31 
             [
 
@@ -33,7 +33,7 @@  discard block
 
 block discarded – undo
33 33 
                 'v1' => $userGroupIdentifier,
34 34 
             ],
35 35 
         ];
36 
-        $statement0    = MockStatementFactory::createReadStatement($this, $valuesToBind, $returnValues);
36 
+        $statement0 = MockStatementFactory::createReadStatement($this, $valuesToBind, $returnValues);
37 37
38 38 
         $this->readConnectionMock
39 39 
             ->expects($this->exactly(1))
Please login to merge, or discard this patch.
tests/Databases/Queries/BlockCacheTest.php 1 patch
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch 
@@ -25,15 +25,15 @@  discard block
 
 block discarded – undo
25 25 
         $identifiers = ['foo', 'bar'];
26 26 
         $cacheTime   = 'baz';
27 27
28 
-        $sql0          = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
28 
+        $sql0 = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
29 29 
         $valuesToBind = [
30 30 
             [$identifiers[0], \PDO::PARAM_STR],
31 31 
             [$identifiers[1], \PDO::PARAM_STR],
32 32 
             [$cacheTime, \PDO::PARAM_STR],
33 33 
             [$cacheTime, \PDO::PARAM_STR],
34 34 
         ];
35 
-        $returnValue  = '0';
36 
-        $statement0    = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
35 
+        $returnValue = '0';
36 
+        $statement0 = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
37 37
38 38 
         $this->readConnectionMock
39 39 
             ->expects($this->once())
 
@@ -51,15 +51,15 @@  discard block
 
 block discarded – undo
51 51 
         $identifiers = ['foo', 'bar'];
52 52 
         $cacheTime   = 'baz';
53 53
54 
-        $sql0          = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
54 
+        $sql0 = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
55 55 
         $valuesToBind = [
56 56 
             [$identifiers[0], \PDO::PARAM_STR],
57 57 
             [$identifiers[1], \PDO::PARAM_STR],
58 58 
             [$cacheTime, \PDO::PARAM_STR],
59 59 
             [$cacheTime, \PDO::PARAM_STR],
60 60 
         ];
61 
-        $returnValue  = '2';
62 
-        $statement0    = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
61 
+        $returnValue = '2';
62 
+        $statement0 = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
63 63
64 64 
         $this->readConnectionMock
65 65 
             ->expects($this->once())
 
@@ -81,14 +81,14 @@  discard block
 
 block discarded – undo
81 81 
         $this->expectException(Database::class);
82 82 
         $this->expectExceptionCode($errorInfo[1]);
83 83
84 
-        $sql0          = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
84 
+        $sql0 = 'SELECT COUNT(*) AS count FROM blocks LEFT JOIN block_layouts AS layouts ON layouts.id = blocks.layout_id WHERE (blocks.deleted_at IS NULL) AND (blocks.identifier IN (?,?)) AND (blocks.updated_at > ? OR layouts.updated_at > ?)'; // phpcs:ignore
85 85 
         $valuesToBind = [
86 86 
             [$identifiers[0], \PDO::PARAM_STR],
87 87 
             [$identifiers[1], \PDO::PARAM_STR],
88 88 
             [$cacheTime, \PDO::PARAM_STR],
89 89 
             [$cacheTime, \PDO::PARAM_STR],
90 90 
         ];
91 
-        $statement0    = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
91 
+        $statement0 = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
92 92
93 93 
         $this->readConnectionMock
94 94 
             ->expects($this->once())
Please login to merge, or discard this patch.
tests/Databases/Queries/LoginThrottleTest.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch 
@@ -26,13 +26,13 @@  discard block
 
 block discarded – undo
26 26 
         $username        = 'bar';
27 27 
         $maxFailureCount = 11;
28 28
29 
-        $sql0          = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
29 
+        $sql0 = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
30 30 
         $valuesToBind = [
31 31 
             [$ipHash, \PDO::PARAM_STR],
32 32 
             [$username, \PDO::PARAM_STR],
33 33 
         ];
34 
-        $returnValue  = 2;
35 
-        $statement0    = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
34 
+        $returnValue = 2;
35 
+        $statement0 = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
36 36
37 37 
         $this->readConnectionMock
38 38 
             ->expects($this->once())
 
@@ -51,13 +51,13 @@  discard block
 
 block discarded – undo
51 51 
         $username        = 'bar';
52 52 
         $maxFailureCount = 11;
53 53
54 
-        $sql0          = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
54 
+        $sql0 = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
55 55 
         $valuesToBind = [
56 56 
             [$ipHash, \PDO::PARAM_STR],
57 57 
             [$username, \PDO::PARAM_STR],
58 58 
         ];
59 
-        $returnValue  = 14;
60 
-        $statement0    = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
59 
+        $returnValue = 14;
60 
+        $statement0 = MockStatementFactory::createReadColumnStatement($this, $valuesToBind, $returnValue);
61 61
62 62 
         $this->readConnectionMock
63 63 
             ->expects($this->exactly(1))
 
@@ -81,12 +81,12 @@  discard block
 
 block discarded – undo
81 81 
         $username        = 'bar';
82 82 
         $maxFailureCount = 11;
83 83
84 
-        $sql0          = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
84 
+        $sql0 = 'SELECT COUNT(*) AS count FROM login_attempts AS la WHERE (la.ip_hash = ? OR la.username = ?) AND (la.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
85 85 
         $valuesToBind = [
86 86 
             [$ipHash, \PDO::PARAM_STR],
87 87 
             [$username, \PDO::PARAM_STR],
88 88 
         ];
89 
-        $statement0    = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
89 
+        $statement0 = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
90 90
91 91 
         $this->readConnectionMock
92 92 
             ->expects($this->exactly(1))
 
@@ -102,12 +102,12 @@  discard block
 
 block discarded – undo
102 102 
         $ipHash   = 'foo';
103 103 
         $username = 'bar';
104 104
105 
-        $sql0          = 'DELETE FROM login_attempts WHERE (login_attempts.ip_hash = ?) AND (login_attempts.username = ?) AND (login_attempts.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
105 
+        $sql0 = 'DELETE FROM login_attempts WHERE (login_attempts.ip_hash = ?) AND (login_attempts.username = ?) AND (login_attempts.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
106 106 
         $valuesToBind = [
107 107 
             [$ipHash, \PDO::PARAM_STR],
108 108 
             [$username, \PDO::PARAM_STR],
109 109 
         ];
110 
-        $statement0    = MockStatementFactory::createWriteStatement($this, $valuesToBind);
110 
+        $statement0 = MockStatementFactory::createWriteStatement($this, $valuesToBind);
111 111
112 112 
         $this->writeConnectionMock
113 113 
             ->expects($this->exactly(1))
 
@@ -128,12 +128,12 @@  discard block
 
 block discarded – undo
128 128 
         $ipHash   = 'foo';
129 129 
         $username = 'bar';
130 130
131 
-        $sql0          = 'DELETE FROM login_attempts WHERE (login_attempts.ip_hash = ?) AND (login_attempts.username = ?) AND (login_attempts.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
131 
+        $sql0 = 'DELETE FROM login_attempts WHERE (login_attempts.ip_hash = ?) AND (login_attempts.username = ?) AND (login_attempts.created_at > NOW() - INTERVAL 1 HOUR)'; // phpcs:ignore
132 132 
         $valuesToBind = [
133 133 
             [$ipHash, \PDO::PARAM_STR],
134 134 
             [$username, \PDO::PARAM_STR],
135 135 
         ];
136 
-        $statement0    = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
136 
+        $statement0 = MockStatementFactory::createErrorStatement($this, $valuesToBind, $errorInfo);
137 137
138 138 
         $this->writeConnectionMock
139 139 
             ->expects($this->exactly(1))
Please login to merge, or discard this patch.
tests/Databases/Queries/AdminResourceAuthLoaderTest.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch 
@@ -33,7 +33,7 @@
 
 block discarded – undo
33 33 
                 'v1' => $adminResourceIdentifier,
34 34 
             ],
35 35 
         ];
36 
-        $statement0   = MockStatementFactory::createReadStatement($this, $valuesToBind, $returnValues);
36 
+        $statement0 = MockStatementFactory::createReadStatement($this, $valuesToBind, $returnValues);
37 37
38 38 
         $this->readConnectionMock
39 39 
             ->expects($this->once())
Please login to merge, or discard this patch.
tests/Orm/DataMappers/UserSqlDataMapperTest.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch 
@@ -36,8 +36,8 @@  discard block
 
 block discarded – undo
36 36 
         $canLogin          = true;
37 37 
         $isGravatarAllowed = true;
38 38
39 
-        $sql0       = 'INSERT INTO users (id, username, email, password, user_language_id, can_login, is_gravatar_allowed) VALUES (?, ?, ?, ?, ?, ?, ?)'; // phpcs:ignore
40 
-        $values    = [
39 
+        $sql0 = 'INSERT INTO users (id, username, email, password, user_language_id, can_login, is_gravatar_allowed) VALUES (?, ?, ?, ?, ?, ?, ?)'; // phpcs:ignore
40 
+        $values = [
41 41 
             [$nextId, \PDO::PARAM_STR],
42 42 
             [$username, \PDO::PARAM_STR],
43 43 
             [$email, \PDO::PARAM_STR],
 
@@ -169,7 +169,7 @@  discard block
 
 block discarded – undo
169 169 
         $canLogin          = true;
170 170 
         $isGravatarAllowed = true;
171 171
172 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id'; // phpcs:ignore
172 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id'; // phpcs:ignore
173 173 
         $values       = [];
174 174 
         $expectedData = [
175 175 
             [
 
@@ -209,7 +209,7 @@  discard block
 
 block discarded – undo
209 209 
         $userGroupIdentifiers = 'ug-1,ug-2';
210 210 
         $userGroupNames       = 'UG #1,UG #2';
211 211
212 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id'; // phpcs:ignore
212 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id'; // phpcs:ignore
213 213 
         $values       = [];
214 214 
         $expectedData = [
215 215 
             [
 
@@ -249,7 +249,7 @@  discard block
 
 block discarded – undo
249 249 
         $canLogin          = true;
250 250 
         $isGravatarAllowed = true;
251 251
252 
-        $sql0          = 'SELECT SQL_CALC_FOUND_ROWS users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id ORDER BY username ASC LIMIT 10 OFFSET 0'; // phpcs:ignore
252 
+        $sql0 = 'SELECT SQL_CALC_FOUND_ROWS users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) GROUP BY users.id ORDER BY username ASC LIMIT 10 OFFSET 0'; // phpcs:ignore
253 253 
         $values       = [];
254 254 
         $expectedData = [
255 255 
             [
 
@@ -289,7 +289,7 @@  discard block
 
 block discarded – undo
289 289 
         $orders     = ['ac.description ASC'];
290 290 
         $conditions = ['ac.description LIKE \'abc%\'', 'abc.description LIKE \'%bca\''];
291 291
292 
-        $sql0          = 'SELECT SQL_CALC_FOUND_ROWS users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (ac.description LIKE \'abc%\') AND (abc.description LIKE \'%bca\') GROUP BY users.id ORDER BY ac.description ASC LIMIT 10 OFFSET 0'; // phpcs:ignore
292 
+        $sql0 = 'SELECT SQL_CALC_FOUND_ROWS users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (ac.description LIKE \'abc%\') AND (abc.description LIKE \'%bca\') GROUP BY users.id ORDER BY ac.description ASC LIMIT 10 OFFSET 0'; // phpcs:ignore
293 293 
         $values       = [];
294 294 
         $expectedData = [
295 295 
             [
 
@@ -326,7 +326,7 @@  discard block
 
 block discarded – undo
326 326 
         $canLogin          = true;
327 327 
         $isGravatarAllowed = true;
328 328
329 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (users.id = :user_id) GROUP BY users.id'; // phpcs:ignore
329 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (users.id = :user_id) GROUP BY users.id'; // phpcs:ignore
330 330 
         $values       = ['user_id' => [$id, \PDO::PARAM_STR]];
331 331 
         $expectedData = [
332 332 
             [
 
@@ -363,7 +363,7 @@  discard block
 
 block discarded – undo
363 363 
         $canLogin          = true;
364 364 
         $isGravatarAllowed = true;
365 365
366 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (`username` = :username) GROUP BY users.id'; // phpcs:ignore
366 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (`username` = :username) GROUP BY users.id'; // phpcs:ignore
367 367 
         $values       = ['username' => [$username, \PDO::PARAM_STR]];
368 368 
         $expectedData = [
369 369 
             [
 
@@ -400,7 +400,7 @@  discard block
 
 block discarded – undo
400 400 
         $canLogin          = true;
401 401 
         $isGravatarAllowed = true;
402 402
403 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (email = :email) GROUP BY users.id'; // phpcs:ignore
403 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (email = :email) GROUP BY users.id'; // phpcs:ignore
404 404 
         $values       = ['email' => [$email, \PDO::PARAM_STR]];
405 405 
         $expectedData = [
406 406 
             [
 
@@ -437,7 +437,7 @@  discard block
 
 block discarded – undo
437 437 
         $canLogin          = true;
438 438 
         $isGravatarAllowed = true;
439 439
440 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND ((username = :identifier OR email = :identifier)) GROUP BY users.id'; // phpcs:ignore
440 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND ((username = :identifier OR email = :identifier)) GROUP BY users.id'; // phpcs:ignore
441 441 
         $values       = ['identifier' => [$username, \PDO::PARAM_STR]];
442 442 
         $expectedData = [
443 443 
             [
 
@@ -474,7 +474,7 @@  discard block
 
 block discarded – undo
474 474 
         $canLogin          = true;
475 475 
         $isGravatarAllowed = true;
476 476
477 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND ((username = :identifier OR email = :identifier)) GROUP BY users.id'; // phpcs:ignore
477 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND ((username = :identifier OR email = :identifier)) GROUP BY users.id'; // phpcs:ignore
478 478 
         $values       = ['identifier' => [$email, \PDO::PARAM_STR]];
479 479 
         $expectedData = [
480 480 
             [
 
@@ -512,7 +512,7 @@  discard block
 
 block discarded – undo
512 512 
         $isGravatarAllowed = true;
513 513 
         $clientId          = '063b730f-3458-49dc-b60e-8171cefacabf';
514 514
515 
-        $sql0          = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL INNER JOIN api_clients AS ac ON ac.user_id = users.id AND ac.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (ac.id = :client_id) GROUP BY users.id'; // phpcs:ignore
515 
+        $sql0 = 'SELECT users.id, users.username, users.email, users.password, users.user_language_id, ul.identifier AS user_language_identifier, users.can_login, users.is_gravatar_allowed, GROUP_CONCAT(ug.id) AS user_group_ids, GROUP_CONCAT(ug.identifier) AS user_group_identifiers, GROUP_CONCAT(ug.name) AS user_group_names FROM users INNER JOIN user_languages AS ul ON ul.id = users.user_language_id AND ul.deleted_at IS NULL INNER JOIN api_clients AS ac ON ac.user_id = users.id AND ac.deleted_at IS NULL LEFT JOIN users_user_groups AS uug ON uug.user_id = users.id AND uug.deleted_at IS NULL LEFT JOIN user_groups AS ug ON ug.id = uug.user_group_id AND ug.deleted_at IS NULL WHERE (users.deleted_at IS NULL) AND (ac.id = :client_id) GROUP BY users.id'; // phpcs:ignore
516 516 
         $values       = ['client_id' => [$clientId, \PDO::PARAM_STR]];
517 517 
         $expectedData = [
518 518 
             [
Please login to merge, or discard this patch.
tests/Orm/DataMappers/LoginAttemptSqlDataMapperTest.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -119,7 +119,7 @@  discard block
 
 block discarded – undo
119 119 
             ['id' => $id0, 'ip_hash' => $ipHash0, 'username' => $username0, 'ip_address' => null],
120 120 
             ['id' => $id1, 'ip_hash' => $ipHash1, 'username' => $username1, 'ip_address' => $ipAddress1],
121 121 
         ];
122 
-        $statement0   = MockStatementFactory::createReadStatement($this, $values, $expectedData);
122 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
123 123
124 124 
         $this->readConnectionMock
125 125 
             ->expects($this->once(0))
 
@@ -138,12 +138,12 @@  discard block
 
 block discarded – undo
138 138 
         $ipHash   = 'foo';
139 139 
         $username = 'Foo';
140 140
141 
-        $sql0          = 'SELECT login_attempts.id, login_attempts.ip_hash, login_attempts.username, login_attempts.ip_address FROM login_attempts WHERE (login_attempts.id = :login_attempt_id)'; // phpcs:ignore
141 
+        $sql0 = 'SELECT login_attempts.id, login_attempts.ip_hash, login_attempts.username, login_attempts.ip_address FROM login_attempts WHERE (login_attempts.id = :login_attempt_id)'; // phpcs:ignore
142 142 
         $values       = ['login_attempt_id' => [$id, \PDO::PARAM_STR]];
143 143 
         $expectedData = [
144 144 
             ['id' => $id, 'ip_hash' => $ipHash, 'username' => $username, 'ip_address' => null],
145 145 
         ];
146 
-        $statement0    = MockStatementFactory::createReadStatement($this, $values, $expectedData);
146 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
147 147
148 148 
         $this->readConnectionMock
149 149 
             ->expects($this->once())
Please login to merge, or discard this patch.
tests/Orm/DataMappers/UserLanguageSqlDataMapperTest.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -82,7 +82,7 @@  discard block
 
 block discarded – undo
82 82 
             ['id' => $id0, 'identifier' => $identifier0, 'name' => $name0],
83 83 
             ['id' => $id1, 'identifier' => $identifier1, 'name' => $name1],
84 84 
         ];
85 
-        $statement0   = MockStatementFactory::createReadStatement($this, $values, $expectedData);
85 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
86 86
87 87 
         $this->readConnectionMock
88 88 
             ->expects($this->once())
 
@@ -113,7 +113,7 @@  discard block
 
 block discarded – undo
113 113 
             ['id' => $id0, 'identifier' => $identifier0, 'name' => $name0],
114 114 
             ['id' => $id1, 'identifier' => $identifier1, 'name' => $name1],
115 115 
         ];
116 
-        $statement0   = MockStatementFactory::createReadStatement($this, $values, $expectedData);
116 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
117 117
118 118 
         $this->readConnectionMock
119 119 
             ->expects($this->once())
Please login to merge, or discard this patch.
tests/Orm/DataMappers/TokenSqlDataMapperTest.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -88,7 +88,7 @@  discard block
 
 block discarded – undo
88 88 
         $expiresAt   = new \DateTimeImmutable();
89 89
90 90 
         $sql0       = 'UPDATE tokens AS tokens SET deleted_at = NOW() WHERE (id = ?)'; // phpcs:ignore
91 
-        $values    = [[$id, \PDO::PARAM_STR]];
91 
+        $values = [[$id, \PDO::PARAM_STR]];
92 92 
         $statement0 = MockStatementFactory::createWriteStatement($this, $values);
93 93
94 94 
         $this->writeConnectionMock
 
@@ -120,7 +120,7 @@  discard block
 
 block discarded – undo
120 120 
             ['id' => $id0, 'api_client_id' => $apiClientId0, 'expires_at' => $expiresAt0, 'revoked_at' => $revokedAt0],
121 121 
             ['id' => $id1, 'api_client_id' => $apiClientId1, 'expires_at' => $expiresAt1, 'revoked_at' => $revokedAt1],
122 122 
         ];
123 
-        $statement0   = MockStatementFactory::createReadStatement($this, $values, $expectedData);
123 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
124 124
125 125 
         $this->readConnectionMock
126 126 
             ->expects($this->once())
 
@@ -179,7 +179,7 @@  discard block
 
 block discarded – undo
179 179 
                 'revoked_at'    => $revokedAt,
180 180 
             ],
181 181 
         ];
182 
-        $statement0   = MockStatementFactory::createReadStatement($this, $values, $expectedData);
182 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
183 183
184 184 
         $this->readConnectionMock
185 185 
             ->expects($this->once())
Please login to merge, or discard this patch.
tests/Orm/DataMappers/UserGroupSqlDataMapperTest.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -32,7 +32,7 @@  discard block
 
 block discarded – undo
32 32 
         $name       = 'bar';
33 33
34 34 
         $sql0       = 'INSERT INTO user_groups (id, identifier, name) VALUES (?, ?, ?)'; // phpcs:ignore
35 
-        $values    = [[$nextId, \PDO::PARAM_STR], [$identifier, \PDO::PARAM_STR], [$name, \PDO::PARAM_STR]];
35 
+        $values = [[$nextId, \PDO::PARAM_STR], [$identifier, \PDO::PARAM_STR], [$name, \PDO::PARAM_STR]];
36 36 
         $statement0 = MockStatementFactory::createWriteStatement($this, $values);
37 37
38 38 
         $this->writeConnectionMock
 
@@ -123,7 +123,7 @@  discard block
 
 block discarded – undo
123 123 
         $identifier = 'foo';
124 124 
         $name       = 'bar';
125 125
126 
-        $sql0          = 'SELECT ug.id, ug.identifier, ug.name, GROUP_CONCAT(ugar.admin_resource_id) AS admin_resource_ids FROM user_groups AS ug LEFT JOIN user_groups_admin_resources AS ugar ON ugar.user_group_id = ug.id WHERE (ug.deleted_at IS NULL) GROUP BY ug.id'; // phpcs:ignore
126 
+        $sql0 = 'SELECT ug.id, ug.identifier, ug.name, GROUP_CONCAT(ugar.admin_resource_id) AS admin_resource_ids FROM user_groups AS ug LEFT JOIN user_groups_admin_resources AS ugar ON ugar.user_group_id = ug.id WHERE (ug.deleted_at IS NULL) GROUP BY ug.id'; // phpcs:ignore
127 127 
         $values       = [];
128 128 
         $expectedData = [
129 129 
             [
 
@@ -134,7 +134,7 @@  discard block
 
 block discarded – undo
134 134 
                 // phpcs:ignore
135 135 
             ],
136 136 
         ];
137 
-        $statement0    = MockStatementFactory::createReadStatement($this, $values, $expectedData);
137 
+        $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData);
138 138
139 139 
         $this->readConnectionMock
140 140 
             ->expects($this->once())
Please login to merge, or discard this patch.