Laravel migration from nullable to not null with null data in database

Question

my code below is working fine. Problem is when i got data in database which is null in user_id field. Migration rollback will not pass successfully. What is good approach to solve this problem? Should i change every null in column user_id to empty string before i change nullable to false in rollback?

    public function up()
    {
        Schema::table('classes', function (Blueprint $table) {
            $table->text('user_id')->nullable()->change();
        });
    }
    
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('classes', function (Blueprint $table) {
            $table->text('user_id')->nullable(false)->change();
        });
    }

Héctor William · Accepted Answer · 2021-06-07 14:44:58Z

2

This problem has been seem before, I couldn't find other solution than update the values to empty string before changing the column, the database engine will always complaint.

Updated:

You could do this like this and should work:

use Illuminate\Support\Facades\DB;

/*
*
* Some code
*
*/


public function up()
{
    DB::table('classes')->whereNull('user_id')->update(['user_id'=>'']);
    Schema::table('classes', function (Blueprint $table) {
        $table->text('user_id')->nullable()->change();
    });
}

edited Jun 7, 2021 at 14:44

answered Jun 7, 2021 at 14:21

Héctor William

7968 silver badges26 bronze badges

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

3 Comments

Lupik Over a year ago

okay, thank you so much for your answer. DB::statement(raw_sql) is good solution or maybe you have better for this situation?

Héctor William Over a year ago

Yes you could do that, just updated my answer.

Lupik Over a year ago

thank you so much , your solution is better than just raw sql

Collectives™ on Stack Overflow

Laravel migration from nullable to not null with null data in database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related