frank-native-criteria-builder

frank-native-criteria-builder - Simplified Criteria Query.

The Criteria API allows you to build up a criteria query object programmatically.

Usage:

    new Criteria(
        [
            // name = 'Harry'
            new SimpleCriterion("eq","name","Harry"),
            // and 
            //  --------
            //  (
            //    name = 'Harry' 
            //  or 
            //    name = 'Hbrry' 
            //  or 
            //    name = 'Hcrry'
            //  )
            new ComplexCriterion("or",
                [
                    new SimpleCriterion("eq","name","Harry"),
                    new SimpleCriterion("eq","name","Hbrry"),
                    new SimpleCriterion("eq","name","Hcrry"),
                ]
             ),
             // and
             // --------
             // age > 15
             new SimpleCriterion("gt","age","15")
        ],
        // order by
        [
            // createTime asc
            new Order("asc","createTime"),
            // age desc
            new Order("desc","age")
        ]
    )

Main Classes

// 1. 
Criteria criteria = new Criteria([],[]);
// 2. 
Order order = new Order("desc","createTime");
// 3.
SimpleCriterion = new SimpleCriterion("like","name","%Harry%");
// 4.
ComplexCriterion = new ComplexCriterion("not",
        [new SimpleCriterion("like","name","%Harry%")]);

Thanks for reading

If you have any questions, my email address is [e-mail].