testmonitor/eloquent-incrementable

Define a custom auto-increment field in your Eloquent model, that is determined through PHP rather than your database engine.

5.0.0 2023-04-09 15:23 UTC

This package is auto-updated.

Last update: 2024-10-04 13:33:42 UTC


README

Latest Stable Version StyleCI codecov License

Define a custom auto-increment field in your Eloquent model, that is determined through PHP rather than your database engine.

Furthermore, by making use of increment groups, you can restart counting in-table based on other fields. Consider this example:

Imagine a bug tracking application that stores each bug in a single table, but is represented on a per-project basis. You'll want start each project with a fresh bug count, while maintaining a unique database id. Incrementable will enable you to automatically reset the code counter once a new project_id is defined.

Table of Contents

Installation

This package can be installed through Composer:

$ composer require testmonitor/eloquent-incrementable

Usage

In order to add Incrementable to your Eloquent model, you'll need to:

  1. Use the trait TestMonitor\Incrementable\Traits\Incrementable on your model(s).
  2. Configure the incrementable field (note: make sure its an integer column).
  3. Optionally, add one or more increment groups.

Add the Incrementable trait on the models you want to track:

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use TestMonitor\Incrementable\Traits\Incrementable;

class Bug extends Model
{
    use Incrementable, SoftDeletes;

    protected $table = 'bugs';

    protected $incrementable = 'code';

    // This will cause the code to reset once
    // a new project_id is found.
    protected $incrementableGroup = ['project_id'];
}

In order to avoid collisions, Incrementable will preserve the count for a soft-deleted model. Although this will cause a gap between this and the next model, it will ensure uniqueness when the model is restored.

Examples

In this example, we have set up the following:

  • A table containing a name and code field.
  • An Eloquent model called App\Bug, which uses the Incrementable trait
  • A property on the Bug model: $incrementable = 'code'

We can now run this example:

$bug = new App\Bug(['name' => 'It doesn\'t work.']);
$bug->save();

// Will show '1'
echo $bug->code;

$bug = new App\Bug(['name' => 'It really doesn\'t work.']);
$bug->save();

// Will show '2'
echo $bug->code;

Tests

The package contains integration tests. You can run them using PHPUnit.

$ vendor/bin/phpunit

Changelog

Refer to CHANGELOG for more information.

Contributing

Refer to CONTRIBUTING for contributing details.

Credits

License

The MIT License (MIT). Refer to the License for more information.