<?php namespace Doctrine\DBAL\Driver; use Doctrine\DBAL\DBALException; use Doctrine\DBAL\ParameterType; /** * Connection interface. * Driver connections must implement this interface. * * This resembles (a subset of) the PDO interface. */ interface Connection { /** * Prepares a statement for execution and returns a Statement object. */ public function prepare(string $sql) : Statement; /** * Executes an SQL statement, returning a result set as a Statement object. * * @throws DBALException */ public function query(string $sql) : ResultStatement; /** * Quotes a string for use in a query. * * @param mixed $input * @param int $type * * @return mixed */ public function quote($input, $type = ParameterType::STRING); /** * Executes an SQL statement and return the number of affected rows. * * @throws DBALException */ public function exec(string $statement) : int; /** * Returns the ID of the last inserted row or sequence value. * * @param string|null $name * * @return string */ public function lastInsertId($name = null); /** * Initiates a transaction. * * @return bool TRUE on success or FALSE on failure. */ public function beginTransaction(); /** * Commits a transaction. * * @return bool TRUE on success or FALSE on failure. */ public function commit(); /** * Rolls back the current transaction, as initiated by beginTransaction(). * * @return bool TRUE on success or FALSE on failure. */ public function rollBack(); /** * Returns the error code associated with the last operation on the database handle. * * @return string|null The error code, or null if no operation has been run on the database handle. */ public function errorCode(); /** * Returns extended error information associated with the last operation on the database handle. * * @return mixed[] */ public function errorInfo(); }