-
-
Notifications
You must be signed in to change notification settings - Fork 10
Expand file tree
/
Copy pathStrictFunctionsTests.cs
More file actions
108 lines (91 loc) · 3.56 KB
/
Copy pathStrictFunctionsTests.cs
File metadata and controls
108 lines (91 loc) · 3.56 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
namespace NpgsqlRestTests;
public static partial class Database
{
public static void StrictFunctionsTests()
{
script.Append(@"
create function strict_function(_p1 int, _p2 int)
returns text
strict
language plpgsql
as
$$
begin
raise info '_p1 = %, _p2 = %', _p1, _p2;
return 'strict';
end;
$$;
create function returns_null_on_null_input_function(_p1 int, _p2 int)
returns text
returns null on null input
language plpgsql
as
$$
begin
raise info '_p1 = %, _p2 = %', _p1, _p2;
return 'returns null on null input';
end;
$$;
");
}
}
[Collection("TestFixture")]
public class StrictFunctionsTests(TestFixture test)
{
[Fact]
public async Task Test_strict_function_NoNulls()
{
using var body = new StringContent("{\"p1\": 1, \"p2\": 2}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/strict-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.OK);
response.Content.Headers.ContentType?.MediaType.Should().Be("text/plain");
content.Should().Be("strict");
}
[Fact]
public async Task Test_strict_function_OneNull()
{
using var body = new StringContent("{\"p1\": 1, \"p2\": null}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/strict-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
content.Should().Be("");
}
[Fact]
public async Task Test_strict_function_TwoNulls()
{
using var body = new StringContent("{\"p1\": null, \"p2\": null}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/strict-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
content.Should().Be("");
}
[Fact]
public async Task Test_returns_null_on_null_input_function_NoNulls()
{
using var body = new StringContent("{\"p1\": 1, \"p2\": 2}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/returns-null-on-null-input-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.OK);
response.Content.Headers.ContentType?.MediaType.Should().Be("text/plain");
content.Should().Be("returns null on null input");
}
[Fact]
public async Task Test_returns_null_on_null_input_function_OneNull()
{
using var body = new StringContent("{\"p1\": 1, \"p2\": null}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/returns-null-on-null-input-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
content.Should().Be("");
}
[Fact]
public async Task Test_returns_null_on_null_input_function_TwoNulls()
{
using var body = new StringContent("{\"p1\": null, \"p2\": null}", Encoding.UTF8, "application/json");
using var response = await test.Client.PostAsync("/api/returns-null-on-null-input-function", body);
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
content.Should().Be("");
}
}