public void GerarArquivoDumpProcedure(string procedure, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
var queryExpress = VariaveisGeral.Container.GetInstance <IQueryExpress>();
var sqlDefiner = FactorySql.SqlGetAllProcedures();
var definer = queryExpress.ExecuteScalarString(sqlDefiner, "Definer");
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteLine(string.Format("DROP PROCEDURE IF EXISTS `{0}`;", procedure));
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteComment(string.Format("Definições da Procedure '{0}'", procedure));
_exportToFile.ExportWriteComment("");
var sqlCreateProcedure = FactorySql.SqlCreateProcedure(procedure: procedure, definer: definer) + ";";
_exportToFile.ExportWriteLine(sqlCreateProcedure);
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public IEnumerable <string> RelacaoNomeProcedures()
{
try
{
var sql = FactorySql.SqlGetAllProcedures();
try
{
var listProcedures = _queryExpress.ExecuteReader(sql, "name").ToList();
return(listProcedures.OrderBy(x => x).ToList());
}
catch (Exception e)
{
Console.WriteLine(e);
return(new List <string>());
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(new List <string>());
}
}
