protected function execute(InputInterface $input, OutputInterface $output)
{
$db = \Database::connection();
$em = $db->getEntityManager();
$cacheDriver = $em->getConfiguration()->getMetadataCacheImpl();
$cacheDriver->flushAll();
$tool = new \Doctrine\ORM\Tools\SchemaTool($em);
$schemas = [];
/**
* @var $sm MySqlSchemaManager
*/
$sm = $db->getSchemaManager();
$dbSchema = $sm->createSchema();
// core xml tables
$schemas[] = Schema::getCoreXMLSchema();
// core entities
$sm = new DatabaseStructureManager($em);
$entities = $sm->getMetadatas();
$schemas[] = $tool->getSchemaFromMetadata($entities);
// core, application and package block types
$env = Environment::get();
$list = new BlockTypeList();
$list->includeInternalBlockTypes();
foreach ($list->get() as $bt) {
$r = $env->getRecord(DIRNAME_BLOCKS . '/' . $bt->getBlockTypeHandle() . '/' . FILENAME_BLOCK_DB, $bt->getPackageHandle());
if ($r->exists()) {
$parser = Schema::getSchemaParser(simplexml_load_file($r->file));
$parser->setIgnoreExistingTables(false);
$schemas[] = $parser->parse($db);
}
}
// packages
$packages = Package::getInstalledList();
foreach ($packages as $pkg) {
$xmlFile = $pkg->getPackagePath() . '/' . FILENAME_BLOCK_DB;
if (file_exists($xmlFile)) {
$parser = Schema::getSchemaParser(simplexml_load_file($xmlFile));
$parser->setIgnoreExistingTables(false);
$schemas[] = $parser->parse($db);
}
}
// Finalize output.
$comparator = new \Doctrine\DBAL\Schema\Comparator();
$saveQueries = array();
foreach ($schemas as $schema) {
$schemaDiff = $comparator->compare($dbSchema, $schema);
$saveQueries = array_merge($saveQueries, $schemaDiff->toSaveSql($db->getDatabasePlatform()));
}
$saveQueries = $this->filterQueries($saveQueries);
if (count($saveQueries)) {
$output->writeln(t2('%s query found', '%s queries found', count($saveQueries)));
$i = 1;
foreach ($saveQueries as $query) {
$output->writeln(sprintf('%s: %s', $i, $query));
$i++;
}
} else {
$output->writeln(t('No differences found between schema and database.'));
}
}
protected function updatePackage($pkgHandle, OutputInterface $output, $force)
{
$output->write("Looking for package '{$pkgHandle}'... ");
$pkg = null;
foreach (Package::getInstalledList() as $installed) {
if ($installed->getPackageHandle() === $pkgHandle) {
$pkg = $installed;
break;
}
}
if ($pkg === null) {
throw new Exception(sprintf("No package with handle '%s' is installed", $pkgHandle));
}
$output->writeln(sprintf('<info>found (%s).</info>', $pkg->getPackageName()));
$output->write('Checking preconditions... ');
$upPkg = null;
foreach (Package::getLocalUpgradeablePackages() as $updatable) {
if ($updatable->getPackageHandle() === $pkgHandle) {
$upPkg = $updatable;
break;
}
}
if ($upPkg === null && $force !== true) {
$output->writeln(sprintf("<info>the package is already up-to-date (v%s)</info>", $pkg->getPackageVersion()));
} else {
$test = $pkg->testForInstall(false);
if (is_object($test)) {
/**
* @var $test Error
*/
throw new Exception(implode("\n", $test->getList()));
}
$output->writeln('<info>good.</info>');
if ($upPkg === null) {
$output->write(sprintf('Forcing upgrade at v%s... ', $pkg->getPackageVersion()));
$upPkg = Package::getByHandle($pkgHandle);
} else {
$output->write(sprintf('Updating from v%s to v%s... ', $upPkg->getPackageEntity()->getPackageVersion(), $upPkg->getPackageVersion()));
}
$upPkg->upgradeCoreData();
$upPkg->upgrade();
$output->writeln('<info>done.</info>');
}
}
/**
* @deprecated
*/
public static function getInstalledList()
{
// this should go through the facade instead
return \Concrete\Core\Support\Facade\Package::getInstalledList();
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$rc = 0;
try {
$pkgHandle = $input->getArgument('package');
$packageOptions = array();
foreach ($input->getArgument('package-options') as $keyValuePair) {
list($key, $value) = explode('=', $keyValuePair, 2);
$key = trim($key);
if (substr($key, -2) === '[]') {
$isArray = true;
$key = rtrim(substr($key, 0, -2));
} else {
$isArray = false;
}
if ($key === '' || !isset($value)) {
throw new Exception(sprintf("Unable to parse the package option '%s': it must be in the form of key=value", $keyValuePair));
}
if (isset($packageOptions[$key])) {
if (!($isArray && is_array($packageOptions[$key]))) {
throw new Exception(sprintf("Duplicated package option '%s'", $key));
}
$packageOptions[$key][] = $value;
} else {
$packageOptions[$key] = $isArray ? (array) $value : $value;
}
}
$output->write("Looking for package '{$pkgHandle}'... ");
foreach (Package::getInstalledList() as $installed) {
if ($installed->getPackageHandle() === $pkgHandle) {
throw new Exception(sprintf("The package '%s' (%s) is already installed", $pkgHandle, $installed->getPackageName()));
}
}
$pkg = null;
foreach (Package::getAvailablePackages() as $available) {
if ($available->getPackageHandle() === $pkgHandle) {
$pkg = $available;
break;
}
}
if ($pkg === null) {
throw new Exception(sprintf("No package with handle '%s' was found", $pkgHandle));
}
$output->writeln(sprintf('<info>found (%s).</info>', $pkg->getPackageName()));
$output->write('Checking preconditions... ');
$test = $pkg->testForInstall();
if (is_object($test)) {
throw new Exception(implode("\n", $test->getList()));
}
$output->write('Preconditions good. Installing...');
$r = Package::install($pkg, []);
if ($r instanceof ErrorList) {
throw new Exception(implode("\n", $r->getList()));
}
$output->writeln('<info>Package Installed.</info>');
$swapper = new ContentSwapper();
if ($swapper->allowsFullContentSwap($pkg) && $input->getOption('full-content-swap')) {
$output->write('Performing full content swap... ');
$swapper->swapContent($pkg, array());
if (method_exists($pkg, 'on_after_swap_content')) {
$pkg->on_after_swap_content(array());
}
$output->writeln('<info>done.</info>');
}
} catch (Exception $x) {
$output->writeln('<error>' . $x->getMessage() . '</error>');
$rc = 1;
}
return $rc;
}