Access model meta data as if it was a property on your model (Fork based on the work of https://github.com/Azirius/hasmeta) for Laravel 5
jlopezcur/metable is a Laravel package for access model meta data as if it was a property on your model (fork based on the work of https://github.com/azirius/hasmeta) for laravel 5.
It currently has 0 GitHub stars and 21 downloads on Packagist (latest version v0.1.4).
Install it with composer require jlopezcur/metable.
Discover more Laravel packages by jlopezcur
or browse all Laravel packages to compare alternatives.
Last updated
A Laravel trait to access model meta data as if it was a property on your model (Fork based on the work of https://github.com/Azirius/hasmeta) for Laravel 5
Run composer require jlopezcur/metable 0.1.* or add "jlopezcur/metable": "0.1.*" to your composer.json file
In the Model that you want to utilise Metable add the following properties
use Jlopezcur\Metable\MetableTrait;
protected $meta_model = 'ModelName'; // the name of your meta data model
protected $meta_foreign_key = 'user_id'; // the foreign key of your main model
protected $meta_primary_key = 'meta_id'; // the primary key of you meta data model
protected $meta_key_name = 'dataName'; // the column name that stores your meta data key name
protected $meta_value_name = 'dataValue'; // the column name that stores your meta data value
Nothing like a simple example to explain things
users table
| id | email | password | | ------------- | ------------- | ------------- | | 1 | [email protected] | ADpQeKh$2y$10$0dh/BerzTrEOBhu4SR3w05 | | 2 | [email protected] | pQeKhrzTrEOBhu$2y$10$0dh/BeAD4SR3w05 | | 3 | [email protected] | ADpQeKhrzTrEOBhu4SR3w05$2y$10$0dh/Be | | 4 | [email protected] | BeADpQeKhrzTrEO$2y$10$0dh/Bhu4SR3w05 | | 5 | [email protected] | DpQeKhrzTrEOBhu4SR3w05$2y$10$0dh/BeA |
users_meta table
| id | user_id | meta_name | meta_value | ------------- | ------------- | ------------- | ------------- | | 1 | 1 | first_name | John | | 2 | 1 | surname | Roberts | | 3 | 1 | age | 20 | | 4 | 1 | gender | Male | | 5 | 2 | first_name | Steven | | 6 | 2 | surname | Watson | | 7 | 2 | age | 35 | | 8 | 2 | gender | Male | | 9 | 3 | first_name | Sam | | 10 | 3 | surname | Faddy | | 11 | 3 | age | 30 | | 12 | 3 | gender | Female | | 13 | 4 | first_name | Ben | | 14 | 4 | surname | Prokop | | 15 | 4 | age | 32 | | 16 | 4 | gender | Male | | 17 | 5 | first_name | Jo | | 18 | 5 | surname | Blair | | 19 | 5 | age | 31 | | 20 | 5 | gender | Female |
User.php model
class User extends Eloquent {
use Jlopezcur\Metable\MetableTrait;
protected $meta_model = 'UserMeta';
protected $meta_foreign_key = 'user_id';
protected $meta_primary_key = 'id';
protected $meta_key_name = 'meta_name';
protected $meta_value_name = 'meta_value';
/**
* The database table used by the model.
*
* @var string
*/
protected $table = 'users';
/**
* The primary key on the table
*
* @var string
*/
protected $primaryKey = 'id';
// ...
}
UserMeta.php model
class UserMeta extends Eloquent {
/**
* The database table used by the model.
*
* @var string
*/
protected $table = 'users_meta';
/**
* The primary key on the table
*
* @var string
*/
protected $primaryKey = 'id';
// ...
}
Now we can simply do this for getting meta data...
$user = User::find(1);
echo $user->gender; // Will output 'Male'
We can save meta data easily too...
$user = User::find(1);
$user->gender = 'Female';
$user->save();
Delete meta...
$user = User::find(1);
$user->gender = null;
$user->save();
New meta...
$user = User::find(1);
$user->anything_you_want = 'some lovely value';
$user->save();
Mass assignment...
$user = User::find(1);
$user->fill($request->input())->save();
$user->save();
For mass assignment Remember add in your model...
protected $guarded = array();
