Independent fork by Yii2 Database 2.0.4.
- Supports the following databases out of box:
- Query Builder/DBAL/DAO: Querying the database using a simple abstraction layer
- Active Record: The Active Record ORM, retrieving and manipulating records, and defining relations
- Migrations
- Behaviors (SluggableBehavior, TimestampBehavior,...)
- Data Provider
- Validation and Sanitization rules for AR (Model)
- Caching queries
- Standalone module/component for Rock Framework
Bolded features are different from Yii2 Database.
From the Command Line:
composer require romeoz/rock-db
In your composer.json:
{
"require": {
"romeoz/rock-db": "*"
}
}
####Query Builder
$rows = (new \rock\db\Query())
->select('id, name')
->from('users')
->limit(10)
->all();
####Active Record
// find
$users = Users::find()
->where(['status' => Users::STATUS_ACTIVE])
->orderBy('id')
->all();
// insert
$users = new Users();
$users ->name = 'Tom';
$users ->save();
- Basic: Connecting to a database, basic queries, transactions, and schema manipulation
- Query Builder
- Active Record
- Migrations: Apply version control to your databases in a team development environment
- Data Providers
- PHP 5.4+
- For validation rules a model required Rock Validate:
composer require romeoz/rock-validate
- For sanitization rules a model required Rock Sanitize:
composer require romeoz/rock-sanitize
- For using behaviors a model required Rock Behaviors:
composer require romeoz/rock-behaviors
- For using Data Provider required Rock Data Provider:
composer require romeoz/rock-dataprovider
- For caching queries required Rock Cache:
composer require romeoz/rock-cache
All unbolded dependencies is optional
The Object Relational Mapping (ORM) is open-sourced software licensed under the MIT license.