terabytesoft/db-pgsql

Yii DataBase PostgreSQL Extension

dev-main 2022-02-10 19:06 UTC

Requires

• php: ^8.0
• ext-json: *
• ext-pdo: *
• terabytesoft/db: @dev
• yiisoft/arrays: ^2.0
• yiisoft/json: ^1.0
• yiisoft/strings: ^2.0

Requires (Dev)

• phpunit/phpunit: ^9.5
• roave/infection-static-analysis-plugin: ^1.7
• vimeo/psalm: ^4.4
• yiisoft/aliases: ^1.1|^2.0
• yiisoft/cache: ^1.0
• yiisoft/log: ^1.0

BSD-3-Clause

• pgsql
• yii

README

Yii DataBase PostgreSQL Extension

This package provides PostgreSQL extension for Yii DataBase library. It is used in Yii Framework but is supposed to be usable separately.

Support version

PHP	Pgsql Version	CI-Actions
7.4 - 8.0	9.0 - 13.0

Installation

The package could be installed via composer:

composer require yiisoft/db-pgsql

Configuration

Using yiisoft/composer-config-plugin automatically get the settings of Yiisoft\Cache\CacheInterface::class, LoggerInterface::class, and Profiler::class.

Di-Container:

use Yiisoft\Db\Connection\ConnectionInterface;
use Yiisoft\Db\Pgsql\Connection as PgsqlConnection;

return [
    ConnectionInterface::class => [
        'class' => PgsqlConnection::class,
        '__construct()' => [
            'dsn' => $params['yiisoft/db-pgsql']['dsn']
        ],
        'setUsername()' => [$params['yiisoft/db-pgsql']['username']],
        'setPassword()' => [$params['yiisoft/db-pgsql']['password']],
    ]
];

Params.php

use Yiisoft\Db\Connection\Dsn;

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

Unit testing

The package is tested with PHPUnit. To run tests:

./vendor/bin/phpunit

Mutation testing

The package tests are checked with Infection mutation framework. To run it:

./vendor/bin/infection

Static analysis

The code is statically analyzed with Psalm. To run static analysis:

./vendor/bin/psalm

Support the project

Follow updates

License

The Yii DataBase PostgreSQL Extension is free software. It is released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.