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