/**
* Executes query and return either Iterator (for SELECT queries) or number of affected rows
* (for other query types).
*
* @return Iterator | int
*/
public function execute()
{
$temp = M('Db')->getConnection()->getConnectionName();
M('Db')->setCurrentConnection($this->_connection->getConnectionName());
list($sql, $binds) = $this->render();
$res = $this->_command == 'select' ? M('Db')->query($sql, $binds) : M('Db')->exec($sql, $binds);
M('Db')->setCurrentConnection($temp);
return $res;
}
