import-sqlite-for-user.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. #!/usr/bin/env php
  2. <?php
  3. declare(strict_types=1);
  4. require(__DIR__ . '/_cli.php');
  5. performRequirementCheck(FreshRSS_Context::systemConf()->db['type'] ?? '');
  6. $cliOptions = new class extends CliOptionsParser {
  7. public string $user;
  8. public string $filename;
  9. public string $forceOverwrite;
  10. public function __construct() {
  11. $this->addRequiredOption('user', (new CliOption('user')));
  12. $this->addRequiredOption('filename', (new CliOption('filename')));
  13. $this->addOption('forceOverwrite', (new CliOption('force-overwrite'))->withValueNone());
  14. parent::__construct();
  15. }
  16. };
  17. if (!empty($cliOptions->errors)) {
  18. fail('FreshRSS error: ' . array_shift($cliOptions->errors) . "\n" . $cliOptions->usage);
  19. }
  20. $username = cliInitUser($cliOptions->user);
  21. $filename = $cliOptions->filename;
  22. if (pathinfo($filename, PATHINFO_EXTENSION) !== 'sqlite') {
  23. fail('Only *.sqlite files are supported!');
  24. }
  25. echo 'FreshRSS importing database from SQLite for user “', $username, "”…\n";
  26. $databaseDAO = FreshRSS_Factory::createDatabaseDAO($username);
  27. $clearFirst = isset($cliOptions->forceOverwrite);
  28. $ok = $databaseDAO->dbCopy($filename, FreshRSS_DatabaseDAO::SQLITE_IMPORT, $clearFirst);
  29. if (!$ok) {
  30. echo 'If you would like to clear the user database first, use the option --force-overwrite', "\n";
  31. }
  32. invalidateHttpCache($username);
  33. done($ok);