romeoz/rock-db

Object Relational Mapping (ORM) for PHP.

Object Relational Mapping (ORM) for PHP

Independent fork by Yii2 Database 2.0.4., _(*1)

, _(*2)

Features

• Supports the following databases out of box:
  • MySQL
  • MariaDB
  • SQLite
  • PostgreSQL
  • CUBRID: version 9.3 or higher.
  • Oracle
  • MSSQL: version 2008 or higher.
• 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., _(*3)

Installation

From the Command Line:, _(*4)

composer require romeoz/rock-db, _(*5)

In your composer.json:, _(*6)

{
    "require": {
        "romeoz/rock-db": "*"
    }
}

Quick Start

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();    

Documentation

• 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

Requirements

• 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, _(*7)

License

The Object Relational Mapping (ORM) is open-sourced software licensed under the MIT license., _(*8)