/**
* Execute the current query on the given Alt_Database.
*
* @param mixed $db Alt_Database instance or name of instance
* @param string result object classname, TRUE for stdClass or FALSE for array
* @param array result object constructor arguments
* @return object Alt_Database_Result for SELECT queries
* @return mixed the insert id for INSERT queries
* @return integer number of affected rows for all other queries
*/
public function execute($db = NULL, $as_object = NULL, $object_params = NULL)
{
if (!is_object($db)) {
// Get the Alt_Database instance
$db = Alt_Database::instance($db);
}
if ($as_object === NULL) {
$as_object = $this->_as_object;
}
if ($object_params === NULL) {
$object_params = $this->_object_params;
}
// Compile the SQL query
$sql = $this->compile($db);
if ($this->_lifetime !== NULL and $this->_type === Alt_Database::SELECT) {
// Set the cache key based on the Alt_Database instance name and SQL
$cache_key = 'Alt_Database::query("' . $db . '", "' . $sql . '")';
// Read the cache first to delete a possible hit with lifetime <= 0
if (($result = Alt::cache($cache_key, NULL, $this->_lifetime)) !== NULL and !$this->_force_execute) {
// Return a cached result
return new Alt_Database_Result_Cached($result, $sql, $as_object, $object_params);
}
}
// Execute the query
$result = $db->query($this->_type, $sql, $as_object, $object_params);
if (isset($cache_key) and $this->_lifetime > 0) {
// Cache the result array
Alt::cache($cache_key, $result->as_array(), $this->_lifetime);
}
return $result;
}
