public void FindWhere(string s, bool expectedResult)
{
var result = _finder.FindPhrase(s, "where");
Assert.Equal(expectedResult, result.hasPhrase);
Assert.True(result.hasPhrase ? result.startIndex > -1 : result.startIndex == -1);
}
public virtual string Apply(string s)
{
const string where = "where";
const int whereLength = 6;
const string groupBy = "group by";
const string orderBy = "order by";
var sb = new StringBuilder(s);
bool hasWhere = _phraseFinder.FindPhrase(s, where).hasPhrase;
(bool hasGroupBy, int groupByIndex) = _phraseFinder.FindPhrase(s, groupBy);
(bool hasOrderBy, int orderByIndex) = _phraseFinder.FindPhrase(s, orderBy);
int insertionIndex = hasGroupBy
? groupByIndex - 1
: orderByIndex - 1;
if (!hasWhere)
{
if (hasGroupBy || hasOrderBy)
{
sb.Insert(insertionIndex, $"{where}\n");
}
else
{
sb.AppendLine(where);
}
insertionIndex = _phraseFinder.FindPhrase(sb.ToString(), where).startIndex + whereLength;
}
string conditionType = "";
if (this is IChainedCondition chainedCondition)
{
conditionType = hasWhere
? chainedCondition.ConditionType.ToSql().WithTrailingSpace() // TODO: review
: "";
}
string conditionString = $"\t{conditionType}{ToSql().InParentheses()}";
if (hasGroupBy || hasOrderBy)
{
sb.Insert(insertionIndex, $"{conditionString}\n");
}
else
{
sb.AppendLine(conditionString);
}
string result = sb.ToString();
return(result);
}