BookStack Code Mirror - system-cli/blob - tests/Commands/RestoreCommandTest.php

   1 <?php declare(strict_types=1);
   2
   3 namespace Tests\Commands;
   4
   5 use mysqli;
   6 use Tests\TestCase;
   7
   8 class RestoreCommandTest extends TestCase
   9 {
  10
  11     public function test_restore_into_cwd_by_default_with_all_content_types()
  12     {
  13         $mysql = new mysqli('db', 'bookstack', 'bookstack', 'bookstack');
  14         $mysql->query('CREATE TABLE xx_testing (labels varchar(255));');
  15
  16         $result = $mysql->query('SHOW TABLES LIKE \'zz_testing\';');
  17         $this->assertEquals(0, mysqli_num_rows($result));
  18
  19         $zipFile = $this->buildZip(function (\ZipArchive $zip) {
  20             $zip->addFromString('.env', "APP_KEY=abc123\nAPP_URL=https://example.com");
  21             $zip->addFromString('public/uploads/test.txt', 'hello-public-uploads');
  22             $zip->addFromString('storage/uploads/test.txt', 'hello-storage-uploads');
  23             $zip->addFromString('themes/test.txt', 'hello-themes');
  24             $zip->addFromString('db.sql', "CREATE TABLE zz_testing (names varchar(255));\nINSERT INTO zz_testing values ('barry');");
  25         });
  26
  27         exec('cp -r /var/www/bookstack /var/www/bookstack-restore');
  28         chdir('/var/www/bookstack-restore');
  29
  30         $result = $this->runCommand('restore', [
  31             'backup-zip' => $zipFile,
  32         ], [
  33             'yes', '1'
  34         ]);
  35
  36         $result->dumpError();
  37         $result->assertSuccessfulExit();
  38         $result->assertStdoutContains('✔ .env Config File');
  39         $result->assertStdoutContains('✔ Themes Folder');
  40         $result->assertStdoutContains('✔ Public File Uploads');
  41         $result->assertStdoutContains('✔ Private File Uploads');
  42         $result->assertStdoutContains('✔ Database Dump');
  43         $result->assertStdoutContains('Restore operation complete!');
  44
  45         $result = $mysql->query('SELECT * FROM zz_testing where names = \'barry\';');
  46         $this->assertEquals(1, mysqli_num_rows($result));
  47         $result = $mysql->query('SHOW TABLES LIKE \'xx_testing\';');
  48         $this->assertEquals(0, mysqli_num_rows($result));
  49
  50         $this->assertStringEqualsFile('/var/www/bookstack-restore/public/uploads/test.txt', 'hello-public-uploads');
  51         $this->assertStringEqualsFile('/var/www/bookstack-restore/storage/uploads/test.txt', 'hello-storage-uploads');
  52         $this->assertStringEqualsFile('/var/www/bookstack-restore/themes/test.txt', 'hello-themes');
  53
  54         $mysql->query("DROP TABLE zz_testing;");
  55         exec('rm -rf /var/www/bookstack-restore');
  56     }
  57
  58     public function test_command_fails_on_zip_with_no_expected_contents()
  59     {
  60         $zipFile = $this->buildZip(function (\ZipArchive $zip) {
  61             $zip->addFromString('spaghetti', "Hello world!");
  62         });
  63
  64         chdir('/var/www/bookstack');
  65
  66         $result = $this->runCommand('restore', [
  67             'backup-zip' => $zipFile,
  68         ]);
  69
  70         $result->assertErrorExit();
  71         $result->assertStderrContains("Provided ZIP backup [{$zipFile}] does not have any expected restorable content.");
  72     }
  73
  74     public function test_limited_restore_using_app_directory_option()
  75     {
  76         $zipFile = $this->buildZip(function (\ZipArchive $zip) {
  77             $zip->addFromString('db.sql', "CREATE TABLE zz_testing (names varchar(255));");
  78             $zip->addFromString('themes/hello.txt', "limited restore test!");
  79         });
  80
  81         chdir('/home');
  82
  83         $result = $this->runCommand('restore', [
  84             'backup-zip' => $zipFile,
  85             '--app-directory' => '/var/www/bookstack'
  86         ], ['yes']);
  87
  88         $result->assertSuccessfulExit();
  89         $result->assertStdoutContains('❌ .env Config File');
  90         $result->assertStdoutContains('✔ Themes Folder');
  91         $result->assertStdoutContains('❌ Public File Uploads');
  92         $result->assertStdoutContains('❌ Private File Uploads');
  93         $result->assertStdoutContains('✔ Database Dump');
  94         $this->assertStringEqualsFile('/var/www/bookstack/themes/hello.txt', 'limited restore test!');
  95
  96         unlink('/var/www/bookstack/themes/hello.txt');
  97         $mysql = new mysqli('db', 'bookstack', 'bookstack', 'bookstack');
  98         $mysql->query("DROP TABLE zz_testing;");
  99     }
 100
 101     protected function buildZip(callable $builder): string
 102     {
 103         $zipFile = tempnam(sys_get_temp_dir(), 'cli-test');
 104         $testZip = new \ZipArchive('');
 105         $testZip->open($zipFile);
 106         $builder($testZip);
 107         $testZip->close();
 108
 109         return $zipFile;
 110     }
 111 }