private static string ReplacePropertyWithInlineKeyword(FtsSetting setting, string flag, string text)
{
var keyword = setting.KeyWord;
var regex = new Regex(
$@"\((\[\w*\]\.\[\w*\]\s*[\+]*\s*)+\s*LIKE\s*N'%\({flag}\s?([^\)]+)\)%'\)\s?(ESCAPE N?'~')?",
RegexOptions.Compiled);
var matchs = regex.Matches(text);
foreach (Match match in matchs)
{
if (match.Success)
{
var value = match.Groups[2].Value;
if (match.Groups.Count > 3 && match.Groups[3].Value.StartsWith("ESCAPE"))
{
value = value.Replace("~", "");
}
var fields = match.Groups[0].Value.Trim('(').GetSplitLikeFirst();
text = text.Replace(match.Value,
$@"({keyword}(({fields.Replace('+', ',').Trim()}), N'{value}'))"
);
}
}
var regex1 = new Regex($@"(\[\w*\].\[\w*\]\s*)\s*LIKE\s*N'%\({flag}\s?([^\)]+)\)%'\s?(ESCAPE N?'~')?",
RegexOptions.Compiled);
var matchs1 = regex1.Matches(text);
foreach (Match match in matchs1)
{
if (match.Success)
{
var value = match.Groups[2].Value;
if (match.Groups.Count > 3 && match.Groups[3].Value.StartsWith("ESCAPE"))
{
value = value.Replace("~", "");
}
var fields = match.Groups[0].Value.Trim('(').GetSplitLikeFirst();
text = text.Replace(match.Value,
$@"({keyword}(({fields.Replace('+', ',').Trim()}), N'{value}'))"
);
}
}
return(text);
}
private static string ReplacePropertyWithParameterKeyword(FtsSetting setting, string flag, string text, DbCommand cmd)
{
var keyword = setting.KeyWord;
for (var i = 0; i < cmd.Parameters.Count; i++)
{
var parameter = cmd.Parameters[i];
if (!new[]
{
DbType.String,
DbType.AnsiString,
DbType.StringFixedLength,
DbType.AnsiStringFixedLength
}
.Contains(parameter.DbType))
{
continue;
}
if (parameter.Value == DBNull.Value)
{
continue;
}
var value = (string)parameter.Value;
if (value.IndexOf(flag) >= 0)
{
parameter.Size = 4096;
parameter.DbType = DbType.AnsiStringFixedLength;
value = value.Replace(flag, "");
// remove prefix we added n linq query
value = value.Substring(1, value.Length - 2);
parameter.Value = value;
text = Regex.Replace(text,
$@"(\[(?<t>\w*)\].\[(?<p>\w*)\]\s*\+?\s*)+LIKE\s*@{parameter.ParameterName}\s?(?:ESCAPE N?'~')",
match =>
{
var sb = new StringBuilder();
sb.Append(keyword).Append("(");
if (setting.Property == "*")
{
sb.Append("*");
}
else
{
sb.Append("(");
foreach (Capture capture in match.Groups[1].Captures)
{
sb.Append(capture.Value.Replace("+", ","));
}
sb.Append(")");
}
sb.Append(",@").Append(parameter.ParameterName).Append(")");
return(sb.ToString());
});
if (text == cmd.CommandText)
{
throw new Exception("FTS was not replaced on: " + text);
}
}
}
return(text);
}
