@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\Locking; |
| 6 | 6 | |
@@ -89,7 +89,7 @@ discard block |
||
| 89 | 89 | $article = new CmsArticle(); |
| 90 | 90 | |
| 91 | 91 | $this->expectException(\InvalidArgumentException::class); |
| 92 | - $this->expectExceptionMessage('Entity ' . CmsArticle::class); |
|
| 92 | + $this->expectExceptionMessage('Entity '.CmsArticle::class); |
|
| 93 | 93 | |
| 94 | 94 | $this->em->lock($article, LockMode::OPTIMISTIC, $article->version + 1); |
| 95 | 95 | } |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | { |
| 139 | 139 | $writeLockSql = $this->em->getConnection()->getDatabasePlatform()->getWriteLockSQL(); |
| 140 | 140 | |
| 141 | - if (! $writeLockSql) { |
|
| 141 | + if ( ! $writeLockSql) { |
|
| 142 | 142 | $this->markTestSkipped('Database Driver has no Write Lock support.'); |
| 143 | 143 | } |
| 144 | 144 | |
@@ -173,7 +173,7 @@ discard block |
||
| 173 | 173 | { |
| 174 | 174 | $readLockSql = $this->em->getConnection()->getDatabasePlatform()->getReadLockSQL(); |
| 175 | 175 | |
| 176 | - if (! $readLockSql) { |
|
| 176 | + if ( ! $readLockSql) { |
|
| 177 | 177 | $this->markTestSkipped('Database Driver has no Write Lock support.'); |
| 178 | 178 | } |
| 179 | 179 | |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | */ |
| 207 | 207 | public function testLockOptimisticNonVersionedThrowsExceptionInDQL() |
| 208 | 208 | { |
| 209 | - $dql = 'SELECT u FROM ' . CmsUser::class . " u WHERE u.username = 'gblanco'"; |
|
| 209 | + $dql = 'SELECT u FROM '.CmsUser::class." u WHERE u.username = 'gblanco'"; |
|
| 210 | 210 | |
| 211 | 211 | $this->expectException(OptimisticLockException::class); |
| 212 | 212 | $this->expectExceptionMessage('The optimistic lock on an entity failed.'); |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\Locking; |
| 6 | 6 | |
@@ -19,7 +19,7 @@ discard block |
||
| 19 | 19 | |
| 20 | 20 | protected function setUp() |
| 21 | 21 | { |
| 22 | - if (! class_exists('GearmanClient', false)) { |
|
| 22 | + if ( ! class_exists('GearmanClient', false)) { |
|
| 23 | 23 | $this->markTestSkipped('pecl/gearman is required for this test to run.'); |
| 24 | 24 | } |
| 25 | 25 | |
@@ -135,11 +135,11 @@ discard block |
||
| 135 | 135 | $this->gearman->runTasks(); |
| 136 | 136 | |
| 137 | 137 | self::assertTrue($this->maxRunTime > $forTime, |
| 138 | - 'Because of locking this tests should have run at least ' . $forTime . ' seconds, ' . |
|
| 139 | - 'but only did for ' . $this->maxRunTime . ' seconds.'); |
|
| 138 | + 'Because of locking this tests should have run at least '.$forTime.' seconds, '. |
|
| 139 | + 'but only did for '.$this->maxRunTime.' seconds.'); |
|
| 140 | 140 | self::assertTrue($this->maxRunTime < $notLongerThan, |
| 141 | - 'The longest task should not run longer than ' . $notLongerThan . ' seconds, ' . |
|
| 142 | - 'but did for ' . $this->maxRunTime . ' seconds.' |
|
| 141 | + 'The longest task should not run longer than '.$notLongerThan.' seconds, '. |
|
| 142 | + 'but did for '.$this->maxRunTime.' seconds.' |
|
| 143 | 143 | ); |
| 144 | 144 | } |
| 145 | 145 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\SchemaTool; |
| 6 | 6 | |
@@ -57,7 +57,7 @@ discard block |
||
| 57 | 57 | */ |
| 58 | 58 | public function testDropPartSchemaWithForeignKeys() |
| 59 | 59 | { |
| 60 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 60 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 61 | 61 | $this->markTestSkipped('Foreign Key test'); |
| 62 | 62 | } |
| 63 | 63 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\SchemaTool; |
| 6 | 6 | |
@@ -86,6 +86,6 @@ discard block |
||
| 86 | 86 | $sql = $schemaDiff->toSql($this->em->getConnection()->getDatabasePlatform()); |
| 87 | 87 | $sql = array_filter($sql, function($sql) { return strpos($sql, 'DROP') === false; }); |
| 88 | 88 | |
| 89 | - self::assertCount(0, $sql, 'SQL: ' . implode(PHP_EOL, $sql)); |
|
| 89 | + self::assertCount(0, $sql, 'SQL: '.implode(PHP_EOL, $sql)); |
|
| 90 | 90 | } |
| 91 | 91 | } |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\SchemaTool; |
| 6 | 6 | |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | parent::setUp(); |
| 17 | 17 | |
| 18 | 18 | if ($this->em->getConnection()->getDatabasePlatform()->getName() !== 'postgresql') { |
| 19 | - $this->markTestSkipped('The ' . __CLASS__ . ' requires the use of postgresql.'); |
|
| 19 | + $this->markTestSkipped('The '.__CLASS__.' requires the use of postgresql.'); |
|
| 20 | 20 | } |
| 21 | 21 | } |
| 22 | 22 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\SchemaTool; |
| 6 | 6 | |
@@ -15,7 +15,7 @@ discard block |
||
| 15 | 15 | { |
| 16 | 16 | parent::setUp(); |
| 17 | 17 | if ($this->em->getConnection()->getDatabasePlatform()->getName() !== 'mysql') { |
| 18 | - $this->markTestSkipped('The ' . __CLASS__ . ' requires the use of mysql.'); |
|
| 18 | + $this->markTestSkipped('The '.__CLASS__.' requires the use of mysql.'); |
|
| 19 | 19 | } |
| 20 | 20 | } |
| 21 | 21 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -234,8 +234,8 @@ discard block |
||
| 234 | 234 | $eventManager->addEventListener([Events::postLoad], $listener); |
| 235 | 235 | |
| 236 | 236 | $this->em->find(CmsUser::class, $this->userId); |
| 237 | - self::assertSame(1, $listener->countHandledEvents(CmsUser::class), CmsUser::class . ' should be handled once!'); |
|
| 238 | - self::assertSame(1, $listener->countHandledEvents(CmsEmail::class), CmsEmail::class . ' should be handled once!'); |
|
| 237 | + self::assertSame(1, $listener->countHandledEvents(CmsUser::class), CmsUser::class.' should be handled once!'); |
|
| 238 | + self::assertSame(1, $listener->countHandledEvents(CmsEmail::class), CmsEmail::class.' should be handled once!'); |
|
| 239 | 239 | } |
| 240 | 240 | |
| 241 | 241 | private function loadFixture() |
@@ -311,7 +311,7 @@ discard block |
||
| 311 | 311 | { |
| 312 | 312 | $object = $event->getObject(); |
| 313 | 313 | $class = StaticClassNameConverter::getClass($object); |
| 314 | - if (! isset($this->firedByClasses[$class])) { |
|
| 314 | + if ( ! isset($this->firedByClasses[$class])) { |
|
| 315 | 315 | $this->firedByClasses[$class] = 1; |
| 316 | 316 | } else { |
| 317 | 317 | $this->firedByClasses[$class]++; |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | */ |
| 37 | 37 | private function registerType(string $className) |
| 38 | 38 | { |
| 39 | - $type = constant($className . '::NAME'); |
|
| 39 | + $type = constant($className.'::NAME'); |
|
| 40 | 40 | |
| 41 | 41 | if (DBALType::hasType($type)) { |
| 42 | 42 | DBALType::overrideType($type, $className); |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | foreach ($classes as $class) { |
| 73 | 73 | $ce = $validator->validateClass($class); |
| 74 | 74 | |
| 75 | - self::assertEmpty($ce, 'Invalid Modelset: ' . $modelSet . ' class ' . $class->getClassName() . ': ' . implode("\n", $ce)); |
|
| 75 | + self::assertEmpty($ce, 'Invalid Modelset: '.$modelSet.' class '.$class->getClassName().': '.implode("\n", $ce)); |
|
| 76 | 76 | } |
| 77 | 77 | } |
| 78 | 78 | } |
@@ -25,7 +25,7 @@ discard block |
||
| 25 | 25 | public function testAggregateSum() |
| 26 | 26 | { |
| 27 | 27 | $salarySum = $this->em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 28 | - ->getSingleResult(); |
|
| 28 | + ->getSingleResult(); |
|
| 29 | 29 | |
| 30 | 30 | self::assertEquals(1500000, $salarySum['salary']); |
| 31 | 31 | } |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | public function testAggregateAvg() |
| 34 | 34 | { |
| 35 | 35 | $salaryAvg = $this->em->createQuery('SELECT AVG(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 36 | - ->getSingleResult(); |
|
| 36 | + ->getSingleResult(); |
|
| 37 | 37 | |
| 38 | 38 | self::assertEquals(375000, round($salaryAvg['salary'], 0)); |
| 39 | 39 | } |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | public function testAggregateMin() |
| 42 | 42 | { |
| 43 | 43 | $salary = $this->em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 44 | - ->getSingleResult(); |
|
| 44 | + ->getSingleResult(); |
|
| 45 | 45 | |
| 46 | 46 | self::assertEquals(100000, $salary['salary']); |
| 47 | 47 | } |
@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | public function testAggregateMax() |
| 50 | 50 | { |
| 51 | 51 | $salary = $this->em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 52 | - ->getSingleResult(); |
|
| 52 | + ->getSingleResult(); |
|
| 53 | 53 | |
| 54 | 54 | self::assertEquals(800000, $salary['salary']); |
| 55 | 55 | } |
@@ -57,7 +57,7 @@ discard block |
||
| 57 | 57 | public function testAggregateCount() |
| 58 | 58 | { |
| 59 | 59 | $managerCount = $this->em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 60 | - ->getSingleResult(); |
|
| 60 | + ->getSingleResult(); |
|
| 61 | 61 | |
| 62 | 62 | self::assertEquals(4, $managerCount['managers']); |
| 63 | 63 | } |
@@ -65,7 +65,7 @@ discard block |
||
| 65 | 65 | public function testFunctionAbs() |
| 66 | 66 | { |
| 67 | 67 | $result = $this->em->createQuery('SELECT m, ABS(m.salary * -1) AS abs FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 68 | - ->getResult(); |
|
| 68 | + ->getResult(); |
|
| 69 | 69 | |
| 70 | 70 | self::assertCount(4, $result); |
| 71 | 71 | self::assertEquals(100000, $result[0]['abs']); |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | public function testFunctionConcat() |
| 78 | 78 | { |
| 79 | 79 | $arg = $this->em->createQuery('SELECT m, CONCAT(m.name, m.department) AS namedep FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 80 | - ->getArrayResult(); |
|
| 80 | + ->getArrayResult(); |
|
| 81 | 81 | |
| 82 | 82 | self::assertCount(4, $arg); |
| 83 | 83 | self::assertEquals('Roman B.IT', $arg[0]['namedep']); |
@@ -89,7 +89,7 @@ discard block |
||
| 89 | 89 | public function testFunctionLength() |
| 90 | 90 | { |
| 91 | 91 | $result = $this->em->createQuery('SELECT m, LENGTH(CONCAT(m.name, m.department)) AS namedeplength FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 92 | - ->getArrayResult(); |
|
| 92 | + ->getArrayResult(); |
|
| 93 | 93 | |
| 94 | 94 | self::assertCount(4, $result); |
| 95 | 95 | self::assertEquals(10, $result[0]['namedeplength']); |
@@ -101,10 +101,10 @@ discard block |
||
| 101 | 101 | public function testFunctionLocate() |
| 102 | 102 | { |
| 103 | 103 | $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
| 104 | - "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
| 104 | + "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
| 105 | 105 | |
| 106 | 106 | $result = $this->em->createQuery($dql) |
| 107 | - ->getArrayResult(); |
|
| 107 | + ->getArrayResult(); |
|
| 108 | 108 | |
| 109 | 109 | self::assertCount(4, $result); |
| 110 | 110 | self::assertEquals(0, $result[0]['loc']); |
@@ -120,7 +120,7 @@ discard block |
||
| 120 | 120 | public function testFunctionLower() |
| 121 | 121 | { |
| 122 | 122 | $result = $this->em->createQuery("SELECT m, LOWER(m.name) AS lowername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
| 123 | - ->getArrayResult(); |
|
| 123 | + ->getArrayResult(); |
|
| 124 | 124 | |
| 125 | 125 | self::assertCount(4, $result); |
| 126 | 126 | self::assertEquals('roman b.', $result[0]['lowername']); |
@@ -132,7 +132,7 @@ discard block |
||
| 132 | 132 | public function testFunctionMod() |
| 133 | 133 | { |
| 134 | 134 | $result = $this->em->createQuery("SELECT m, MOD(m.salary, 3500) AS amod FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
| 135 | - ->getArrayResult(); |
|
| 135 | + ->getArrayResult(); |
|
| 136 | 136 | |
| 137 | 137 | self::assertCount(4, $result); |
| 138 | 138 | self::assertEquals(2000, $result[0]['amod']); |
@@ -144,7 +144,7 @@ discard block |
||
| 144 | 144 | public function testFunctionSqrt() |
| 145 | 145 | { |
| 146 | 146 | $result = $this->em->createQuery("SELECT m, SQRT(m.salary) AS sqrtsalary FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
| 147 | - ->getArrayResult(); |
|
| 147 | + ->getArrayResult(); |
|
| 148 | 148 | |
| 149 | 149 | self::assertCount(4, $result); |
| 150 | 150 | self::assertEquals(316, round($result[0]['sqrtsalary'])); |
@@ -156,7 +156,7 @@ discard block |
||
| 156 | 156 | public function testFunctionUpper() |
| 157 | 157 | { |
| 158 | 158 | $result = $this->em->createQuery("SELECT m, UPPER(m.name) AS uppername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
| 159 | - ->getArrayResult(); |
|
| 159 | + ->getArrayResult(); |
|
| 160 | 160 | |
| 161 | 161 | self::assertCount(4, $result); |
| 162 | 162 | self::assertEquals('ROMAN B.', $result[0]['uppername']); |
@@ -171,7 +171,7 @@ discard block |
||
| 171 | 171 | "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name"; |
| 172 | 172 | |
| 173 | 173 | $result = $this->em->createQuery($dql) |
| 174 | - ->getArrayResult(); |
|
| 174 | + ->getArrayResult(); |
|
| 175 | 175 | |
| 176 | 176 | self::assertCount(4, $result); |
| 177 | 177 | self::assertEquals('Ben', $result[0]['str1']); |
@@ -188,8 +188,8 @@ discard block |
||
| 188 | 188 | public function testFunctionTrim() |
| 189 | 189 | { |
| 190 | 190 | $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
| 191 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
| 192 | - "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
| 191 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
| 192 | + "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
| 193 | 193 | |
| 194 | 194 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 195 | 195 | |
@@ -330,8 +330,8 @@ discard block |
||
| 330 | 330 | ); |
| 331 | 331 | |
| 332 | 332 | $result = $this->em->createQuery($query) |
| 333 | - ->setMaxResults(1) |
|
| 334 | - ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
| 333 | + ->setMaxResults(1) |
|
| 334 | + ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
| 335 | 335 | |
| 336 | 336 | self::assertArrayHasKey('now', $result); |
| 337 | 337 | self::assertArrayHasKey('sub', $result); |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | |
| 101 | 101 | public function testFunctionLocate() |
| 102 | 102 | { |
| 103 | - $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
|
| 103 | + $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ". |
|
| 104 | 104 | "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
| 105 | 105 | |
| 106 | 106 | $result = $this->em->createQuery($dql) |
@@ -167,7 +167,7 @@ discard block |
||
| 167 | 167 | |
| 168 | 168 | public function testFunctionSubstring() |
| 169 | 169 | { |
| 170 | - $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ' . |
|
| 170 | + $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 '. |
|
| 171 | 171 | "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name"; |
| 172 | 172 | |
| 173 | 173 | $result = $this->em->createQuery($dql) |
@@ -187,8 +187,8 @@ discard block |
||
| 187 | 187 | |
| 188 | 188 | public function testFunctionTrim() |
| 189 | 189 | { |
| 190 | - $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
|
| 191 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
| 190 | + $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, ". |
|
| 191 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ". |
|
| 192 | 192 | "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
| 193 | 193 | |
| 194 | 194 | $result = $this->em->createQuery($dql)->getArrayResult(); |
@@ -360,12 +360,12 @@ discard block |
||
| 360 | 360 | */ |
| 361 | 361 | public function testBitOrComparison() |
| 362 | 362 | { |
| 363 | - $dql = 'SELECT m, ' . |
|
| 364 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
| 365 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
| 366 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 367 | - 'ORDER BY ' . |
|
| 368 | - 'm.id ' ; |
|
| 363 | + $dql = 'SELECT m, '. |
|
| 364 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
| 365 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
| 366 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 367 | + 'ORDER BY '. |
|
| 368 | + 'm.id '; |
|
| 369 | 369 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 370 | 370 | |
| 371 | 371 | self::assertEquals(4 | 2, $result[0]['bit_or']); |
@@ -373,10 +373,10 @@ discard block |
||
| 373 | 373 | self::assertEquals(4 | 2, $result[2]['bit_or']); |
| 374 | 374 | self::assertEquals(4 | 2, $result[3]['bit_or']); |
| 375 | 375 | |
| 376 | - self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
| 377 | - self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
| 378 | - self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
| 379 | - self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
| 376 | + self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
| 377 | + self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
| 378 | + self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
| 379 | + self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
| 380 | 380 | } |
| 381 | 381 | |
| 382 | 382 | /** |
@@ -384,12 +384,12 @@ discard block |
||
| 384 | 384 | */ |
| 385 | 385 | public function testBitAndComparison() |
| 386 | 386 | { |
| 387 | - $dql = 'SELECT m, ' . |
|
| 388 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
| 389 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
| 390 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 391 | - 'ORDER BY ' . |
|
| 392 | - 'm.id ' ; |
|
| 387 | + $dql = 'SELECT m, '. |
|
| 388 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
| 389 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
| 390 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 391 | + 'ORDER BY '. |
|
| 392 | + 'm.id '; |
|
| 393 | 393 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 394 | 394 | |
| 395 | 395 | self::assertEquals(4 & 2, $result[0]['bit_and']); |
@@ -397,10 +397,10 @@ discard block |
||
| 397 | 397 | self::assertEquals(4 & 2, $result[2]['bit_and']); |
| 398 | 398 | self::assertEquals(4 & 2, $result[3]['bit_and']); |
| 399 | 399 | |
| 400 | - self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
| 401 | - self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
| 402 | - self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
| 403 | - self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
| 400 | + self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
| 401 | + self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
| 402 | + self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
| 403 | + self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
| 404 | 404 | } |
| 405 | 405 | |
| 406 | 406 | protected function generateFixture() |