yii2tech/filedb Provides ActiveRecord interface for data declared in static files

activerecordfiledbstatic

12951949

File DB Extension for Yii 2


This extension provides ActiveRecord interface for the data declared in static files. Such solution allows declaration of static entities like groups, statuses and so on via files, which are stored under version control instead of database.

Note: although this extension allows writing of the data, it is not recommended. You should consider using regular relational database based on SQLite in case you need sophisticated local data storage.

For license information check the LICENSE-file.

Latest Stable Version Total Downloads Build Status

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist yii2tech/filedb

or add

"yii2tech/filedb": "*"

to the require section of your composer.json.

Usage

This extension works similar to regular Yii2 database access layer. First of all you should add a [[\yii2tech\filedb\Connection]] component to your application configuration:

return [
    'components' => [
        'filedb' => [
            'class' => 'yii2tech\filedb\Connection',
            'path' => '@app/data/static',
        ],
        // ...
    ],
    // ...
];

Now you can declare actual entities and their data via files stored under '@app/data/static' path. By default regular PHP code files are used for this, but you can choose different format via [[\yii2tech\filedb\Connection::format]]. Each entity should have a file with corresponding name, like 'UserGroup', 'ItemStatus' etc. So full file names for them would be '/path/to/project/data/static/UserGroup.php', '/path/to/project/data/static/ItemStatus.php' and so on. Each file should return an array containing actual entity data, for example:

// file 'UserGroup.php'
return [
    [
        'id' => 1,
        'name' => 'admin',
        'description' => 'Site administrator',
    ],
    [
        'id' => 2,
        'name' => 'member',
        'description' => 'Registered front-end user',
    ],
];

In file DB each data row should have a unique field, which identifies it - a primary key. Its name is specified by [[\yii2tech\filedb\Connection::primaryKeyName]]. You may ommit primary key at rows declaration in this case key, under which row is declared in the data array will be used as primary key value. So previous data file example can be rewritten in following way:

// file 'UserGroup.php'
return [
    1 => [
        'name' => 'admin',
        'description' => 'Site administrator',
    ],
    2 => [
        'name' => 'member',
        'description' => 'Registered front-end user',
    ],
];

Querying Data

You may execute complex query on the data declared in files using [[\yii2tech\filedb\Query]] class. This class works similar to regular [[\yii\db\Query]] and uses same syntax. For example:

use yii2tech\filedb\Query;

$query = new Query();
$query->from('UserGroup')
    ->limit(10);
$rows = $query->all();

$query = new Query();
$row = $query->from('UserGroup')
    ->where(['name' => 'admin'])
    ->one();

Using ActiveRecord

The main purpose of this extension is provide an ActiveRecord interface for the static data. It is done via [[\yii2tech\filedb\ActiveRecord]] and [[\yii2tech\filedb\ActiveQuery]] classes. Particular ActiveRecord class should extend [[\yii2tech\filedb\ActiveRecord]] and override its fileName() method, specifying source data file name. For example:

class UserGroup extends \yii2tech\filedb\ActiveRecord
{
    public static function fileName()
    {
        return 'UserGroup';
    }
}

Note: by default fileName() returns own class base name (without namespace), so if you declare source data file with name equal to the class base name, you can ommit fileName() method overriding.

[[\yii2tech\filedb\ActiveRecord]] works similar to regular [[\yii\db\ActiveRecord]], allowing finding, validation and saving models. It can establish relations to other ActiveRecord classes, which are usually represents entities from relational database. For example:

class UserGroup extends \yii2tech\filedb\ActiveRecord
{
    public function getUsers()
    {
        return $this->hasMany(User::className(), ['groupId' => 'id']);
    }
}

class User extends \yii\db\ActiveRecord
{
    public function getGroup()
    {
        return $this->hasOne(UserGroup::className(), ['id' => 'groupId']);
    }
}

So relational queries can be performed like following:

$users = User::find()->with('group')->all();
foreach ($users as $user) {
    echo 'username: ' . $user->name . "\n";
    echo 'group: ' . $user->group->name . "\n\n";
}

$adminGroup = UserGroup::find()->where(['name' => 'admin'])->one();
foreach ($adminGroup->users as $user) {
    echo $user->name . "\n";
}

Changelog

Yii 2 File DB extension Change Log

1.0.6, April 9, 2018

  • Bug #10: Fixed ActiveQuery::indexBy() does not apply while using Yii 2.0.14 (klimov-paul)

1.0.5, November 3, 2017

  • Bug: Fixed count() usage at QueryProcessor::filterInCondition() for compatibility with PHP 7.2 (klimov-paul)

1.0.4, July 7, 2017

  • Bug #8: Fixed QueryProcessor is unable to process comparison condition, e.g. column operator value (klimov-paul)

1.0.3, February 6, 2017

  • Enh: QueryProcessor::filterHashCondition() allows to specify filter value as \Closure instance (klimov-paul)
  • Enh #5: QueryProcessor::filterInCondition() advanced allowing comparison against array-type columns (klimov-paul)
  • Enh #6: Added QueryProcessor::filterCallbackCondition() allowing to specify PHP callback as filter (klimov-paul)

1.0.2, June 28, 2016

  • Bug #4: Fixed Query unable to fetch default connection component for data fetching (klimov-paul)

1.0.1, June 3, 2016

  • Enh #3: FileManagerPhp::writeData() now invalidates script file cache performed by 'OPCache' or 'APC' (klimov-paul)
  • Bug #2: Fixed ActiveRecord looses not 'dirty' data on update (fps01)

1.0.0, December 26, 2015

  • Initial release.

Statistics

Downloads
GitHub Stars
GitHub Forks

Releases

Comments



1.0.6 is the latest of 7 releases



BSD-3-Clause license
Stats
69 github stars & 10 github forks
2 downloads in the last day
742 downloads in the last 30 days
30965 total downloads