iatstuti/laravel-nullable-fields

This trait allows you to easily flag attributes that should be set as null when being persisted to the database using the Laravel PHP Framework.

Wednesday, February 14, 2018
by michaeldyrynda
Repository
4 Watchers
68 Stars
62,479 Installations

PHP
4 Dependents
1 Suggesters
6 Forks
0 Open issues
22 Versions
10 % Grown

The README.md

Nullable database fields for the Laravel PHP Framework

, _(*1)

Often times, database fields that are not assigned values are defaulted to null. This is particularly important when creating records with foreign key constraints, where the relationship is not yet established., _(*2)

public function up()
{
    Schema::create('profile_user', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('user_id')->nullable()->default(null);
        $table->foreign('user_id')->references('users')->on('id'); 
        $table->string('twitter_profile')->nullable()->default(null);
        $table->string('facebook_profile')->nullable()->default(null);
        $table->string('linkedin_profile')->nullable()->default(null);
        $table->text('array_casted')->nullable()->default(null);
        $table->text('array_not_casted')->nullable()->default(null);
    });
}

More recent versions of MySQL will convert the value to an empty string if the field is not configured to allow null. Be aware that older versions may actually return an error., _(*3)

Laravel does not currently support automatically setting nullable database fields as null when the value assigned to a given attribute is empty., _(*4)

Installation

This trait is installed via Composer. To install, simply add it to your composer.json file:, _(*5)

$ composer require dyrynda/laravel-nullable-fields

In order to use this trait, import it in your Eloquent model, then set the protected $nullable property as an array of fields you would like to be saved as null when empty., _(*6)

<?php

use Illuminate\Database\Eloquent\Model;
use Dyrynda\Database\Support\NullableFields;

class UserProfile extends Model
{
    use NullableFields;

    protected $nullable = [
        'facebook_profile',
        'twitter_profile',
        'linkedin_profile',
        'array_casted',
        'array_not_casted',
    ];

    protected $casts = [ 'array_casted' => 'array', ];
}

Now, any time you are saving a UserProfile profile instance, any empty attributes that are set in the $nullable property will be saved as null., _(*7)

<?php

$profile = new UserProfile::find(1);
$profile->facebook_profile = ' '; // Empty, saved as null
$profile->twitter_profile  = 'michaeldyrynda';
$profile->linkedin_profile = '';  // Empty, saved as null
$profile->array_casted = []; // Empty, saved as null
$profile->array_not_casted = []; // Empty, saved as null
$profile->save();

If you want to extend this behaviour to all fields on your model, you may do so by specifying $nullable as *:, _(*8)

class UserProfile extends Model
{
    use NullableFields;

    protected $nullable = '*';
}

More information

Working with nullable fields in Eloquent models - first iteration, _(*9)

Working with nullable fields in Eloquent models - Part Deux - second iteration, covers the details of this package, _(*10)

Support

If you are having general issues with this package, feel free to contact me on Twitter., _(*11)

If you believe you have found an issue, please report it using the GitHub issue tracker, or better yet, fork the repository and submit a pull request., _(*12)

If you're using this package, I'd love to hear your thoughts. Thanks!, _(*13)

Treeware

You're free to use this package, but if it makes it to your production environment you are required to buy the world a tree., _(*14)

It’s now common knowledge that one of the best tools to tackle the climate crisis and keep our temperatures from rising above 1.5C is to plant trees. If you support this package and contribute to the Treeware forest you’ll be creating employment for local families and restoring wildlife habitats., _(*15)

You can buy trees here, _(*16)

Read more about Treeware at treeware.earth, _(*17)

The Versions

14/02 2018

dev-master

9999999-dev

This trait allows you to easily flag attributes that should be set as null when being persisted to the database using the Laravel PHP Framework.

utility laravel-nullable-fields

This trait allows you to easily flag attributes that should be set as null when being persisted to the database using the Laravel PHP Framework.

iatstuti/laravel-nullable-fields

The README.md

Nullable database fields for the Laravel PHP Framework

Installation

More information

Support

Treeware

The Versions

dev-master

The Requires

The Development Requires

by Michael Dyrynda

1.6.0

The Requires

The Development Requires

by Michael Dyrynda

1.5.0

The Requires

The Development Requires

by Michael Dyrynda

1.4.1

The Requires

The Development Requires

by Michael Dyrynda

1.4.0

The Requires

The Development Requires

by Michael Dyrynda

dev-5.4-compatibility

The Requires

The Development Requires

by Michael Dyrynda

dev-#19-fix-incorrect-attribute-updates

The Requires

The Development Requires

by Michael Dyrynda

1.3.1

The Requires

The Development Requires

by Michael Dyrynda

1.3.0

The Requires

The Development Requires

by Michael Dyrynda

1.2.2

The Requires

The Development Requires

by Michael Dyrynda

1.2.1

The Requires

The Development Requires

by Michael Dyrynda

1.2.0

The Requires

The Development Requires

by Michael Dyrynda

1.1.0

The Requires

The Development Requires

by Michael Dyrynda

1.0.2

The Requires

The Development Requires

by Michael Dyrynda

1.0.0

The Requires

The Development Requires

by Michael Dyrynda

0.1.6

The Requires

by Michael Dyrynda

0.1.5

The Requires

by Michael Dyrynda

0.1.4

The Requires

by Michael Dyrynda

0.1.3