2010-02-24 05:25:09 +03:00
|
|
|
<?php
|
2008-05-06 17:41:22 +04:00
|
|
|
/*
|
|
|
|
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
|
|
|
|
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
|
|
|
|
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
|
|
|
|
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
|
|
|
|
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
|
|
|
|
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
|
|
|
|
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
|
|
|
|
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
|
|
|
|
* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
|
|
|
|
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
|
|
|
|
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
|
|
|
|
*
|
|
|
|
* This software consists of voluntary contributions made by many individuals
|
2012-05-26 16:37:00 +04:00
|
|
|
* and is licensed under the MIT license. For more information, see
|
2009-05-11 14:43:27 +04:00
|
|
|
* <http://www.doctrine-project.org>.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
|
|
|
|
2009-01-22 22:38:10 +03:00
|
|
|
namespace Doctrine\ORM;
|
2008-05-30 16:09:24 +04:00
|
|
|
|
2012-11-19 20:09:18 +04:00
|
|
|
use Doctrine\ORM\Query\ResultSetMappingBuilder;
|
2011-02-16 05:02:45 +03:00
|
|
|
use Doctrine\Common\Persistence\ObjectRepository;
|
2012-06-19 02:01:03 +04:00
|
|
|
use Doctrine\Common\Collections\Selectable;
|
|
|
|
use Doctrine\Common\Collections\Criteria;
|
|
|
|
use Doctrine\Common\Collections\ArrayCollection;
|
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
2009-05-26 15:30:07 +04:00
|
|
|
* An EntityRepository serves as a repository for entities with generic as well as
|
|
|
|
* business specific methods for retrieving entities.
|
2010-02-24 05:25:09 +03:00
|
|
|
*
|
2009-05-26 15:30:07 +04:00
|
|
|
* This class is designed for inheritance and users can subclass this class to
|
2009-08-13 14:13:06 +04:00
|
|
|
* write their own repositories with business-specific methods to locate entities.
|
2008-05-06 17:41:22 +04:00
|
|
|
*
|
2010-03-31 01:14:17 +04:00
|
|
|
* @since 2.0
|
|
|
|
* @author Benjamin Eberlei <kontakt@beberlei.de>
|
|
|
|
* @author Guilherme Blanco <guilhermeblanco@hotmail.com>
|
|
|
|
* @author Jonathan Wage <jonwage@gmail.com>
|
|
|
|
* @author Roman Borschel <roman@code-factory.org>
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
2012-06-19 02:01:03 +04:00
|
|
|
class EntityRepository implements ObjectRepository, Selectable
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2010-01-17 01:39:54 +03:00
|
|
|
/**
|
|
|
|
* @var string
|
|
|
|
*/
|
2009-10-05 08:11:29 +04:00
|
|
|
protected $_entityName;
|
2010-01-17 01:39:54 +03:00
|
|
|
|
|
|
|
/**
|
|
|
|
* @var EntityManager
|
|
|
|
*/
|
2009-10-05 08:11:29 +04:00
|
|
|
protected $_em;
|
2010-01-17 01:39:54 +03:00
|
|
|
|
|
|
|
/**
|
2011-12-12 00:52:29 +04:00
|
|
|
* @var \Doctrine\ORM\Mapping\ClassMetadata
|
2010-01-17 01:39:54 +03:00
|
|
|
*/
|
2009-10-05 08:11:29 +04:00
|
|
|
protected $_class;
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2009-07-30 19:16:02 +04:00
|
|
|
/**
|
|
|
|
* Initializes a new <tt>EntityRepository</tt>.
|
2010-02-24 05:25:09 +03:00
|
|
|
*
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param EntityManager $em The EntityManager to use.
|
|
|
|
* @param Mapping\ClassMetadata $class The class descriptor.
|
2009-07-30 19:16:02 +04:00
|
|
|
*/
|
2010-03-15 20:19:00 +03:00
|
|
|
public function __construct($em, Mapping\ClassMetadata $class)
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2009-07-30 19:16:02 +04:00
|
|
|
$this->_entityName = $class->name;
|
2012-06-11 14:39:18 +04:00
|
|
|
$this->_em = $em;
|
|
|
|
$this->_class = $class;
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2009-10-05 09:42:30 +04:00
|
|
|
/**
|
2012-12-01 20:28:06 +04:00
|
|
|
* Creates a new QueryBuilder instance that is prepopulated for this entity name.
|
2009-10-05 09:42:30 +04:00
|
|
|
*
|
2010-02-24 05:25:09 +03:00
|
|
|
* @param string $alias
|
2013-08-29 01:35:29 +04:00
|
|
|
* @param string $indexBy The index for the from.
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
|
|
|
* @return QueryBuilder
|
2009-10-05 09:42:30 +04:00
|
|
|
*/
|
2013-08-29 01:35:29 +04:00
|
|
|
public function createQueryBuilder($alias, $indexBy = null)
|
2009-10-05 09:42:30 +04:00
|
|
|
{
|
|
|
|
return $this->_em->createQueryBuilder()
|
|
|
|
->select($alias)
|
2013-08-29 01:35:29 +04:00
|
|
|
->from($this->_entityName, $alias, $indexBy);
|
2009-10-05 09:42:30 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2012-11-19 20:09:18 +04:00
|
|
|
/**
|
2012-12-01 20:28:06 +04:00
|
|
|
* Creates a new result set mapping builder for this entity.
|
2012-11-19 20:09:18 +04:00
|
|
|
*
|
|
|
|
* The column naming strategy is "INCREMENT".
|
|
|
|
*
|
|
|
|
* @param string $alias
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
2012-11-19 20:09:18 +04:00
|
|
|
* @return ResultSetMappingBuilder
|
|
|
|
*/
|
|
|
|
public function createResultSetMappingBuilder($alias)
|
|
|
|
{
|
|
|
|
$rsm = new ResultSetMappingBuilder($this->_em, ResultSetMappingBuilder::COLUMN_RENAMING_INCREMENT);
|
|
|
|
$rsm->addRootEntityFromClassMetadata($this->_entityName, $alias);
|
|
|
|
|
|
|
|
return $rsm;
|
|
|
|
}
|
|
|
|
|
2011-03-07 00:45:09 +03:00
|
|
|
/**
|
2012-12-01 20:28:06 +04:00
|
|
|
* Creates a new Query instance based on a predefined metadata named query.
|
2011-03-07 00:45:09 +03:00
|
|
|
*
|
|
|
|
* @param string $queryName
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
2011-03-07 00:45:09 +03:00
|
|
|
* @return Query
|
|
|
|
*/
|
|
|
|
public function createNamedQuery($queryName)
|
|
|
|
{
|
|
|
|
return $this->_em->createQuery($this->_class->getNamedQuery($queryName));
|
|
|
|
}
|
|
|
|
|
2012-02-26 23:51:39 +04:00
|
|
|
/**
|
|
|
|
* Creates a native SQL query.
|
|
|
|
*
|
|
|
|
* @param string $queryName
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
2012-02-26 23:51:39 +04:00
|
|
|
* @return NativeQuery
|
|
|
|
*/
|
|
|
|
public function createNativeNamedQuery($queryName)
|
|
|
|
{
|
|
|
|
$queryMapping = $this->_class->getNamedNativeQuery($queryName);
|
|
|
|
$rsm = new Query\ResultSetMappingBuilder($this->_em);
|
2012-02-27 02:27:42 +04:00
|
|
|
$rsm->addNamedNativeQueryMapping($this->_class, $queryMapping);
|
2012-06-11 14:39:18 +04:00
|
|
|
|
2012-02-26 23:51:39 +04:00
|
|
|
return $this->_em->createNativeQuery($queryMapping['query'], $rsm);
|
|
|
|
}
|
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
2008-05-14 01:20:34 +04:00
|
|
|
* Clears the repository, causing all managed entities to become detached.
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
|
|
|
* @return void
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
|
|
|
public function clear()
|
|
|
|
{
|
2009-07-30 19:16:02 +04:00
|
|
|
$this->_em->clear($this->_class->rootEntityName);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
2009-07-30 19:16:02 +04:00
|
|
|
* Finds an entity by its primary key / identifier.
|
2008-05-06 17:41:22 +04:00
|
|
|
*
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param mixed $id The identifier.
|
2014-02-01 21:05:47 +04:00
|
|
|
* @param int|null $lockMode One of the \Doctrine\DBAL\LockMode::* constants
|
|
|
|
* or NULL if no specific lock mode should be used
|
|
|
|
* during the search.
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param int|null $lockVersion The lock version.
|
2012-07-23 08:52:41 +04:00
|
|
|
*
|
2013-02-12 15:49:44 +04:00
|
|
|
* @return object|null The entity instance or NULL if the entity can not be found.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
2014-02-01 21:05:47 +04:00
|
|
|
public function find($id, $lockMode = null, $lockVersion = null)
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2012-07-23 08:52:41 +04:00
|
|
|
return $this->_em->find($this->_entityName, $id, $lockMode, $lockVersion);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
|
|
|
|
|
|
|
/**
|
2008-05-24 21:10:45 +04:00
|
|
|
* Finds all entities in the repository.
|
2008-05-06 17:41:22 +04:00
|
|
|
*
|
2009-08-13 14:13:06 +04:00
|
|
|
* @return array The entities.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
2009-08-13 14:13:06 +04:00
|
|
|
public function findAll()
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2009-08-13 14:13:06 +04:00
|
|
|
return $this->findBy(array());
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
2009-08-13 14:13:06 +04:00
|
|
|
* Finds entities by a set of criteria.
|
2008-05-06 17:41:22 +04:00
|
|
|
*
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param array $criteria
|
2011-05-01 01:18:24 +04:00
|
|
|
* @param array|null $orderBy
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param int|null $limit
|
|
|
|
* @param int|null $offset
|
|
|
|
*
|
2011-05-01 01:18:24 +04:00
|
|
|
* @return array The objects.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
2011-05-01 01:18:24 +04:00
|
|
|
public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2012-03-15 09:00:29 +04:00
|
|
|
$persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
|
|
|
|
|
|
|
|
return $persister->loadAll($criteria, $orderBy, $limit, $offset);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
2009-08-13 14:13:06 +04:00
|
|
|
* Finds a single entity by a set of criteria.
|
2008-05-06 17:41:22 +04:00
|
|
|
*
|
2010-09-04 14:18:02 +04:00
|
|
|
* @param array $criteria
|
2012-11-05 22:55:54 +04:00
|
|
|
* @param array|null $orderBy
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
2013-02-12 15:49:44 +04:00
|
|
|
* @return object|null The entity instance or NULL if the entity can not be found.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
2012-11-05 22:55:54 +04:00
|
|
|
public function findOneBy(array $criteria, array $orderBy = null)
|
2008-05-06 17:41:22 +04:00
|
|
|
{
|
2012-03-15 09:00:29 +04:00
|
|
|
$persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
|
|
|
|
|
2014-02-01 21:05:47 +04:00
|
|
|
return $persister->load($criteria, null, null, array(), null, 1, $orderBy);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2008-05-06 17:41:22 +04:00
|
|
|
/**
|
|
|
|
* Adds support for magic finders.
|
|
|
|
*
|
2012-12-01 20:28:06 +04:00
|
|
|
* @param string $method
|
|
|
|
* @param array $arguments
|
|
|
|
*
|
2009-08-13 14:13:06 +04:00
|
|
|
* @return array|object The found entity/entities.
|
2012-12-01 20:28:06 +04:00
|
|
|
*
|
|
|
|
* @throws ORMException
|
|
|
|
* @throws \BadMethodCallException If the method called is an invalid find* method
|
2009-12-07 15:47:23 +03:00
|
|
|
* or no find* method at all and therefore an invalid
|
|
|
|
* method call.
|
2008-05-06 17:41:22 +04:00
|
|
|
*/
|
|
|
|
public function __call($method, $arguments)
|
|
|
|
{
|
2011-12-01 19:00:26 +04:00
|
|
|
switch (true) {
|
2012-04-03 19:33:00 +04:00
|
|
|
case (0 === strpos($method, 'findBy')):
|
|
|
|
$by = substr($method, 6);
|
2011-12-01 19:00:26 +04:00
|
|
|
$method = 'findBy';
|
|
|
|
break;
|
|
|
|
|
2012-04-03 19:33:00 +04:00
|
|
|
case (0 === strpos($method, 'findOneBy')):
|
|
|
|
$by = substr($method, 9);
|
2011-12-01 19:00:26 +04:00
|
|
|
$method = 'findOneBy';
|
|
|
|
break;
|
|
|
|
|
|
|
|
default:
|
|
|
|
throw new \BadMethodCallException(
|
|
|
|
"Undefined method '$method'. The method name must start with ".
|
|
|
|
"either findBy or findOneBy!"
|
|
|
|
);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2011-08-26 08:51:29 +04:00
|
|
|
|
2011-08-26 09:15:28 +04:00
|
|
|
if (empty($arguments)) {
|
2011-12-01 19:00:26 +04:00
|
|
|
throw ORMException::findByRequiresParameter($method . $by);
|
2011-08-26 08:51:29 +04:00
|
|
|
}
|
2010-02-24 05:25:09 +03:00
|
|
|
|
2009-08-13 14:13:06 +04:00
|
|
|
$fieldName = lcfirst(\Doctrine\Common\Util\Inflector::classify($by));
|
|
|
|
|
2010-09-28 00:13:14 +04:00
|
|
|
if ($this->_class->hasField($fieldName) || $this->_class->hasAssociation($fieldName)) {
|
2012-03-15 09:00:29 +04:00
|
|
|
switch (count($arguments)) {
|
|
|
|
case 1:
|
|
|
|
return $this->$method(array($fieldName => $arguments[0]));
|
|
|
|
|
|
|
|
case 2:
|
|
|
|
return $this->$method(array($fieldName => $arguments[0]), $arguments[1]);
|
|
|
|
|
|
|
|
case 3:
|
|
|
|
return $this->$method(array($fieldName => $arguments[0]), $arguments[1], $arguments[2]);
|
|
|
|
|
2012-10-12 15:37:17 +04:00
|
|
|
case 4:
|
2012-03-15 09:00:29 +04:00
|
|
|
return $this->$method(array($fieldName => $arguments[0]), $arguments[1], $arguments[2], $arguments[3]);
|
|
|
|
|
|
|
|
default:
|
|
|
|
// Do nothing
|
2011-09-02 17:53:52 +04:00
|
|
|
}
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2011-12-01 19:00:26 +04:00
|
|
|
|
|
|
|
throw ORMException::invalidFindByCall($this->_entityName, $fieldName, $method.$by);
|
2008-05-06 17:41:22 +04:00
|
|
|
}
|
2010-04-27 21:37:27 +04:00
|
|
|
|
|
|
|
/**
|
|
|
|
* @return string
|
|
|
|
*/
|
|
|
|
protected function getEntityName()
|
|
|
|
{
|
|
|
|
return $this->_entityName;
|
|
|
|
}
|
|
|
|
|
2011-10-26 01:21:39 +04:00
|
|
|
/**
|
|
|
|
* @return string
|
|
|
|
*/
|
|
|
|
public function getClassName()
|
|
|
|
{
|
|
|
|
return $this->getEntityName();
|
|
|
|
}
|
|
|
|
|
2010-04-27 21:37:27 +04:00
|
|
|
/**
|
|
|
|
* @return EntityManager
|
|
|
|
*/
|
|
|
|
protected function getEntityManager()
|
|
|
|
{
|
|
|
|
return $this->_em;
|
|
|
|
}
|
|
|
|
|
|
|
|
/**
|
|
|
|
* @return Mapping\ClassMetadata
|
|
|
|
*/
|
|
|
|
protected function getClassMetadata()
|
|
|
|
{
|
|
|
|
return $this->_class;
|
|
|
|
}
|
2012-06-19 02:01:03 +04:00
|
|
|
|
|
|
|
/**
|
|
|
|
* Select all elements from a selectable that match the expression and
|
|
|
|
* return a new collection containing these elements.
|
|
|
|
*
|
|
|
|
* @param \Doctrine\Common\Collections\Criteria $criteria
|
|
|
|
*
|
|
|
|
* @return \Doctrine\Common\Collections\Collection
|
|
|
|
*/
|
|
|
|
public function matching(Criteria $criteria)
|
|
|
|
{
|
|
|
|
$persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
|
|
|
|
|
2013-12-19 23:13:44 +04:00
|
|
|
return new LazyCriteriaCollection($persister, $criteria);
|
2012-06-19 02:01:03 +04:00
|
|
|
}
|
2011-10-26 01:21:39 +04:00
|
|
|
}
|