public function save(Entity $entity) { $data = array('name' => $entity->getName(), 'email' => $entity->getEmail(), 'phone' => $entity->getPhone(), 'message' => $entity->getMessage(), 'date' => $entity->getDate()); if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('username' => $entity->getUsername(), 'password' => $entity->getPassword()); if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('product_id' => $entity->getProductId(), 'date' => $entity->getDate(), 'name' => $entity->getName(), 'email' => $entity->getEmail(), 'phone' => $entity->getPhone(), 'is_complete' => $entity->getIsComplete(), 'user_id' => $entity->getUserId()); if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('title' => $entity->getTitle(), 'content' => $entity->getContent()); if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('name' => $entity->getName(), 'content' => $entity->getContent(), 'date' => date('Y-m-d H:i:s', strtotime($entity->getDate())), 'news_id' => $this->news_id); if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
protected function arrayToEntity(array $array) { $entity = new Entity(); $entity->setId($array['id']); $entity->setIdentifier($array['identifier']); $entity->setReceived($array['received']); $entity->setSend($array['send']); $entity->setSuccess($array['success']); return $entity; }
public function save(Entity $entity) { $data = array('product_id' => $entity->getProductId()); if ($entity->getImage() != '') { $data['image'] = $entity->getImage(); } if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('title' => $entity->getTitle(), 'description' => $entity->getDescription(), 'price' => $entity->getPrice()); if ($entity->getImage() != '') { $data['image'] = $entity->getImage(); } if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function save(Entity $entity) { $data = array('title' => $entity->getTitle(), 'content' => $entity->getContent(), 'author' => $entity->getAuthor(), 'date' => date('Y-m-d H:i:s', strtotime($entity->getDate()))); if ($entity->getImage() != '') { $data['image'] = $entity->getImage(); } if ($entity->getId() > 0) { $this->db->update($this->table, $data, $entity->getId()); } else { $entity->setId($this->db->insert($this->table, $data)); } }
public function findWhere($keys, $values) { $tag = "EntityDAO: findWhere()"; Log::notice("{$tag}: ({$keys}, {$values})"); $blueprint = $this->blueprint; $timezone_offset = $this->timezone_offset_select; $blueprintKey = $this->tableName(); $query = new EntityQuery($blueprint, $timezone_offset); if (!is_array($keys) && !is_array($values)) { // convert non-array arguments into single element arrays $keys = array($keys); $values = array($values); } else { if (is_array($keys) && !is_array($values) || count($keys) != count($values)) { throw new Exception("Length of (key,value) arguments do not match"); } } try { for ($i = 0; $i < count($keys); $i++) { $key = $keys[$i]; $value = $values[$i]; $field = $blueprint->get($key); switch ($field->getDataType()) { case "int": $query->where("{$blueprintKey}.{$key}={$value}"); break; case "datetime": case "time": $query->where("{$blueprintKey}.{$key}=CONVERT_TZ('{$value}', '{$timezone_offset}', '" . BPTimezone::UTC . "')"); break; default: $query->where("{$blueprintKey}.{$key}='{$value}'"); break; } } } catch (Exception $e) { Log::error("{$tag}: Field [{$key}] is not defined by [" . $blueprint->getKey() . "]"); throw $e; } try { $sql = new DatabaseQuery($query->toString()); $sql->doQuery(); $matches = array(); $num_rows = $sql->get_num_rows(); Log::debug("{$tag}: Found {$num_rows} matches"); for ($i = 0; $i < $sql->get_num_rows(); $i++) { $row = $sql->get_next_row(); $entity = new Entity($blueprint); $entity->setId($row->id); $entity->setModified($row->modified); foreach ($blueprint->fields() as $field) { $key = $field->getKey(); $value = $row->{$key}; if ($field->isForeignKey()) { $foreignValueColumn = str_replace(".", "_", $field->getForeignValue()); $foreignValue = $row->{$foreignValueColumn}; $entity->setForeignValue($key, $foreignValue); } switch ($field->getDataType()) { case "binary": if (get_magic_quotes_gpc()) { $value = stripslashes($str); } $lengthKey = $key . "_length"; $length = $row->{$lengthKey}; $entity->length($key, $length); break; } $entity->set($key, $value); } $matches[] = $entity; } return $matches; } catch (Exception $e) { Log::error("{$tag}: [" . $sql->err_code . "] " . $sql->err_message); throw $e; } }
public function relationshipProvider() { $child = new Child(); $child->setId($this->childId); $child->setTheirField($this->childTheirField); $insertEntity = new Entity(); $insertEntity->setChild($child); $updateEntity = new Entity(); $updateEntity->setId(9); $updateEntity->setChild($child); return [[[$insertEntity], ["Silktide\\Reposition\\Sql\\Test\\QueryInterpreter\\Type\\Child" => [EntityMetadata::METADATA_RELATIONSHIP_TYPE => EntityMetadata::RELATIONSHIP_TYPE_ONE_TO_ONE, EntityMetadata::METADATA_RELATIONSHIP_PROPERTY => "child", EntityMetadata::METADATA_RELATIONSHIP_OUR_FIELD => "child_id", EntityMetadata::METADATA_RELATIONSHIP_THEIR_FIELD => null]], "INSERT INTO `{$this->collection}` (`field_1`, `child_id`) VALUES (:value_0, :value_1)", ["value_1" => $this->childId]], [[$insertEntity], [[EntityMetadata::METADATA_RELATIONSHIP_TYPE => EntityMetadata::RELATIONSHIP_TYPE_ONE_TO_ONE, EntityMetadata::METADATA_RELATIONSHIP_PROPERTY => "child", EntityMetadata::METADATA_RELATIONSHIP_OUR_FIELD => "", EntityMetadata::METADATA_RELATIONSHIP_THEIR_FIELD => null]], "INSERT INTO `{$this->collection}` (`field_1`) VALUES (:value_0)"], [[$insertEntity], [[EntityMetadata::METADATA_RELATIONSHIP_TYPE => EntityMetadata::RELATIONSHIP_TYPE_ONE_TO_MANY, EntityMetadata::METADATA_RELATIONSHIP_PROPERTY => "child", EntityMetadata::METADATA_RELATIONSHIP_THEIR_FIELD => "whatever"]], "INSERT INTO `{$this->collection}` (`field_1`) VALUES (:value_0)"], [[$insertEntity], [[EntityMetadata::METADATA_RELATIONSHIP_TYPE => EntityMetadata::RELATIONSHIP_TYPE_ONE_TO_ONE, EntityMetadata::METADATA_RELATIONSHIP_PROPERTY => "child", EntityMetadata::METADATA_RELATIONSHIP_OUR_FIELD => "child_id", EntityMetadata::METADATA_RELATIONSHIP_THEIR_FIELD => "their_field"]], "INSERT INTO `{$this->collection}` (`field_1`, `child_id`) VALUES (:value_0, :value_1)", ["value_1" => $this->childTheirField]], [[$updateEntity], [[EntityMetadata::METADATA_RELATIONSHIP_TYPE => EntityMetadata::RELATIONSHIP_TYPE_ONE_TO_ONE, EntityMetadata::METADATA_RELATIONSHIP_PROPERTY => "child", EntityMetadata::METADATA_RELATIONSHIP_OUR_FIELD => "child_id", EntityMetadata::METADATA_RELATIONSHIP_THEIR_FIELD => null]], "UPDATE `{$this->collection}` SET `field_1` = :value_0, `child_id` = :value_1 WHERE `id` = :searchId", ["value_1" => $this->childId]]]; }