Laravel - Update all fields from a large table

Question

I have the following problem...

I am migrating a system, and in the same I own a client table

This table has a field called "cli_password", in which the customer’s password

To use Laravel authentication I had to create a column "password"

Now I need to replicate all the passwords in the column "cli_password" for the column "password".

But I can’t just duplicate the column cli_password and rename to password

Or perform a simple SQL to update the column password taking the value of cli_password for the field cli_password has no encryption.

Then I am obliged to go through all the fields of the table by performing the proper Hash.

But the table has more than 40 thousand records, and every time I query the screen returns blank, I can only select 5 thousand records through the "Chunk"

Would anyone have any suggestions or methods that are more efficient than doing multiple searches and updating their records?

Answer 1

Hello,

the code you will make is very simple.

$users = User::wherePassword(null)->take(5000);
foreach($users as $user){
    $user->password = Hash::make($user->cli_senha);
    $user->save();
}

Answer 2

can create an Migration to rename the column and update passwords:

Schema::table('users', function($table) {
    $table->renameColumn('cli_senha', 'password');
});

foreach(User::all() as $user) {
    $user->password = Hash::make($user->password);
    $user->save();
}

http://laravel.com/docs/schema#renaming-Columns