PHP Zend_Db_Select::assemble方法代碼示例

 /**
  * Performs a validation on the select query before passing back to the parent class.
  * Ensures that only columns from the primary Zend_Db_Table are returned in the result.
  *
  * @return string|null This object as a SELECT string (or null if a string cannot be produced)
  */
 public function assemble()
 {
     $fields = $this->getPart(Zend_Db_Table_Select::COLUMNS);
     $primary = $this->_info[Zend_Db_Table_Abstract::NAME];
     $schema = $this->_info[Zend_Db_Table_Abstract::SCHEMA];
     if (count($this->_parts[self::UNION]) == 0) {
         // If no fields are specified we assume all fields from primary table
         if (!count($fields)) {
             $this->from($primary, self::SQL_WILDCARD, $schema);
             $fields = $this->getPart(Zend_Db_Table_Select::COLUMNS);
         }
         $from = $this->getPart(Zend_Db_Table_Select::FROM);
         if ($this->_integrityCheck !== false) {
             foreach ($fields as $columnEntry) {
                 list($table, $column) = $columnEntry;
                 // Check each column to ensure it only references the primary table
                 if ($column) {
                     if (!isset($from[$table]) || $from[$table]['tableName'] != $primary) {
                         require_once PHP_LIBRARY_PATH . 'Zend/Db/Table/Select/Exception.php';
                         throw new Zend_Db_Table_Select_Exception('Select query cannot join with another table');
                     }
                 }
             }
         }
     }
     return parent::assemble();
 }

 /**
  * Constructor.
  *
  * @param Zend_Db_Select $select The select query
  */
 public function __construct(Zend_Db_Select $select)
 {
     $this->_select = $select;
     $this->_cacheIdentifier = md5($select->assemble());
 }

 private function setup2(Zend_Db_Select $select, $columes = null)
 {
     $conn = $select->getAdapter();
     $this->setConnection($conn);
     $extFields = array();
     if ($columes == null) {
         $sql = $select->assemble();
         $db = $this->conn;
         $columes = $this->_getColumns($sql, $db);
     }
     foreach ($columes as $field) {
         $extFields[]['field'] = $field;
     }
     $this->_setFields($extFields);
     $this->strTable = " (   {$sql}    ) AS tableName ";
 }

 /**
  * @group ZF-6989
  */
 public function testCacheIdentifierIsHashOfAssembledSelect()
 {
     $dbAdapter = $this->getMockForAbstractClass('Zend_Db_Adapter_Abstract', array(''), '', false);
     $select = new Zend_Db_Select($dbAdapter);
     $select->from('ZF_6989');
     $paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($select);
     $this->assertSame(md5($select->assemble()), $paginatorAdapter->getCacheIdentifier(), 'Cache identifier incorrect!');
 }

 /**
  * @param \Zend_Db_Select $select
  * @param array $params
  * @return \Generator
  * @throws Exception
  */
 public function fetchEach(\Zend_Db_Select $select, $params = [])
 {
     $sql = $select->assemble();
     $statement = $this->getReadAdapter()->query($sql, $params);
     while ($record = $statement->fetch()) {
         (yield $record);
     }
 }

 /**
  * Removes a all cache entries matching given constraint.
  *
  * @param Zend_Db_Select $select Select statement to use as subselect
  *  The statement MUST return a list of document ids
  * @return void
  */
 public function removeAllEntriesWhereSubSelect($select)
 {
     $where = 'document_id IN (' . $select->assemble() . ')';
     $this->_table->delete($where);
 }

 /**
  * @return String
  */
 public function assemble()
 {
     return $this->_selector->assemble();
 }

 private function setup2(Zend_Db_Select $select, $columes = null)
 {
     $conn = $select->getAdapter();
     $this->setConnection($conn);
     if ($conn instanceof Zend_Db_Adapter_Pdo_Mysql) {
         $this->_drivertype = 'mysql';
     }
     $extFields = array();
     if ($columes == null) {
         $sql = $select->assemble();
         $db = $this->conn;
         if ($db instanceof Zend_Db_Adapter_Sqlsrv) {
             $columes = $this->_getSqlsrvColumns($sql, $db);
         } elseif ($db instanceof Zend_Db_Adapter_Pdo_Mysql) {
             $columes = $this->_getMysqlColumns($sql, $db);
         }
     }
     foreach ($columes as $field) {
         $extFields[]['field'] = $field;
     }
     $this->_setFields($extFields);
     $this->strTable = " (   {$sql}    ) AS tableName ";
 }

 /**
  * Add a subselect as constraint
  * 
  * @param Zend_Db_Select $select A select object used as subselect in query.
  * The subquery must return a list of document ids.
  * 
  * @return Opus_DocumentFinder Fluent interface.
  */
 public function setSubSelectNotExists($select)
 {
     $this->select->where(' NOT d.id IN (' . $select->assemble() . ')');
     return $this;
 }

 /**
  * Performs a validation on the select query before passing back to the parent class.
  * Ensures that only columns from the primary Kwf_Db_Table are returned in the result.
  *
  * @return string|null This object as a SELECT string (or null if a string cannot be produced)
  */
 public function assemble()
 {
     $fields = $this->getPart(Kwf_Db_Table_Select::COLUMNS);
     $primary = $this->_table->getTableName();
     $schema = $this->_table->getSchemaName();
     if (count($this->_parts[self::UNION]) == 0) {
         // If no fields are specified we assume all fields from primary table
         if (!count($fields)) {
             $this->from($primary, self::SQL_WILDCARD, $schema);
             $fields = $this->getPart(Kwf_Db_Table_Select::COLUMNS);
         }
         $from = $this->getPart(Kwf_Db_Table_Select::FROM);
         if ($this->_integrityCheck !== false) {
             foreach ($fields as $columnEntry) {
                 list($table, $column) = $columnEntry;
                 // Check each column to ensure it only references the primary table
                 if ($column) {
                     if (!isset($from[$table]) || $from[$table]['tableName'] != $primary) {
                         throw new Kwf_Exception('Select query cannot join with another table');
                     }
                 }
             }
         }
     }
     return parent::assemble();
 }