Pheasant\Query\Query::toSql PHP Method

toSql() public method

Returns the sql for the query
public toSql ( )
    public function toSql()
    {
        return implode(' ', array_filter(array($this->_clause($this->_distinct ? 'SELECT DISTINCT' : 'SELECT', $this->_select), $this->_clause('FROM', $this->_from), implode(' ', $this->_joins), $this->_clause('WHERE', $this->_where), $this->_clause('GROUP BY', $this->_group), $this->_clause('ORDER BY', $this->_order), $this->_limit, $this->_lock)));
    }

Usage Example

Example #1
0
 public function testDistinctColumn()
 {
     $query = new Query();
     $query->distinct()->select('userid')->from('user');
     $this->assertEquals('SELECT DISTINCT userid FROM user', $query->toSql());
 }