Hello!
Another question :)
Is there way to get SQL or PHQL query string from Phalcon\Mvc\Model\Criteria ?
For example:
$content = new users();
$criteria = $content->query();How to get string "SELECT * FROM users" from $criteria ?
P.S. Yes, I want to use \Phalcon as query builder ;)
You can implement a logger: https://docs.phalcon.io/en/latest/reference/models.html#logging-low-level-sql-statements.
However, I just ended up turning on the MySQL general query log and tailing that file.
I can use logger after querying database, but I need to build the query with OO and execute the query with PDO or smthng else.
There is way to get SQL query:
Class MySqlBuilder extends \Phalcon\Mvc\Model\Query\Builder
{
public function getParams()
{
return $this->_bindParams;
}
public function getSQL()
{
$queryS = $this->getPhql();
$queryS = str_replace(array("[", "]"), "", $queryS);
$queryS = str_replace(":,", ",", $queryS);
$queryS = str_replace(":)", ")", $queryS);
return queryS
}
}Than insert MySQLBuilder to DI...
Is there more beautiful way?
