-
Notifications
You must be signed in to change notification settings - Fork 3.1k
/
NorthwindODataQueryTests.cs
123 lines (95 loc) · 4.63 KB
/
NorthwindODataQueryTests.cs
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
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
using System.Net;
using Microsoft.EntityFrameworkCore.Extensions;
using Newtonsoft.Json.Linq;
namespace Microsoft.EntityFrameworkCore.Query;
public class NorthwindODataQueryTests : ODataQueryTestBase, IClassFixture<NorthwindODataQueryTestFixture>
{
public NorthwindODataQueryTests(NorthwindODataQueryTestFixture fixture)
: base(fixture)
{
}
[ConditionalFact]
public async Task Basic_query_customers()
{
var requestUri = $"{BaseAddress}/odata/Customers";
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Customers", result["@odata.context"].ToString());
var customers = result["value"] as JArray;
Assert.Equal(91, customers.Count);
}
[ConditionalFact]
public async Task Basic_query_select_single_customer()
{
var requestUri = string.Format(@"{0}/odata/Customers('ALFKI')", BaseAddress);
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Customers/$entity", result["@odata.context"].ToString());
Assert.Equal("ALFKI", result["CustomerID"].ToString());
}
[ConditionalFact]
public async Task Query_for_alfki_expand_orders()
{
var requestUri = string.Format(@"{0}/odata/Customers?$filter=CustomerID eq 'ALFKI'&$expand=Orders", BaseAddress);
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Customers", result["@odata.context"].ToString());
var customers = result["value"] as JArray;
Assert.Single(customers);
Assert.Equal("ALFKI", customers[0]["CustomerID"]);
var orders = customers[0]["Orders"] as JArray;
Assert.Equal(6, orders.Count);
}
[ConditionalFact]
public async Task Basic_query_orders()
{
var requestUri = $"{BaseAddress}/odata/Orders";
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Orders", result["@odata.context"].ToString());
var orders = result["value"] as JArray;
Assert.Equal(830, orders.Count);
}
[ConditionalFact]
public async Task Query_orders_select_single_property()
{
var requestUri = $"{BaseAddress}/odata/Orders?$select=OrderDate";
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Orders(OrderDate)", result["@odata.context"].ToString());
var orderDates = result["value"] as JArray;
Assert.Equal(830, orderDates.Count);
}
[ConditionalFact]
public async Task Basic_query_order_details()
{
var requestUri = $"{BaseAddress}/odata/Order Details";
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Order%20Details", result["@odata.context"].ToString());
}
[ConditionalFact]
public async Task Basic_query_order_details_single_element_composite_key()
{
var requestUri = $"{BaseAddress}/odata/Order Details(OrderID=10248,ProductID=11)";
var request = new HttpRequestMessage(HttpMethod.Get, requestUri);
var response = await Client.SendAsync(request);
Assert.Equal(HttpStatusCode.OK, response.StatusCode);
var result = await response.Content.ReadAsObject<JObject>();
Assert.Contains("$metadata#Order%20Details", result["@odata.context"].ToString());
}
}