Examples of org.apache.cayenne.query.Ordering

org.apache.cayenne.query.Ordering
Defines object sorting criteria, used either for in-memory sorting of object lists or as a specification for building ORDER BY clause of a SelectQuery query. Note that in case of in-memory sorting, Ordering can be used with any JavaBeans, not just DataObjects.

        }


        Iterator<Ordering> it = ((SelectQuery) q).getOrderings().iterator();


        while (it.hasNext()) {
            Ordering ord = it.next();


            if (ord.isCaseInsensitive()) {
                out.append("UPPER(");
            }


            Expression exp = ord.getSortSpec();


            if (exp.getType() == Expression.OBJ_PATH) {
                appendObjPath(exp);
            }
            else if (exp.getType() == Expression.DB_PATH) {
                appendDbPath(exp);
            }
            else {
                throw new CayenneRuntimeException("Unsupported ordering expression: "
                        + exp);
            }


            // Close UPPER() modifier
            if (ord.isCaseInsensitive()) {
                out.append(")");
            }


            orderByColumnList.add(out.toString());


            // "ASC" is a noop, omit it from the query
            if (!ord.isAscending()) {
                out.append(" DESC");
            }


            if (it.hasNext()) {
                out.append(", ");

View Full Code Here

    }


    public void testSuccessLockingOnMixed() throws Exception {
        createTestData("testLockingOnMixed");
        SelectQuery query = new SelectQuery(SimpleLockingTestEntity.class);
        query.addOrdering(new Ordering("db:LOCKING_TEST_ID", SortOrder.ASCENDING));


        List allObjects = context.performQuery(query);
        assertEquals(3, allObjects.size());


        SimpleLockingTestEntity object1 = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here

        // case insensitive ordering appends extra columns
        // to the query when query is using DISTINCT...
        // verify that the result is not messed up


        SelectQuery query = new SelectQuery(Artist.class);
        Ordering ordering = new Ordering(
                Artist.ARTIST_NAME_PROPERTY,
                SortOrder.ASCENDING_INSENSITIVE);
        query.addOrdering(ordering);
        query.setDistinct(true);

View Full Code Here

    public void onRender() {
        super.onRender();


        if (getSchedulerService() != null) {
            List<JobAndSimpleTrigger> rowList = getSchedulerService().getJobAndTriggerList();
            Collections.sort(rowList, new Ordering("job.name", Ordering.ASC));
            table.setRowList(rowList);
        }
    }

View Full Code Here

    public List getStudentsByHouse() {
        SelectQuery query = new SelectQuery(Student.class);
        query.addPrefetch("studentHouse");


        // Add in-memory ordering
        Ordering ordering = new Ordering("studentHouse.name", true);
        List result = performQuery(query);
        ordering.orderList(result);
        return result;
    }

View Full Code Here

    }


    public void testSort() throws Exception {
        prepareList(6);


        new Ordering(Artist.ARTIST_NAME_PROPERTY, SortOrder.DESCENDING).orderList(list);


        Iterator it = list.iterator();
        Artist previousArtist = null;
        while (it.hasNext()) {
            Artist artist = (Artist) it.next();

View Full Code Here

        if (path != null && path.trim().length() == 0) {
            path = null;
        }
        boolean isDescending = "true".equalsIgnoreCase(descending);
        boolean isIgnoringCase = "true".equalsIgnoreCase(ignoreCase);
        orderings.add(new Ordering(path, !isDescending, isIgnoringCase));
    }

View Full Code Here

    public void onRender() {
        super.onRender();


        if (getSchedulerService() != null) {
            List<JobAndSimpleTrigger> rowList = getSchedulerService().getJobAndTriggerList();
            Collections.sort(rowList, new Ordering("job.name", Ordering.ASC));
            table.setRowList(rowList);
        }
    }

View Full Code Here

    }


    public void testSort() throws Exception {
        SimpleIdIncrementalFaultList<?> list = prepareList(6);


        new Ordering(Artist.ARTIST_NAME_PROPERTY, SortOrder.DESCENDING).orderList(list);


        Iterator<?> it = list.iterator();
        Artist previousArtist = null;
        while (it.hasNext()) {
            Artist artist = (Artist) it.next();

View Full Code Here


    public void testSuccessLockingOnMixed() throws Exception {
        createLockingOnMixedDataSet();


        SelectQuery query = new SelectQuery(SimpleLockingTestEntity.class);
        query.addOrdering(new Ordering("db:LOCKING_TEST_ID", SortOrder.ASCENDING));


        List<?> allObjects = context.performQuery(query);
        assertEquals(3, allObjects.size());


        SimpleLockingTestEntity object1 = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.apache.cayenne.query.Ordering

com.adaptrex.core.persistence.cayenne.CayenneStoreData

org.apache.cayenne.access.DataContextTest

org.apache.cayenne.access.OptimisticLockingTest

org.apache.cayenne.access.SimpleIdIncrementalFaultListTest

org.apache.cayenne.access.trans.OrderingTranslator

org.apache.cayenne.exp.Expression

org.apache.cayenne.exp.parser.ASTDbPath

org.apache.cayenne.exp.parser.ASTObjPath

org.apache.cayenne.exp.Property

org.apache.cayenne.map.MapLoaderLoadTest

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.