bump version 2023.12

[friendica.git] / src / Console / DatabaseStructure.php

diff --git a/src/Console/DatabaseStructure.php b/src/Console/DatabaseStructure.php
index b44400c01a0b710c6cb8dc8b36c6239b6c155731..4d4125e88a7d6cf2f9de7f919221caa7feb64fc0 100644 (file)
--- a/src/Console/DatabaseStructure.php
+++ b/src/Console/DatabaseStructure.php
@@ -1,6 +1,6 @@
 <?php
 /**
 <?php
 /**

- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2023, the Friendica project

  *
  * @license GNU AGPL version 3 or any later version
  *
  *
  * @license GNU AGPL version 3 or any later version
  *


@@ -21,10 +21,16 @@
 
 namespace Friendica\Console;
 
 
 namespace Friendica\Console;
 

-use Friendica\Core\Config\Cache;
+use Friendica\Core\Config\Capability\IManageConfigValues;

 use Friendica\Core\Update;
 use Friendica\Database\Database;
 use Friendica\Database\DBStructure;
 use Friendica\Core\Update;
 use Friendica\Database\Database;
 use Friendica\Database\DBStructure;

+use Friendica\Database\Definition\DbaDefinition;
+use Friendica\Database\Definition\ViewDefinition;
+use Friendica\Util\BasePath;
+use Friendica\Util\Writer\DbaDefinitionSqlWriter;
+use Friendica\Util\Writer\DocWriter;
+use Friendica\Util\Writer\ViewDefinitionSqlWriter;

 use RuntimeException;
 
 /**
 use RuntimeException;
 
 /**


@@ -34,14 +40,20 @@ class DatabaseStructure extends \Asika\SimpleConsole\Console
 {
        protected $helpOptions = ['h', 'help', '?'];
 
 {
        protected $helpOptions = ['h', 'help', '?'];
 

-       /**
-        * @var Database
-        */
+       /** @var Database */

        private $dba;
        private $dba;

-       /**
-        * @var Cache
-        */
-       private $configCache;
+
+       /** @var IManageConfigValues */
+       private $config;
+
+       /** @var DbaDefinition */
+       private $dbaDefinition;
+
+       /** @var ViewDefinition */
+       private $viewDefinition;
+
+       /** @var string */
+       private $basePath;

 
        protected function getHelp()
        {
 
        protected function getHelp()
        {


@@ -52,7 +64,7 @@ Usage
 
 Commands
     drop     Show tables that aren't in use by Friendica anymore and can be dropped
 
 Commands
     drop     Show tables that aren't in use by Friendica anymore and can be dropped

-       -e|--execute    Execute the dropping
+       -e|--execute    Execute the removal

 
     update   Update database schema
        -f|--force      Force the update command (Even if the database structure matches)
 
     update   Update database schema
        -f|--force      Force the update command (Even if the database structure matches)


@@ -71,15 +83,18 @@ HELP;
                return $help;
        }
 
                return $help;
        }
 

-       public function __construct(Database $dba, Cache $configCache, $argv = null)
+       public function __construct(Database $dba, DbaDefinition $dbaDefinition, ViewDefinition $viewDefinition, BasePath $basePath, IManageConfigValues $config, $argv = null)

        {
                parent::__construct($argv);
 
                $this->dba = $dba;
        {
                parent::__construct($argv);
 
                $this->dba = $dba;

-               $this->configCache = $configCache;
+               $this->dbaDefinition = $dbaDefinition;
+               $this->viewDefinition = $viewDefinition;
+               $this->config = $config;
+               $this->basePath = $basePath->getPath();

        }
 
        }
 

-       protected function doExecute()
+       protected function doExecute(): int

        {
                if ($this->getOption('v')) {
                        $this->out('Class: ' . __CLASS__);
        {
                if ($this->getOption('v')) {
                        $this->out('Class: ' . __CLASS__);


@@ -102,7 +117,7 @@ HELP;
                        throw new RuntimeException('Unable to connect to database');
                }
 
                        throw new RuntimeException('Unable to connect to database');
                }
 

-               $basePath = $this->configCache->get('system', 'basepath');
+               $basePath = $this->config->get('system', 'basepath');

 
                switch ($this->getArgument(0)) {
                        case "dryrun":
 
                switch ($this->getArgument(0)) {
                        case "dryrun":


@@ -120,10 +135,9 @@ HELP;
                                $output = ob_get_clean();
                                break;
                        case "dumpsql":
                                $output = ob_get_clean();
                                break;
                        case "dumpsql":

-                               DBStructure::writeStructure();
-                               ob_start();
-                               DBStructure::printStructure($basePath);
-                               $output = ob_get_clean();
+                               DocWriter::writeDbDefinition($this->dbaDefinition, $this->basePath);
+                               $output = DbaDefinitionSqlWriter::create($this->dbaDefinition);
+                               $output .= ViewDefinitionSqlWriter::create($this->viewDefinition);

                                break;
                        case "toinnodb":
                                ob_start();
                                break;
                        case "toinnodb":
                                ob_start();