From 8f8dbaf53f28cbe6db9b630c08dea9a1a0f16aa3 Mon Sep 17 00:00:00 2001 From: Vincent Vanwaelscappel Date: Mon, 18 Nov 2019 18:15:43 +0100 Subject: [PATCH] wip #3198 --- app/Console/Commands/CMSMigration.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/app/Console/Commands/CMSMigration.php b/app/Console/Commands/CMSMigration.php index 36010b1..e08555d 100644 --- a/app/Console/Commands/CMSMigration.php +++ b/app/Console/Commands/CMSMigration.php @@ -9,14 +9,14 @@ use Illuminate\Support\Facades\DB; class CMSMigration extends Command { - protected $signature = 'pmi:importcmsdatafromstaging'; - protected $description = 'Export CMS data filed in dev to staging'; + protected $signature = 'pmi:importcmsdatafromprod'; + protected $description = 'Export CMS data filed in dev to prod'; public function handle() { echo 'Run backup of dev' . "\n"; echo `cd /home/pmi/dev;php artisan backup:run`; - echo 'Run backup of staging' . "\n"; + echo 'Run backup of prod' . "\n"; echo `cd /home/pmi/www;php artisan backup:run`; $tables = ['cubist_cms_pages', 'cubist_news', 'cubist_settings', 'cubist_locales', 'cubist_translate', 'applications']; @@ -33,7 +33,7 @@ class CMSMigration extends Command DB::statement('INSERT pmi_dev.' . $table . ' SELECT * FROM pmi.' . $table); } - echo 'Remove old media from staging' . "\n"; + echo 'Remove old media from prod' . "\n"; $sql = 'SELECT * FROM pmi_dev.media WHERE model_type IN (' . $modelssql . ')'; foreach (DB::select($sql) as $item) { $item = ArrayUtil::asArray($item); @@ -44,7 +44,7 @@ class CMSMigration extends Command } DB::delete('DELETE FROM pmi_dev.media WHERE model_type IN (' . $modelssql . ')'); - echo 'Copy media from staging to dev' . "\n"; + echo 'Copy media from prod to dev' . "\n"; foreach (DB::select('SELECT * FROM pmi.media WHERE model_type IN(' . $modelssql . ')') as $item) { $item = ArrayUtil::asArray($item); @@ -52,7 +52,7 @@ class CMSMigration extends Command unset($item['id']); $id = DB::table('pmi_dev.media')->insertGetId($item); - echo 'Copy files from dev #' . $devId . ' to staging #' . $id . "\n"; + echo 'Copy files from dev #' . $devId . ' to prod #' . $id . "\n"; $dest = '/home/pmi/dev/public/storage/' . $id; if (file_exists($dest)) { $destprotect = $dest . '_'; -- 2.39.5