uisits/compoships

Laravel relationships with support for composite/multiple keys

dev-master 2019-03-07 00:32 UTC

Requires

• php: ^7.1.3
• illuminate/cache: 5.7.28
• illuminate/console: 5.7.28
• illuminate/database: 5.7.28
• illuminate/support: 5.7.28

Requires (Dev)

• fzaninotto/faker: ^1.8
• laravel/laravel: 5.7.*
• phpunit/phpunit: ^7.0

Suggests

• uisits/blade-active: Blade directives for the Laravel 'Active' package
• uisits/eloquent-auto-append: Automatically append accessors to model serialization
• uisits/eloquent-mutators: Reusable mutators (getters/setters) for Laravel 5's Eloquent
• uisits/syntactic: Syntactic sugar for named and indexed parameters call.

MIT

• UIS ITS

• laravel
• laravel composite keys
• laravel relationships

README

This Package is exact replica of awobaz/compoships. This package just provides support for Laravel version ^5.7

Compoships offers the ability to specify relationships based on two (or more) columns in Laravel 5's Eloquent. The need to match multiple columns in the definition of an Eloquent relationship often arises when working with third party or pre existing schema/database.

The problem

Eloquent doesn't support composite keys. As a consequence, there is no way to define a relationship from one model to another by matching more than one column. Trying to use where clauses (like in the example below) won't work when eager loading the relationship because at the time the relationship is processed $this->f2 is null.

namespace App;

use Illuminate\Database\Eloquent\Model;

class Foo extends Model
{
    public function bars()
    {
        //WON'T WORK WITH EAGER LOADING!!!
        return $this->hasMany('Bar', 'f1', 'f1')->where('f2', $this->f2);
    }
}

Related discussions:

• Relationship on multiple keys
• Querying relations with extra conditions not working as expected
• Querying relations with extra conditions in Eager Loading not working
• BelongsTo relationship with 2 foreign keys
• Laravel Eloquent: multiple foreign keys for relationship
• Laravel hasMany association with multiple columns

Installation

The recommended way to install Compoships is through Composer

$ composer require uisits/compoships

Usage

Using the uisits\Compoships\Database\Eloquent\Model class

Simply make your model class derive from the uisits\Compoships\Database\Eloquent\Model base class. The uisits\Compoships\Database\Eloquent\Model extends the Eloquent base class without changing its core functionality.

Using the uisits\Compoships\Compoships trait

If for some reasons you can't derive your models from uisits\Compoships\Database\Eloquent\Model, you may take advantage of the uisits\Compoships\Compoships trait. Simply use the trait in your models.

Note: To define a multi-columns relationship from a model A to another model B, both models must either extend uisits\Compoships\Database\Eloquent\Model or use the uisits\Compoships\Compoships trait

Syntax

... and now we can define a relationship from a model A to another model B by matching two or more columns (by passing an array of columns instead of a string).

namespace App;

use Illuminate\Database\Eloquent\Model;

class A extends Model
{
    use \uisits\Compoships\Compoships;

    public function b()
    {
        return $this->hasMany('B', ['f1', 'f2'], ['f1', 'f2']);
    }
}

We can use the same syntax to define the inverse of the relationship:

namespace App;

use Illuminate\Database\Eloquent\Model;

class B extends Model
{
    use \uisits\Compoships\Compoships;

    public function a()
    {
        return $this->belongsTo('A', ['f1', 'f2'], ['f1', 'f2']);
    }
}

Supported relationships

Compoships only supports the following Laravel 5's Eloquent relationships:

• hasOne
• HasMany
• belongsTo

Disclaimer

Compoships doesn't bring support for composite keys in Laravel 5's Eloquent. This package only offers the ability to specify relationships based on more than one column. We believe that all models' tables should have a single primary key. But there are situations where you'll need to match many columns in the definition of a relationship even when your models' tables have a single primary key.

Contributing

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests.

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Unit Tests

In order to run the test suite, install the development dependencies:

$ composer install --dev

Then, run the following command:

$ vendor/bin/phpunit