/**
* Returns the fragment SQL string
*
* @param rdbms.DBConnection conn
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(\rdbms\DBConnection $conn)
{
$s = '';
foreach ($this->projections as $e) {
$s .= 0 != strlen($e['alias']) ? $conn->prepare(', %c as %l', $e['projection']->asSql($conn), $e['alias']) : $conn->prepare(', %c', $e['projection']->asSql($conn));
}
return substr($s, 1);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(\rdbms\DBConnection $conn, \rdbms\Peer $peer)
{
return $conn->prepare('not (%c)', $this->criterion->asSql($conn, $peer));
}
/**
* get the SELECT query
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @param rdbms.join.Joinprocessor jp optional
* @return rdbms.ResultSet
*/
public function getSelectQueryString(DBConnection $conn, Peer $peer, $jp = null)
{
if ($this->isJoin()) {
$jp->setFetchmodes($this->fetchmode);
}
return $conn->prepare('select %c from %c %c', $this->projections($conn, $peer, $jp), $this->isJoin() ? $jp->getJoinString() : $peer->table, $this->toSQL($conn, $peer, $jp));
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn)
{
return $conn->prepare($this->command, $this->field);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
*/
public function asSql(DBConnection $conn, Peer $peer)
{
$lhs = $this->lhs instanceof SQLFragment ? $this->lhs : $peer->column($this->lhs);
return $conn->prepare('%c ' . str_replace('?', $lhs->getType(), $this->op), $lhs, $this->value);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(\rdbms\DBConnection $conn, \rdbms\Peer $peer)
{
$lhs = $this->lhs instanceof \rdbms\SQLFragment ? $this->lhs : $peer->column($this->lhs);
return $conn->prepare('%c between ' . $lhs->getType() . ' and ' . $lhs->getType(), $lhs, $this->lo, $this->hi);
}
