PHP Insert::into方法代码示例

 /**
  * Sets up the fixture, for example, opens a network connection.
  * This method is called before a test is executed.
  *
  * @return void
  */
 protected function setUp()
 {
     $this->view = ViewModel::fromArray(array('name' => 'View Name', 'identifier' => 'View identifier', 'description' => 'View Description', 'content' => 'View Content'));
     $this->view->save();
     $this->layout = LayoutModel::fromArray(array('name' => 'Layout Name', 'identifier' => 'Layout identifier', 'description' => 'Layout Description', 'content' => 'Layout Content'));
     $this->layout->save();
     $this->user = UserModel::fromArray(array('lastname' => 'User test', 'firstname' => 'User test', 'email' => 'pierre.rambaud86@gmail.com', 'login' => 'test', 'user_acl_role_id' => 1));
     $this->user->setPassword('test');
     $this->user->save();
     $this->object = Model::fromArray(array('name' => 'Document Type Name', 'description' => 'Document Type description', 'icon_id' => 1, 'defaultview_id' => $this->view->getId(), 'user_id' => $this->user->getId()));
     $this->object->save();
     $this->documentTypeChildren = Model::fromArray(array('name' => 'Document Type children Name', 'description' => 'Document Type children description', 'icon_id' => 1, 'defaultview_id' => $this->view->getId(), 'user_id' => $this->user->getId()));
     $this->documentTypeChildren->save();
     $insert = new Insert();
     $insert->into('document_type_dependency')->values(array('parent_id' => $this->object->getId(), 'children_id' => $this->documentTypeChildren->getId()));
     $this->object->execute($insert);
     $insert = new Insert();
     $insert->into('document_type_view')->values(array('view_id' => $this->view->getId(), 'document_type_id' => $this->object->getId()));
     $this->object->execute($insert);
 }

 /**
  * @covers Zend\Db\Sql\Insert::getSqlString
  * @todo   Implement testGetSqlString().
  */
 public function testGetSqlString()
 {
     $this->insert->into('foo')->values(array('bar' => 'baz', 'boo' => new Expression('NOW()')));
     $this->assertEquals('INSERT INTO "foo" ("bar", "boo") VALUES (\'baz\', NOW())', $this->insert->getSqlString());
 }

 /**
  * @todo add $columns support
  *
  * @param Insert $insert
  * @return int
  * @throws Exception\RuntimeException
  */
 protected function executeInsert(Insert $insert)
 {
     $insertState = $insert->getRawState();
     if ($insertState['table'] != $this->table) {
         throw new Exception\RuntimeException('The table name of the provided Insert object must match that of the table');
     }
     // apply preInsert features
     $this->featureSet->apply(EventFeatureEventsInterface::EVENT_PRE_INSERT, [$insert]);
     // Most RDBMS solutions do not allow using table aliases in INSERTs
     // See https://github.com/zendframework/zf2/issues/7311
     $unaliasedTable = false;
     if (is_array($insertState['table'])) {
         $tableData = array_values($insertState['table']);
         $unaliasedTable = array_shift($tableData);
         $insert->into($unaliasedTable);
     }
     $statement = $this->sql->prepareStatementForSqlObject($insert);
     $result = $statement->execute();
     $this->lastInsertValue = $this->adapter->getDriver()->getConnection()->getLastGeneratedValue();
     // apply postInsert features
     $this->featureSet->apply(EventFeatureEventsInterface::EVENT_POST_INSERT, [$statement, $result]);
     // Reset original table information in Insert instance, if necessary
     if ($unaliasedTable) {
         $insert->into($insertState['table']);
     }
     return $result->getAffectedRows();
 }

 /**
  * Build a sql object to insert a contact request record
  *
  * @param ContactEntity $contact
  * @return Insert
  */
 protected function contactInsert(ContactEntity $contact)
 {
     $insert = new Insert();
     $insert->into('contact_request')->values(['name' => $contact->getName(), 'email' => $contact->getEmail(), 'message' => $contact->getMessage()]);
     return $insert;
 }

 /**
  * @group ZF2-536
  */
 public function testValuesMerge()
 {
     $this->insert->into('foo')->values(array('bar' => 'baz', 'boo' => new Expression('NOW()'), 'bam' => null));
     $this->insert->into('foo')->values(array('qux' => 100), Insert::VALUES_MERGE);
     $this->assertEquals('INSERT INTO "foo" ("bar", "boo", "bam", "qux") VALUES (\'baz\', NOW(), NULL, \'100\')', $this->insert->getSqlString(new TrustingSql92Platform()));
 }

 /**
  * Get a sql object to insert a new blog post
  *
  * @param PostEntity $post
  * @return Insert
  */
 protected function getPostInsert(PostEntity $post)
 {
     $insert = new Insert();
     $insert->into(new TableIdentifier('blog_post'))->values(['title' => $post->getTitle(), 'author' => $post->getAuthor(), 'content' => $post->getContent(), 'is_visible' => $post->getIsVisible()]);
     return $insert;
 }

 /**
  * Build a sql object to insert a new blog post asset
  *
  * @param AssetEntity $asset
  * @return Insert
  */
 protected function assetInsert(AssetEntity $asset)
 {
     $insert = new Insert();
     $insert->into(new TableIdentifier('blog_asset'))->values(['blog_post_id' => $asset->getBlogPostId(), 'directory' => $asset->getDirectory(), 'baseurl' => $asset->getBaseurl(), 'filename' => $asset->getFilename()]);
     return $insert;
 }

 /**
  * Install module
  *
  * @param ModuleManager $moduleManager Module manager
  * @param string        $moduleName    Module Name
  *
  * @return boolean|integer
  */
 public static function install(ModuleManager $moduleManager, $moduleName)
 {
     try {
         $object = $moduleManager->loadModule($moduleName);
     } catch (\Exception $e) {
         //Don't care
     }
     if (empty($object) or !$object->install()) {
         return false;
     }
     $model = new Model();
     $model->setName($moduleName);
     $model->save();
     $select = new Sql\Select();
     $select->from('user_acl_resource')->columns(array('id'))->where->equalTo('resource', 'modules');
     $insert = new Sql\Insert();
     $insert->into('user_acl_permission')->values(array('permission' => $moduleName, 'user_acl_resource_id' => $model->fetchOne($select)));
     $model->execute($insert);
     return $model->getId();
 }

 /**
  * Save properties
  *
  * @return boolean
  */
 public function save()
 {
     $this->events()->trigger(__CLASS__, 'before.save', $this);
     if (!empty($this->data['document_type_id'])) {
         $this->delete();
         $insert = new Insert();
         $insert->into('document_type_view');
         foreach ($this->getElements() as $view) {
             $insert->values(array('document_type_id' => $this->getDocumentTypeId(), 'view_id' => $view->getId()));
             $this->execute($insert);
         }
         $this->events()->trigger(__CLASS__, 'after.save', $this);
         return true;
     }
     $this->events()->trigger(__CLASS__, 'after.save.failed', $this);
     return false;
 }

 /**
  * Save document type model
  *
  * @return integer
  */
 public function save()
 {
     $this->events()->trigger(__CLASS__, 'before.save', $this);
     $arraySave = array('name' => $this->getName(), 'updated_at' => new Expression('NOW()'), 'description' => $this->getDescription(), 'icon_id' => $this->getIconId(), 'default_view_id' => $this->getDefaultViewId(), 'user_id' => $this->getUserId());
     try {
         $id = $this->getId();
         if (empty($id)) {
             $arraySave['created_at'] = new Expression('NOW()');
             $this->insert($arraySave);
             $this->setId($this->getLastInsertId());
         } else {
             $this->update($arraySave, array('id' => (int) $this->getId()));
         }
         $delete = new Sql\Delete();
         $delete->from('document_type_view');
         $delete->where(array('document_type_id' => (int) $this->getId()));
         $this->execute($delete);
         foreach ($this->views as $viewId) {
             if (empty($viewId)) {
                 continue;
             }
             $insert = new Sql\Insert();
             $insert->into('document_type_view')->values(array('document_type_id' => $this->getId(), 'view_id' => $viewId));
             $this->execute($insert);
         }
         $delete = new Sql\Delete();
         $delete->from('document_type_dependency');
         $delete->where->equalTo('parent_id', (int) $this->getId());
         $this->execute($delete);
         $dependencies = $this->getDependencies();
         if (!empty($dependencies)) {
             foreach ($dependencies as $childrenId) {
                 $insert = new Sql\Insert();
                 $insert->into('document_type_dependency')->values(array('parent_id' => $this->getId(), 'children_id' => $childrenId));
                 $this->execute($insert);
             }
         }
         $this->events()->trigger(__CLASS__, 'after.save', $this);
         return $this->getId();
     } catch (\Exception $e) {
         $this->events()->trigger(__CLASS__, 'after.save.failed', $this);
         throw new \Gc\Exception($e->getMessage(), $e->getCode(), $e);
     }
 }

 /**
  * Set config value
  *
  * @param string $source       Source
  * @param array  $destinations Destinations
  *
  * @return boolean
  */
 public function setValue($source, array $destinations)
 {
     if (is_numeric($source)) {
         $row = $this->fetchRow($this->select(array('id' => $source)));
         if (empty($row)) {
             return false;
         }
         $sourceId = $row['id'];
     } else {
         $row = $this->fetchRow($this->select(array('source' => $source)));
         if (!empty($row)) {
             $sourceId = $row['id'];
         } else {
             $this->insert(array('source' => $source));
             $sourceId = $this->getLastInsertId();
         }
     }
     foreach ($destinations as $destination) {
         if (empty($destination['locale']) or empty($destination['value'])) {
             continue;
         }
         $select = new Select();
         $select->from('core_translate_locale');
         $select->where->equalTo('locale', $destination['locale']);
         $select->where->equalTo('core_translate_id', $sourceId);
         $row = $this->fetchRow($select);
         if (!empty($row)) {
             $destination['dst_id'] = $row['id'];
         }
         if (!empty($destination['dst_id'])) {
             $update = new Update('core_translate_locale');
             $update->set(array('destination' => $destination['value'], 'locale' => $destination['locale']));
             $update->where->equalTo('id', $destination['dst_id']);
             $this->execute($update);
         } else {
             $insert = new Insert();
             $insert->into('core_translate_locale')->values(array('destination' => $destination['value'], 'locale' => $destination['locale'], 'core_translate_id' => $sourceId));
             $this->execute($insert);
         }
     }
     return true;
 }

 /**
  * Get url id
  *
  * @param string $requestUri Request URI
  * @param string $referer    Referer
  *
  * @return integer
  */
 public function getUrlId($requestUri, $referer)
 {
     $select = new Select();
     $select->from('log_url_info')->where->equalTo('url', $requestUri);
     if (is_null($referer)) {
         $select->where->isNull('referer');
     } else {
         $select->where->equalTo('referer', $referer);
     }
     $urlInfo = $this->fetchRow($select);
     if (!empty($urlInfo['id'])) {
         $urlId = $urlInfo['id'];
     } else {
         $insert = new Insert();
         $insert->into('log_url_info')->values(array('url' => $requestUri, 'referer' => $referer));
         $this->execute($insert);
         $urlId = $this->getLastInsertId('log_url_info');
     }
     return $urlId;
 }