/**
* REMOVE ENTITY
*
* @param \Berie\ORM\Entity $entity
*
* @return \Berie\ORM\Entity
*/
public function remove(\Berie\ORM\Manager\Entity $entity)
{
$table = $entity->getPref()['params']['table'];
$manager = new Manager($this->connect, $table);
$manager->removeEntity($entity);
return $entity;
}
function saveEntity(\Berie\ORM\Manager\Entity $entity)
{
$id = $entity->getPref()['params']['id'];
$table = $entity->getPref()['params']['table'];
$data = (new \Berie\ORM\DataType\Factory())->managerPreSave($entity);
if (!empty($id)) {
(new \Berie\ORM\Builder($this->database))->update($table)->set($data)->where('id', $id)->getQuery();
} else {
unset($data['id']);
(new \Berie\ORM\Builder($this->database))->insert($table)->set($data)->getQuery();
$id = $this->database->lastInsertId();
$entity->set('id', $id);
$entity->setPreference('id', $id);
}
return $entity;
}
public function managerPreSave(\Berie\ORM\Manager\Entity $entity)
{
$data = $entity->getData();
$dataType = $entity->getPref()["dataType"];
foreach ($data as $key => $value) {
switch ($dataType[$key]["type"]["glob"]) {
case "STRING":
if (is_array($value)) {
if ($dataType[$key]["type"]["sub"] === "TINYTEXT" || $dataType[$key]["type"]["sub"] === "TEXT" || $dataType[$key]["type"]["sub"] === "MEDIUMTEXT" || $dataType[$key]["type"]["sub"] === "LONGTEXT") {
$data[$key] = @serialize($value);
} else {
// exception serialize array
}
}
break;
case "DATETIME":
if (is_object($value) && get_class($value) === "DateTime") {
if ($dataType[$key]["type"]["sub"] === "DATE") {
$data[$key] = $value->format("Y-m-d");
} elseif ($dataType[$key]["type"]["sub"] === "DATETIME") {
$data[$key] = $value->format("Y-m-d H:i:s");
} elseif ($dataType[$key]["type"]["sub"] === "TIMESTAMP") {
$data[$key] = $value->format("U");
} elseif ($dataType[$key]["type"]["sub"] === "TIME") {
$data[$key] = $value->format("H:i:s");
} elseif ($dataType[$key]["type"]["sub"] === "YEAR") {
$data[$key] = $value->format("Y");
}
} else {
if (\DateTime::createFromFormat("Y-m-d", $value) || \DateTime::createFromFormat("Y-m-d H:i:s", $value) || \DateTime::createFromFormat("U", $value) || \DateTime::createFromFormat("H:i:s", $value) || \DateTime::createFromFormat("Y", $value)) {
$data[$key] = $value;
} else {
// exception not datetime
}
}
break;
}
}
return $data;
}
