DbFilterSelectorFactoryTest.java

package net.codjo.control.server.handler;
import java.util.HashMap;
import java.util.Map;
import junit.framework.TestCase;
import net.codjo.mad.server.handler.sql.HandlerSqlMock;
import org.junit.Test;
/**
 *
 */
public class DbFilterSelectorFactoryTest extends TestCase {
    private DbFilterSelectorFactory queryFactory = new DbFilterSelectorFactory();


    @Test
    public void test_sorter_empty() throws Exception {
        Map<String, String> args = createSorterParameters("");
        String query = queryFactory.buildQuery(args, new HandlerSqlMock("dbFilter"));

        assertEquals("select distinct NAV as VALUE from AP_FUND_PRICE", query);
    }


    @Test
    public void test_sorter_null() throws Exception {
        Map<String, String> args = createSorterParameters(null);
        String query = queryFactory.buildQuery(args, new HandlerSqlMock("dbFilter"));

        assertEquals("select distinct NAV as VALUE from AP_FUND_PRICE", query);
    }


    @Test
    public void test_sorter_descending() throws Exception {
        Map<String, String> args = createSorterParameters("descending");
        String query = queryFactory.buildQuery(args, new HandlerSqlMock("dbFilter"));

        assertEquals("select distinct NAV as VALUE from AP_FUND_PRICE order by NAV desc", query);
    }


    @Test
    public void test_sorter_ascending() throws Exception {
        Map<String, String> args = createSorterParameters("ascending");
        String query = queryFactory.buildQuery(args, new HandlerSqlMock("dbFilter"));

        assertEquals("select distinct NAV as VALUE from AP_FUND_PRICE order by NAV", query);
    }


    @Test
    public void test_sorter_pipo() throws Exception {
        Map<String, String> args = createSorterParameters("pipo");
        String query = queryFactory.buildQuery(args, new HandlerSqlMock("dbFilter"));

        assertEquals("select distinct NAV as VALUE from AP_FUND_PRICE order by NAV", query);
    }


    private Map<String, String> createSorterParameters(String sorter) {
        Map<String, String> args = new HashMap<String, String>();
        args.put("tableName", "AP_FUND_PRICE");
        args.put("columnName", "NAV");
        args.put("sorter", sorter);
        return args;
    }
}