Examples of Greater

Examples of com.vaadin.data.util.filter.Compare.Greater

    }


    @Test
    public void getWhereStringForFilter_greater() {
        StatementHelper sh = mockedStatementHelper(18);
        Greater f = new Greater("AGE", 18);
        Assert.assertEquals("\"AGE\" > ?",
                QueryBuilder.getWhereStringForFilter(f, sh));
        EasyMock.verify(sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

    @Test
    public void getWhereStringForFilters_listOfFilters() {
        StatementHelper sh = mockedStatementHelper("%lle", 18);
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Like("NAME", "%lle"));
        filters.add(new Greater("AGE", 18));
        Assert.assertEquals(" WHERE \"NAME\" LIKE ? AND \"AGE\" > ?",
                QueryBuilder.getWhereStringForFilters(filters, sh));
        EasyMock.verify(sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater


    @Test
    public void getWhereStringForFilters_oneAndFilter() {
        StatementHelper sh = mockedStatementHelper("%lle", 18);
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new And(new Like("NAME", "%lle"), new Greater("AGE", 18)));
        Assert.assertEquals(" WHERE (\"NAME\" LIKE ? AND \"AGE\" > ?)",
                QueryBuilder.getWhereStringForFilters(filters, sh));
        EasyMock.verify(sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater


    @Test
    public void getWhereStringForFilters_oneOrFilter() {
        StatementHelper sh = mockedStatementHelper("%lle", 18);
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Or(new Like("NAME", "%lle"), new Greater("AGE", 18)));
        Assert.assertEquals(" WHERE (\"NAME\" LIKE ? OR \"AGE\" > ?)",
                QueryBuilder.getWhereStringForFilters(filters, sh));
        EasyMock.verify(sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

    @Test
    public void getWhereStringForFilters_complexCompoundFilters() {
        StatementHelper sh = mockedStatementHelper("%lle", 18, 65, "Pelle");
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Or(new And(new Like("NAME", "%lle"), new Or(new Less(
                "AGE", 18), new Greater("AGE", 65))),
                new Equal("NAME", "Pelle")));
        Assert.assertEquals(
                " WHERE ((\"NAME\" LIKE ? AND (\"AGE\" < ? OR \"AGE\" > ?)) OR \"NAME\" = ?)",
                QueryBuilder.getWhereStringForFilters(filters, sh));
        EasyMock.verify(sh);

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

    public void getWhereStringForFilters_complexCompoundFiltersAndSingleFilter() {
        StatementHelper sh = mockedStatementHelper("%lle", 18, 65, "Pelle",
                "Virtanen");
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Or(new And(new Like("NAME", "%lle"), new Or(new Less(
                "AGE", 18), new Greater("AGE", 65))),
                new Equal("NAME", "Pelle")));
        filters.add(new Equal("LASTNAME", "Virtanen"));
        Assert.assertEquals(
                " WHERE ((\"NAME\" LIKE ? AND (\"AGE\" < ? OR \"AGE\" > ?)) OR \"NAME\" = ?) AND \"LASTNAME\" = ?",
                QueryBuilder.getWhereStringForFilters(filters, sh));

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

        Filter equalZero = new Equal(PROPERTY1, zero);
        Assert.assertFalse(equalZero.passesFilter(null, itemNegative));
        Assert.assertTrue(equalZero.passesFilter(null, itemZero));
        Assert.assertFalse(equalZero.passesFilter(null, itemPositive));


        Filter isPositive = new Greater(PROPERTY1, zero);
        Assert.assertFalse(isPositive.passesFilter(null, itemNegative));
        Assert.assertFalse(isPositive.passesFilter(null, itemZero));
        Assert.assertTrue(isPositive.passesFilter(null, itemPositive));


        Filter isNegative = new Less(PROPERTY1, zero);
        Assert.assertTrue(isNegative.passesFilter(null, itemNegative));
        Assert.assertFalse(isNegative.passesFilter(null, itemZero));
        Assert.assertFalse(isNegative.passesFilter(null, itemPositive));

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

        Filter equalZero = new Equal(PROPERTY1, zero);
        Assert.assertFalse(equalZero.passesFilter(null, itemNegative));
        Assert.assertTrue(equalZero.passesFilter(null, itemZero));
        Assert.assertFalse(equalZero.passesFilter(null, itemPositive));


        Filter isPositive = new Greater(PROPERTY1, zero);
        Assert.assertFalse(isPositive.passesFilter(null, itemNegative));
        Assert.assertFalse(isPositive.passesFilter(null, itemZero));
        Assert.assertTrue(isPositive.passesFilter(null, itemPositive));


        Filter isNegative = new Less(PROPERTY1, zero);
        Assert.assertTrue(isNegative.passesFilter(null, itemNegative));
        Assert.assertFalse(isNegative.passesFilter(null, itemZero));
        Assert.assertFalse(isNegative.passesFilter(null, itemPositive));

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

        Filter equalNow = new Equal(PROPERTY1, now);
        Assert.assertFalse(equalNow.passesFilter(null, itemEarlier));
        Assert.assertTrue(equalNow.passesFilter(null, itemNow));
        Assert.assertFalse(equalNow.passesFilter(null, itemLater));


        Filter after = new Greater(PROPERTY1, now);
        Assert.assertFalse(after.passesFilter(null, itemEarlier));
        Assert.assertFalse(after.passesFilter(null, itemNow));
        Assert.assertTrue(after.passesFilter(null, itemLater));


        Filter before = new Less(PROPERTY1, now);
        Assert.assertTrue(before.passesFilter(null, itemEarlier));
        Assert.assertFalse(before.passesFilter(null, itemNow));
        Assert.assertFalse(before.passesFilter(null, itemLater));

View Full Code Here

Examples of com.vaadin.data.util.filter.Compare.Greater

        Filter equalEmptyProperty2 = new Equal(PROPERTY2, "");
        Filter equalA = new Equal(PROPERTY1, "a");
        Filter equalB2 = new Equal(PROPERTY1, "b");
        Filter equalBProperty2 = new Equal(PROPERTY2, "b");


        Filter greaterEmpty = new Greater(PROPERTY1, "");


        // equals()
        Assert.assertEquals(equalNull, equalNull);
        Assert.assertEquals(equalNull, equalNull2);
        Assert.assertFalse(equalNull.equals(equalNullProperty2));
        Assert.assertFalse(equalNull.equals(equalEmpty));
        Assert.assertFalse(equalNull.equals(equalB));


        Assert.assertEquals(equalEmpty, equalEmpty);
        Assert.assertFalse(equalEmpty.equals(equalNull));
        Assert.assertEquals(equalEmpty, equalEmpty2);
        Assert.assertFalse(equalEmpty.equals(equalEmptyProperty2));
        Assert.assertFalse(equalEmpty.equals(equalB));


        Assert.assertEquals(equalB, equalB);
        Assert.assertFalse(equalB.equals(equalNull));
        Assert.assertFalse(equalB.equals(equalEmpty));
        Assert.assertEquals(equalB, equalB2);
        Assert.assertFalse(equalB.equals(equalBProperty2));
        Assert.assertFalse(equalB.equals(equalA));


        Assert.assertEquals(greaterB, greaterB);
        Assert.assertFalse(greaterB.equals(lessB));
        Assert.assertFalse(greaterB.equals(greaterEqualB));
        Assert.assertFalse(greaterB.equals(lessEqualB));


        Assert.assertFalse(greaterNull.equals(greaterEmpty));
        Assert.assertFalse(greaterNull.equals(greaterB));
        Assert.assertFalse(greaterEmpty.equals(greaterNull));
        Assert.assertFalse(greaterEmpty.equals(greaterB));
        Assert.assertFalse(greaterB.equals(greaterNull));
        Assert.assertFalse(greaterB.equals(greaterEmpty));


        // hashCode()
        Assert.assertEquals(equalNull.hashCode(), equalNull2.hashCode());

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.