/**
* Render COLUMNS section
*
* @param Select $select
* @param string $sql
* @return null|string
* @throws \Zend_Db_Select_Exception
*/
public function render(Select $select, $sql = '')
{
if (!count($select->getPart(Select::COLUMNS))) {
return null;
}
$columns = [];
foreach ($select->getPart(Select::COLUMNS) as $columnEntry) {
list($correlationName, $column, $alias) = $columnEntry;
if ($column instanceof \Zend_Db_Expr) {
$columns[] = $this->quote->quoteColumnAs($column, $alias);
} else {
if ($column == Select::SQL_WILDCARD) {
$column = new \Zend_Db_Expr(Select::SQL_WILDCARD);
$alias = null;
}
if (empty($correlationName)) {
$columns[] = $this->quote->quoteColumnAs($column, $alias);
} else {
$columns[] = $this->quote->quoteColumnAs([$correlationName, $column], $alias);
}
}
}
return $sql . ' ' . implode(', ', $columns);
}
/**
* @param string|array $identifier
* @param string $expectedResult
* @dataProvider getStringArrayToQuoteWithAliasDataProvider
*/
public function testQuoteColumn($identifier, $alias, $expectedResult)
{
$this->assertEquals($expectedResult, $this->model->quoteColumnAs($identifier, $alias));
}
