cycle / database
DBAL, schema introspection, migration and pagination
Fund package maintenance!
cycle
Installs: 380 233
Dependents: 26
Suggesters: 0
Security: 0
Stars: 54
Watchers: 5
Forks: 24
Open Issues: 27
Requires
- php: >=8.0
- ext-pdo: *
- psr/log: 1 - 3
- spiral/core: ^2.8 || ^3.0
- spiral/pagination: ^2.8 || ^3.0
- symfony/polyfill-php83: ^1.28
Requires (Dev)
- ergebnis/composer-normalize: ^2.42
- infection/infection: ^0.26.10
- mockery/mockery: ^1.5
- phpunit/phpunit: ^9.5
- spiral/code-style: ~2.2.0
- spiral/tokenizer: ^2.14 || ^3.0
- vimeo/psalm: ^5.18
Conflicts
- 2.x-dev
- 2.11.2
- 2.11.1
- 2.11.0
- 2.10.0
- 2.9.0
- 2.8.1
- 2.8.0
- 2.7.1
- 2.7.0
- 2.6.1
- 2.6.0
- 2.5.2
- 2.5.1
- 2.5.0
- 2.4.1
- 2.4.0
- 2.3.0
- 2.2.2
- 2.2.1
- 2.2.0
- 2.1.3
- 2.1.2
- 2.1.1
- 2.1.0
- 2.0.0
- 1.x-dev
- 1.0.4
- 1.0.3
- 1.0.2
- 1.0.1
- 1.0.0
- dev-release-please--branches--2.x--components--database
- dev-ci-common-workflows
- dev-fix-ci
- dev-feat/automate-changelog
- dev-feat/infra-dx-v2
- dev-release-please--branches--feat/infra-dx-v2--components--database
- dev-feat/infra-dx
- dev-release-please--branches--feat/dx--components--database
- dev-feat/dx
- dev-feature/alias
- dev-hotfix/strict-type
- dev-driver-enhancments
- dev-feature/oracle
- dev-feature/oracle-support
This package is auto-updated.
Last update: 2024-10-23 15:39:00 UTC
README
Secure, multiple SQL dialects (MySQL, PostgreSQL, SQLite, SQLServer), schema introspection, schema declaration, smart identifier wrappers, database partitions, query builders, nested queries.
Documentation
- Installation and Configuration
- Access Database
- Database Isolation
- Query Builders
- Transactions
- Schema Introspection
- Schema Declaration
- Migrations
- Errata
Requirements
Make sure that your server is configured with following PHP version and extensions:
- PHP 8.0+
- PDO Extension with desired database drivers
Installation
To install the component:
composer require cycle/database
Example
Given example demonstrates the connection to SQLite database, creation of table schema, data insertion and selection:
<?php declare(strict_types=1); require_once "vendor/autoload.php"; use Cycle\Database\Config; use Cycle\Database\DatabaseManager; $dbm = new DatabaseManager(new Config\DatabaseConfig([ 'databases' => [ 'default' => ['connection' => 'sqlite'], ], 'connections' => [ 'sqlite' => new Config\SQLiteDriverConfig( connection: new Config\SQLite\FileConnectionConfig( database: 'runtime/database.db' ), ), ], ])); $users = $dbm->database('default')->table('users'); // create or update table schema $schema = $users->getSchema(); $schema->primary('id'); $schema->string('name'); $schema->datetime('created_at'); $schema->datetime('updated_at'); $schema->save(); // insert data $users->insertOne([ 'name' => 'test', 'created_at' => new DateTimeImmutable(), 'updated_at' => new DateTimeImmutable(), ]); // select data foreach ($users->select()->where(['name' => 'test']) as $u) { print_r($u); }
License:
MIT License (MIT). Please see LICENSE
for more information. Maintained
by Spiral Scout.