Skip to content

Instantly share code, notes, and snippets.

@dulao5
Last active February 15, 2019 09:01
Show Gist options
  • Save dulao5/fedc1e68b06ffd14e7e339dd3daea85d to your computer and use it in GitHub Desktop.
Save dulao5/fedc1e68b06ffd14e7e339dd3daea85d to your computer and use it in GitHub Desktop.
laravel
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"\nphp -r "if (hash_file('sha384', 'composer-setup.php') === '48e3236262b34d30969dca3c37281b3b4bbe3221bda826ac6a9a62d6444cdb0dcd0615698a5cbe587c3f0fe57a54d8f5') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

php composer-setup.php --install-dir=/usr/local/bin --filename=composer
vim .zshrc

# https://laravel.com/docs/5.7
composer global require laravel/installer

vim .zshrc

rehash
laravel new php-redis-json

cd php-redis-json
composer require predis/predis

# https://readouble.com/laravel/5.3/ja/artisan.html
php artisan list
php artisan make:command inputVideos

vi app/Console/Commands/inputVideos.php
@dulao5
Copy link
Author

dulao5 commented Feb 15, 2019

https://laravel.com/docs/5.7/queries#chunking-results

DB::table('users')->orderBy('id')->chunk(100, function ($users) {
    foreach ($users as $user) {
        //
    }
});

DB::table('users')->where('active', false)
    ->chunkById(100, function ($users) {
        foreach ($users as $user) {
            DB::table('users')
                ->where('id', $user->id)
                ->update(['active' => true]);
        }
    });

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment