* * $phql = "SELECT c.price*0.16 AS taxes, c.* FROM Cars AS c JOIN Brands AS b * WHERE b.name = :name: ORDER BY c.name"; * * $result = $manager->executeQuery($phql, array( * 'name' => 'Lamborghini' * )); * * foreach ($result as $row) { * echo "Name: ", $row->cars->name, "\n"; * echo "Price: ", $row->cars->price, "\n"; * echo "Taxes: ", $row->taxes, "\n"; * } * * */ class Query implements \Phalcon\Mvc\Model\QueryInterface, \Phalcon\DI\InjectionAwareInterface { const TYPE_SELECT = 309; const TYPE_INSERT = 306; const TYPE_UPDATE = 300; const TYPE_DELETE = 303; protected $_dependencyInjector; protected $_manager; protected $_metaData; protected $_type; protected $_phql; protected $_ast; protected $_intermediate; protected $_models; protected $_sqlAliases; protected $_sqlAliasesModels; protected $_sqlModelsAliases; protected $_sqlAliasesModelsInstances; protected $_sqlColumnAliases; protected $_modelsInstances; protected $_cache; protected $_cacheOptions; protected $_uniqueRow; protected $_bindParams; protected $_bindTypes; protected static $_irPhqlCache; /** * \Phalcon\Mvc\Model\Query constructor * * @param string $phql * @param \Phalcon\DiInterface $dependencyInjector */ public function __construct($phql=null, $dependencyInjector=null){ } /** * Sets the dependency injection container * * @param \Phalcon\DiInterface $dependencyInjector */ public function setDI($dependencyInjector){ } /** * Returns the dependency injection container * * @return \Phalcon\DiInterface */ public function getDI(){ } /** * Tells to the query if only the first row in the resultset must be returned * * @param boolean $uniqueRow * @return \Phalcon\Mvc\Model\Query */ public function setUniqueRow($uniqueRow){ } /** * Check if the query is programmed to get only the first row in the resultset * * @return boolean */ public function getUniqueRow(){ } /** * Replaces the model's name to its source name in a qualifed-name expression * * @param array $expr * @return string */ protected function _getQualified(){ } /** * Resolves a expression in a single call argument * * @param array $argument * @return string */ protected function _getCallArgument(){ } /** * Resolves a expression in a single call argument * * @param array $expr * @return string */ protected function _getFunctionCall(){ } /** * Resolves an expression from its intermediate code into a string * * @param array $expr * @param boolean $quoting * @return string */ protected function _getExpression(){ } /** * Resolves a column from its intermediate representation into an array used to determine * if the resulset produced is simple or complex * * @param array $column * @return array */ protected function _getSelectColumn(){ } /** * Resolves a table in a SELECT statement checking if the model exists * * @param \Phalcon\Mvc\Model\ManagerInterface $manager * @param array $qualifiedName * @return string */ protected function _getTable(){ } /** * Resolves a JOIN clause checking if the associated models exist * * @param \Phalcon\Mvc\Model\ManagerInterface $manager * @param array $join * @return array */ protected function _getJoin(){ } /** * Resolves a JOIN type * * @param array $join * @return string */ protected function _getJoinType(){ } /** * Resolves joins involving has-one/belongs-to/has-many relations * * @param string $joinType * @param string $joinSource * @param string $modelAlias * @param string $joinAlias * @param \Phalcon\Mvc\Model\RelationInterface $relation * @return array */ protected function _getSingleJoin(){ } /** * Resolves joins involving many-to-many relations * * @param string $joinType * @param string $joinSource * @param string $modelAlias * @param string $joinAlias * @param \Phalcon\Mvc\Model\RelationInterface $relation * @return array */ protected function _getMultiJoin(){ } /** * Processes the JOINs in the query returning an internal representation for the database dialect * * @param array $select * @return array */ protected function _getJoins(){ } /** * Returns a processed order clause for a SELECT statement * * @param array $order * @return string */ protected function _getOrderClause(){ } /** * Returns a processed group clause for a SELECT statement * * @param array $group * @return string */ protected function _getGroupClause(){ } /** * Analyzes a SELECT intermediate code and produces an array to be executed later * * @return array */ protected function _prepareSelect(){ } /** * Analyzes an INSERT intermediate code and produces an array to be executed later * * @return array */ protected function _prepareInsert(){ } /** * Analyzes an UPDATE intermediate code and produces an array to be executed later * * @return array */ protected function _prepareUpdate(){ } /** * Analyzes a DELETE intermediate code and produces an array to be executed later * * @return array */ protected function _prepareDelete(){ } /** * Parses the intermediate code produced by \Phalcon\Mvc\Model\Query\Lang generating another * intermediate representation that could be executed by \Phalcon\Mvc\Model\Query * * @return array */ public function parse(){ } /** * Sets the cache parameters of the query * * @param array $cacheOptions * @return \Phalcon\Mvc\Model\Query */ public function cache($cacheOptions){ } /** * Returns the current cache options * * @param array */ public function getCacheOptions(){ } /** * Returns the current cache backend instance * * @return \Phalcon\Cache\BackendInterface */ public function getCache(){ } /** * Executes the SELECT intermediate representation producing a \Phalcon\Mvc\Model\Resultset * * @param array $intermediate * @param array $bindParams * @param array $bindTypes * @return \Phalcon\Mvc\Model\ResultsetInterface */ protected function _executeSelect(){ } /** * Executes the INSERT intermediate representation producing a \Phalcon\Mvc\Model\Query\Status * * @param array $intermediate * @param array $bindParams * @param array $bindTypes * @return \Phalcon\Mvc\Model\Query\StatusInterface */ protected function _executeInsert(){ } /** * Query the records on which the UPDATE/DELETE operation well be done * * @param \Phalcon\Mvc\Model $model * @param array $intermediate * @param array $bindParams * @param array $bindTypes * @return \Phalcon\Mvc\Model\ResultsetInterface */ protected function _getRelatedRecords(){ } /** * Executes the UPDATE intermediate representation producing a \Phalcon\Mvc\Model\Query\Status * * @param array $intermediate * @param array $bindParams * @param array $bindTypes * @return \Phalcon\Mvc\Model\Query\StatusInterface */ protected function _executeUpdate(){ } /** * Executes the DELETE intermediate representation producing a \Phalcon\Mvc\Model\Query\Status * * @param array $intermediate * @param array $bindParams * @param array $bindTypes * @return \Phalcon\Mvc\Model\Query\StatusInterface */ protected function _executeDelete(){ } /** * Executes a parsed PHQL statement * * @param array $bindParams * @param array $bindTypes * @return mixed */ public function execute($bindParams=null, $bindTypes=null){ } /** * Executes the query returning the first result * * @param array $bindParams * @param array $bindTypes * @return Ṕhalcon\Mvc\ModelInterface */ public function getSingleResult($bindParams=null, $bindTypes=null){ } /** * Sets the type of PHQL statement to be executed * * @param int $type * @return \Phalcon\Mvc\Model\Query */ public function setType($type){ } /** * Gets the type of PHQL statement executed * * @return int */ public function getType(){ } /** * Set default bind parameters * * @param array $bindParams * @return \Phalcon\Mvc\Model\Query */ public function setBindParams($bindParams){ } /** * Returns default bind params * * @return array */ public function getBindParams(){ } /** * Set default bind parameters * * @param array $bindTypes * @return \Phalcon\Mvc\Model\Query */ public function setBindTypes($bindTypes){ } /** * Returns default bind types * * @return array */ public function getBindTypes(){ } /** * Allows to set the IR to be executed * * @param array $intermediate * @return \Phalcon\Mvc\Model\Query */ public function setIntermediate($intermediate){ } /** * Returns the intermediate representation of the PHQL statement * * @return array */ public function getIntermediate(){ } } }