Package com.vaadin.data.util.filter.Compare

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

56
57
58
59
60
61
62
63
64
65
    }

    @Test
    public void getWhereStringForFilter_less() {
        StatementHelper sh = mockedStatementHelper(65);
        Less f = new Less("AGE", 65);
        Assert.assertEquals("\"AGE\" < ?",
                QueryBuilder.getWhereStringForFilter(f, sh));
        EasyMock.verify(sh);
    }
View Full Code Here
228
229
230
231
232
233
234
235
236
237
238
    @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));
View Full Code Here
242
243
244
245
246
247
248
249
250
251
252
    @Test
    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\" = ?",
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
147
148
149
        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));

        Filter isNonNegative = new GreaterOrEqual(PROPERTY1, zero);
        Assert.assertFalse(isNonNegative.passesFilter(null, itemNegative));
        Assert.assertTrue(isNonNegative.passesFilter(null, itemZero));
        Assert.assertTrue(isNonNegative.passesFilter(null, itemPositive));
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
194
195
196
        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));

        Filter isNonNegative = new GreaterOrEqual(PROPERTY1, zero);
        Assert.assertFalse(isNonNegative.passesFilter(null, itemNegative));
        Assert.assertTrue(isNonNegative.passesFilter(null, itemZero));
        Assert.assertTrue(isNonNegative.passesFilter(null, itemPositive));
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
243
244
245
        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));

        Filter afterOrNow = new GreaterOrEqual(PROPERTY1, now);
        Assert.assertFalse(afterOrNow.passesFilter(null, itemEarlier));
        Assert.assertTrue(afterOrNow.passesFilter(null, itemNow));
        Assert.assertTrue(afterOrNow.passesFilter(null, itemLater));
View Full Code Here
TOP

Related Classes of com.vaadin.data.util.filter.Compare.Less

  • com.vaadin.data.util.filter.CompareFilterTest
  • com.vaadin.data.util.sqlcontainer.query.QueryBuilderTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.