yiisoft/db-mysql

Yii DataBase MySQL Extension

dev-master / 3.0.x-dev 2022-02-10 13:33 UTC

Requires

• php: ^7.4|^8.0
• ext-json: *
• ext-pdo: *
• yiisoft/db: ^3.0
• yiisoft/json: ^1.0

Requires (Dev)

• phpunit/phpunit: ^9.5
• roave/infection-static-analysis-plugin: ^1.16
• spatie/phpunit-watcher: ^1.23
• vimeo/psalm: ^4.18
• yiisoft/aliases: ^1.1|^2.0
• yiisoft/log-target-file: ^1.0

BSD-3-Clause

• mysql
• yii

README

Yii DataBase MySQL Extension

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

Support version

PHP	Mysql Version	CI-Actions
7.4 - 8.0	5.7 - 8.0

Installation

The package could be installed via composer:

composer require yiisoft/db-mysql

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\Mysql\Connection as MySqlConnection;

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

Params.php

use Yiisoft\Db\Connection\Dsn;

return [
    'yiisoft/db-mysql' => [
        'dsn' => (new Dsn('mysql', '127.0.0.1', 'yiitest', '3306'))->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 MySQL Extension is free software. It is released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.