in database/migrations/2018_12_29_091017_default_temperature_scale.php [16:45]
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->string('temperature_scale')->default('celsius')->change();
});
$country = null;
$currentLocale = null;
User::orderBy('locale')->chunkById(200, function ($users) use ($country, $currentLocale) {
foreach ($users as $user) {
if ($user->locale != $currentLocale || $country == null) {
$country = CountriesHelper::getCountryFromLocale($user->locale);
$currentLocale = $user->locale;
}
switch ($country->cca2) {
case 'US':
case 'BZ':
case 'KY':
$user->temperature_scale = 'fahrenheit';
break;
default:
$user->temperature_scale = 'celsius';
break;
}
$user->save();
}
});
}