Examples of cat.quickdb.query.model.CompleteQuery

cat.quickdb.query.model.CompleteQuery

            another.setMount(55.35);
            another.setProperty("son name");
            another.setDescription("parent description");
            admin.save(another);


            CompleteQuery query = new CompleteQuery();
            query.setName("diego sarmentero");
            query.setSalary(3500.50);
            query.setAge(20);
            query.setBirth(new java.sql.Date(85, 9, 2));
            query.setCond(true);


            admin.save(query);


            CompleteQuery query2 = new CompleteQuery();
            query2.setName("cat");
            query2.setAge(24);
            query2.setSalary(1500.50);
            query2.setBirth(new java.sql.Date(104, 4, 20));
            query2.setCond(false);


            admin.save(query2);
        }
    }

View Full Code Here

        Assert.assertEquals("son value", user.getReference().getValue());
    }


    @Test
    public void testMatchOrNotEqual(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("name").
                match("diego sarmentero").or("cond").notEqual(true).findAll();


        Assert.assertEquals(2, array.size());

View Full Code Here

        Assert.assertEquals(2, array.size());
    }


    @Test
    public void testBetweenAndLower(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("birth").inRange("1980-01-01", "2010-12-31").
                and("salary").lower(2000).findAll();


        Assert.assertEquals(1, array.size());

View Full Code Here

        Assert.assertEquals(1, array.size());
    }


    @Test
    public void testInOrMatch(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("age").in(22, 23, 24, 25).
                or("name").match("sarmentero").findAll();


        Assert.assertEquals(2, array.size());

View Full Code Here

        Assert.assertEquals(2, array.size());
    }


    @Test
    public void testIsNotNullAndGreater(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("name").isNotNull().
                and("salary").equalORgreater(2000).findAll();


        Assert.assertEquals(1, array.size());

View Full Code Here

        Assert.assertEquals(1, array.size());
    }


    @Test
    public void testSort(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).sort(true, "salary").findAll();


        Assert.assertEquals("cat", ((CompleteQuery)array.get(0)).getName());
    }

View Full Code Here

        Assert.assertEquals("cat", ((CompleteQuery)array.get(0)).getName());
    }


    @Test
    public void testGroupHaving(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("age").greater(10).
                group("salary").ifGroup("salary").greater(2000).findAll();


        Assert.assertEquals(1, array.size());

View Full Code Here

        Assert.assertEquals(1, array.size());
    }


    @Test
    public void testDateMonthEqual(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("birth").date().month().equal(5).findAll();


        Assert.assertEquals(1, array.size());
        Assert.assertEquals("cat", ((CompleteQuery)array.get(0)).getName());

View Full Code Here

        Assert.assertEquals("cat", ((CompleteQuery)array.get(0)).getName());
    }


    @Test
    public void testDateDayLower(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("birth").date().
                day().lower(21).findAll();


        Assert.assertEquals(2, array.size());

View Full Code Here

        Assert.assertEquals(2, array.size());
    }


    @Test
    public void testDateDifferenceWith(){
        CompleteQuery query = new CompleteQuery();


        ArrayList array = admin.obtain(query).If("birth").date().
                differenceWith("20040522").equal(2).findAll();


        Assert.assertEquals(1, array.size());

View Full Code Here

TOP

Related Classes of cat.quickdb.query.model.CompleteQuery

cat.quickdb.query.QueryTest

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.