forked from zzzprojects/System.Linq.Dynamic.Core
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathQueryableTests.OrderBy.cs
More file actions
175 lines (145 loc) · 5.79 KB
/
QueryableTests.OrderBy.cs
File metadata and controls
175 lines (145 loc) · 5.79 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
using System.Collections;
using System.Collections.Generic;
using System.Linq.Dynamic.Core.Exceptions;
using System.Linq.Dynamic.Core.Tests.Helpers.Models;
using Xunit;
namespace System.Linq.Dynamic.Core.Tests
{
public partial class QueryableTests
{
public class IntComparerT : IComparer<int>
{
public int Compare(int x, int y)
{
return new CaseInsensitiveComparer().Compare(y, x);
}
}
public class StringComparerT : IComparer<string>
{
public int Compare(string x, string y)
{
return new CaseInsensitiveComparer().Compare(y, x);
}
}
public class ObjectComparer : IComparer
{
public int Compare(object x, object y)
{
return new CaseInsensitiveComparer().Compare(y, x);
}
}
[Fact]
public void OrderBy_Dynamic_IComparer_StringComparer()
{
// Arrange
var testList = User.GenerateSampleModels(2);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderBy(x => x.UserName, StringComparer.OrdinalIgnoreCase).ToArray();
var orderByDynamic = qry.OrderBy("UserName", StringComparer.OrdinalIgnoreCase).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic_IComparer_ObjectComparer_Int()
{
// Arrange
var testList = User.GenerateSampleModels(3);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderBy(x => x.Income, new IntComparerT()).ToArray();
var orderByDynamic = qry.OrderBy("Income", new ObjectComparer()).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic_IComparer_ObjectComparer_String()
{
// Arrange
var testList = User.GenerateSampleModels(3);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderBy(x => x.UserName, new StringComparerT()).ToArray();
var orderByDynamic = qry.OrderBy("UserName", new ObjectComparer()).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic_IComparer_IntComparerT()
{
// Arrange
var testList = User.GenerateSampleModels(3);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderBy(x => x.Income, new IntComparerT()).ToArray();
var orderByDynamic = qry.OrderBy("Income", new IntComparerT()).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic_IComparer_IntComparerT_Asc()
{
// Arrange
var testList = User.GenerateSampleModels(2);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderBy(x => x.Income, new IntComparerT()).ToArray();
var orderByDynamic = qry.OrderBy("Income asc", new IntComparerT()).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic_IComparer_IntComparerT_Desc()
{
// Arrange
var testList = User.GenerateSampleModels(2);
var qry = testList.AsQueryable();
// Act
var orderBy = testList.OrderByDescending(x => x.Income, new IntComparerT()).ToArray();
var orderByDynamic = qry.OrderBy("Income desc", new IntComparerT()).ToArray();
// Assert
Assert.Equal(orderBy, orderByDynamic);
}
[Fact]
public void OrderBy_Dynamic()
{
// Arrange
var testList = User.GenerateSampleModels(100);
var qry = testList.AsQueryable();
// Act
var orderById = qry.OrderBy("Id");
var orderByAge = qry.OrderBy("Profile.Age");
var orderByComplex1 = qry.OrderBy("Profile.Age, Id");
// Assert
Assert.Equal(testList.OrderBy(x => x.Id).ToArray(), orderById.ToArray());
Assert.Equal(testList.OrderBy(x => x.Profile.Age).ToArray(), orderByAge.ToArray());
Assert.Equal(testList.OrderBy(x => x.Profile.Age).ThenBy(x => x.Id).ToArray(), orderByComplex1.ToArray());
}
[Fact]
public void OrderBy_Dynamic_AsStringExpression()
{
// Arrange
var testList = User.GenerateSampleModels(100);
var qry = testList.AsQueryable();
// Act
var expected = qry.SelectMany(x => x.Roles.OrderBy(y => y.Name)).Select(x => x.Name);
var orderById = qry.SelectMany("Roles.OrderBy(Name)").Select("Name");
// Assert
Assert.Equal(expected.ToArray(), orderById.Cast<string>().ToArray());
}
[Fact]
public void OrderBy_Dynamic_Exceptions()
{
// Arrange
var testList = User.GenerateSampleModels(100, allowNullableProfiles: true);
var qry = testList.AsQueryable();
// Act
Assert.Throws<ParseException>(() => qry.OrderBy("Bad=3"));
Assert.Throws<ParseException>(() => qry.Where("Id=123"));
Assert.Throws<ArgumentNullException>(() => DynamicQueryableExtensions.OrderBy(null, "Id"));
Assert.Throws<ArgumentNullException>(() => qry.OrderBy(null));
Assert.Throws<ArgumentException>(() => qry.OrderBy(""));
Assert.Throws<ArgumentException>(() => qry.OrderBy(" "));
}
}
}