Laravel: How check if model field is nullable on database

Question

I'm set all empty fields to null when saving

Using OctoberCMS model event beforeSave (equivalent to Laravel model saving)

public function beforeSave()
{
    // $this => the model
    foreach ( $this->toArray() as $name => $value )
    {
         if ( empty( $value ) ) {
                 $this->{$name} = null;
         }
    }
}

The problem is when field has a default value defined on database (mysql), for example:

$table->integer('value')->default(1);

I need to get an array of all nullable or not nullable fields of current model.

How do this?

Maytham Fahmi · Accepted Answer · 2016-08-19 21:50:11Z

6

Laravel/Eloquent have no clue about the structure of your database. Assumption is made that whatever operations you implement, database structure is ready for them.

You could query the database to get information about columns. For MySQL you'd need to run

show columns from <table_name>;

This will result in additional queries sent to the database.

A better option, in my opinion, is to just store such information in model classes, e.g. in

protected $notNullable = ['field1', 'field2'];

in a similar fashion like $fillable or $guarded fields are stored. When you write your models you should be aware which columns are nullable and which aren't, so it should be the easiest solution.

edited Aug 19, 2016 at 21:50

Maytham Fahmi

33.2k17 gold badges132 silver badges159 bronze badges

answered Aug 15, 2015 at 22:13

jedrzej.kurylo

41.1k10 gold badges108 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jedrzej.kurylo Over a year ago

Dear down-voters, please leave a comment, I'd love to learn what is wrong with the answer :)

Alexandre Demelas Over a year ago

oh sorry. to solve i just set protected $notNullables = ['foo', 'bar'] and create the conditions inside the loop. Worked fine.

Solo.dmitry · Accepted Answer · 2020-01-24 08:22:04Z

2

Add this to your model or trait

use DB;
...
    protected static $_columns_info = NULL;
    protected static $_nullable_fields = NULL;
    public function is_nullable(string $field_name){
        if (is_null(static::$_columns_info) ){
            static::$_columns_info = DB::select('show columns from '.$this->gettable() );
        }
        if (is_null(static::$_nullable_fields) ){
            static::$_nullable_fields = array_map( function ($fld){return $fld->Field;}, array_filter(static::$_columns_info,function($v){return $v->Null=='YES';}));
        }
        return in_array( $field_name, static::$_nullable_fields );
    }

and use like

app(Model::class)->is_nullable(you_column_name)

answered Jan 24, 2020 at 8:22

Solo.dmitry

79012 silver badges16 bronze badges

Comments

ILiyan Dimitrov · Accepted Answer · 2024-01-08 13:10:34Z

0

For PostgreSQL I've updated Sole.dmitry's answer and made a funcion, wich can be performed on a given model. For ex. model User, then on an instance $user->getNullableFields() will return them as an array of the field names that are nullable

public function getNullableFields(){

        $columns_info = DB::select("SELECT COLUMN_NAME, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '{$this->getTable()}'");

        $nullableFields = array_filter($columns_info, function($v) { return $v->is_nullable == 'YES'; });

        $nullable_fields = json_decode(json_encode($nullableFields), true);

        return array_map(function ($fields) { return $fields['column_name']; }, $nullable_fields);
    }

answered Jan 8, 2024 at 13:10

ILiyan Dimitrov

611 silver badge7 bronze badges

Collectives™ on Stack Overflow

Laravel: How check if model field is nullable on database

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related