2017 © Pedro Peláez
 

library eloquent-sti

Implement Single Table Inheritance within the Eloquent ORM

image

srlabs/eloquent-sti

Implement Single Table Inheritance within the Eloquent ORM

  • Monday, August 10, 2015
  • by SRLabs
  • Repository
  • 2 Watchers
  • 6 Stars
  • 1,968 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 3 Forks
  • 1 Open issues
  • 8 Versions
  • 1 % Grown

The README.md

Eloquent Single Table Inheritance

This package provides an easy way to extend Eloquent model objects to provide support for single table inheritance. Inspired by an article written by Pallav Kaushish., (*1)

Installation

This package should be installed via composer:, (*2)

$ composer require srlabs/eloquent-sti

Usage

In your Model, add the SingleTableInheritanceTrait trait and then specify these configuration values:, (*3)

  • table: The name of the database table assigned to the base model
  • morphClass: The full class name of the base Eloquent Object
  • discriminatorColumn: The column in the database table used to distinguish STI entity types
  • inheritanceMap: An array mapping discriminator column values to corresponding entity classes

Here is an imaginary Widget model as an example:, (*4)

// app/Epiphyte/Widget.php
class Widget extends Illuminate\Database\Eloquent\Model {

    /*****************************************************************************
     *  Eloquent Configuration
     *****************************************************************************/

    protected $guarded = ['id'];
    protected $fillable = ['name', 'description', 'status'];

    /*****************************************************************************
     * Single Table Inheritance Configuration
     *****************************************************************************/

    use SingleTableInheritanceTrait;
    protected $table = 'widgets';
    protected $morphClass = 'Epiphyte\Widget';
    protected $discriminatorColumn = 'status';
    protected $inheritanceMap = [
        'new' => 'Epiphyte\Entities\Widgets\NewWidget',
        'processed' => 'Epiphyte\Entities\Widgets\ProcessedWidget'
        'complete' => 'Epiphyte\Entities\Widgets\CompleteWidget'
    ];

    // ...
}

Next you need to create each of your child entity classes. I often keep them in an Entities folder, but any namespaced location will work., (*5)

Here is a hypothetical example:, (*6)

// app/Epiphyte/Entities/Widgets/NewWidget.php
class NewWidget extends Epiphyte\Widget {

    /**
     * Limit the query scope if we define a query against the base table using this class.
     *
     * @param bool $excludeDeleted
     *
     * @return $this
     */
    public function newQuery($excludeDeleted = true)
    {
        return parent::newQuery($excludeDeleted)->where('status', '=', 'new');
    }

    // Remaining child entity methods go here...
}

Whenever Eloquent wants to return an instance of the base model it will use the value of the discriminator column to determine the appropriate entity type and return an instance of that class instead. This holds true for all Eloquent actions but it will not work on direct database (i.e. DB::table()) calls., (*7)

Providing the newQuery() method in the child class will allow you to use the Entity as a traditional Eloquent accessor that only returns entities of its own type. In this case, NewWidget::all(); would return all of the widgets flagged as 'new' in the database., (*8)

Any questions about this package should be posted on the package website., (*9)

The Versions

10/08 2015

dev-master

9999999-dev

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

MIT

The Requires

 

by Ryan C. Durham

laravel eloquent trait single-table-inheritance

10/08 2015

v2.0.3

2.0.3.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

MIT

The Requires

 

by Ryan C. Durham

laravel eloquent trait single-table-inheritance

10/04 2015

v2.0.2

2.0.2.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

MIT

The Requires

 

by Ryan C. Durham

laravel eloquent trait single-table-inheritance

26/03 2015

2.0.x-dev

2.0.9999999.9999999-dev

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

MIT

The Requires

 

by Ryan C. Durham

laravel eloquent trait single-table-inheritance

26/03 2015

v2.0.1

2.0.1.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

MIT

The Requires

 

by Ryan C. Durham

laravel eloquent trait single-table-inheritance

26/03 2015

v2.0.0

2.0.0.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

The Requires

 

by Ryan C. Durham

24/01 2015

v1.0.1

1.0.1.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

The Requires

 

by Ryan C. Durham

19/01 2015

v1.0.0

1.0.0.0

Implement Single Table Inheritance within the Eloquent ORM

  Sources   Download

The Requires

 

by Ryan C. Durham