public DataTable GetTable(string sql) { var mySqlConnection = BackupMySqlConnection.CriarConexao(); var dt = new DataTable(); try { if (mySqlConnection.State != ConnectionState.Open) { mySqlConnection.Open(); } using (var command = new MySqlCommand(sql, mySqlConnection)) { command.CommandText = sql; using (var da = new MySqlDataAdapter(command)) { da.Fill(dt); } return(dt); } } catch (Exception e) { Console.WriteLine(e); return(new DataTable()); } finally { mySqlConnection.Close(); } }
public string ExecuteScalarString(string sql) { var mySqlConnection = BackupMySqlConnection.CriarConexao(); try { if (mySqlConnection.State != ConnectionState.Open) { mySqlConnection.Open(); } using (var command = new MySqlCommand(sql, mySqlConnection)) { command.CommandText = sql; var ob = command.ExecuteScalar(); if (ob is byte[] bytes) { return(Encoding.UTF8.GetString(bytes)); } return(ob + ""); } } catch (Exception e) { Console.WriteLine(e); return(string.Empty); } finally { mySqlConnection.Close(); } }
private void PreencherDadosServidor() { using (var mySqlConnection = BackupMySqlConnection.CriarConexao()) { Server = mySqlConnection.DataSource; DataBase = mySqlConnection.Database; } }
public IEnumerable <string> ExecuteReader(string sql, int columnIndex) { var result = new List <string>(); var mySqlConnection = BackupMySqlConnection.CriarConexao(); try { if (mySqlConnection.State != ConnectionState.Open) { mySqlConnection.Open(); } using (var command = new MySqlCommand(sql, mySqlConnection)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var r = reader[columnIndex].ToString(); result.Add(r); } } } } catch (Exception e) { Console.WriteLine(e); return(new List <string>()); } finally { mySqlConnection.Close(); } return(result); }
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); } }