DQL syntax to hide irrelevant values for the result
<?php
use PHPSnippets\Db\Entity\Test;
$getResult = function($dql) use ($entityManager) {
return $entityManager->createQuery($dql)
->setMaxResults(5)
->getResult();
};
// Regular DQL Query
$dql = 'SELECT t, MOD(t.id, 2) as modulo FROM '.Test::class.' t
ORDER BY modulo DESC';
dump($getResult($dql));
// DQL Query with HIDDEN for modulo alias
$dql = 'SELECT t, MOD(t.id, 2) as HIDDEN modulo FROM '.Test::class.' t
ORDER BY modulo DESC';
dump($getResult($dql));
Result
array:3 [
0 => array:2 [
0 => Test {#1466
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#1463
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1499
-snapshot: []
-owner: Test {#1466}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1491
-elements: []
}
#initialized: false
}
}
"modulo" => "1"
]
1 => array:2 [
0 => Test {#1503
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#1500
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1502
-snapshot: []
-owner: Test {#1503}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1495
-elements: []
}
#initialized: false
}
}
"modulo" => "1"
]
2 => array:2 [
0 => Test {#1498
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#1483
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1509
-snapshot: []
-owner: Test {#1498}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1510
-elements: []
}
#initialized: false
}
}
"modulo" => "0"
]
]
array:3 [
0 => Test {#1466
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#1463
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1499
-snapshot: []
-owner: Test {#1466}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1491
-elements: []
}
#initialized: false
}
}
1 => Test {#1503
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#1500
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1502
-snapshot: []
-owner: Test {#1503}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1495
-elements: []
}
#initialized: false
}
}
2 => Test {#1498
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#1483
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
+subTests: PersistentCollection {#1509
-snapshot: []
-owner: Test {#1498}
-association: array:15 [ …15]
-em: EntityManager {#1437 …11}
-backRefFieldName: "test"
-typeClass: ClassMetadata {#1506 …}
-isDirty: false
#collection: ArrayCollection {#1510
-elements: []
}
#initialized: false
}
}
]
More Snippets
Used Versions
PHP 7.4, Zend 3.0, Symfony 4.3, Laravel 5.8, PHPUnit 8.0, Doctrine 2.10