semperton/database

A compact PDO / SQLite wrapper library.

2.1.0 2022-12-14 13:18 UTC

Requires

• php: >=7.4

Requires (Dev)

• ext-pdo: *
• ext-pdo_sqlite: *
• ext-sqlite3: *
• phpunit/phpunit: ^9.5
• vimeo/psalm: ^4.8

MIT

README

Semperton Database

A compact PDO / SQLite wrapper library.

Installation

Just use Composer:

composer require semperton/database

Database requires PHP 7.4+

Connection

The PDOConnection class is a PDO wrapper. Its constructor accepts the same parameters as the PDO constructor.

use Semperton\Database\Connection\PDOConnection;

$connection = new PDOConnection('dsn', null, null, [
	PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);

The internal PDO object is lazily created, when you make the first database call. You can pass a callable as the 5th argument to the PDOConnection constructor that gets called, when PDO first initializes.

Interface

interface ConnectionInterface
{
	public function execute(string $sql, ?array $params = null): bool;
	public function fetchRow(string $sql, ?array $params = null): ?array;
	public function fetchColumn(string $sql, ?array $params = null, int $column = 0): Generator;
	public function fetchAll(string $sql, ?array $params = null): Generator;
	public function fetchResult(string $sql, ?array $params = null): ResultSetInterface;
	public function fetchValue(string $sql, ?array $params = null);
	public function inTransaction(): bool;
	public function beginTransaction(): bool;
	public function commit(): bool;
	public function rollBack(): bool;
	public function lastInsertId(): int;
	public function affectedRows(): int;
}

ResultSet

The ResultSet class is a wrapper around PDOStatement::execute and PDOStatement::fetch calls. It's an Iterator with additional first(), count() and toArray() methods.

$users = $connection->fetchAll('select * from user limit :limit', ['limit' => 5]);

$firstUser = $users->first();

foreach($users as $user){
	// ...
}

$userCount = $users->count();
$userArray = $users->toArray();