Laravel Model UUID

A simple package to sanitize model data to create/update table records.

Installation

Require the package using composer:

composer require touhidurabir/laravel-model-sanitize

What is does ?

The Sanitize package sanitize the passed attributes to proper model fillables at create or update.

A model has multiple table schema based attributed associated with it. When we try to create a new model record or update an existing model record, we must provide the an array attributes that is propelry mapped to those arrtibute or table columns names . For example

$user = User::create([
    'email' => '[email protected]',
    'password' => Hash::make('password')
]);

The above code will run without any issue as both the email and password column presents in the users table . But for the following code

User::create([
    'email' => '[email protected]', 
    'password' => 'password', 
    'data' => 'some data'
]);

It will throw an \Illuminate\Database\QueryException if the data column not present in the users table.

Illuminate\Database\QueryException with message 'SQLSTATE[HY000] [2002] Connection refused (SQL: insert into `users` (`email`, `password`, `updated_at`, `created_at`) values ([email protected], password, 2021-08-23 10:15:25, 2021-08-23 10:15:25))'

The Sanitize package target to make it easier to handle such case as follow by including the Sanitizable trait in the models

$data = [
    'email' => '[email protected]', 
    'password' => 'password', 
    'data' => 'some data'
];

User::create($data);

The above code will work if the Sanitizable trait is used in the User model class. it will sanitize the passed attributed to model fillables and table columns, thus removing the extra or non useable attributes from it .

How it will be helpful ?

A great use case of this package is where one need to create multiple model instances from validated request data . For example

$validated = $request->validated();

$user = User::create($validated);

$profile = $user->profile->create($validated);

I personally use this appraoch in many of my laravel apps .

Usage

Use the trait Sanitizable in model where uuid needed to attach

use Touhidurabir\ModelSanitize\Sanitizable;
use Illuminate\Database\Eloquent\Model;

class User extends Model {
    
    use Sanitizable;
}

And thats all . it will automatically work for all the following methods

• updateOrCreate
• firstOrCreate
• firstOrNew
• create
• forceCreate
• update

This package also includes some helper methods that can be used to handle the sanitization process manually.

The sanitize static method will sanitize the given attributes list and retuen back the useable and valid attributes as an array

$data = [
    'email' => '[email protected]', 
    'password' => 'password', 
    'data' => 'some data', 
    'name' => 'Test User'
];

User::sanitize($data);

This will return back as such :

[
    'email' => '[email protected]', 
    'password' => 'password', 
    'name' => 'Test User'
]

The gibberish static method will sanitize the given attributes list and retuen back the gibberish/non userbale attributes as an array

$data = [
    'email' => '[email protected]', 
    'password' => 'password', 
    'data' => 'some data', 
    'name' => 'Test User'
];

User::gibberish($data);

This will return back as such :

[
    'data' => 'some data', 
]

The sanitize and gibberish methods can be used to check or manually sanitize and evaluate the in valid data that can be passed to create/update model records.

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT