Wouldn't it be cool if you could have a bit of the spirit of NoSQL available in Eloquent? This package does just that. It provides a trait that when applied on a model, allows you to store arbitrary values in a single JSON column.
Here are a few examples. We're using the extra_attributes
column here, but you can name it whatever you want.
// add and retrieve an attribute
$yourModel->extra_attributes->name = 'value';
$yourModel->extra_attributes->name; // returns 'value'
// you can also use the array approach
$yourModel->extra_attributes['name'] = 'value';
$yourModel->extra_attributes['name'] // returns 'value'
// setting multiple values in one go
$yourModel->extra_attributes = [
'rey' => ['side' => 'light'],
'snoke' => ['side' => 'dark']
];
// setting/updating multiple values in one go via set()
$yourModel->extra_attributes->set([
'han' => ['side' => 'light'],
'snoke' => ['side' => 'dark']
]);
// retrieving values using dot notation
$yourModel->extra_attributes->get('rey.side'); // returns 'light'
// retrieve default value when attribute is not exists
$yourModel->extra_attributes->get('non_existing', 'default'); // returns 'default'
// it has a scope to retrieve all models with the given schemaless attributes
$yourModel->withSchemalessAttributes(['name' => 'value', 'name2' => 'value2'])->get();
We invest a lot of resources into creating best in class open source packages. You can support us by buying one of our paid products.
We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on our contact page. We publish all received postcards on our virtual postcard wall.
This package requires a database with support for json
columns like MySQL 5.7 or higher.
You can install the package via composer:
composer require spatie/laravel-schemaless-attributes
The schemaless attributes will be stored in a json column on the table of your model. Let's add that column and prepare the model.
Add a migration for all models where you want to add schemaless attributes to. You should use schemalessAttributes
method on Blueprint
to add a column. The argument you give to schemalessAttributes
is the column name that will be added. You can use any name you'd like. You're also free to add as many schemaless attribute columns to your table as you want. In all examples of this readme we'll use a single column named extra_attributes
.
Schema::table('your_models', function (Blueprint $table) {
$table->schemalessAttributes('extra_attributes');
});
In order to work with the schemaless attributes you'll need to add a cast, an accessor and a scopes on your model. Here's an example of what you need to add if you've chosen extra_attributes
as your column name.
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
use Spatie\SchemalessAttributes\SchemalessAttributes;
class TestModel extends Model
{
// ...
public $casts = [
'extra_attributes' => 'array',
];
public function getExtraAttributesAttribute(): SchemalessAttributes
{
return SchemalessAttributes::createForModel($this, 'extra_attributes');
}
public function scopeWithExtraAttributes(): Builder
{
return SchemalessAttributes::scopeWithSchemalessAttributes('extra_attributes');
}
// ...
}
If you need support for multiple schemaless columns on a single model, you should use SchemalessAttributesTrait
trait. Here's an example of what you need to add if you've chosen extra_attributes, other_extra_attributes
as your column names.
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
use Spatie\SchemalessAttributes\SchemalessAttributes;
use Spatie\SchemalessAttributes\SchemalessAttributesTrait;
class TestModel extends Model
{
use SchemalessAttributesTrait;
// ...
/**
* @var array
*/
protected $schemalessAttributes = [
'extra_attributes',
'other_extra_attributes',
];
public function scopeWithExtraAttributes(): Builder
{
return SchemalessAttributes::scopeWithSchemalessAttributes('extra_attributes');
}
public function scopeWithOtherExtraAttributes(): Builder
{
return SchemalessAttributes::scopeWithSchemalessAttributes('other_extra_attributes');
}
// ...
}
If you want to reuse this behaviour across multiple models you could opt to put the function in a trait of your own. Here's what that trait could look like:
namespace App\Models\Concerns;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
use Spatie\SchemalessAttributes\SchemalessAttributes;
trait HasSchemalessAttributes
{
public function getExtraAttributesAttribute(): SchemalessAttributes
{
return SchemalessAttributes::createForModel($this, 'extra_attributes');
}
public function scopeWithExtraAttributes(): Builder
{
return SchemalessAttributes::scopeWithSchemalessAttributes('extra_attributes');
}
}
This is the easiest way to get and set schemaless attributes:
$yourModel->extra_attributes->name = 'value';
$yourModel->extra_attributes->name; // Returns 'value'
Alternatively you can use an array approach:
$yourModel->extra_attributes['name'] = 'value';
$yourModel->extra_attributes['name']; // Returns 'value'
You can replace all existing schemaless attributes by assigning an array to it.
// All existing schemaless attributes will be replaced
$yourModel->extra_attributes = ['name' => 'value'];
$yourModel->extra_attributes->all(); // Returns ['name' => 'value']
You can also opt to use get
and set
. The methods have support for dot notation.
$yourModel->extra_attributes = [
'rey' => ['side' => 'light'],
'snoke' => ['side' => 'dark'],
];
$yourModel->extra_attributes->set('rey.side', 'dark');
$yourModel->extra_attributes->get('rey.side'); // Returns 'dark
You can also pass a default value to the get
method.
$yourModel->extra_attributes->get('non_existing', 'default'); // Returns 'default'
To persist schemaless attributes you should, just like you do for normal attributes, call save()
on the model.
$yourModel->save(); // Persists both normal and schemaless attributes
Here's how you can use the provided scope.
// Returns all models that have all the given schemaless attributes
$yourModel->withExtraAttributes(['name' => 'value', 'name2' => 'value2'])->get();
If you only want to search on a single custom attribute, you can use the scope like this
// returns all models that have a schemaless attribute `name` set to `value`
$yourModel->withExtraAttributes('name', 'value')->get();
First create a MySQL database named laravel_schemaless_attributes
. After that you can run the tests with:
composer test
Please see CHANGELOG for more information what has changed recently.
Please see CONTRIBUTING for details.
If you discover any security related issues, please email [email protected] instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.