private string GetTargetedTable(string sql)
{
MySqlTokenizer tokenizer = new MySqlTokenizer(sql);
tokenizer.ReturnComments = false;
tokenizer.AnsiQuotes = sql_mode.ToLowerInvariant().Contains("ansi_quotes");
tokenizer.BackslashEscapes = !sql_mode.ToLowerInvariant().Contains("no_backslash_escapes");
string token = null;
while (token != "ON" || tokenizer.Quoted)
{
token = tokenizer.NextToken();
}
string tableName = tokenizer.NextToken();
if (tokenizer.NextToken() == ".")
{
tableName = tokenizer.NextToken();
}
if (tableName.StartsWith("`"))
{
return(tableName.Trim('`'));
}
if (tableName.StartsWith("\"") && tokenizer.AnsiQuotes)
{
return(tableName.Trim('"'));
}
return(tableName);
}
private static string ParseDataType(SyncRow row, MySqlTokenizer tokenizer)
{
StringBuilder dtd = new StringBuilder(tokenizer.NextToken().ToUpperInvariant());
row["DATA_TYPE"] = dtd.ToString();
string type = row["DATA_TYPE"].ToString();
string token = tokenizer.NextToken();
if (token == "(")
{
token = tokenizer.ReadParenthesis();
dtd.AppendFormat(CultureInfo.InvariantCulture, "{0}", token);
if (type != "ENUM" && type != "SET")
{
ParseDataTypeSize(row, token);
}
token = tokenizer.NextToken();
}
else
{
dtd.Append(GetDataTypeDefaults(type, row));
}
while (token != ")" &&
token != "," &&
String.Compare(token, "begin", StringComparison.OrdinalIgnoreCase) != 0 &&
String.Compare(token, "return", StringComparison.OrdinalIgnoreCase) != 0)
{
if (String.Compare(token, "CHARACTER", StringComparison.OrdinalIgnoreCase) == 0 ||
String.Compare(token, "BINARY", StringComparison.OrdinalIgnoreCase) == 0)
{
} // we don't need to do anything with this
else if (String.Compare(token, "SET", StringComparison.OrdinalIgnoreCase) == 0 ||
String.Compare(token, "CHARSET", StringComparison.OrdinalIgnoreCase) == 0)
{
row["CHARACTER_SET_NAME"] = tokenizer.NextToken();
}
else if (String.Compare(token, "ASCII", StringComparison.OrdinalIgnoreCase) == 0)
{
row["CHARACTER_SET_NAME"] = "latin1";
}
else if (String.Compare(token, "UNICODE", StringComparison.OrdinalIgnoreCase) == 0)
{
row["CHARACTER_SET_NAME"] = "ucs2";
}
else if (String.Compare(token, "COLLATE", StringComparison.OrdinalIgnoreCase) == 0)
{
row["COLLATION_NAME"] = tokenizer.NextToken();
}
else
{
dtd.AppendFormat(CultureInfo.InvariantCulture, " {0}", token);
}
token = tokenizer.NextToken();
}
if (dtd.Length > 0)
{
row["DTD_IDENTIFIER"] = dtd.ToString();
}
// now default the collation if one wasn't given
//if (string.IsNullOrEmpty((string)row["COLLATION_NAME"]) &&
// !string.IsNullOrEmpty((string)row["CHARACTER_SET_NAME"]))
// row["COLLATION_NAME"] = CharSetMap.GetDefaultCollation(
// row["CHARACTER_SET_NAME"].ToString(), connection);
// now set the octet length
//if (row["CHARACTER_MAXIMUM_LENGTH"] != null)
//{
// if (row["CHARACTER_SET_NAME"] == null)
// row["CHARACTER_SET_NAME"] = "";
// row["CHARACTER_OCTET_LENGTH"] =
// CharSetMap.GetMaxLength((string)row["CHARACTER_SET_NAME"], connection) *
// (int)row["CHARACTER_MAXIMUM_LENGTH"];
//}
return(token);
}
private static void ParseProcedureBody(SyncTable parametersTable, string body, string sqlMode, string schema, string procName)
{
var modes = new List <string>(new string[3] {
"IN", "OUT", "INOUT"
});
int pos = 1;
var tokenizer = new MySqlTokenizer(body)
{
AnsiQuotes = sqlMode.IndexOf("ANSI_QUOTES") != -1,
BackslashEscapes = sqlMode.IndexOf("NO_BACKSLASH_ESCAPES") == -1,
ReturnComments = false
};
string token = tokenizer.NextToken();
// this block will scan for the opening paren while also determining
// if this routine is a function. If so, then we need to add a
// parameter row for the return parameter since it is ordinal position
// 0 and should appear first.
while (token != "(")
{
if (String.Compare(token, "FUNCTION", StringComparison.OrdinalIgnoreCase) == 0)
{
var newRow = parametersTable.NewRow();
InitParameterRow(newRow, schema, procName);
parametersTable.Rows.Add(newRow);
}
token = tokenizer.NextToken();
}
token = tokenizer.NextToken(); // now move to the next token past the (
while (token != ")")
{
var parmRow = parametersTable.NewRow();
InitParameterRow(parmRow, schema, procName);
parmRow["ORDINAL_POSITION"] = pos++;
// handle mode and name for the parameter
string mode = token.ToUpperInvariant();
if (!tokenizer.Quoted && modes.Contains(mode))
{
parmRow["PARAMETER_MODE"] = mode;
token = tokenizer.NextToken();
}
if (tokenizer.Quoted)
{
token = token.Substring(1, token.Length - 2);
}
parmRow["PARAMETER_NAME"] = token;
// now parse data type
token = ParseDataType(parmRow, tokenizer);
if (token == ",")
{
token = tokenizer.NextToken();
}
parametersTable.Rows.Add(parmRow);
}
// now parse out the return parameter if there is one.
token = tokenizer.NextToken().ToUpperInvariant();
if (String.Compare(token, "RETURNS", StringComparison.OrdinalIgnoreCase) == 0)
{
var parameterRow = parametersTable.Rows[0];
parameterRow["PARAMETER_NAME"] = "RETURN_VALUE";
ParseDataType(parameterRow, tokenizer);
}
}