public void GerarArquivoDumpView(string view, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteLine(string.Format("DROP TABLE IF EXISTS `{0}`;", view));
_exportToFile.ExportWriteLine(string.Format("DROP VIEW IF EXISTS `{0}`;", view));
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteComment(string.Format("Definições da View '{0}'", view));
_exportToFile.ExportWriteComment("");
var sqlCreateView = FactorySql.SqlCreateView(view);
_exportToFile.ExportWriteLine(sqlCreateView);
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void GerarArquivoDumpEvent(string eventName, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
var queryExpress = VariaveisGeral.Container.GetInstance <IQueryExpress>();
var sqlDefiner = FactorySql.SqlGetAllEvents();
var definer = queryExpress.ExecuteScalarString(sqlDefiner, "Definer");
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteLine(string.Format("DROP EVENT IF EXISTS `{0}`;", eventName));
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteComment(string.Format("Definições do Event '{0}'", eventName));
_exportToFile.ExportWriteComment("");
var sqlCreateProcedure = FactorySql.SqlCreateEvent(eventName: eventName, definer: definer) + ";";
_exportToFile.ExportWriteLine(sqlCreateProcedure);
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void GerarArquivoDumpTrigger(string trigger, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
var queryExpress = VariaveisGeral.Container.GetInstance <IQueryExpress>();
var sqlDefiner = FactorySql.SqlGetAllTriggers;
var definer = queryExpress.ExecuteScalarString(sqlDefiner, "Definer");
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteLine(string.Format("DROP TRIGGER `{0}`;", trigger));
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteComment(string.Format("Definições da Trigger '{0}'", trigger));
_exportToFile.ExportWriteComment("");
var sqlCreateTrigger = FactorySql.SqlCreateTrigger(trigger: trigger, definer: definer) + ";";
_exportToFile.ExportWriteLine(sqlCreateTrigger);
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public bool GerarArquivoCriacaoTable(string table, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteLine();
_exportToFile.ExportLinhaTracejada();
_exportToFile.ExportWrite(string.Format("USE {0};", VariaveisGeral.Database));
_exportToFile.ExportLinhaTracejada();
var headerTable = HeaderTable();
_exportToFile.ExportLinhaTracejada();
_exportToFile.ExportWrite(headerTable);
_exportToFile.ExportLinhaTracejada();
var sqlDropIfExiste = SqlDropTableIfExiste(table);
_exportToFile.ExportWrite(sqlDropIfExiste);
_exportToFile.ExportLinhaTracejada();
var sqlCreate = FactorySql.SqlCreateTable(table);
_exportToFile.ExportWrite(sqlCreate);
_exportToFile.ExportWriteLine();
_exportToFile.ExportLinhaTracejada();
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.Write(e);
return(false);
}
return(true);
}
internal static bool GerarArquivoCriacaoDatabase(this MySqlDatabase database, string fileName, string sql)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWrite(sql);
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.Write(e);
return(false);
}
return(true);
}
public bool GerarArquivoDumpTable(string table, string fileName)
{
try
{
using (_exportToFile = new ExportToFile(fileName))
{
_exportToFile.ExportHeaderDatabase();
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteComment(string.Format("Definições da table '{0}'", table));
_exportToFile.ExportWriteComment("");
_exportToFile.ExportWriteLine();
_exportToFile.ExportWriteLine();
_exportToFile.ExportLinhaTracejada();
_exportToFile.ExportWrite(string.Format("USE {0};", VariaveisGeral.Database));
_exportToFile.ExportLinhaTracejada();
var headerTable = HeaderTable();
_exportToFile.ExportLinhaTracejada();
_exportToFile.ExportWrite(headerTable);
_exportToFile.ExportLinhaTracejada();
var sqlDropIfExiste = SqlDropTableIfExiste(table);
_exportToFile.ExportWrite(sqlDropIfExiste);
_exportToFile.ExportWriteLine();
var sqlCreate = FactorySql.SqlCreateTable(table);
_exportToFile.ExportWrite(sqlCreate);
_exportToFile.ExportWriteLine();
_exportToFile.ExportWriteLine("/*!40101 SET character_set_client = @saved_cs_client */;");
_exportToFile.ExportWriteLine();
_exportToFile.ExportLinhaTracejada();
ExportarLinhasTable(_exportToFile, table);
ExportEndDump();
_exportToFile.Export_EndInfo();
}
}
catch (Exception e)
{
Console.Write(e);
return(false);
}
return(true);
}
