PHP TableGateway::update方法代碼示例

 /**
  * {@inheritDoc}
  */
 protected function doUpdateModel($model)
 {
     if ($id = $this->getModelId($model)) {
         $this->tableGateway->update($this->tableGateway->getResultSetPrototype()->getHydrator()->extract($model), array("{$this->idField} = ?" => $id));
     } else {
         $this->tableGateway->insert($this->tableGateway->getResultSetPrototype()->getHydrator()->extract($model));
     }
 }

 public function update($id, array $data)
 {
     $this->table->update($data, array($this->identifierName => $id));
     $entity = $this->find($id);
     if (!$entity) {
         throw new \Exception("Entity not updated?");
     }
     return $entity;
 }

 /**
  * @param AbstractEntity $entity
  * @return $this
  */
 public function persist(AbstractEntity $entity)
 {
     $data = $this->hydrator->extract($entity);
     if ($this->hasIdentity($entity)) {
         $this->gateway->update($data, ['id' => $entity->getId()]);
     } else {
         $this->gateway->insert($data);
         $entity->setId($this->gateway->getLastInsertValue());
     }
     return $this;
 }

 /**
  * @param AbstractModel $model
  */
 protected function internalSave(AbstractModel $model)
 {
     $pKey = $this->getPrimaryKey();
     if (isset($model->id)) {
         $this->tableGateway->update($model->toArray(), [$pKey => $model->{$pKey}]);
     } else {
         $this->tableGateway->insert($model->toArray());
         $id = $this->tableGateway->getLastInsertValue();
         $model->{$pKey} = $id;
     }
 }

 public function saveCategory(Category $category)
 {
     $data = array('id_category' => $category->id_category, 'name' => $category->name, 'slug' => $category->slug);
     $id = (int) $category->id_category;
     if ($id == 0) {
         $this->tableGateway->insert($data);
     } elseif ($this->getCategoryById($id)) {
         $this->tableGateway->update($data, array('id_category = ?' => $id));
     } else {
         throw new \Exception('Form id does not exist');
     }
 }

 /**
  * Saves an account to the db. If the id exists the given dataset will be updated
  * @param \Account\Model\Account $account
  *
  * @throws \Exception
  */
 public function saveWarlog(Warlog $warlog)
 {
     $data = ['wins' => $warlog->getWins(), 'losses' => $warlog->getLosses(), 'draws' => $warlog->getDraws()];
     if (!$warlog->getId()) {
         $this->tableGateway->insert($data);
     } else {
         if ($this->getWarlog()) {
             $this->tableGateway->update($data, ['id' => $warlog->getId()]);
         } else {
             throw new \Exception('Account id does not exist');
         }
     }
 }

 public function saveForm(Form $form)
 {
     $data = array('name' => $form->name);
     $id = (int) $form->id;
     if ($id == 0) {
         $this->tableGateway->insert($data);
     } else {
         if ($this->getForm($id)) {
             $this->tableGateway->update($data, array('id' => $id));
         } else {
             throw new \Exception('Form id does not exist');
         }
     }
 }

 /**
  * Saves the given NewsCategory object to the db
  *
  *  @param NewsCategory
  *  @throws \Exception
  */
 public function saveNewsCategory(NewsCategory $nc)
 {
     $data = ['name' => $nc->getName()];
     $id = (int) $nc->getId();
     if ($id == 0) {
         $this->tableGateway->insert($data);
     } else {
         if ($this->getNewsCategoryBy(['id' => $id])) {
             $this->tableGateway->update($data, ['id' => $id]);
         } else {
             throw new \Ȩxception('NewsCategory id does not exist');
         }
     }
 }

 /**
  * Saves the given object ot the db
  * @param Warstatus $warstatus
  * @throws \Exception
  */
 public function saveWarstatus(Warstatus $warstatus)
 {
     $data = $warstatus->getArrayCopy();
     if ($warstatus->getId() == 0) {
         throw new \Exception('Id needed to save a warstatus');
     } else {
         if ($this->getWarstatus((int) $warstatus->getId())) {
             $this->tableGateway->update($data, ['id' => (int) $warstatus->getId()]);
         } else {
             $data['id'] = $warstatus->getId();
             $this->tableGateway->insert($data);
         }
     }
 }

 /**
  * Saves the given media object to the db
  *
  * @param \Media\Model\Media $media
  *
  * @throws \Exception
  */
 public function saveMedia(Media $media)
 {
     $data = ['account_id' => $media->getAccountId(), 'title' => $media->getTitle(), 'url' => $media->getUrl(), 'date_posted' => $media->getDatePosted()];
     $id = (int) $media->getId();
     if ($id == 0) {
         $this->tableGateway->insert($data);
     } else {
         if ($this->getMedia($id)) {
             $this->tableGateway->update($data, ['id' => $id]);
         } else {
             throw new \Exception('Media id does not exist');
         }
     }
 }

 public function saveCore(Core $core)
 {
     $data = array('name' => $core->name);
     $id = (int) $core->id;
     if ($id == 0) {
         $this->tableGateway->insert($data);
     } else {
         if ($this->getCore($id)) {
             $data['last_updated'] = $core->lastUpdated;
             $this->tableGateway->update($data, array('id' => $id));
         } else {
             throw new \Exception('Core id does not exist');
         }
     }
 }

 protected function _update($itemData, $createIfAbsent = false)
 {
     $adapter = $this->dbTable->getAdapter();
     $identifier = $this->getIdentifier();
     if (!isset($itemData[$identifier])) {
         throw new DataStoreException('Item must has primary key');
     }
     $id = $itemData[$identifier];
     $this->checkIdentifierType($id);
     $queryStr = 'SELECT ' . Select::SQL_STAR . ' FROM ' . $adapter->platform->quoteIdentifier($this->dbTable->getTable()) . ' WHERE ' . $adapter->platform->quoteIdentifier($identifier) . ' = ?' . ' FOR UPDATE';
     //is row with this index exist?
     $rowset = $adapter->query($queryStr, array($id));
     $isExist = !is_null($rowset->current());
     $result = [];
     switch (true) {
         case !$isExist && !$createIfAbsent:
             throw new DataStoreException('Can\'t update item with "id" = ' . $id);
         case !$isExist && $createIfAbsent:
             $this->dbTable->insert($itemData);
             $result = $itemData;
             break;
         case $isExist:
             unset($itemData[$identifier]);
             $this->dbTable->update($itemData, array($identifier => $id));
             $rowset = $adapter->query($queryStr, array($id));
             $result = $rowset->current()->getArrayCopy();
             break;
     }
     return $result;
 }

 public function update($set, $where)
 {
     if (!$where) {
         return [];
     }
     return $this->tableGateway->update($set, $where);
 }

 public function updateSales($data = null)
 {
     $id = $data['id'];
     $data['sales_markup'] = preg_replace("|[\\s]+|s", " ", $data['sales_markup']);
     $data['sales_active'] = $data['sales_active'] == 'on' ? '1' : '0';
     parent::update($data, array('id' => $id));
 }

 public function updateanywhere($mytable, array $data, $where)
 {
     $db = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
     $table = new TableGateway($mytable, $db);
     $results = $table->update($data, $where);
     return 1;
 }