/**
* @param Locality $locality
* @return Locality
* @throws \Doctrine\DBAL\DBALException
* @throws \Exception
*/
public function setupLocalityEntity(Locality $locality)
{
/* In order to NOT auto increment locality ID counter in DB by
INSERTs that actually wont happen (e.g. safePersist()) and
because Doctrine2 does NOT support locking of entire tables,
we have to use native SQL(MySQL) query.
DUAL is "dummy" table - there is no need to reference any table
(more info in MySQL SELECT documentation)
*/
$this->em->getConnection()->executeQuery('INSERT INTO locality (name)
SELECT :name FROM DUAL
WHERE NOT EXISTS(
SELECT l.name
FROM locality l
WHERE l.name = :name)
LIMIT 1', ['name' => $locality->getName()]);
$result = $this->em->createQuery('SELECT l FROM ' . Locality::class . ' l
WHERE l.name = :name')->setParameters(['name' => $locality->getName()])->getSingleResult();
return $result;
}
public function compare(ListingItem $listingItem)
{
if ($this->day != $listingItem->day) {
return false;
}
if ($this->locality->getId() != $listingItem->getLocality()->getId()) {
return false;
}
if ($this->workedHours->getId() != $listingItem->getWorkedHours()->getId()) {
return false;
}
return true;
}