iframe-proxy | Sunbelt Computer Software

History

45 lines (40 loc) · 1001 Bytes

Raw

namespace NpgsqlRestTests;

public static partial class Database

{

public static void IdentNamesTests()

{

script.Append("""

create function "select"("group" int, "order" int)

returns table (

"from" int,

"join" int

)

language plpgsql

begin

return query

select t.*

from (

values

("group", "order")

) t;

end;

$$;

""");

}

[Collection("TestFixture")]

public class IdentNamesTests(TestFixture test)

{

[Fact]

public async Task Test_select_ident_names_function()

{

using var body = new StringContent("{\"group\": 1, \"order\": 2}", Encoding.UTF8);

using var response = await test.Client.PostAsync("/api/select/", body);

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

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

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

content.Should().Be("[{\"from\":1,\"join\":2}]");

}

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

IdentNamesTests.cs

Latest commit

History

IdentNamesTests.cs

File metadata and controls