@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | $requestStub = new Request([], [], [], [], [], [], null); |
40 | 40 | $responseStub = new Response(); |
41 | 41 | |
42 | - $next = function () use ($responseStub) { |
|
42 | + $next = function() use ($responseStub) { |
|
43 | 43 | return $responseStub; |
44 | 44 | }; |
45 | 45 | |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | $responseStub = new Response(); |
62 | 62 | |
63 | 63 | |
64 | - $next = function () use ($responseStub) { |
|
64 | + $next = function() use ($responseStub) { |
|
65 | 65 | return $responseStub; |
66 | 66 | }; |
67 | 67 | |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | $requestStub = new Request([], [], [], [], [], $env, null); |
83 | 83 | $responseStub = new Response(); |
84 | 84 | |
85 | - $next = function () use ($responseStub) { |
|
85 | + $next = function() use ($responseStub) { |
|
86 | 86 | return $responseStub; |
87 | 87 | }; |
88 | 88 | |
@@ -128,14 +128,14 @@ discard block |
||
128 | 128 | |
129 | 129 | $this->cacheBridgeMock->expects($this->once())->method('has')->willReturn(false); |
130 | 130 | |
131 | - $env = [ |
|
131 | + $env = [ |
|
132 | 132 | Env::ENV_NAME => Environment::PRODUCTION, |
133 | 133 | Env::OAUTH2_PRIVATE_KEY_PASSWORD => $oauth2PrivateKeyPassword, |
134 | 134 | ]; |
135 | 135 | $requestStub = new Request([], [], [], [], [], $env, null); |
136 | 136 | $responseStub = new Response(); |
137 | 137 | |
138 | - $next = function () use ($responseStub) { |
|
138 | + $next = function() use ($responseStub) { |
|
139 | 139 | return $responseStub; |
140 | 140 | }; |
141 | 141 | |
@@ -156,14 +156,14 @@ discard block |
||
156 | 156 | $this->cacheBridgeMock->expects($this->any())->method('has')->willReturn(false); |
157 | 157 | $this->cacheBridgeMock->expects($this->once())->method('set')->willReturn(true); |
158 | 158 | |
159 | - $env = [ |
|
159 | + $env = [ |
|
160 | 160 | Env::ENV_NAME => Environment::PRODUCTION, |
161 | 161 | Env::OAUTH2_PRIVATE_KEY_PASSWORD => $oauth2PrivateKeyPassword, |
162 | 162 | ]; |
163 | 163 | $requestStub = new Request([], [], [], [], [], $env, null); |
164 | 164 | $responseStub = new Response(); |
165 | 165 | |
166 | - $next = function () use ($responseStub) { |
|
166 | + $next = function() use ($responseStub) { |
|
167 | 167 | return $responseStub; |
168 | 168 | }; |
169 | 169 |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | $requestStub = new Request([], [], [], [], [], [], null); |
75 | 75 | $responseStub = new Response(); |
76 | 76 | |
77 | - $next = function () use ($responseStub) { |
|
77 | + $next = function() use ($responseStub) { |
|
78 | 78 | return $responseStub; |
79 | 79 | }; |
80 | 80 | |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | $requestStub = new Request([], [], [], [], [], [], null); |
98 | 98 | $responseStub = new Response(); |
99 | 99 | |
100 | - $next = function () use ($responseStub) { |
|
100 | + $next = function() use ($responseStub) { |
|
101 | 101 | return $responseStub; |
102 | 102 | }; |
103 | 103 | |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | $requestStub = new Request([], [], [], [], [], [], null); |
132 | 132 | $responseStub = new Response(); |
133 | 133 | |
134 | - $next = function () use ($responseStub) { |
|
134 | + $next = function() use ($responseStub) { |
|
135 | 135 | return $responseStub; |
136 | 136 | }; |
137 | 137 | |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | $requestStub = new Request([], [], [], [], [], [], null); |
172 | 172 | $responseStub = new Response(); |
173 | 173 | |
174 | - $next = function () use ($responseStub) { |
|
174 | + $next = function() use ($responseStub) { |
|
175 | 175 | return $responseStub; |
176 | 176 | }; |
177 | 177 | |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | $requestStub = new Request([], [], [], [], [], [], null); |
213 | 213 | $responseStub = new Response(); |
214 | 214 | |
215 | - $next = function () use ($responseStub) { |
|
215 | + $next = function() use ($responseStub) { |
|
216 | 216 | return $responseStub; |
217 | 217 | }; |
218 | 218 | |
@@ -245,7 +245,7 @@ discard block |
||
245 | 245 | $requestStub = new Request([], [], [], [], [], [], null); |
246 | 246 | $responseStub = new Response(); |
247 | 247 | |
248 | - $next = function () use ($responseStub) { |
|
248 | + $next = function() use ($responseStub) { |
|
249 | 249 | return $responseStub; |
250 | 250 | }; |
251 | 251 |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | $requestStub = new Request([], [], [], [], [], [], null); |
58 | 58 | $responseStub = new Response(); |
59 | 59 | |
60 | - $next = function () use ($responseStub) { |
|
60 | + $next = function() use ($responseStub) { |
|
61 | 61 | return $responseStub; |
62 | 62 | }; |
63 | 63 | |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | $requestStub = new Request([], [], [], [], [], [], null); |
77 | 77 | $responseStub = new Response(); |
78 | 78 | |
79 | - $next = function () use ($responseStub) { |
|
79 | + $next = function() use ($responseStub) { |
|
80 | 80 | return $responseStub; |
81 | 81 | }; |
82 | 82 | |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | $requestStub = new Request([], [], [], [], [], [], null); |
100 | 100 | $responseStub = new Response(); |
101 | 101 | |
102 | - $next = function () use ($responseStub) { |
|
102 | + $next = function() use ($responseStub) { |
|
103 | 103 | return $responseStub; |
104 | 104 | }; |
105 | 105 | |
@@ -124,7 +124,7 @@ discard block |
||
124 | 124 | $requestStub = new Request([], [], [], [], [], [], null); |
125 | 125 | $responseStub = new Response(); |
126 | 126 | |
127 | - $next = function () use ($responseStub) { |
|
127 | + $next = function() use ($responseStub) { |
|
128 | 128 | return $responseStub; |
129 | 129 | }; |
130 | 130 |
@@ -36,8 +36,8 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | [ |
@@ -119,7 +119,7 @@ discard block |
||
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 |
||
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()) |
@@ -82,7 +82,7 @@ discard block |
||
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 |
||
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()) |
@@ -88,7 +88,7 @@ discard block |
||
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 |
||
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 |
||
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()) |
@@ -32,7 +32,7 @@ discard block |
||
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 |
||
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 |
||
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()) |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | ['id' => $id0, 'user_id' => $userId0, 'description' => $description0, 'secret' => $secret0], |
168 | 168 | ['id' => $id1, 'user_id' => $userId1, 'description' => $description1, 'secret' => $secret1], |
169 | 169 | ]; |
170 | - $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
170 | + $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
171 | 171 | |
172 | 172 | $this->readConnectionMock |
173 | 173 | ->expects($this->once()) |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | 'admin_resource_identifiers' => $arIdentifier10, |
218 | 218 | ], |
219 | 219 | ]; |
220 | - $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
220 | + $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
221 | 221 | |
222 | 222 | $this->readConnectionMock |
223 | 223 | ->expects($this->once()) |
@@ -247,7 +247,7 @@ discard block |
||
247 | 247 | ['id' => $id0, 'user_id' => $userId0, 'description' => $description0, 'secret' => $secret0], |
248 | 248 | ['id' => $id1, 'user_id' => $userId1, 'description' => $description1, 'secret' => $secret1], |
249 | 249 | ]; |
250 | - $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
250 | + $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
251 | 251 | |
252 | 252 | $this->readConnectionMock |
253 | 253 | ->expects($this->once()) |
@@ -280,7 +280,7 @@ discard block |
||
280 | 280 | ['id' => $id0, 'user_id' => $userId0, 'description' => $description0, 'secret' => $secret0], |
281 | 281 | ['id' => $id1, 'user_id' => $userId1, 'description' => $description1, 'secret' => $secret1], |
282 | 282 | ]; |
283 | - $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
283 | + $statement0 = MockStatementFactory::createReadStatement($this, $values, $expectedData); |
|
284 | 284 | |
285 | 285 | $this->readConnectionMock |
286 | 286 | ->expects($this->once()) |