How does \Zend_Db_Select::reset() work?

dmitry_fedyuk · April 29, 2016, 3:59pm

Context:

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L713-L719


/**
 * Clear parts of the Select object, or an individual part.
 *
 * @param string $part OPTIONAL
 * @return Zend_Db_Select
 */
public function reset($part = null)

github.com

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L721-L725


if ($part == null) {
    $this->_parts = self::$_partsInit;
} elseif (array_key_exists($part, self::$_partsInit)) {
    $this->_parts[$part] = self::$_partsInit[$part];
}

github.com

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L100-L119


/**
 * The initial values for the $_parts array.
 * NOTE: It is important for the 'FOR_UPDATE' part to be last to ensure
 * meximum compatibility with database adapters.
 *
 * @var array
 */
protected static $_partsInit = array(
    self::DISTINCT     => false,
    self::COLUMNS      => array(),
    self::UNION        => array(),
    self::FROM         => array(),
    self::WHERE        => array(),
    self::GROUP        => array(),
    self::HAVING       => array(),
    self::ORDER        => array(),
    self::LIMIT_COUNT  => null,
    self::LIMIT_OFFSET => null,
    self::FOR_UPDATE   => false
);