public async Task ExecuteAsync(IPluginJobContext context) { if (!CliUtils.ParseArgs(_options, context.Args)) { return; } if (_isHelp) { PrintUsage(); return; } await Console.Out.WriteLineAsync($"Cli version: {_settingsManager.Version}"); var entryAssembly = Assembly.GetExecutingAssembly(); await Console.Out.WriteLineAsync($"Cli location: {entryAssembly.Location}"); await Console.Out.WriteLineAsync($"Work location: {_settingsManager.ContentRootPath}"); var configPath = CliUtils.GetConfigPath(_settingsManager); if (FileUtils.IsFileExists(configPath)) { await Console.Out.WriteLineAsync($"Database type: {_settingsManager.Database.DatabaseType.GetDisplayName()}"); await Console.Out.WriteLineAsync($"Database connection string: {_settingsManager.DatabaseConnectionString}"); if (!string.IsNullOrEmpty(_settingsManager.DatabaseConnectionString)) { var(isConnectionWorks, errorMessage) = await _settingsManager.Database.IsConnectionWorksAsync(); if (!isConnectionWorks) { await WriteUtils.PrintErrorAsync($"Unable to connect to database, error message:{errorMessage}"); return; } await Console.Out.WriteLineAsync("Database status: Connection successful"); } var plugins = _pluginManager.Plugins; foreach (var plugin in plugins) { await Console.Out.WriteLineAsync($"PluginId: {plugin.PluginId}, Version: {plugin.Version}"); } } else { await Console.Out.WriteLineAsync($"The sscms.json file does not exist: {configPath}"); } var(status, _) = _apiService.GetStatus(); if (status != null) { await Console.Out.WriteLineAsync($"Login user: {status.UserName}"); } }
public async Task ExecuteAsync(IPluginJobContext context) { if (!CliUtils.ParseArgs(_options, context.Args)) { return; } if (_isHelp) { PrintUsage(); return; } var directory = _directory; if (string.IsNullOrEmpty(directory)) { directory = string.Empty; } var configPath = CliUtils.GetConfigPath(_settingsManager); if (!FileUtils.IsFileExists(configPath)) { await WriteUtils.PrintErrorAsync($"The sscms.json file does not exist: {configPath}"); return; } await Console.Out.WriteLineAsync($"Database type: {_settingsManager.DatabaseType.GetDisplayName()}"); await Console.Out.WriteLineAsync($"Database connection string: {_settingsManager.DatabaseConnectionString}"); var(isConnectionWorks, errorMessage) = await _settingsManager.Database.IsConnectionWorksAsync(); if (!isConnectionWorks) { await WriteUtils.PrintErrorAsync($"Unable to connect to database, error message: {errorMessage}"); return; } var site = await _databaseManager.SiteRepository.GetSiteByDirectoryAsync(directory); if (site == null) { await WriteUtils.PrintErrorAsync($"Unable to find the site, directory: {directory}"); return; } await Console.Out.WriteLineAsync($"site: {site.SiteName}"); //await _createManager.CreateByAllAsync(site.Id); await _createManager.ExecuteAsync(site.Id, CreateType.All, 0, 0, 0, 0); await WriteUtils.PrintSuccessAsync("create pages successfully!"); }
public async Task ExecuteAsync(IPluginJobContext context) { if (!CliUtils.ParseArgs(_options, context.Args)) { return; } if (_isHelp) { PrintUsage(); return; } var directory = _directory; if (string.IsNullOrEmpty(directory)) { directory = $"backup/{DateTime.Now:yyyy-MM-dd}"; } var treeInfo = new TreeInfo(_settingsManager, directory); DirectoryUtils.CreateDirectoryIfNotExists(treeInfo.DirectoryPath); var configPath = CliUtils.GetConfigPath(_settingsManager); if (!FileUtils.IsFileExists(configPath)) { await WriteUtils.PrintErrorAsync($"The sscms.json file does not exist: {configPath}"); return; } await Console.Out.WriteLineAsync($"Database type: {_settingsManager.DatabaseType.GetDisplayName()}"); await Console.Out.WriteLineAsync($"Database connection string: {_settingsManager.DatabaseConnectionString}"); await Console.Out.WriteLineAsync($"Backup folder: {treeInfo.DirectoryPath}"); //WebConfigUtils.Load(_settingsManager.ContentRootPath, webConfigPath); //if (string.IsNullOrEmpty(WebConfigUtils.ConnectionString)) //{ // await CliUtils.PrintErrorAsync($"{webConfigPath} 中数据库连接字符串 connectionString 未设置"); // return; //} //await Console.Out.WriteLineAsync($"数据库类型: {_settingsManager.Database.DatabaseType.GetValue()}"); //await Console.Out.WriteLineAsync($"连接字符串: {WebConfigUtils.ConnectionString}"); //await Console.Out.WriteLineAsync($"备份文件夹: {treeInfo.DirectoryPath}"); //var (isConnectionWorks, errorMessage) = await _settingsManager.Database.IsConnectionWorksAsync(); //if (!isConnectionWorks) //{ // await CliUtils.PrintErrorAsync($"数据库连接错误:{errorMessage}"); // return; //} var(isConnectionWorks, errorMessage) = await _settingsManager.Database.IsConnectionWorksAsync(); if (!isConnectionWorks) { await WriteUtils.PrintErrorAsync($"Unable to connect to database, error message:{errorMessage}"); return; } if (_excludes == null) { _excludes = new List <string>(); } _excludes.Add("bairong_Log"); _excludes.Add("bairong_ErrorLog"); _excludes.Add("siteserver_ErrorLog"); _excludes.Add("siteserver_Log"); _excludes.Add("siteserver_Tracking"); var errorLogFilePath = CliUtils.DeleteErrorLogFileIfExists(CommandName, _settingsManager); await Backup(_settingsManager, _databaseManager, _includes, _excludes, _maxRows, treeInfo, errorLogFilePath); await WriteUtils.PrintRowLineAsync(); await WriteUtils.PrintSuccessAsync("backup database to folder successfully!"); }
public async Task ExecuteAsync(IPluginJobContext context) { if (!CliUtils.ParseArgs(_options, context.Args)) { return; } if (_isHelp) { PrintUsage(); return; } if (string.IsNullOrEmpty(_directory)) { await WriteUtils.PrintErrorAsync("Restore folder name not specified: --directory"); return; } var treeInfo = new TreeInfo(_settingsManager, _directory); if (!DirectoryUtils.IsDirectoryExists(treeInfo.DirectoryPath)) { await WriteUtils.PrintErrorAsync($"恢复数据的文件夹 {treeInfo.DirectoryPath} 不存在"); return; } var tablesFilePath = treeInfo.TablesFilePath; if (!FileUtils.IsFileExists(tablesFilePath)) { await WriteUtils.PrintErrorAsync($"恢复文件 {treeInfo.TablesFilePath} 不存在"); return; } var configPath = CliUtils.GetConfigPath(_settingsManager); if (!FileUtils.IsFileExists(configPath)) { await WriteUtils.PrintErrorAsync($"The sscms.json file does not exist: {configPath}"); return; } //WebConfigUtils.Load(_settingsManager.ContentRootPath, webConfigPath); //if (string.IsNullOrEmpty(WebConfigUtils.ConnectionString)) //{ // await CliUtils.PrintErrorAsync($"{webConfigPath} 中数据库连接字符串 connectionString 未设置"); // return; //} //await Console.Out.WriteLineAsync($"数据库类型: {_settingsManager.Database.DatabaseType.GetValue()}"); //await Console.Out.WriteLineAsync($"连接字符串: {WebConfigUtils.ConnectionString}"); //await Console.Out.WriteLineAsync($"恢复文件夹: {treeInfo.DirectoryPath}"); await Console.Out.WriteLineAsync($"Database type: {_settingsManager.Database.DatabaseType.GetDisplayName()}"); await Console.Out.WriteLineAsync($"Database connection string: {_settingsManager.Database.ConnectionString}"); await Console.Out.WriteLineAsync($"Restore folder: {treeInfo.DirectoryPath}"); var(isConnectionWorks, errorMessage) = await _settingsManager.Database.IsConnectionWorksAsync(); if (!isConnectionWorks) { await WriteUtils.PrintErrorAsync($"Unable to connect to database, error message:{errorMessage}"); return; } //if (!_dataOnly) //{ // if (!await _configRepository.IsNeedInstallAsync()) // { // await WriteUtils.PrintErrorAsync("The data could not be restored on the installed sscms database"); // return; // } // // 恢复前先创建表,确保系统在恢复的数据库中能够使用 // //await _databaseManager.CreateSiteServerTablesAsync(); // if (_settingsManager.DatabaseType == DatabaseType.SQLite) // { // var filePath = PathUtils.Combine(_settingsManager.ContentRootPath, Constants.DefaultLocalDbFileName); // if (!FileUtils.IsFileExists(filePath)) // { // await FileUtils.WriteTextAsync(filePath, string.Empty); // } // } // await _databaseManager.SyncDatabaseAsync(); //} await WriteUtils.PrintRowLineAsync(); await WriteUtils.PrintRowAsync("Restore table name", "Count"); await WriteUtils.PrintRowLineAsync(); var errorLogFilePath = CliUtils.DeleteErrorLogFileIfExists(_settingsManager); var errorTableNames = await _restoreService.RestoreAsync(_includes, _excludes, tablesFilePath, treeInfo, errorLogFilePath); if (errorTableNames.Count == 0) { await WriteUtils.PrintSuccessAsync("restore database successfully!"); } else { await WriteUtils.PrintErrorAsync($"Database restore failed and the following table was not successfully restored: {ListUtils.ToString(errorTableNames)}"); } }