public static async Task<string> ChangeRecoveryModelType(ModelBackupSchedule _databaseSchedule, string recoveryModeValue)
{
try
{
string _command = null;
string script = null;
if (recoveryModeValue == "1")
{
script = $"ALTER DATABASE { _databaseSchedule.Databases.DatabaseName} SET RECOVERY FULL WITH NO_WAIT";
await SystemFileHelps.CreateFile($"{_databaseSchedule.Databases.Directory}/{_databaseSchedule.Directory}/setRecoveryFull{_databaseSchedule.Databases.DatabaseName}.sql", script, false);
_command = $"docker exec -i {_databaseSchedule.Databases.ConteinerName} /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P {_databaseSchedule.Databases.CustomerProduct.LoginPassword} -i /var/opt/mssql/{_databaseSchedule.Directory}/setRecoveryFull{_databaseSchedule.Databases.DatabaseName}.sql";
}
else if (recoveryModeValue == "3")
{
script = $"ALTER DATABASE {_databaseSchedule.Databases.DatabaseName} SET RECOVERY SIMPLE WITH NO_WAIT";
await SystemFileHelps.CreateFile($"{_databaseSchedule.Databases.Directory}/{_databaseSchedule.Directory}/setRecoverySimple{_databaseSchedule.Databases.DatabaseName}.sql", script, false);
_command = $"docker exec -i {_databaseSchedule.Databases.ConteinerName} /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P {_databaseSchedule.Databases.CustomerProduct.LoginPassword} -i /var/opt/mssql/{_databaseSchedule.Directory}/setRecoverySimple{_databaseSchedule.Databases.DatabaseName}.sql";
}
else
return $"Opção inválida{recoveryModeValue}(DatabaseServiceHelper/ChangeRecoveryModelType). 1 para FULL e 3 para SIMPLE.";
return await CommandBash.Execute(_command);
}
catch(Exception err)
{
if (!String.IsNullOrEmpty(err.InnerException.Message))
{
return err.Message + "\n" + err.InnerException.Message;
}
return err.Message;
}
}
public static async Task<string> ReturnRecoveryModelType(ModelBackupSchedule _databaseSchedule)
{
try
{
string _command = $"docker exec -i {_databaseSchedule.Databases.ConteinerName} /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P {_databaseSchedule.Databases.CustomerProduct.LoginPassword} -Q \"SELECT recovery_model_desc FROM sys.databases WHERE name = '{_databaseSchedule.Databases.DatabaseName}'\"; ";
string msg = await CommandBash.Execute(_command);
if (msg.Contains("FULL"))
return "1";
else if (msg.Contains("SIMPLE"))
return "3";
else if(msg.Contains("(0 rows affected)"))
{
return "0 rows affected";
}
else
return msg;
}
catch (Exception err)
{
if (!String.IsNullOrEmpty(err.InnerException.Message))
{
return err.Message + "\n" + err.InnerException.Message;
}
return err.Message;
}
}
public async static Task <string> UpdateCredential(string credentialFileName)
{
try
{
string script = $"/servicesCeltaWare/consolegoogle/ServicesCeltaWare.UtilitariosInfra.ConsoleGoogleApi 5 {credentialFileName} \"destinationName\" \"url\" \"folderId\" ";
string msg = await CommandBash.Execute(script);
if (!msg.ToUpperInvariant().Contains("OK"))
{
return(msg);
}
return(msg);
//string url = "http://192.168.100.115:8080/file/TokenResponse-user.TokenResponse-user";
//string destino = "/servicesCeltaWare/consolegoogle/credential/Google.Apis.Auth.OAuth2.Responses.TokenResponse-user";
//Uri siteUri = new Uri(url);
//WebClient client = new WebClient();
//await client.DownloadFileTaskAsync(siteUri, destino);
//return "ok";
}
catch (Exception err)
{
if (err.InnerException != null)
{
HelperLogs.WriteLog("HelperGoogleDrive UpdateCredential", err.Message + "\n" + err.InnerException.Message);
return(err.Message + "\n" + err.InnerException.Message);
}
HelperLogs.WriteLog("HelperGoogleDrive UpdateCredential", err.Message + "\n" + err.InnerException.Message);
return(err.Message);
}
}
public static async Task<string> Execute(string _command)
{
try
{
string msg = await CommandBash.Execute(_command);
return msg;
}
catch (Exception err)
{
return err.Message;
}
}
public async static Task <string> UploadFromLinux(string credentialFileName, string backupFileName, string path, string folderId)
{
try
{
string script = $"/servicesCeltaWare/consolegoogle/ServicesCeltaWare.UtilitariosInfra.ConsoleGoogleApi 1 {credentialFileName} \"{backupFileName}\" {path} {folderId}";
string msg = await CommandBash.Execute(script);
return(msg);
}
catch (Exception err)
{
return(err.Message);
}
}
public static async Task<string> Restart(string _command)
{
try
{
string _error = "iniciando";
string msg = null;
msg = await CommandBash.Execute(_command);
if (_error != "iniciando")
return _error;
else
return msg;
}
catch(Exception err)
{
throw err;
}
}
public async static Task <string> ValidFolderUpload(string credentialFileName, string folderName)
{
try
{
string script = $"/servicesCeltaWare/consolegoogle/ServicesCeltaWare.UtilitariosInfra.ConsoleGoogleApi 2 {credentialFileName} {"backupFileName"} {"path"} {folderName}";
string msg = await CommandBash.Execute(script);
if (msg.Contains("0"))
{
script = $"/servicesCeltaWare/consolegoogle/ServicesCeltaWare.UtilitariosInfra.ConsoleGoogleApi 3 {credentialFileName} {"backupFileName"} {"path"} {folderName}";
msg = await CommandBash.Execute(script);
}
return(msg);
}
catch (Exception err)
{
return(err.Message);
}
}
