public function unite(Identifiable $object, Identifiable $old)
{
Assert::isNotNull($object->getId());
Assert::isTypelessEqual($object->getId(), $old->getId(), 'cannot merge different objects');
$query = OSQL::update($this->getTable());
foreach ($this->getProtoClass()->getPropertyList() as $property) {
$getter = $property->getGetter();
if ($property->getClassName() === null) {
$changed = $old->{$getter}() !== $object->{$getter}();
} else {
/**
* way to skip pointless update and hack for recursive
* comparsion.
**/
$changed = $old->{$getter}() !== $object->{$getter}() || $old->{$getter}() != $object->{$getter}();
}
if ($changed) {
$property->fillQuery($query, $object);
}
}
if (!$query->getFieldsCount()) {
return $object;
}
$this->targetizeUpdateQuery($query, $object);
return $this->doInject($query, $object);
}
public static function increment(DAOConnected &$object, array $fields, $refreshCurrent = true, $query = null)
{
$objectDao = $object->dao();
if ($query) {
$updateQuery = $query;
} else {
$updateQuery = OSQL::update()->setTable($objectDao->getTable())->where(Expression::eqId('id', $object));
}
$mapping = $objectDao->getProtoClass()->getMapping();
foreach ($mapping as $field => $column) {
if (isset($fields[$field])) {
$updateQuery->set($column, Expression::add($column, $fields[$field]));
}
}
$updateCount = DBPool::getByDao($objectDao)->queryCount($updateQuery);
if ($query) {
$objectDao->uncacheLists();
} else {
$objectDao->uncacheById($object->getId());
}
if ($refreshCurrent && !$query) {
$object = $objectDao->getById($object->getId());
}
return $updateCount;
}
public function unite(Identifiable $object, Identifiable $old)
{
$query = $this->getProtoClass()->fillQuery(OSQL::update($this->getTable()), $object, $old);
if (!$query->getFieldsCount()) {
return $object;
}
return $this->doInject($this->targetizeUpdateQuery($query, $object), $object);
}
public function testUpdateQueryByUserWithSameValueObject()
{
//if value object same for both main objects - we'll update all fields from value object
$contactExt = $this->spawnContactValueExt();
$oldUser = $this->spawnUserWithContactExt(array('contactExt' => $contactExt));
$user = $this->spawnUserWithContactExt(array('contactExt' => $contactExt));
$updateUser = $user->proto()->fillQuery(OSQL::update(), $user, $oldUser);
$this->assertEquals('UPDATE SET email = foo@bar.com, icq = 12345678, ' . 'phone = 89012345678, city_id = NULL, ' . 'web = https://www.github.com/, skype = github', $updateUser->toDialectString(ImaginaryDialect::me()));
}
public function testHasNoReturning()
{
$dialect = ImaginaryDialect::me();
$query = OSQL::update('test_table')->set('field1', 1)->where(Expression::eq('field1', 2))->returning('field1');
try {
$query->toDialectString($dialect);
} catch (UnimplementedFeatureException $e) {
return $this;
}
$this->fail();
}
private function checkEnumerationReferentialIntegrity(Enumeration $enumeration, $tableName)
{
$updateQueries = null;
$db = DBPool::me()->getLink();
$class = get_class($enumeration);
$ids = array();
$list = $enumeration->getObjectList();
foreach ($list as $enumerationObject) {
$ids[$enumerationObject->getId()] = $enumerationObject->getName();
}
$rows = $db->querySet(OSQL::select()->from($tableName)->multiGet('id', 'name'));
echo "\n";
foreach ($rows as $row) {
if (!isset($ids[$row['id']])) {
echo "Class '{$class}', strange id: {$row['id']} found. \n";
} else {
if ($ids[$row['id']] != $row['name']) {
echo "Class '{$class}',id: {$row['id']} sync names. \n";
$updateQueries .= OSQL::update($tableName)->set('name', $ids[$row['id']])->where(Expression::eq('id', $row['id']))->toDialectString($db->getDialect()) . ";\n";
}
unset($ids[$row['id']]);
}
}
foreach ($ids as $id => $name) {
echo "Class '{$class}', id: {$id} not present in database. \n";
}
echo $updateQueries;
return $this;
}
/**
* @return UpdateQuery
**/
private function makeMassUpdateQuery($ids)
{
$uc = $this->container;
return OSQL::update($uc->getDao()->getTable())->set($uc->getParentIdField(), null)->where(Expression::in($uc->getChildIdField(), $ids));
}
private function checkEnumerationReferentialIntegrity($enumeration, $tableName)
{
Assert::isTrue($enumeration instanceof Enumeration || $enumeration instanceof Enum, 'argument enumeation must be instacne of Enumeration or Enum! gived, "' . gettype($enumeration) . '"');
$updateQueries = null;
$db = DBPool::me()->getLink();
$class = get_class($enumeration);
$ids = array();
if ($enumeration instanceof Enumeration) {
$list = $enumeration->getList();
} elseif ($enumeration instanceof Enum) {
$list = ClassUtils::callStaticMethod($class . '::getList');
}
foreach ($list as $enumerationObject) {
$ids[$enumerationObject->getId()] = $enumerationObject->getName();
}
$rows = $db->querySet(OSQL::select()->from($tableName)->multiGet('id', 'name'));
echo "\n";
foreach ($rows as $row) {
if (!isset($ids[$row['id']])) {
echo "Class '{$class}', strange id: {$row['id']} found. \n";
} else {
if ($ids[$row['id']] != $row['name']) {
echo "Class '{$class}',id: {$row['id']} sync names. \n";
$updateQueries .= OSQL::update($tableName)->set('name', $ids[$row['id']])->where(Expression::eq('id', $row['id']))->toDialectString($db->getDialect()) . ";\n";
}
unset($ids[$row['id']]);
}
}
foreach ($ids as $id => $name) {
echo "Class '{$class}', id: {$id} not present in database. \n";
}
echo $updateQueries;
return $this;
}