DuckDB.NET/DuckDB.NET.Test/DuckDBBitStringReaderTests.cs at develop · Giorgi/DuckDB.NET · GitHub

36 lines (27 loc) · 1.02 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

using System.Collections;

namespace DuckDB.NET.Test;

public class DuckDBBitStringReaderTests(DuckDBDatabaseFixture db) : DuckDBTestBase(db)

{

[Fact]

public void ReadBitString()

{

Command.CommandText = "SELECT bitstring('0101011', 12)";

var reader = Command.ExecuteReader();

reader.Read();

reader.GetFieldType(0).Should().Be(typeof(string));

var value = reader.GetValue(0);

value.Should().Be("000000101011");

value = reader.GetFieldValue<string>(0);

value.Should().Be("000000101011");

}

[Fact]

public void ReadBitStringAsBitArray()

{

Command.CommandText = "SELECT bitstring('0101011', 12)";

var reader = Command.ExecuteReader();

reader.Read();

var expected = new BitArray(new bool[] { false, false, false, false, false, false, true, false, true, false, true, true });

var value = reader.GetFieldValue<BitArray>(0);

expected.Xor(value).OfType<bool>().All(b => !b).Should().BeTrue();

}

}