Skip to content

pgsql.md

Latest commit

 

History

History
67 lines (52 loc) · 1.7 KB

pgsql.md

File metadata and controls

67 lines (52 loc) · 1.7 KB

Connecting PostgreSQL

To configure Yii DB PostgreSQL with a DI container, you need to create config/common/di/db-pgsql.php configuration file:

use Yiisoft\Db\Connection\ConnectionInterface;
use Yiisoft\Db\Pgsql\Connection;
use Yiisoft\Db\Pgsql\Driver;

/** @var array $params */

return [
    ConnectionInterface::class => [
        'class' => Connection::class,
        '__construct()' => [
            'driver' => new Driver(
                $params['yiisoft/db-pgsql']['dsn'],
                $params['yiisoft/db-pgsql']['username'],
                $params['yiisoft/db-pgsql']['password'],
            ),
        ],
    ],
];

Create a file config/common/params.php for common parameters.

use Yiisoft\Db\Pgsql\Dsn;

return [
    'yiisoft/db-pgsql' => [
        'dsn' => new Dsn('pgsql', '127.0.0.1', 'yiitest', '5432'),
        'username' => 'user',
        'password' => 'password',
    ],
];

To use more than one database connection you can use class-aliases.

To configure without DI container, you need to follow these steps:

use Yiisoft\Cache\ArrayCache;
use Yiisoft\Db\Cache\SchemaCache;
use Yiisoft\Db\Pgsql\Connection;
use Yiisoft\Db\Pgsql\Driver;
use Yiisoft\Db\Pgsql\Dsn;

// Dsn.
$dsn = new Dsn('pgsql', '127.0.0.1', 'yiitest', '5432');

// PSR-16 cache implementation.
$arrayCache = new ArrayCache();

// Schema cache.
$schemaCache = new SchemaCache($arrayCache);

// PDO driver.
$pdoDriver = new Driver($dsn, 'user', 'password'); 

// Connection.
$db = new Connection($pdoDriver, $schemaCache);