PHP TableGateway::getLastInsertValue方法代码示例

 /**
  * Create a resource
  *
  * @param  mixed $data
  * @return ApiProblem|mixed
  */
 public function create($data)
 {
     $entity = new ClienteEntity();
     $data = json_decode(json_encode($data), true);
     $entity->exchangeArray($data);
     $data = $entity->getArrayCopy();
     $this->tableGateway->insert($data);
     $data['id'] = $this->tableGateway->getLastInsertValue();
     return $data;
 }

 /**
  * @param array $data
  * @return object
  */
 public function create(array $data)
 {
     $this->table->insert($data);
     $id = $this->table->getLastInsertValue();
     $entity = $this->find($id);
     if (!$entity) {
         throw new \Exception("Entity not created?");
     }
     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;
     }
 }

 /**
  * Insert node
  *
  * @param integer $level
  * @param integer $nearKey
  * @param array $data
  * @param array $filter
  * @param boolean $useTransaction
  * @return integer|string
  */
 protected function insertNode($level, $nearKey, array $data, array $filter = [], $useTransaction = true)
 {
     try {
         if ($useTransaction) {
             $this->tableGateway->getAdapter()->getDriver()->getConnection()->beginTransaction();
         }
         $this->tableGateway->update([$this->left => new Expression('IF (' . $this->left . ' > ?, ' . $this->left . ' + 2, ' . $this->left . ')', [$nearKey]), $this->right => new Expression('IF (' . $this->right . '  > ?, ' . $this->right . ' + 2, ' . $this->right . ')', [$nearKey])], [(new Predicate())->greaterThanOrEqualTo($this->right, $nearKey)] + $filter);
         $leftKey = $nearKey + 1;
         $rightKey = $nearKey + 2;
         $level = $level + 1;
         // insert a new node
         $this->tableGateway->insert([$this->left => $leftKey, $this->right => $rightKey, $this->level => $level] + $data);
         $insertId = $this->tableGateway->getLastInsertValue();
         // update parent info
         if (false !== ($parent = $this->getParentNode($leftKey, $rightKey, $level, $filter))) {
             $this->tableGateway->update([$this->parent => $parent[$this->nodeId]], [$this->nodeId => $insertId]);
         }
         if ($useTransaction) {
             $this->tableGateway->getAdapter()->getDriver()->getConnection()->commit();
         }
     } catch (Exception $e) {
         if ($useTransaction) {
             $this->tableGateway->getAdapter()->getDriver()->getConnection()->rollback();
         }
         ApplicationErrorLogger::log($e);
         return $e->getMessage();
     }
     return $insertId;
 }

 /**
  * Create easypay trade.
  * @see \Zend\Mvc\Controller\AbstractActionController::indexAction()
  */
 public function indexAction()
 {
     if ($this->verifyRequest()) {
         $this->appendTitle('收银台');
         $this->layout()->setVariable('is_cashier_page', true);
         $dbAdapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
         /**
          * Check the parameters if they are valid.
          */
         $parameters = $this->getRequest()->getQuery();
         // if merchant exsist
         // if trade|redirect_url|notify_url|sign empty
         // if price is a floating numberic
         $exception = new \Exception('Parameters is invalid!');
         if (empty(trim($parameters['trade'])) || empty(trim($parameters['redirect_url'])) || empty(trim($parameters['notify_url'])) || empty(trim($parameters['sign']))) {
             throw $exception;
         }
         if (!is_numeric(trim($parameters['price']))) {
             throw $exception;
         }
         $merchant_validator = new \Zend\Validator\Db\NoRecordExists(array('table' => 'merchant', 'field' => 'name', 'adapter' => $dbAdapter));
         if ($merchant_validator->isValid(intval($parameters['merchant']))) {
             throw $exception;
         }
         /**
          * Check if there is an exsist trade.
          */
         $GetMerchantIdByName = $this->getServiceLocator()->get('GetMerchantIdByName');
         $merchant_id = $GetMerchantIdByName($parameters['merchant']);
         $trade = $this->getTrade($merchant_id, trim($parameters['trade']));
         $trade_id = null;
         $payment_interface_type = null;
         if (!empty($trade)) {
             // Trade exsist.
             if ($trade->pay_status) {
                 throw new \Exception('Trade had payed before!');
             } else {
                 // Update the exsist trade
                 $trade->price = trim($parameters['price']);
                 $trade->redirect_url = trim($parameters['redirect_url']);
                 $trade->notify_url = trim($parameters['notify_url']);
                 $trade->save();
                 $trade_id = $trade->id;
                 $payment_interface_type = $trade->payment_interface_type;
             }
         } else {
             // Trade not exsist.
             // Create a new trade
             $tableGateway = new TableGateway('trade', $dbAdapter, new Feature\RowGatewayFeature('id'));
             $tableGateway->insert(array('merchant_id' => $merchant_id, 'merchant_trade_id' => trim($parameters['trade']), 'redirect_url' => trim($parameters['redirect_url']), 'notify_url' => trim($parameters['notify_url']), 'price' => trim($parameters['price']), 'pay_status' => 0, 'create_time' => date('Y-n-j H:i:s', time())));
             $trade_id = $tableGateway->getLastInsertValue();
         }
         return array('price' => trim($parameters['price']), 'merchant' => $parameters['merchant'], 'trade' => trim($parameters['trade']), 'selected_payment' => $payment_interface_type);
     } else {
         throw new \Exception('Bad Reaquest !');
     }
 }

 /**
  * Saves the given rating to the storage system.
  *
  * @param Rating $rating The rating to persist.
  */
 public function persist(Rating $rating)
 {
     if ($rating->getId()) {
         $this->gateway->update(array('typeId' => $rating->getTypeId(), 'userId' => $rating->getUserId(), 'rating' => $rating->getRating()), array('id' => $rating->getId()));
     } else {
         $this->gateway->insert(array('typeId' => $rating->getTypeId(), 'userId' => $rating->getUserId(), 'rating' => $rating->getRating()));
         $id = $this->gateway->getLastInsertValue();
         $rating->setId($id);
     }
 }

 /**
  * Adds a data
  */
 public function insert()
 {
     $id = $this->table->insert($this->data);
     if (is_null($id)) {
         if (array_key_exists('firephp', $GLOBALS)) {
             $GLOBALS['firephp']->error('Error on query ' . $this->table->getSql()->getSqlPlatform()->getSqlString($this->table->getAdapter()->getPlatform()));
         }
         throw new Exception('Error on query ' . $this->table->getSql()->getSqlPlatform()->getSqlString($this->table->getAdapter()->getPlatform()));
     }
     $this->data[$this->primary] = $this->table->getLastInsertValue();
 }

 /**
  * Сохраняет объект в таблице
  *
  * @param EntityInterface $object
  * @throws \Exception
  */
 public function save(EntityInterface $object)
 {
     $data = array();
     foreach ($this->fields as $field) {
         $data[$field] = $object->{$field};
     }
     $id = $object->getKeyValue();
     if (null === $id) {
         $this->tableGateway->insert($data);
         $object->{$object->getKeyName()} = $this->tableGateway->getLastInsertValue();
     } else {
         if ($this->getByKey($id, $object->getKeyName())) {
             $this->tableGateway->update($data, array($object->getKeyName() => $id));
         } else {
             throw new \Exception('row with ' . $id . ' id does not exist');
         }
     }
 }

 /**
  * {@inheritdoc}
  *
  * {@inheritdoc}
  */
 public function create($itemData, $rewriteIfExist = false)
 {
     $identifier = $this->getIdentifier();
     $adapter = $this->dbTable->getAdapter();
     // begin Transaction
     $errorMsg = 'Can\'t start insert transaction';
     $adapter->getDriver()->getConnection()->beginTransaction();
     try {
         if (isset($itemData[$identifier]) && $rewriteIfExist) {
             $errorMsg = 'Can\'t delete item with "id" = ' . $itemData[$identifier];
             $this->dbTable->delete(array($identifier => $itemData[$identifier]));
         }
         $errorMsg = 'Can\'t insert item';
         $rowsCount = $this->dbTable->insert($itemData);
         $adapter->getDriver()->getConnection()->commit();
     } catch (\Exception $e) {
         $adapter->getDriver()->getConnection()->rollback();
         throw new DataStoresException($errorMsg, 0, $e);
     }
     $id = $this->dbTable->getLastInsertValue();
     $newItem = array_merge(array($identifier => $id), $itemData);
     return $newItem;
 }

 protected function _create($itemData, $rewriteIfExist = false)
 {
     $identifier = $this->getIdentifier();
     if ($rewriteIfExist) {
         if (isset($itemData[$identifier])) {
             $this->deleteIfExist($itemData, $identifier);
         } else {
             if (isset($itemData[0]) && isset($itemData[0][$identifier])) {
                 foreach ($itemData as $item) {
                     $this->deleteIfExist($item, $identifier);
                 }
             }
         }
     }
     $this->dbTable->insert($itemData);
     if (!isset($itemData[$identifier])) {
         $id = $this->dbTable->getLastInsertValue();
         $newItem = $this->read($id);
     } else {
         $newItem = $itemData;
     }
     return $newItem;
 }

 /**
  * @covers Zend\Db\TableGateway\TableGateway::getLastInsertValue
  */
 public function testGetLastInsertValue()
 {
     $this->table->insert(array('foo' => 'bar'));
     $this->assertEquals(10, $this->table->getLastInsertValue());
 }

 public function save($version)
 {
     $this->tableGateway->insert(['version' => $version]);
     return $this->tableGateway->getLastInsertValue();
 }

 public function index05Action()
 {
     $table = "user";
     $adapter = $this->getServiceLocator()->get("db_books");
     $tableGateway = new TableGateway($table, $adapter);
     $insertObj = new Insert("user");
     $insertObj->columns(array("name", "email"))->values(array("name" => "Armasky", "email" => "ak@hotmail.com"));
     $tableGateway->insertWith($insertObj);
     //last record inserted
     echo $tableGateway->getLastInsertValue();
     return false;
 }

 public function addSimpleData($table, $data)
 {
     $tableGateway = new TableGateway($table, $this->dbAdapter);
     $tableGateway->insert($data);
     return $tableGateway->getLastInsertValue();
 }