Jérémy Munsch
81aabdab72
This removes api authentification with token in favor of signature method. Refactorize code and clean up. It add more unit test plus code coverage in test/converage. - Added config.api.timestampTimeout - Added Helper::signRequest This calculates the request signature - Added more unit tests and extend code coverage. - Added rate limiter for web routes - Added RemoveSpaces Sanitizer on api requests - Added stress test suite - Changed AuthServiceProvider api-token to api-hmac - Changed CustomerSeeder to have at least of customer activated (for unit tests) - Changed used transation for saveing multiple models - Changed, in ServiceController generateApiToken to generateServicePassword - Changed, timestamp has to be send in request with a DateTime format, it also has to a UTC value - Composer added brianium/paratest - Composer update - Fixed case where removing single optin could be the wrong one (not for the good service) - Fixed customer delete - Fixed customer would not be resolved by brand. - Fixed Really check that request is json checking body content, preventing sending malformed requests - Remove ApiError::needAuth - Removed api_token - Removed ApiController::authenticate - Removed config.api.tokenTimeout - Removed Header check or usage because of HAProxy doing weird stuff - Removed lock files from gitignore - Removed memcached dependency - Removed unused questions resources api routes - Removed workspace file Migrations - Added unique index on services.bearer_token - Changed customer_id on customer_answer is nullable - Changed services.bearer_pwd length to 312 (the size of the token) - Dropped services.api_token and service.api_token_date
73 lines
1.9 KiB
PHP
73 lines
1.9 KiB
PHP
<?php
|
|
|
|
namespace App\Console\Commands;
|
|
|
|
use App\Lib\MigrateOldData;
|
|
use App\Models\Brand;
|
|
use Exception;
|
|
use Illuminate\Console\Command;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
/**
|
|
* @codeCoverageIgnore
|
|
*/
|
|
class MigrateCrmUsers extends Command
|
|
{
|
|
/**
|
|
* The name and signature of the console command.
|
|
*
|
|
* @var string
|
|
*/
|
|
protected $signature = 'migrate:crm';
|
|
|
|
/**
|
|
* The console command description.
|
|
*
|
|
* @var string
|
|
*/
|
|
protected $description = 'Migrate crm users';
|
|
|
|
|
|
/**
|
|
* Execute the console command.
|
|
*
|
|
* @return integer
|
|
*/
|
|
public function handle()
|
|
{
|
|
try {
|
|
$table = $this->ask('What is the tmp table name with users data ?');
|
|
|
|
try {
|
|
DB::connection(config('database.oldDB'))->table($table)->exists();
|
|
} catch (Exception $e) {
|
|
$this->error(sprintf('%s table not found on old crm database', $table));
|
|
return -1;
|
|
}
|
|
|
|
$brandname = $this->ask('What is the brand name ?');
|
|
$brand = Brand::where('name', 'LIKE', "%$brandname%")->first();
|
|
if (!$brand) {
|
|
if (!$this->confirm(sprintf('Would you like to use %s ? ', $brandname))) {
|
|
$this->info('Command cancelled');
|
|
return 0;
|
|
}
|
|
if ($this->confirm('Would you like to create a new one ?')) {
|
|
$brand = new Brand();
|
|
$brand->name = $brandname;
|
|
$brand->save();
|
|
} else {
|
|
$this->info('Command cancelled');
|
|
return 0;
|
|
}
|
|
}
|
|
|
|
$mgOldData = new MigrateOldData();
|
|
$mgOldData->runMigration($brand, $table);
|
|
} catch (Exception $e) {
|
|
$this->error(sprintf('Failed %s', $e));
|
|
return -1;
|
|
}//end try
|
|
return 0;
|
|
}
|
|
}
|