FuncSample/FuncSample/FuncSample.Lib.Tests/SqlQueryHelperTests.cs at main · erionpc/FuncSample · GitHub

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
using Xunit;
using FuncSample.Lib;
using System;
using System.Collections.Generic;
using System.Text;

namespace FuncSample.Lib.Tests
{
    public class SqlQueryHelperTests
    {
        public static IEnumerable<object[]> TestCases()
        {
            var query = "select * from items where active = 1";

            yield return new object[] {
                query,
                null,
                query
            };

            yield return new object[] {
                query,
                new Dictionary<string, bool>(),
                query
            };

            yield return new object[] {
                query,
                new Dictionary<string, bool>() {
                    { "columnA", true }
                },
                $"{query} AND (columnA = 1)"
            };

            yield return new object[] {
                query,
                new Dictionary<string, bool>() {
                    { "columnA", true },
                    { "columnB", false },
                    { "columnC", true }
                },
                $"{query} AND (columnA = 1 OR columnC = 1)"
            };

            yield return new object[] {
                query,
                new Dictionary<string, bool>() {
                    { "columnA", true },
                    { "columnB", false },
                    { "columnC", true },
                    { "columnD", false },
                    { "columnE", true },
                    { "columnF", true }
                },
                $"{query} AND (columnA = 1 OR columnC = 1 OR columnE = 1 OR columnF = 1)"
            };

            yield return new object[] {
                query,
                new Dictionary<string, bool>() {
                    { "columnA", true },
                    { "columnB", true }
                },
                $"{query} AND (columnA = 1 OR columnB = 1)"
            };
        }

        [Theory()]
        [MemberData(nameof(TestCases))]
        public void AppendOrBlockToQueryTest(string query, Dictionary<string, bool> orFilters, string expectedResult)
        {
            var result = SqlQueryHelper.AppendOrBlockToQuery(query, orFilters);

            Assert.Equal(expectedResult, result);
        }
    }
}