Skip to content

Instantly share code, notes, and snippets.

@Braunson
Created June 24, 2020 20:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Braunson/749d11ac8b08435db4391a6458d00689 to your computer and use it in GitHub Desktop.
Save Braunson/749d11ac8b08435db4391a6458d00689 to your computer and use it in GitHub Desktop.
Command to use with the iSeed package to get tables, generated the seeds for all tables in one command `php artisan iseed:all`
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
class iseedAll extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'iseed:all';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Command plugin for iseed to seed all databases except migrations table';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$dbName = env('DB_DATABASE');
$query = \DB::select("SHOW TABLES WHERE 'Tables_in_$dbName' NOT LIKE 'migrations'");
$collection = new \Illuminate\Support\Collection($query);
$dbPrefix = \DB::getTablePrefix();
$hasDBPrefix = (bool) ($dbPrefix != '');
$tables = "";
$collectionArray = $collection->toArray();
$iteration = 0;
foreach ($collectionArray as $item) {
if ($iteration < (sizeof($collectionArray) - 2)) {
$tablesName = array_values((array) $item)[0].",";
} else {
$tablesName .= array_values((array) $item)[0];
}
$tables .= str_replace($dbPrefix, '', $tablesName);
$iteration++;
}
$this->info('Calling iseed for all tables except migrations ...');
$this->call('iseed', ["tables" => $tables]);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment