How to get the SQL expression for a \Magento\Framework\DB\Select or \Zend_Db_Select instance

dmitry_fedyuk · February 4, 2016, 4:28pm

Use the assemble() or the magic __toString() method, or (string) expression (which is the same as __toString() call).

github.com

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L696-L711


/**
 * Converts this object to an SQL SELECT string.
 *
 * @return string|null This object as a SELECT string. (or null if a string cannot be produced.)
 */
public function assemble()
{
    $sql = self::SQL_SELECT;
    foreach (array_keys(self::$_partsInit) as $part) {
        $method = '_render' . ucfirst($part);
        if (method_exists($this, $method)) {
            $sql = $this->$method($sql);
        }
    }
    return $sql;
}

github.com

zendframework/zf1/blob/release-1.12.16/library/Zend/Db/Select.php#L1342-L1356


/**
 * Implements magic method.
 *
 * @return string This object as a SELECT string.
 */
public function __toString()
{
    try {
        $sql = $this->assemble();
    } catch (Exception $e) {
        trigger_error($e->getMessage(), E_USER_WARNING);
        $sql = '';
    }
    return (string)$sql;
}

dmitry_fedyuk · February 4, 2016, 4:42pm