Rinvex Attributable is a robust, intelligent, and integrated Entity-Attribute-Value model (EAV) implementation for Laravel Eloquent, with powerful underlying for managing entity attributes implicitly as relations with ease. It utilizes the power of Laravel Eloquent, with smooth and seamless integration.
This package is a rewritten fork of the awesome IsraelOrtuno's awesome EAV Package, original credits goes to him. It's been widely rewritten, with same core concepts as it's fundamentally good in our opinion. The main differences in this fork include:
- Huge boost of performance utilizing rinvex/cacheable
- Serialize and deserialize the entity with it's relations
- Laravel integrated without framework-agnostic overhead complexity
- Attributes could be attached to none, one, or more entities through pivot table
- Attributes are sortable, sluggable, translatable, grouped, and most exciting cacheable
- Entity attributes are treated more naturally like normal attributes, in every possible Eloquent way
- Entity attributes are also treated more naturally like normal relations, in every possible Eloquent way
- Introduction
- Installation
- Usage
- Changelog
- Support
- Contributing & Protocols
- Security Vulnerabilities
- About Rinvex
- License
EAV Definition From Wikipedia:
Entity–attribute–value model (EAV) is a data model to encode, in a space-efficient manner, entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest.
An entity represents a real model which needs to extend its attributes dynamically. Example: models such as Product, Customer or Company are likely to be entities.
In this case an entity will be represented by an Eloquent model.
The attribute act as the "column" we would like to add to an entity. An attribute gets a name such as price, city or colors to get identified and will be attached to an entity. It will also play very closely with a data type instance which will cast or format its value when writing or reading from database.
This attribute will also be responsible of defining some default behaviour like data validation or default values.
This is responsible of storing data values related to a certain attribute and to a particular entity instance (row).
In Attributable implementation, a Value instance will represent the content of an attribute related to a particular entity instance.
Values are stored in different tables based on their data type. String values will be stored in a table called (by default) values_varchar, while integer values would use values_integer instead, and so on. Both tables' columns are identical except the data type of the content column which is adapted to the data type they store.
EAV modeling is known for its lack of performance. It is also known for its complexity in terms of querying data if compared with the cost of querying any other horizontal structure. This paradigm has been tagged as anti-pattern in many articles and there is a lot of polemic about whether it should be used.
Since we are storing our entity, attribute and value in different tables, it's required to perform multiple queries to perform any operation. This means if we have 4 attributes registered for an entity, the package will perform at least 5 queries:
select * from `companies`
select * from `values_varchar` where `attribute_id` = '1' and `values_varchar`.`entity_id` in ('1', '2', '3', '4', '5') and `eav_values_varchar`.`entity_type` = 'App\Company'
select * from `values_varchar` where `attribute_id` = '2' and `values_varchar`.`entity_id` in ('1', '2', '3', '4', '5') and `eav_values_varchar`.`entity_type` = 'App\Company'
select * from `values_varchar` where `attribute_id` = '3' and `values_varchar`.`entity_id` in ('1', '2', '3', '4', '5') and `eav_values_varchar`.`entity_type` = 'App\Company'
select * from `values_varchar` where `attribute_id` = '4' and `values_varchar`.`entity_id` in ('1', '2', '3', '4', '5') and `eav_values_varchar`.`entity_type` = 'App\Company'But, there's Good News! Rinvex Attributable utilizes Rinvex Cacheable which caches model results transparently, and may reduce these queries to only one or even ZERO queries! Yes, it's possible and already implemented by default!!
However, despite the performance issues, EAV provides a very high flexibility. It let us have dynamic attributes that can be added / removed at any time without affecting database structure. It also helps when working with columns that will mainly store NULL values.
Considering you accepts the lack of performance EAV comes with, the package has been developed with flexibility in mind so at least you can fight that performance issue. Performance could be improved by loading all the entity related values in a single query and letting a bit of PHP logic organize them into relationships but decided not to, in favor of making database querying more flexible.
As explained below, this package loads the entity values as if they were custom Eloquent relationships. Is for this reason we can easily query through them as if they were a regular Eloquent relation.
Loading values as relationships will let us load only those values we may require for a certain situation, leaving some others just unloaded. It will also let us make use of the powerful Eloquent tools for querying relations so we could easily filter the entities we are fetching from database based on conditions we will directly apply to the values content.
This trait is the most important and let the other classes play together.
The Attributable class has got the responsibility of handling the interactions within the entity. This trait performs the set and get operations of the EAV attributes, calls the RelationBuilder class which adds the relation methods to the $entityAttributeRelations array. These relations may be called as usual as we are overriding the magic method __call looking for these calls. It’s responsible for setting the event listeners for saving and deleting, add the global scope and fetch the attributes related to this entity.
When trying to access an entity attribute, if it corresponds to an EAV attribute, this trait contains the logic for providing its value, create a new value instance, update collections or any other set/get interaction.
When reading values there are not too much things to check, if the value exists, we'll just format and provide it, otherwise we'll return null or empty collections.
When setting values it gets a little bit more complex. We have 3 things to consider at the moment when setting values:
- Setting a single value which does not exist in database so we have to create the new model instance and relate to attribute and entity.
- Update the content for an existing single value model (database row).
- Replace an existing (or empty) collection of values with a new one so we have to trash the previous stored values (delete from database).
It also overrides few entity methods such as bootIfNotBooted, relationsToArray, setRelation, getRelationValue to provide a smooth and seamless integration with Eloquent models in every possible way. It wires everything together.
// To build entity relations for every instance
bootIfNotBooted();
// To include attributes as relations when converting to array/json
relationsToArray();
// To link entity & attribute to value collections (multivalued attributes)
setRelation()
// To let Eloquent use our attribute relations as part of the model
getRelationValue()Rinvex Attributable let you register multivalued attributes. In order to make playing with collections easier, we have included a new collection type which just extends Illuminate\Database\Eloquent\Collection and provide some extra functionality. This class let us add and remove values from the attribute. What it basically does is to let the user play with a collection class without having to worry about creating Value model instances. A bit of code will help here:
// This is how it works
$entity->cities->add('Alexandria');
// And this is what you would have to do without this collection:
$value = new Varchar(['content' => 'Alexandria', 'attribute_id' => 1, 'entity_type' => 'App\Company', 'entity_id' => 1]);
$entity->cities->push($value);
// You could also pass an array
$entity->cities->add(['Alexandria', 'Cairo']);Collections may get improved and add more features but enough for the moment. Value base model replaces the Eloquent methodnewCollection method in order to return this type of collections when playing with multivalued attributes.
This class creates the Eloquent relations to the attribute values based on their type. If they are multivalued, it will provide a hasMany relation, otherwise just a hasOne. This class creates closures that return this kind of relations and may be called straight from the entity model. These closures are stored in $entityAttributeRelations property in the Attributable trait.
-
Install the package via composer:
composer require rinvex/attributable
-
Execute migrations via the following command:
php artisan migrate --path="vendor/rinvex/attributable/database/migrations" -
Add the following service provider to the
'providers'array insideapp/config/app.php:Rinvex\Attributable\Providers\AttributableServiceProvider::class
And then you can publish the migrations by running the following command:
php artisan vendor:publish --tag="migrations" --provider="Rinvex\Attributable\Providers\AttributableServiceProvider"
And also you can publish the config by running the following command:
php artisan vendor:publish --tag="config" --provider="Rinvex\Attributable\Providers\AttributableServiceProvider"
-
Done!
Rinvex Attributable has been specially made for Eloquent and simplicity has been taken very serious as in any other Laravel related aspect. To add EAV functionality to your Eloquent model just use the \Rinvex\Attributable\Traits\Attributable trait like this:
class Company extends Model
{
use \Rinvex\Attributable\Traits\Attributable;
}That's it, we only have to include that trait in our Eloquent model!
app('rinvex.attributable.types')->push(\Path\To\Your\Type::class);You can call the 'rinvex.attributable.types' service from anywhere in your application, and anytime in the request lifecycle (preferred inside the boot method of a service provider). It's a singleton object, holds a pure Laravel Collection.
app('rinvex.attributable.entities')->push(\Path\To\Your\Entity::class);You can call the 'rinvex.attributable.entities' service from anywhere in your application, and anytime in the request lifecycle (preferred inside the boot method of a service provider). It's a singleton object, holds a pure Laravel Collection.
Like any normal Eloquent model you can create attributes as follows:
Attribute::create(['code' => 'size', 'name' => ['en' => 'Product Size'], 'type' => '\Rinvex\Attributable\Models\Type\Varchar', 'entities' => ['App\Models\Company', 'App\Models\Product']]);Rinvex Attributable tries to do everything in the same way Eloquent would normally do. When loading a model it internally creates a regular relationship for every entity attribute. This means we can query filtering by our registered attribute values like we would normally do when querying Eloquent relationships:
// City is an entity attribute
$companies = Company::whereHas('city', function ($query) {
$query->where('content', 'Alexandria');
})->get();Or simply use the builtin query scope as follows:
$companies = Company::hasAttribute('content', 'Alexandria')->get();And of course you can fetch entity attributes as normal Eloquent attributes, or as raw relations:
$company = Company::find(1);
// Get entity attributes
$company->cities;
// Get entity raw relation
$company->cities();Rinvex Attributable takes into account the powerful Eloquent eager loading system. When accessing an entity attribute in an Eloquent model, it will be loaded just in time as Eloquent does when working with relationships. However we can work with Rinvex Attributable using Eloquent eager loading for better performance and to avoid the n+1 query problem.
Rinvex Attributable has a special relationship name reserved for loading all the registered attributes. This relationship is called eav. When using eav for loading values, it will load all the attributes related to the entity we are playing with, as if you explicitly included all relations in the $with model property.
Again, as any regular Eloquent relationship we can decide when to load our attributes. Do it as if you were normally loading a relationship:
$company->load('eav');
$company->load('city', 'colors');Eloquent ships with a $with which accepts an array of relationships that should be eager loaded. We can use it as well:
namespace App\Models;
class Company extends Model
{
use \Rinvex\Attributable\Traits\Attributable;
// Eager loading all the registered attributes
protected $with = ['eav'];
// Or just load a few of them
protected $with = ['city', 'colors'];
}Note: If your model eager loads
eavrelation, and it's been queued for notification sending, this may cause some issues since theeavrelation is being evaluated through a global scope, while theSerializesAndRestoresModelIdentifierstrait which is used for queued notifications unserialize the queued models WITHOUT global scopes, so you will get "Call to undefined relationship [eav] on model [App\Models\Company]" exception.
Refer to the Changelog for a full history of the project.
The following support channels are available at your fingertips:
Thank you for considering contributing to this project! The contribution guide can be found in CONTRIBUTING.md.
Bug reports, feature requests, and pull requests are very welcome.
If you discover a security vulnerability within this project, please send an e-mail to help@rinvex.com. All security vulnerabilities will be promptly addressed.
Rinvex is a software solutions startup, specialized in integrated enterprise solutions for SMEs established in Alexandria, Egypt since June 2016. We believe that our drive The Value, The Reach, and The Impact is what differentiates us and unleash the endless possibilities of our philosophy through the power of software. We like to call it Innovation At The Speed Of Life. That’s how we do our share of advancing humanity.
This software is released under The MIT License (MIT).
(c) 2016-2017 Rinvex LLC, Some rights reserved.