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 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 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); }
public void ExportEndDump() { var sb = new StringBuilder(); sb.AppendLine("/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;"); sb.AppendLine("/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;"); sb.AppendLine("/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;"); sb.AppendLine("/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;"); sb.AppendLine("/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;"); sb.AppendLine("/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;"); sb.AppendLine("/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;"); sb.AppendLine("/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;"); _exportToFile.ExportWriteLine(sb.ToString()); }
public void ExportarLinhasTableDados(ExportToFile exportToFile, string table) { var mySqlConnection = BackupMySqlConnection.CriarConexao(); var sql = string.Format("SELECT * FROM `{0}`;", table); try { if (mySqlConnection.State != ConnectionState.Open) { mySqlConnection.Open(); } using (var command = new MySqlCommand(sql, mySqlConnection)) { var rdr = command.ExecuteReader(); var totalBytes = default(int); if (!rdr.HasRows) { return; } _exportToFile.ExportWriteLine(); _exportToFile.ExportWriteLine(string.Format("LOCK TABLES `{0}` WRITE;", table)); _exportToFile.ExportWriteLine(); exportToFile.ExportWriteLine(); exportToFile.ExportWriteLine(string.Format("/*!40000 ALTER TABLE `{0}` DISABLE KEYS */;", table)); exportToFile.ExportWriteLine(); exportToFile.ExportWriteLine(); ExcluirIndex(table); exportToFile.ExportWriteLine(); while (rdr.Read()) { try { var sqlDataRow = GetValueString(rdr, table); exportToFile.ExportWriteLine(sqlDataRow); totalBytes += sqlDataRow.Length; if (totalBytes < VariaveisGeral.LimiteCommit) { continue; } exportToFile.ExportWriteCommit(); totalBytes = 0; } catch (Exception e) { Console.Write("tabela ==> " + table); Console.WriteLine(e); } } exportToFile.ExportWriteLine(); exportToFile.ExportWriteLine(string.Format("/*!40000 ALTER TABLE `{0}` ENABLE KEYS */;", table)); exportToFile.ExportWriteLine(); IncluirIndex(table); _exportToFile.ExportWriteLine(); _exportToFile.ExportWriteLine("UNLOCK TABLES;"); _exportToFile.ExportWriteLine(); } } catch (Exception e) { Console.WriteLine(e); } }
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); }