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