iframe-proxy | Sunbelt Computer Software

History

74 lines (68 loc) · 1.8 KB

Raw

namespace NpgsqlRestTests;

public static partial class Database

{

public static void SetofRecordTests()

{

script.Append("""""

create function get_test_records()

returns setof record

language sql

select * from (

values

(1, true, 'one'),

(2, false, 'two'),

(3, null, 'three'),

(null, true, 'foo,bar'),

(null, null, 'foo"bar'),

(null, null, null),

(1, null, 't'),

(1, true, null),

(null, null, '"foo"bar"'),

(null, null, 'foo""bar'),

(null, null, 'foo""""bar'),

(null, null, 'foo"",""bar'),

(null, null, 'foo\bar'),

(null, null, 'foo/bar'),

(null, null, E'foo\nbar')

) v;

$$;

""""");

}

[Collection("TestFixture")]

public class SetofRecordTests(TestFixture test)

{

[Fact]

public async Task Test_get_test_records()

{

using var response = await test.Client.GetAsync("/api/get-test-records");

var content = await response.Content.ReadAsStringAsync();

response?.StatusCode.Should().Be(HttpStatusCode.OK);

response?.Content?.Headers?.ContentType?.MediaType.Should().Be("application/json");

var expextedContent = """

[

["1","t","one"],

["2","f","two"],

["3",null,"three"],

[null,"t","foo,bar"],

[null,null,"foo\"bar"],

[null,null,null],

["1",null,"t"],

["1","t",null],

[null,null,"\"foo\"bar\""],

[null,null,"foo\"\"bar"],

[null,null,"foo\"\"\"\"bar"],

[null,null,"foo\"\",\"\"bar"],

[null,null,"foo\\bar"],

[null,null,"foo/bar"],

[null,null,"foo\nbar"]

]

"""

.Replace(" ", "")

.Replace("\r", "")

.Replace("\n", "");

content.Should().Be(expextedContent);

}

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Uh oh!

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

Uh oh!

FilesExpand file tree

SetofRecordTests.cs

Latest commit

History

SetofRecordTests.cs

File metadata and controls