public void GetTotalRows(MySqlCommand cmd, GetTotalRowsMethod enumGetTotalRowsMode)
{
if (enumGetTotalRowsMode == GetTotalRowsMethod.InformationSchema)
{
DataTable dtTotalRows = QueryExpress.GetTable(cmd, string.Format("SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = '{0}';", _name));
int _tableCountTotalRow = 0;
foreach (DataRow dr in dtTotalRows.Rows)
{
string _tbname = dr["TABLE_NAME"] + "";
long _totalRowsThisTable = 0L;
long.TryParse(dr["TABLE_ROWS"] + "", out _totalRowsThisTable);
if (_listTable.Contains(_tbname))
{
_listTable[_tbname].SetTotalRows(_totalRowsThisTable);
}
}
}
else if (enumGetTotalRowsMode == GetTotalRowsMethod.SelectCount)
{
for (int i = 0; i < _listTable.Count; i++)
{
_listTable[i].GetTotalRowsByCounting(cmd);
if (GetTotalRowsProgressChanged != null)
{
GetTotalRowsProgressChanged(this, new GetTotalRowsArgs(_listTable.Count, i + 1));
}
}
}
}
public void GetTotalRows(MySqlCommand cmd, GetTotalRowsMethod enumGetTotalRowsMode)
{
int i = 0;
var timer = new Timer
{
Interval = 10000
};
timer.Elapsed += (sender, e) =>
{
GetTotalRowsProgressChanged?.Invoke(this, new GetTotalRowsArgs(_listTable.Count, i));
};
if (enumGetTotalRowsMode == GetTotalRowsMethod.InformationSchema)
{
DataTable dtTotalRows = QueryExpress.GetTable(cmd, string.Format("SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = '{0}';", _name));
timer.Start();
foreach (DataRow dr in dtTotalRows.Rows)
{
i++;
var _tbname = dr["TABLE_NAME"] + "";
long.TryParse(dr["TABLE_ROWS"] + "", out var _totalRowsThisTable);
if (_listTable.Contains(_tbname))
{
_listTable[_tbname].SetTotalRows((long)(_totalRowsThisTable * 1.1)); // Adiciona 10% de erro
}
}
timer.Stop();
GetTotalRowsProgressChanged?.Invoke(this, new GetTotalRowsArgs(_listTable.Count, _listTable.Count));
}
else if (enumGetTotalRowsMode == GetTotalRowsMethod.SelectCount)
{
timer.Start();
foreach (var table in _listTable)
{
i++;
table.GetTotalRowsByCounting(cmd);
}
timer.Stop();
GetTotalRowsProgressChanged?.Invoke(this, new GetTotalRowsArgs(_listTable.Count, _listTable.Count));
}
}
public void GetDatabaseInfo(MySqlCommand cmd, GetTotalRowsMethod enumGetTotalRowsMode)
{
_name = QueryExpress.ExecuteScalarStr(cmd, "SELECT DATABASE();");
_defaultCharSet = QueryExpress.ExecuteScalarStr(cmd, "SHOW VARIABLES LIKE 'character_set_database';", 1);
_createDatabaseSql = QueryExpress.ExecuteScalarStr(cmd, string.Format("SHOW CREATE DATABASE `{0}`;", _name), 1).Replace("CREATE DATABASE", "CREATE DATABASE IF NOT EXISTS") + ";";
_dropDatabaseSql = string.Format("DROP DATABASE IF EXISTS `{0}`;", _name);
_listTable = new MySqlTableList(cmd);
_listProcedure = new MySqlProcedureList(cmd);
_listFunction = new MySqlFunctionList(cmd);
_listTrigger = new MySqlTriggerList(cmd);
_listEvent = new MySqlEventList(cmd);
_listView = new MySqlViewList(cmd);
if (enumGetTotalRowsMode != GetTotalRowsMethod.Skip)
{
GetTotalRows(cmd, enumGetTotalRowsMode);
}
}
public void GetDatabaseInfo(string conn, GetTotalRowsMethod enumGetTotalRowsMode)
{
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = new MySqlConnection(conn);
cmd.Connection.Open();
_name = QueryExpress.ExecuteScalarStr(cmd, "SELECT DATABASE();");
_defaultCharSet = QueryExpress.ExecuteScalarStr(cmd, "SHOW VARIABLES LIKE 'character_set_database';", 1);
_createDatabaseSql = QueryExpress.ExecuteScalarStr(cmd, string.Format("SHOW CREATE DATABASE `{0}`;", _name), 1).Replace("CREATE DATABASE", "CREATE DATABASE IF NOT EXISTS") + ";";
_dropDatabaseSql = string.Format("DROP DATABASE IF EXISTS `{0}`;", _name);
_listTable = new MySqlTableList(cmd);
cmd.Connection.Close();
// SELECT
//CONCAT_WS(' ',
// 'DELIMITER $$\n',
// 'CREATE ',
// CONCAT_WS('=', r.SECURITY_TYPE, CONCAT_WS('@', CONCAT('`', SUBSTRING_INDEX(r.`definer`, '@', 1), '`'), CONCAT('`', SUBSTRING_INDEX(r.`definer`, '@', -1), '`'))),
// '\n',
// r.ROUTINE_TYPE,
// CONCAT_WS('.', ROUTINE_SCHEMA, ROUTINE_NAME),
// CONCAT('(', GROUP_CONCAT(CONCAT_WS(' ', p.PARAMETER_NAME, p.DTD_IDENTIFIER)), ')'),
// IF(o_p.DTD_IDENTIFIER is not null, CONCAT('RETURNS ', o_p.DTD_IDENTIFIER), ''),
// ROUTINE_DEFINITION,
// '$$') stmt_ FROM information_schema.routines r
//LEFT JOIN information_schema.parameters p
//ON p.SPECIFIC_SCHEMA = r.routine_schema AND
//p.specific_name = r.routine_name AND p.PARAMETER_MODE = 'IN'
//LEFT JOIN information_schema.parameters o_p ON o_p.SPECIFIC_SCHEMA =
// r.routine_schema AND o_p.specific_name = r.routine_name AND o_p.PARAMETER_MODE
// IS NULL WHERE ROUTINE_SCHEMA IN('grt_talentoz')
//GROUP BY
//CONCAT_WS('.', ROUTINE_SCHEMA, ROUTINE_NAME)
var pro = Task.Factory.StartNew(() =>
{
MySqlCommand cmd1 = new MySqlCommand();
cmd1.Connection = new MySqlConnection(conn);
cmd1.Connection.Open();
_listProcedure = new MySqlProcedureList(cmd1);
cmd1.Connection.Close();
});
var fn = Task.Factory.StartNew(() =>
{
MySqlCommand cmd1 = new MySqlCommand();
cmd1.Connection = new MySqlConnection(conn);
cmd1.Connection.Open();
_listFunction = new MySqlFunctionList(cmd1);
cmd1.Connection.Close();
});
var trg = Task.Factory.StartNew(() =>
{
MySqlCommand cmd1 = new MySqlCommand();
cmd1.Connection = new MySqlConnection(conn);
cmd1.Connection.Open();
_listTrigger = new MySqlTriggerList(cmd1);
cmd1.Connection.Close();
});
var evnt = Task.Factory.StartNew(() =>
{
MySqlCommand cmd1 = new MySqlCommand();
cmd1.Connection = new MySqlConnection(conn);
cmd1.Connection.Open();
_listEvent = new MySqlEventList(cmd1);
cmd1.Connection.Close();
});
var vw = Task.Factory.StartNew(() =>
{
MySqlCommand cmd1 = new MySqlCommand();
cmd1.Connection = new MySqlConnection(conn);
cmd1.Connection.Open();
_listView = new MySqlViewList(cmd1);
cmd1.Connection.Close();
});
Task.WaitAll(pro, fn, trg, evnt, vw);
if (enumGetTotalRowsMode != GetTotalRowsMethod.Skip)
{
GetTotalRows(cmd, enumGetTotalRowsMode);
}
}
