Examples of cat.quickdb.query.model.ObjectSummary

    public void testSummaryAttributes(){
        if(this.admin.checkTableExist("ObjectSummary")){
            this.admin.executeQuery("DROP TABLE ObjectSummary");
        }


        ObjectSummary summ = new ObjectSummary();
        summ.setValue(23);
        summ.setSalary(100.5);
        Assert.assertTrue(admin.save(summ));


        ObjectSummary summ2 = new ObjectSummary();
        summ2.setValue(5);
        summ2.setSalary(500.5);
        Assert.assertTrue(admin.save(summ2));


        ObjectSummary summ3 = new ObjectSummary();
        summ3.setValue(34);
        summ3.setSalary(200);
        Assert.assertTrue(admin.save(summ3));


        ObjectSummary summ4 = new ObjectSummary();
        admin.obtain(summ4).If("value").greater(2).find();
        Assert.assertEquals(62.0, summ4.getSummmary());
        Assert.assertEquals(267.0, summ4.getPromSalary());
        Assert.assertEquals(34.0, summ4.getMaxValue());
        Assert.assertEquals(5.0, summ4.getMinValue());
        Assert.assertEquals(3.0, summ4.getCountValue());


        ObjectSummary summ5 = new ObjectSummary();
        admin.obtain(summ5, "value > 10");
        Assert.assertEquals(57.0, summ5.getSummmary());
        Assert.assertEquals(150.25, summ5.getPromSalary());
        Assert.assertEquals(34.0, summ5.getMaxValue());
        Assert.assertEquals(23.0, summ5.getMinValue());
        Assert.assertEquals(2.0, summ5.getCountValue());
    }

    public void testQueryIfGroupWithSummary(){
        if(this.admin.checkTableExist("ObjectSummary")){
            Assert.assertTrue(this.admin.executeQuery("DROP TABLE ObjectSummary"));
        }


        ObjectSummary summ = new ObjectSummary();
        summ.setValue(23);
        summ.setSalary(100.5);
        Assert.assertTrue(admin.save(summ));


        ObjectSummary summ2 = new ObjectSummary();
        summ2.setValue(5);
        summ2.setSalary(500.5);
        Assert.assertTrue(admin.save(summ2));


        ObjectSummary summ3 = new ObjectSummary();
        summ3.setValue(34);
        summ3.setSalary(200);
        Assert.assertTrue(admin.save(summ3));


        ObjectSummary summ4 = new ObjectSummary();
        summ4.setValue(23);
        summ4.setSalary(10);
        Assert.assertTrue(admin.save(summ4));


        ObjectSummary summ5 = new ObjectSummary();
        summ5.setValue(5);
        summ5.setSalary(55);
        Assert.assertTrue(admin.save(summ5));


        ObjectSummary summ6 = new ObjectSummary();
        summ6.setValue(34);
        summ6.setSalary(800);
        Assert.assertTrue(admin.save(summ6));


        ObjectSummary summ7 = new ObjectSummary();
        admin.obtain(summ7).If("id").greater(0).group("value").ifGroup("+salary").greater(900).find();


        Assert.assertEquals(34.0, summ7.getMaxValue());
        Assert.assertEquals(34.0, summ7.getMinValue());
        Assert.assertEquals(2.0, summ7.getCountValue());
        Assert.assertEquals(500.0, summ7.getPromSalary());
        Assert.assertEquals(68.0, summ7.getSummmary());
    }

Examples of cat.quickdb.query.model.ObjectSummary

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