public void search_table()
{
var cur_table = new cmd_wraper.table_cmd(curr_conn, tbl_name, db_name);
var show_create = cur_table.show_createtable();
var blob_pattern = @"\`[a-zA-Z_]{3,20}\`\slongblob";
var rawint_pattern = @"\`sm_[a-zA-Z_]{1,20}\`\sbigint\(20\)";
var name_pattern = @"\`[^\`]+\`";
var blob_matches = System.Text.RegularExpressions.Regex.Matches(show_create, blob_pattern);
foreach (System.Text.RegularExpressions.Match m in blob_matches)
{
var m2 = System.Text.RegularExpressions.Regex.Match(m.Value, name_pattern);
var column_name = m2.Value;
column_name = column_name.Substring(1, column_name.Length - 2);
serach_column(column_name, false);
}
var rawint_matches = System.Text.RegularExpressions.Regex.Matches(show_create, rawint_pattern);
foreach (System.Text.RegularExpressions.Match m in rawint_matches)
{
var m2 = System.Text.RegularExpressions.Regex.Match(m.Value, name_pattern);
var column_name = m2.Value;
column_name = column_name.Substring(1, column_name.Length - 2);
serach_column(column_name, true);
}
}
