@@ -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()) |