/**
* Execute a query and return the row count
*
* @param string $query
* @param array $parameters
* @return integer Returns the number of rows affected or selected
* @throws \Phramework\Exceptions\DatabaseException
* @example
* ```php
* $status = Database::execute(
* 'UPDATE "user"
* SET "first_name" = ?
* WHERE "id" = ?
* LIMIT 1',
* [$firstName, $id]
* );
* ```
*/
public static function execute($query, $parameters = [])
{
try {
return static::$adapter->execute($query, $parameters);
} catch (\Exception $e) {
throw new DatabaseException('Database Error', $e->getMessage());
}
}
/**
* Execute a query and return the row count
*
* @param string $query
* @param array $parameters
* Query parameters
* @return integer Returns the number of rows affected or selected
* @throws Phramework\Exceptions\DatabaseException
*/
public function execute($query, $parameters = [])
{
$startTimestamp = time();
$exception = null;
try {
$result = $this->internalAdapter->execute($query, $parameters);
} catch (\Exception $e) {
$exception = $e;
} finally {
//log
$this->log($query, $parameters, $startTimestamp, $exception);
if ($exception) {
throw $exception;
}
}
return $result;
}
