Example #1
0
        public void should_create_select_query_with_complex_filter_and_sort()
        {
            // Setup
            var filter1 = new BlBinaryExpression
            {
                Operator = BlOperator.Eq, IsLeaf = true, PropName = "doors", Value = 4
            };
            var filter2 = new BlBinaryExpression
            {
                Operator = BlOperator.Eq, IsLeaf = true, PropName = "doors", Value = 2
            };
            var filter = new BlBinaryExpression
            {
                IsLeaf   = false,
                Left     = filter1,
                Right    = filter2,
                Operator = BlOperator.And
            };
            var sqlBuilder = new SqlQueryBuilder();

            // Act
            var query = sqlBuilder.SelectPawnsFromTable("cars", 200, 200, filter, "model");

            // Assert
            Assert.Equal("SELECT * FROM cars WHERE ((doors = 4) AND (doors = 2)) ORDER BY model Asc LIMIT 200 OFFSET 200", query);
        }
Example #2
0
        public void should_create_select_query_no_filter_no_sort()
        {
            // Setup
            var sqlBuilder = new SqlQueryBuilder();

            // Act
            var query = sqlBuilder.SelectPawnsFromTable("cars", 0, 200);

            // Assert
            Assert.Equal("SELECT * FROM cars  ORDER BY Id LIMIT 200 OFFSET 0", query);
        }
Example #3
0
        public void should_create_select_query_with_simple_filter_no_sort()
        {
            // Setup
            var filter = new BlBinaryExpression
            {
                Operator = BlOperator.Eq, IsLeaf = true, PropName = "doors", Value = 4
            };
            var sqlBuilder = new SqlQueryBuilder();

            // Act
            var query = sqlBuilder.SelectPawnsFromTable("cars", 0, 200, filter);

            // Assert
            Assert.Equal("SELECT * FROM cars WHERE (doors = 4) ORDER BY Id LIMIT 200 OFFSET 0", query);
        }