-
-
Notifications
You must be signed in to change notification settings - Fork 10
Expand file tree
/
Copy pathCrudDeleteTests.cs
More file actions
89 lines (77 loc) · 2.63 KB
/
Copy pathCrudDeleteTests.cs
File metadata and controls
89 lines (77 loc) · 2.63 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
namespace NpgsqlRestTests;
public static partial class Database
{
public static void CrudDeleteTests()
{
script.Append("""
create table crud_delete1 (
id int,
name text
);
insert into crud_delete1 values (1,'name1'),(2,'name2'),(3,'name3'),(4,'name4');
create table crud_delete2 (
id int,
name text
);
insert into crud_delete2 values (1,'name1'),(2,'name2'),(3,'name3'),(4,'name4');
""");
}
}
[Collection("TestFixture")]
public class CrudDeleteTests(TestFixture test)
{
[Fact]
public async Task Test_crud_delete1()
{
using var response = await test.Client.DeleteAsync("/api/crud-delete1/?id=1");
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
using var getResponse = await test.Client.GetAsync("/api/crud-delete1/");
var content = await getResponse.Content.ReadAsStringAsync();
content.Should().Be("""
[
{"id":2,"name":"name2"},
{"id":3,"name":"name3"},
{"id":4,"name":"name4"}
]
"""
.Replace(" ", "")
.Replace("\n", "")
.Replace("\r", "")
.Trim());
using var response2 = await test.Client.DeleteAsync("/api/crud-delete1/");
response2.StatusCode.Should().Be(HttpStatusCode.NoContent);
using var getResponse2 = await test.Client.GetAsync("/api/crud-delete1/");
var content2 = await getResponse2.Content.ReadAsStringAsync();
content2.Should().Be("[]");
}
[Fact]
public async Task Test_crud_delete2_Returning()
{
using var response = await test.Client.DeleteAsync("/api/crud-delete2/returning/?id=1");
var content = await response.Content.ReadAsStringAsync();
response.StatusCode.Should().Be(HttpStatusCode.OK);
content.Should().Be("""
[
{"id":1,"name":"name1"}
]
"""
.Replace(" ", "")
.Replace("\n", "")
.Replace("\r", "")
.Trim());
using var response2 = await test.Client.DeleteAsync("/api/crud-delete2/returning/");
var content2 = await response2.Content.ReadAsStringAsync();
response2.StatusCode.Should().Be(HttpStatusCode.OK);
content2.Should().Be("""
[
{"id":2,"name":"name2"},
{"id":3,"name":"name3"},
{"id":4,"name":"name4"}
]
"""
.Replace(" ", "")
.Replace("\n", "")
.Replace("\r", "")
.Trim());
}
}