-
-
Save sileence/0597f654098647f2dfee56c874109a96 to your computer and use it in GitHub Desktop.
Proof of concept to add query builder helpers directly in the repository (I'd still prefer to keep them in the query builder anyway)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace App\Repository; | |
| use BadMethodCallException; | |
| use Doctrine\ORM\EntityRepository; | |
| use Doctrine\ORM\QueryBuilder as DoctrineQueryBuilder; | |
| class QueryBuilder extends DoctrineQueryBuilder | |
| { | |
| private $repository; | |
| public function setRepository(EntityRepository $repository) | |
| { | |
| $this->repository = $repository; | |
| return $this; | |
| } | |
| public function __call($name, $arguments) | |
| { | |
| if ($this->repository) { | |
| return $this->repository->$name($this, ...$arguments); | |
| } | |
| throw new BadMethodCallException("The method {$name} was not found"); | |
| } | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| class Repository | |
| { | |
| public function findStatsByCountry() | |
| { | |
| //.... | |
| $result = $this->createQueryBuilder('s') | |
| //..... | |
| ->addSubSelectFromRepository($numberOfPayments, 'num_payments') | |
| ->addSubSelectFromRepository($totalAmount, 'amount') | |
| //.... | |
| ->getQuery() | |
| ->getResult(); | |
| //.... | |
| } | |
| public function addSubSelectFromRepository( | |
| \Doctrine\ORM\QueryBuilder $queryBuilder, | |
| \Doctrine\ORM\QueryBuilder $subselectQueryBuilder, | |
| string $alias | |
| ) { | |
| $queryBuilder->addSelect(sprintf( | |
| '(%s) as %s', | |
| $subselectQueryBuilder->getDQL(), $alias | |
| )); | |
| return $queryBuilder; | |
| } | |
| /** | |
| * @return QueryBuilder | |
| */ | |
| public function createQueryBuilder($alias, $indexBy = null) | |
| { | |
| return (new QueryBuilder($this->_em)) | |
| ->select($alias) | |
| ->from($this->_entityName, $alias, $indexBy) | |
| ->setRepository($this); | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment