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)}");
}
}