com.github.markserrano.jsonquery.jpa.service.OrderServiceTest.java Source code

Introduction

Here is the source code for com.github.markserrano.jsonquery.jpa.service.OrderServiceTest.java

Source

/*
 * Copyright 2011-2012 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package com.github.markserrano.jsonquery.jpa.service;

import org.joda.time.format.DateTimeFormat;
import org.joda.time.format.DateTimeFormatter;
import org.junit.After;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.transaction.TransactionConfiguration;
import org.springframework.transaction.annotation.Transactional;

import com.github.markserrano.jsonquery.jpa.builder.JsonBooleanBuilder;
import com.github.markserrano.jsonquery.jpa.domain.Child;
import com.github.markserrano.jsonquery.jpa.enumeration.OrderEnum;
import com.github.markserrano.jsonquery.jpa.filter.JsonFilter;
import com.github.markserrano.jsonquery.jpa.specifier.Order;
import com.mysema.query.BooleanBuilder;
import com.mysema.query.types.OrderSpecifier;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:applicationContext.xml" })
@TransactionConfiguration(transactionManager = "transactionManager", defaultRollback = true)
@Transactional
public class OrderServiceTest {

    @Autowired
    private IFilterService<Child> service;
    private JsonBooleanBuilder jsonBooleanBuilder = new JsonBooleanBuilder(Child.class);

    private Order order = new Order(Child.class);
    private OrderSpecifier<?> orderSpecifier;
    private DateTimeFormatter fmt = DateTimeFormat.forPattern("yyyy-MM-dd");;

    @Before
    public void setUp() throws Exception {
    }

    @After
    public void tearDown() throws Exception {
        orderSpecifier = null;
    }

    @Test
    public void testReadAndCount_OrderById_ASC() {
        String filter = "{\"groupOp\":\"AND\",\"rules\":"
                + "[{\"field\":\"parent.store\",\"op\":\"ne\",\"data\":\"StoreB\"},"
                + "{\"field\":\"parent.thing.id\",\"op\":\"ne\",\"data\":\"1\"}]" + "}";

        BooleanBuilder builder = jsonBooleanBuilder.build(new JsonFilter(filter));

        orderSpecifier = order.by("id", OrderEnum.ASC);
        Page<Child> results = service.readAndCount(builder, new PageRequest(0, 3), Child.class, orderSpecifier);

        Assert.assertNotNull(results);
        Assert.assertEquals(2, results.getTotalElements());
        Assert.assertEquals("StoreC", results.getContent().get(0).getParent().getStore());
        Assert.assertEquals("StoreD", results.getContent().get(1).getParent().getStore());
    }

    @Test
    public void testReadAndCount_OrderById_DESC() {
        String filter = "{\"groupOp\":\"AND\",\"rules\":"
                + "[{\"field\":\"parent.store\",\"op\":\"ne\",\"data\":\"StoreB\"},"
                + "{\"field\":\"parent.thing.id\",\"op\":\"ne\",\"data\":\"1\"}]" + "}";

        BooleanBuilder builder = jsonBooleanBuilder.build(new JsonFilter(filter));

        orderSpecifier = order.by("id", OrderEnum.DESC);
        Page<Child> results = service.readAndCount(builder, new PageRequest(0, 3), Child.class, orderSpecifier);

        Assert.assertNotNull(results);
        Assert.assertEquals(2, results.getTotalElements());
        Assert.assertEquals("StoreD", results.getContent().get(0).getParent().getStore());
        Assert.assertEquals("StoreC", results.getContent().get(1).getParent().getStore());
    }

    @Test
    public void testReadAndCount_OrderByDateTime_ASC() {
        String filter = "{\"groupOp\":\"AND\",\"rules\":"
                + "[{\"field\":\"parent.store\",\"op\":\"ne\",\"data\":\"StoreB\"},"
                + "{\"field\":\"birthDate\",\"op\":\"gt\",\"data\":\"1995-10-01T00:00:00.000Z\"}]" + "}";

        BooleanBuilder builder = jsonBooleanBuilder.build(new JsonFilter(filter));

        orderSpecifier = order.by("id", OrderEnum.ASC);
        Page<Child> results = service.readAndCount(builder, new PageRequest(0, 3), Child.class, orderSpecifier);

        Assert.assertNotNull(results);
        Assert.assertEquals(3, results.getTotalElements());
        Assert.assertEquals(fmt.parseDateTime("1995-10-05"), results.getContent().get(0).getBirthDate());
        Assert.assertEquals(fmt.parseDateTime("2003-10-12"), results.getContent().get(1).getBirthDate());
        Assert.assertEquals(fmt.parseDateTime("1996-01-01"), results.getContent().get(2).getBirthDate());
    }

    @Test
    public void testReadAndCount_OrderByDateTime_DESC() {
        String filter = "{\"groupOp\":\"AND\",\"rules\":"
                + "[{\"field\":\"parent.store\",\"op\":\"ne\",\"data\":\"StoreB\"},"
                + "{\"field\":\"birthDate\",\"op\":\"gt\",\"data\":\"1995-10-01T00:00:00.000Z\"}]" + "}";

        BooleanBuilder builder = jsonBooleanBuilder.build(new JsonFilter(filter));

        orderSpecifier = order.by("id", OrderEnum.DESC);
        Page<Child> results = service.readAndCount(builder, new PageRequest(0, 3), Child.class, orderSpecifier);

        Assert.assertNotNull(results);
        Assert.assertEquals(3, results.getTotalElements());
        Assert.assertEquals(fmt.parseDateTime("1996-01-01"), results.getContent().get(0).getBirthDate());
        Assert.assertEquals(fmt.parseDateTime("2003-10-12"), results.getContent().get(1).getBirthDate());
        Assert.assertEquals(fmt.parseDateTime("1995-10-05"), results.getContent().get(2).getBirthDate());
    }
}