• 홈
• Doctrine
• DBAL
• Connection

PHP 인터페이스 Doctrine\DBAL\Connection

파일 보기 프로젝트 열기: doctrine/dbal 0 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$_config	Doctrine\DBAL\Configuration
$_conn	Doctrine\DBAL\Driver\Connection	The wrapped driver connection.
$_driver	Doctrine\DBAL\Driver	The used DBAL driver.
$_eventManager	Doctrine\Common\EventManager
$_expr	Doctrine\DBAL\Query\Expression\ExpressionBuilder
$_schemaManager	Doctrine\DBAL\Schema\AbstractSchemaManager	The schema manager.
$defaultFetchMode	integer

공개 메소드들

메소드	설명
__construct ( array $params, Doctrine\DBAL\Driver $driver, Doctrine\DBAL\Configuration $config = null, Doctrine\Common\EventManager $eventManager = null )	Initializes a new instance of the Connection class.
beginTransaction ( ) : void	Starts a transaction by suspending auto-commit mode.
close ( ) : void	Closes the connection.
commit ( ) : void	Commits the current transaction.
connect ( ) : boolean	Establishes the connection with the database.
convertToDatabaseValue ( mixed $value, string $type ) : mixed	Converts a given value to its database representation according to the conversion rules of a specific DBAL mapping type.
convertToPHPValue ( mixed $value, string $type ) : mixed	Converts a given value to its PHP representation according to the conversion rules of a specific DBAL mapping type.
createQueryBuilder ( ) : Doctrine\DBAL\Query\QueryBuilder	Creates a new instance of a SQL query builder.
createSavepoint ( string $savepoint ) : void	Creates a new savepoint.
delete ( string $tableExpression, array $identifier, array $types = [] ) : integer	Executes an SQL DELETE statement on a table.
errorCode ( ) : integer	Fetches the SQLSTATE associated with the last database operation.
errorInfo ( ) : array	Fetches extended error information associated with the last database operation.
exec ( string $statement ) : integer	Executes an SQL statement and return the number of affected rows.
executeCacheQuery ( string $query, array $params, array $types, Doctrine\DBAL\Cache\QueryCacheProfile $qcp ) : Doctrine\DBAL\Driver\ResultStatement	Executes a caching query.
executeQuery ( string $query, array $params = [], array $types = [], Doctrine\DBAL\Cache\QueryCacheProfile $qcp = null ) : Doctrine\DBAL\Driver\Statement	Executes an, optionally parametrized, SQL query.
executeUpdate ( string $query, array $params = [], array $types = [] ) : integer	Executes an SQL INSERT/UPDATE/DELETE query with the given parameters and returns the number of affected rows.
fetchAll ( string $sql, array $params = [], array $types = [] ) : array	Prepares and executes an SQL query and returns the result as an associative array.
fetchArray ( string $statement, array $params = [], array $types = [] ) : array | boolean	Prepares and executes an SQL query and returns the first row of the result as a numerically indexed array.
fetchAssoc ( string $statement, array $params = [], array $types = [] ) : array | boolean	Prepares and executes an SQL query and returns the first row of the result as an associative array.
fetchColumn ( string $statement, array $params = [], integer $column, array $types = [] ) : mixed | boolean	Prepares and executes an SQL query and returns the value of a single column of the first row of the result.
getConfiguration ( ) : Doctrine\DBAL\Configuration	Gets the Configuration used by the Connection.
getDatabase ( ) : string	Gets the name of the database this Connection is connected to.
getDatabasePlatform ( ) : Doctrine\DBAL\Platforms\AbstractPlatform	Gets the DatabasePlatform for the connection.
getDriver ( ) : Doctrine\DBAL\Driver	Gets the DBAL driver instance.
getEventManager ( ) : Doctrine\Common\EventManager	Gets the EventManager used by the Connection.
getExpressionBuilder ( ) : Doctrine\DBAL\Query\Expression\ExpressionBuilder	Gets the ExpressionBuilder for the connection.
getHost ( ) : string | null	Gets the hostname of the currently connected database.
getNestTransactionsWithSavepoints ( ) : boolean	Gets if nested transactions should use savepoints.
getParams ( ) : array	Gets the parameters used during instantiation.
getPassword ( ) : string | null	Gets the password used by this connection.
getPort ( ) : mixed	Gets the port of the currently connected database.
getSchemaManager ( ) : Doctrine\DBAL\Schema\AbstractSchemaManager	Gets the SchemaManager that can be used to inspect or change the database schema through the connection.
getTransactionIsolation ( ) : integer	Gets the currently active transaction isolation level.
getTransactionNestingLevel ( ) : integer	Returns the current transaction nesting level.
getUsername ( ) : string | null	Gets the username used by this connection.
getWrappedConnection ( ) : Doctrine\DBAL\Driver\Connection	Gets the wrapped driver connection.
insert ( string $tableExpression, array $data, array $types = [] ) : integer	Inserts a table row with specified data.
isAutoCommit ( ) : boolean	Returns the current auto-commit mode for this connection.
isConnected ( ) : boolean	Whether an actual connection to the database is established.
isRollbackOnly ( ) : boolean	Checks whether the current transaction is marked for rollback only.
isTransactionActive ( ) : boolean	Checks whether a transaction is currently active.
lastInsertId ( string | null $seqName = null ) : string	Returns the ID of the last inserted row, or the last value from a sequence object, depending on the underlying driver.
ping ( ) : boolean	Ping the server
prepare ( string $statement ) : Statement	Prepares an SQL statement.
project ( string $query, array $params, Closur\Closure $function ) : array	Executes an, optionally parametrized, SQL query and returns the result, applying a given projection/transformation function on each row of the result.
query ( ) : Doctrine\DBAL\Driver\Statement	Executes an SQL statement, returning a result set as a Statement object.
quote ( mixed $input, string | null $type = null ) : string	Quotes a given input parameter.
quoteIdentifier ( string $str ) : string	Quotes a string so it can be safely used as a table or column name, even if it is a reserved name.
releaseSavepoint ( string $savepoint ) : void	Releases the given savepoint.
resolveParams ( array $params, array $types ) : array	Resolves the parameters to a format which can be displayed.
rollBack ( )	Cancels any database changes done during the current transaction.
rollbackSavepoint ( string $savepoint ) : void	Rolls back to the given savepoint.
setAutoCommit ( boolean $autoCommit )	Sets auto-commit mode for this connection.
setFetchMode ( integer $fetchMode ) : void	Sets the fetch mode.
setNestTransactionsWithSavepoints ( boolean $nestTransactionsWithSavepoints ) : void	Sets if nested transactions should use savepoints.
setRollbackOnly ( ) : void	Marks the current transaction so that the only possible outcome for the transaction to be rolled back.
setTransactionIsolation ( integer $level ) : integer	Sets the transaction isolation level.
transactional ( Closur\Closure $func ) : mixed	Executes a function in a transaction.
update ( string $tableExpression, array $data, array $identifier, array $types = [] ) : integer	Executes an SQL UPDATE statement on a table.

보호된 메소드들

메소드	설명
_getNestedTransactionSavePointName ( ) : mixed	Returns the savepoint name to use for nested transactions are false if they are not supported "savepointFormat" parameter is not set

비공개 메소드들

메소드	설명
_bindTypedValues ( Doctrine\DBAL\Driver\Statement $stmt, array $params, array $types ) : void	Binds a set of parameters, some or all of which are typed with a PDO binding type or DBAL mapping type, to a given statement.
commitAll ( )	Commits all current nesting transactions.
detectDatabasePlatform ( )	Detects and sets the database platform.
extractTypeValues ( array $data, array $types ) : array	Extract ordered type list from two associate key lists of data and types.
getBindingInfo ( mixed $value, mixed $type ) : array	Gets the binding type of a given type. The given type can be a PDO or DBAL mapping type.
getDatabasePlatformVersion ( ) : string | null	Returns the version of the related platform if applicable.

메소드 상세

프로퍼티 상세