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