/**
* Execute the console command.
*
* @return mixed
*
* @dispatches UpdateGitMirror
*/
public function handle()
{
$last_mirrored_since = Carbon::now()->subMinutes(self::UPDATE_FREQUENCY_MINUTES);
$todo = self::UPDATES_TO_QUEUE;
Project::where('last_mirrored', '<', $last_mirrored_since)->chunk($todo, function ($projects) {
foreach ($projects as $project) {
$this->dispatch(new UpdateGitMirror($project));
}
});
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$current_mirrors = [];
Project::where('is_template', false)->chunk(10, function ($projects) use(&$current_mirrors) {
foreach ($projects as $project) {
$current_mirrors[] = $project->mirrorPath();
}
});
$current_mirrors = collect($current_mirrors);
$all_mirrors = collect(glob(storage_path('app/mirrors/') . '*.git'));
// Compare the 2 collections get a list of mirrors which are no longer in use
$orphan_mirrors = $all_mirrors->diff($current_mirrors);
$this->info('Found ' . $orphan_mirrors->count() . ' orphaned mirrors');
// Now loop through the mirrors and delete them from storage
foreach ($orphan_mirrors as $mirror_dir) {
$process = new Process('tools.RemoveMirrorDirectory', ['mirror_path' => $mirror_dir]);
$process->run();
if ($process->isSuccessful()) {
$this->info('Deleted ' . basename($mirror_dir));
} else {
$this->info('Failed to delete ' . basename($mirror_dir));
}
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
foreach ($this->relations as $relation) {
$className = "REBELinBLUE\\Deployer\\{$relation}";
$instance = new $className();
$table = $instance->getTable();
// Add the target fields to the tables
Schema::table($table, function (Blueprint $table) {
$table->integer('target_id')->nullable();
$table->string('target_type')->nullable();
});
if (config('database.default') !== 'sqlite') {
$drop = config('database.default') === 'mysql' ? 'FOREIGN KEY' : 'CONSTRAINT';
DB::statement("ALTER TABLE {$table} DROP {$drop} {$table}_project_id_foreign");
}
}
// Now find the existing templates in the project template and move them to templates table
$templates = [];
foreach (Project::where('is_template', true)->get() as $project) {
$data = $project->toArray();
unset($data['id']);
$templates[$project->id] = Template::create($data);
}
// Now loop through the relations and set the target details
foreach ($this->relations as $relation) {
$className = "REBELinBLUE\\Deployer\\{$relation}";
$instance = new $className();
foreach ($instance->all() as $row) {
$row->target_id = $row->project_id;
$row->target_type = 'project';
if (isset($templates[$row->project_id])) {
$row->target_id = $templates[$row->project_id]->id;
$row->target_type = 'template';
}
$row->save();
}
}
// Remove any deleted non templates from group 1 to group 2
$project = new Project();
$project->where('is_template', false)->where('group_id', 1)->withTrashed()->update(['group_id' => 2]);
// Remove the left over fake templates and the containing group
Project::where('is_template', true)->forceDelete();
Group::find(1)->forceDelete();
// Remove the unneeded project ID column
foreach ($this->relations as $relation) {
$className = "REBELinBLUE\\Deployer\\{$relation}";
$instance = new $className();
$table = $instance->getTable();
// You can't drop a column in SQLite
if (config('database.default') !== 'sqlite') {
DB::statement("ALTER TABLE {$table} DROP COLUMN project_id");
}
if (config('database.default') === 'mysql') {
DB::statement("ALTER TABLE {$table} MODIFY target_id INT(11) NOT NULL");
DB::statement("ALTER TABLE {$table} MODIFY target_type VARCHAR(255) NOT NULL");
} elseif (config('database.default') === 'pgsql') {
DB::statement("ALTER TABLE {$table} ALTER COLUMN target_id SET NOT NULL");
DB::statement("ALTER TABLE {$table} ALTER COLUMN target_type SET NOT NULL");
}
}
}
