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