public void GetDifferentSortColumn()
{
_query.Sort = "A_Column_To_Sort";
var sut = new QueryData(_query, _validColumns, _clauseFactory, "My Table");
Assert.Equal("[A_Column_To_Sort_Cleaned]", sut.GetSortColumn());
}
public override string ToString()
{
var column = _queryData.GetSortColumn();
var direction = _queryData.GetSortDirection();
if (string.IsNullOrWhiteSpace(column))
{
return(string.Empty);
}
return(direction == "ASC"
? $"ORDER BY CASE WHEN {column} IS NULL THEN 1 ELSE 0 END, {column}"
: $"ORDER BY {column} DESC");
}
