0 follower

Interface Yiisoft\Db\Connection\ConnectionInterface

All Classes | Methods
Implemented byYiisoft\Db\Connection\AbstractConnection, Yiisoft\Db\Debug\ConnectionInterfaceProxy, Yiisoft\Db\Driver\Pdo\AbstractPdoConnection, Yiisoft\Db\Driver\Pdo\PdoConnectionInterface

This interface provides methods for establishing a connection to a database, executing SQL statements, and performing other tasks related to interacting with a database.

It allows you to access and manipulate databases in a database-agnostic way, so you can write code that works with different database systems without having to worry about the specific details of each one.

Public Methods

Hide inherited methods

Method Description Defined By
beginTransaction() Starts a transaction and returns it, creating a new transaction object only if none is currently active. Yiisoft\Db\Connection\ConnectionInterface
close() Closes the currently active DB connection. Yiisoft\Db\Connection\ConnectionInterface
createBatchQueryResult() Creates {@see BatchQueryResultInterface} instance. Yiisoft\Db\Connection\ConnectionInterface
createCommand() Creates a command for execution. Yiisoft\Db\Connection\ConnectionInterface
createQuery() Creates {@see QueryInterface} instance. Yiisoft\Db\Connection\ConnectionInterface
createTransaction() Creates {@see TransactionInterface} instance. Yiisoft\Db\Connection\ConnectionInterface
getColumnBuilderClass() Returns the column builder class name for the current DB connection. Yiisoft\Db\Connection\ConnectionInterface
getColumnFactory() Returns the column factory for creating column instances. Yiisoft\Db\Connection\ConnectionInterface
getDriverName() Returns the name of the DB driver for the current dsn. Yiisoft\Db\Connection\ConnectionInterface
getLastInsertId() Returns the ID of the last inserted row or a sequence value. Yiisoft\Db\Connection\ConnectionInterface
getQueryBuilder() Returns the query builder for the current DB connection. Yiisoft\Db\Connection\ConnectionInterface
getQuoter() Returns quoter helper for current DB connection. Yiisoft\Db\Connection\ConnectionInterface
getSchema() Returns the schema information for the database opened by this connection. Yiisoft\Db\Connection\ConnectionInterface
getServerInfo() Returns {@see ServerInfoInterface} instance that provides information about the database server. Yiisoft\Db\Connection\ConnectionInterface
getTablePrefix() Returns table prefix for current DB connection. Yiisoft\Db\Connection\ConnectionInterface
getTableSchema() Obtains the schema information for the named table. Yiisoft\Db\Connection\ConnectionInterface
getTransaction() Returns the currently active transaction. Yiisoft\Db\Connection\ConnectionInterface
isActive() Whether the DB connection is active. Yiisoft\Db\Connection\ConnectionInterface
isSavepointEnabled() Whether this DBMS supports savepoint. Yiisoft\Db\Connection\ConnectionInterface
open() Establishes a DB connection. Yiisoft\Db\Connection\ConnectionInterface
quoteValue() Quotes a value for use in a query. Yiisoft\Db\Connection\ConnectionInterface
select() Creates a new {@see Query} instance with the specified columns to be selected. Yiisoft\Db\Connection\ConnectionInterface
setEnableSavepoint() Whether to enable savepoint. Yiisoft\Db\Connection\ConnectionInterface
setTablePrefix() Sets the common prefix or suffix for table names. Yiisoft\Db\Connection\ConnectionInterface
transaction() Executes callback provided in a transaction. Yiisoft\Db\Connection\ConnectionInterface

Method Details

Hide inherited methods

beginTransaction() public abstract method

Starts a transaction and returns it, creating a new transaction object only if none is currently active.

public abstract Yiisoft\Db\Transaction\TransactionInterface beginTransaction ( string|null $isolationLevel = null )
$isolationLevel string|null

The isolation level to use for this transaction.

{@see \Yiisoft\Db\Transaction\TransactionInterface::begin()} for details.
return Yiisoft\Db\Transaction\TransactionInterface

The transaction.
throws Yiisoft\Db\Exception\Exception
throws Yiisoft\Db\Exception\InvalidConfigException
throws Yiisoft\Db\Exception\NotSupportedException
throws Throwable 

                public function beginTransaction(?string $isolationLevel = null): TransactionInterface;
close() public abstract method

Closes the currently active DB connection.

It does nothing if the connection is already closed.

public abstract void close ( )

                public function close(): void;
createBatchQueryResult() public abstract method

Creates {@see BatchQueryResultInterface} instance.

public abstract Yiisoft\Db\Query\BatchQueryResultInterface createBatchQueryResult ( Yiisoft\Db\Query\QueryInterface $query )
$query Yiisoft\Db\Query\QueryInterface

The query to execute.
return Yiisoft\Db\Query\BatchQueryResultInterface

The batch query result.

 

                public function createBatchQueryResult(QueryInterface $query): BatchQueryResultInterface;
createCommand() public abstract method

Creates a command for execution.

public abstract Yiisoft\Db\Command\CommandInterface createCommand ( string|null $sql = null, array $params = [] )
$sql string|null

The SQL statement to execute.
$params array

The parameters to bind to the SQL statement.
return Yiisoft\Db\Command\CommandInterface

The database command.
throws Yiisoft\Db\Exception\Exception
throws Yiisoft\Db\Exception\InvalidConfigException 

                public function createCommand(?string $sql = null, array $params = []): CommandInterface;
createQuery() public abstract method

Creates {@see QueryInterface} instance.

public abstract Yiisoft\Db\Query\QueryInterface createQuery ( )
return Yiisoft\Db\Query\QueryInterface

The query.

 

                public function createQuery(): QueryInterface;
createTransaction() public abstract method

Creates {@see TransactionInterface} instance.

public abstract Yiisoft\Db\Transaction\TransactionInterface createTransaction ( )
return Yiisoft\Db\Transaction\TransactionInterface

The transaction.

 

                public function createTransaction(): TransactionInterface;
getColumnBuilderClass() public abstract method

Returns the column builder class name for the current DB connection.

public abstract string getColumnBuilderClass ( )

                public function getColumnBuilderClass(): string;
getColumnFactory() public abstract method

Returns the column factory for creating column instances.

public abstract Yiisoft\Db\Schema\Column\ColumnFactoryInterface getColumnFactory ( )

                public function getColumnFactory(): ColumnFactoryInterface;
getDriverName() public abstract method

Returns the name of the DB driver for the current dsn.

Use this method for information only.

public abstract string getDriverName ( )
return string

The name of the DB driver for the current dsn.

 

                public function getDriverName(): string;
getLastInsertId() public abstract method

Returns the ID of the last inserted row or a sequence value.

public abstract string getLastInsertId ( string|null $sequenceName = null )
$sequenceName string|null

The name of the sequence object (required by some DBMS).
return string

The row ID of the last row inserted, or the last value retrieved from the sequence object.
throws Yiisoft\Db\Exception\Exception
throws Yiisoft\Db\Exception\InvalidCallException 

                public function getLastInsertId(?string $sequenceName = null): string;
getQueryBuilder() public abstract method

Returns the query builder for the current DB connection.

public abstract Yiisoft\Db\QueryBuilder\QueryBuilderInterface getQueryBuilder ( )
return Yiisoft\Db\QueryBuilder\QueryBuilderInterface

The query builder for the current DB connection.

 

                public function getQueryBuilder(): QueryBuilderInterface;
getQuoter() public abstract method

Returns quoter helper for current DB connection.

public abstract Yiisoft\Db\Schema\QuoterInterface getQuoter ( )
return Yiisoft\Db\Schema\QuoterInterface

The quoter helper for the current DB connection.

 

                public function getQuoter(): QuoterInterface;
getSchema() public abstract method

Returns the schema information for the database opened by this connection.

public abstract Yiisoft\Db\Schema\SchemaInterface getSchema ( )
return Yiisoft\Db\Schema\SchemaInterface

The schema information for the database opened by this connection.

 

                public function getSchema(): SchemaInterface;
getServerInfo() public abstract method

Returns {@see ServerInfoInterface} instance that provides information about the database server.

public abstract Yiisoft\Db\Connection\ServerInfoInterface getServerInfo ( )

                public function getServerInfo(): ServerInfoInterface;
getTablePrefix() public abstract method

Returns table prefix for current DB connection.

public abstract string getTablePrefix ( )
return string

The table prefix for the current DB connection.

 

                public function getTablePrefix(): string;
getTableSchema() public abstract method

Obtains the schema information for the named table.

public abstract Yiisoft\Db\Schema\TableSchemaInterface|null getTableSchema ( string $name, boolean $refresh = false )
$name string

The table name.
$refresh boolean

Whether to reload the table schema even if it's found in the cache.
return Yiisoft\Db\Schema\TableSchemaInterface|null

The schema information for the named table. Null if the named table doesn't exist.

 

                public function getTableSchema(string $name, bool $refresh = false): ?TableSchemaInterface;
getTransaction() public abstract method

Returns the currently active transaction.

public abstract Yiisoft\Db\Transaction\TransactionInterface|null getTransaction ( )
return Yiisoft\Db\Transaction\TransactionInterface|null

The currently active transaction. Null if there is no active transaction.

 

                public function getTransaction(): ?TransactionInterface;
isActive() public abstract method

Whether the DB connection is active.

public abstract boolean isActive ( )
return boolean

Whether the DB connection is active.

 

                public function isActive(): bool;
isSavepointEnabled() public abstract method

Whether this DBMS supports savepoint.

public abstract boolean isSavepointEnabled ( )
return boolean

Whether this DBMS supports savepoint.

 

                public function isSavepointEnabled(): bool;
open() public abstract method

Establishes a DB connection.

It does nothing if a DB connection is active.

public abstract void open ( )
throws Yiisoft\Db\Exception\Exception

If connection fails.
throws Yiisoft\Db\Exception\InvalidConfigException

If a connection can't be established because of incomplete configuration.

 

                public function open(): void;
quoteValue() public abstract method

Quotes a value for use in a query.

public abstract mixed quoteValue ( mixed $value )
$value mixed
return mixed

The quoted string.
throws Yiisoft\Db\Exception\Exception
throws Yiisoft\Db\Exception\InvalidConfigException 

                public function quoteValue(mixed $value): mixed;
select() public abstract method

Creates a new {@see Query} instance with the specified columns to be selected.

public abstract Yiisoft\Db\Query\QueryInterface select ( array|Yiisoft\Db\Expression\ExpressionInterface|scalar $columns = [], string|null $option = null )
$columns array|Yiisoft\Db\Expression\ExpressionInterface|scalar

The columns to be selected. Columns can be specified in either a string (for example id, name) or an array (such as ['id', 'name']). Columns can be prefixed with table names (such as user.id) and/or contain column aliases (for example user.id AS user_id). The method will automatically quote the column names unless a column has some parenthesis (which means the column has a DB expression). A DB expression may also be passed in form of an {@see \Yiisoft\Db\Expression\ExpressionInterface} object. Note that if you are selecting an expression like CONCAT(first_name, ' ', last_name), you should use an array to specify the columns. Otherwise, the expression may be incorrectly split into several parts. When the columns are specified as an array, you may also use array keys as the column aliases (if a column doesn't need alias, don't use a string key).
$option string|null

More option that should be appended to the 'SELECT' keyword. For example, in MySQL, the option 'SQL_CALC_FOUND_ROWS' can be used.

 

                public function select(
    array|bool|float|int|string|ExpressionInterface $columns = [],
    ?string $option = null,
): QueryInterface;
setEnableSavepoint() public abstract method

Whether to enable savepoint.

Note that if the underlying DBMS doesn't support savepoint, setting this property to be true will have no effect.

public abstract void setEnableSavepoint ( boolean $value )
$value boolean

Whether to enable savepoint.

 

                public function setEnableSavepoint(bool $value): void;
setTablePrefix() public abstract method

Sets the common prefix or suffix for table names.

If a table name is {{%TableName}}, then the percentage character % will be replaced with this property value. For example, {{%post}} becomes {{tbl_post}}.

public abstract void setTablePrefix ( string $value )
$value string

The common prefix or suffix for table names.

 

                public function setTablePrefix(string $value): void;
transaction() public abstract method

Executes callback provided in a transaction.

public abstract mixed transaction ( Closure $closure, string|null $isolationLevel = null )
$closure Closure

A valid PHP callback that performs the job. Accepts connection instance as parameter.
$isolationLevel string|null

The isolation level to use for this transaction. {@see \Yiisoft\Db\Transaction\TransactionInterface::begin()} for details.
return mixed

Result of callback function.
throws Throwable

If there is any exception during query. In this case, the transaction will be rolled back.

 

                public function transaction(Closure $closure, ?string $isolationLevel = null): mixed;