terabytesoft/db-sqlite

Yii DataBase SQLite Extension

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

Requires

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

Requires (Dev)

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

BSD-3-Clause

• sqlite
• yii

README

Yii DataBase SQLite Extension

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

Support version

PHP	Sqlite Version	CI-Actions
7.4 - 8.0	3:latest

Installation

The package could be installed via composer:

composer require yiisoft/db-sqlite

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\Sqlite\Connection as SqliteConnection;

return [
    ConnectionInterface::class => [
        'class' => SqliteConnection::class,
        '__construct()' => [
            'dsn' => $params['yiisoft/db-sqlite']['dsn'],
        ]
    ]
];

Params.php

return [
    'yiisoft/db-sqlite' => [
        'dsn' => 'sqlite:' . __DIR__ . '/Data/Runtime/yiitest.sq3',
    ]
];

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 SQLite Extension is free software. It is released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.