terabytesoft/db-mssql

MSSQL Server extension for the Yii framework

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

This package is auto-updated.

Last update: 2022-06-10 20:12:27 UTC


README

68747470733a2f2f796969736f66742e6769746875622e696f2f646f63732f696d616765732f7969695f6c6f676f2e737667 6154722

MSSQL Server Extension for Yii 3


This extension provides the MSSQL Server support for the Yii framework 3 .

Latest Stable Version Total Downloads Scrutinizer Code Quality Code Coverage

Support version

PHP Mssql Version CI-Actions
7.4 - 8.0 2017 - 2019 Build status Mutation testing badge static analysis type-coverage

Installation

The package could be installed via composer:

composer require yiisoft/db-mssql

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\Mssql\Connection as MssqlConnection;

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

Params.php

use Yiisoft\Db\Mssql\Dsn;

return [
    'yiisoft/db-mssql' => [
        'dsn' => (new Dsn('sqlsrv', '127.0.0.1', 'yiitest', '1433'))->asString(),
        'username' => 'SA',
        'password' => 'YourStrong!Passw0rd',
    ]
];

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

Open Collective

Follow updates

Official website Twitter Telegram Facebook Slack

License

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

Maintained by Yii Software.