<?php
/**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2022, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
class DBSync extends BaseAdmin
{
- public static function content(array $parameters = [])
+ protected function content(array $request = []): string
{
- parent::content($parameters);
+ parent::content();
$a = DI::app();
- $o = '';
+ $action = $this->parameters['action'] ?? '';
+ $update = $this->parameters['update'] ?? 0;
- if ($a->argc > 3 && $a->argv[2] === 'mark') {
- // @TODO: Replace with parameter from router
- $update = intval($a->argv[3]);
- if ($update) {
- DI::config()->set('database', 'update_' . $update, 'success');
- $curr = DI::config()->get('system', 'build');
- if (intval($curr) == $update) {
- DI::config()->set('system', 'build', intval($curr) + 1);
+ switch ($action) {
+ case 'mark':
+ if ($update) {
+ DI::config()->set('database', 'update_' . $update, 'success');
+ $curr = DI::config()->get('system', 'build');
+ if (intval($curr) == $update) {
+ DI::config()->set('system', 'build', intval($curr) + 1);
+ }
+
+ DI::sysmsg()->addInfo(DI::l10n()->t('Update has been marked successful'));
}
- info(DI::l10n()->t('Update has been marked successful') . EOL);
- }
- DI::baseUrl()->redirect('admin/dbsync');
- }
- if ($a->argc > 2) {
- if ($a->argv[2] === 'check') {
+ break;
+ case 'check':
// @TODO Seems like a similar logic like Update::check()
- $retval = DBStructure::update($a->getBasePath(), false, true);
+ $retval = DBStructure::performUpdate();
if ($retval === '') {
- $o .= DI::l10n()->t("Database structure update %s was successfully applied.", DB_UPDATE_VERSION) . "<br />";
- DI::config()->set('database', 'last_successful_update', DB_UPDATE_VERSION);
- DI::config()->set('database', 'last_successful_update_time', time());
+ $o = DI::l10n()->t("Database structure update %s was successfully applied.", DB_UPDATE_VERSION) . "<br />";
} else {
- $o .= DI::l10n()->t("Executing of database structure update %s failed with error: %s", DB_UPDATE_VERSION, $retval) . "<br />";
- }
- if ($a->argv[2] === 'check') {
- return $o;
+ $o = DI::l10n()->t("Executing of database structure update %s failed with error: %s", DB_UPDATE_VERSION, $retval) . "<br />";
}
- } elseif (intval($a->argv[2])) {
+
+ return $o;
+ case 'update':
require_once 'update.php';
// @TODO: Replace with parameter from router
- $update = intval($a->argv[2]);
-
- $func = 'update_' . $update;
+ if ($update) {
+ $func = 'update_' . $update;
- if (function_exists($func)) {
- $retval = $func();
+ if (function_exists($func)) {
+ $retval = $func();
- if ($retval === Update::FAILED) {
- $o .= DI::l10n()->t("Executing %s failed with error: %s", $func, $retval);
- } elseif ($retval === Update::SUCCESS) {
- $o .= DI::l10n()->t('Update %s was successfully applied.', $func);
- DI::config()->set('database', $func, 'success');
+ if ($retval === Update::FAILED) {
+ $o = DI::l10n()->t("Executing %s failed with error: %s", $func, $retval);
+ } elseif ($retval === Update::SUCCESS) {
+ $o = DI::l10n()->t('Update %s was successfully applied.', $func);
+ DI::config()->set('database', $func, 'success');
+ } else {
+ $o = DI::l10n()->t('Update %s did not return a status. Unknown if it succeeded.', $func);
+ }
} else {
- $o .= DI::l10n()->t('Update %s did not return a status. Unknown if it succeeded.', $func);
+ $o = DI::l10n()->t('There was no additional update function %s that needed to be called.', $func) . "<br />";
+ DI::config()->set('database', $func, 'success');
}
+
+ return $o;
+ }
+
+ break;
+ default:
+ $failed = [];
+ $configStmt = DBA::select('config', ['k', 'v'], ['cat' => 'database']);
+ while ($config = DBA::fetch($configStmt)) {
+ $upd = intval(substr($config['k'], 7));
+ if ($upd >= 1139 && $config['v'] != 'success') {
+ $failed[] = $upd;
+ }
+ }
+ DBA::close($configStmt);
+
+ if (!count($failed)) {
+ $o = Renderer::replaceMacros(Renderer::getMarkupTemplate('admin/dbsync/structure_check.tpl'), [
+ '$base' => DI::baseUrl()->get(true),
+ '$banner' => DI::l10n()->t('No failed updates.'),
+ '$check' => DI::l10n()->t('Check database structure'),
+ ]);
} else {
- $o .= DI::l10n()->t('There was no additional update function %s that needed to be called.', $func) . "<br />";
- DI::config()->set('database', $func, 'success');
+ $o = Renderer::replaceMacros(Renderer::getMarkupTemplate('admin/dbsync/failed_updates.tpl'), [
+ '$base' => DI::baseUrl()->get(true),
+ '$banner' => DI::l10n()->t('Failed Updates'),
+ '$desc' => DI::l10n()->t('This does not include updates prior to 1139, which did not return a status.'),
+ '$mark' => DI::l10n()->t("Mark success \x28if update was manually applied\x29"),
+ '$apply' => DI::l10n()->t('Attempt to execute this update step automatically'),
+ '$failed' => $failed
+ ]);
}
return $o;
- }
- }
-
- $failed = [];
- $configStmt = DBA::select('config', ['k', 'v'], ['cat' => 'database']);
- while ($config = DBA::fetch($configStmt)) {
- $upd = intval(substr($config['k'], 7));
- if ($upd >= 1139 && $config['v'] != 'success') {
- $failed[] = $upd;
- }
- }
- DBA::close($configStmt);
-
- if (!count($failed)) {
- $o = Renderer::replaceMacros(Renderer::getMarkupTemplate('admin/dbsync/structure_check.tpl'), [
- '$base' => DI::baseUrl()->get(true),
- '$banner' => DI::l10n()->t('No failed updates.'),
- '$check' => DI::l10n()->t('Check database structure'),
- ]);
- } else {
- $o = Renderer::replaceMacros(Renderer::getMarkupTemplate('admin/dbsync/failed_updates.tpl'), [
- '$base' => DI::baseUrl()->get(true),
- '$banner' => DI::l10n()->t('Failed Updates'),
- '$desc' => DI::l10n()->t('This does not include updates prior to 1139, which did not return a status.'),
- '$mark' => DI::l10n()->t("Mark success \x28if update was manually applied\x29"),
- '$apply' => DI::l10n()->t('Attempt to execute this update step automatically'),
- '$failed' => $failed
- ]);
}
- return $o;
+ DI::baseUrl()->redirect('admin/dbsync');
+ return '';
}
}