for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/**
* @license LGPLv3, http://opensource.org/licenses/LGPL-3.0
* @copyright Aimeos (aimeos.org), 2018-2021
*/
namespace Aimeos\MW\Setup\Task;
* Removes address and list records without users entry
class CustomerRemoveLostUserDataLaravel extends \Aimeos\MW\Setup\Task\Base
{
private $sql = [
'users_address' => [
'fk_lvuad_pid' => 'DELETE FROM "users_address" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
],
'users_list' => [
'fk_lvuli_pid' => 'DELETE FROM "users_list" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
'users_property' => [
'fk_lvupr_pid' => 'DELETE FROM "users_property" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
];
* Returns the list of task names which depends on this task.
*
* @return string[] List of task names
public function getPostDependencies() : array
return ['TablesCreateMShop'];
}
* Migrate database schema
public function migrate()
$this->msg( 'Remove left over Laravel user references', 0, '' );
$schema = $this->getSchema( 'db-customer' );
foreach( $this->sql as $table => $map )
foreach( $map as $constraint => $sql )
$this->msg( sprintf( 'Remove records from %1$s', $table ), 1 );
if( $schema->tableExists( 'fe_users' ) && $schema->tableExists( $table )
&& $schema->constraintExists( $table, $constraint ) === false
) {
$this->execute( $sql, 'db-customer' );
$this->status( 'done' );
else
$this->status( 'OK' );
aimeos /
ai-laravel
