Example usage for org.springframework.data.mongodb.core.query Query sort

List of usage examples for org.springframework.data.mongodb.core.query Query sort

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.data.mongodb.core.query.*
  5. Query
  6. sort

Introduction

In this page you can find the example usage for org.springframework.data.mongodb.core.query Query sort.

Prototype

Sort sort

To view the source code for org.springframework.data.mongodb.core.query Query sort.

Click Source Link

Usage

From source file:net.cit.tetrad.rrd.dao.DataAccessObjectForMongoImpl.java

public void setGloballLockPageFaults(Map<String, Object> serverStatusFromMongo) {
    logger.info("\t start settingGloballLock and PageFaults");
    try {//w  ww  .  j a v a  2 s.  com
        Query query = new Query(Criteria.where(COL_DEVICECODE).is(serverStatusFromMongo.get(COL_DEVICECODE)));
        query.sort().on(SERVERSTATUS_REGTIME, Order.DESCENDING);

        ServerStatus recentServerStatus = operations.findOne(query, ServerStatus.class, COLL_DASHBOARD);

        if (recentServerStatus != null) {
            double recentGloballlocktime = recentServerStatus.getGlobalLock_lockTime();
            double recentPagefaults = recentServerStatus.getExtra_info_page_faults();
            double recentGlobalLocksLocked_R = recentServerStatus.getLocks_timeLockedMicros_R();
            double recentGlobalLocksLocked_W = recentServerStatus.getLocks_timeLockedMicros_W();
            double recentDbSumLocksLocked_r = recentServerStatus.getDb_sum_locks_timeLockedMicros_r();
            double recentDbSumLocksLocked_w = recentServerStatus.getDb_sum_locks_timeLockedMicros_w();

            double currentGloballLocktime = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_GLOBALLLOCKTIME));
            double currentPagefaults = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_PAGEFAULTS));
            double currentGlobalLocksLocked_R = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_LOCKSTIMELOCKEDMICROS_R));
            double currentGlobalLocksLocked_W = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_LOCKSTIMELOCKEDMICROS_W));
            double currentDbSumLocksLocked_r = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_DBSUMLOCKSLOCKED_R));
            double currentDbSumLocksLocked_w = CriticalHelper
                    .convertToDouble(serverStatusFromMongo.get(SERVERSTATUS_DBSUMLOCKSLOCKED_W));

            double diffGlobalLockTime = currentGloballLocktime - recentGloballlocktime;
            double diffPageFaults = currentPagefaults - recentPagefaults;
            double diffGlobalLocksLocked_R = currentGlobalLocksLocked_R - recentGlobalLocksLocked_R;
            double diffGlobalLocksLocked_W = currentGlobalLocksLocked_W - recentGlobalLocksLocked_W;
            double diffDbSumLocksLocked_r = currentDbSumLocksLocked_r - recentDbSumLocksLocked_r;
            double diffDbSumLocksLocked_w = currentDbSumLocksLocked_w - recentDbSumLocksLocked_w;

            logger.debug("GlobalLockTime : " + currentGloballLocktime + " - " + recentGloballlocktime + " = "
                    + diffGlobalLockTime);
            logger.debug(
                    "PageFaults : " + currentPagefaults + " - " + recentPagefaults + " = " + diffPageFaults);

            serverStatusFromMongo.put(SERVERSTATUS_DIFF_GLOBALLLOCKTIME, diffGlobalLockTime);
            serverStatusFromMongo.put(SERVERSTATUS_DIFF_PAGEFAULTS, diffPageFaults);
            serverStatusFromMongo.put(SERVERSTATUS_DIFF_LOCKSTIMELOCKEDMICROS_R, diffGlobalLocksLocked_R);
            serverStatusFromMongo.put(SERVERSTATUS_DIFF_LOCKSTIMELOCKEDMICROS_W, diffGlobalLocksLocked_W);
            serverStatusFromMongo.put(SERVERSTATUS_DIFF_DBSUMLOCKSLOCKED_R, diffDbSumLocksLocked_r);
            serverStatusFromMongo.put(SERVERSTATUS_DIFF_DBSUMLOCKSLOCKED_W, diffDbSumLocksLocked_w);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    logger.info("\t end settingGloballLock and PageFaults");
}

From source file:com.ewcms.common.query.mongo.EasyQueryImpl.java

private void setSort(Query query, Sort sort) {
    for (Sort.Order order : sort) {
        if (order.isAscending()) {
            query.sort().on(order.getProperty(), Order.ASCENDING);
        } else {/*w  w  w .  ja v a2s .  com*/
            query.sort().on(order.getProperty(), Order.DESCENDING);
        }
    }
}

From source file:net.cit.tetrad.dao.management.impl.SubDaoImpl.java

public Object getIncludeOptionResult(CommonDto dto) {
    dhtmlxLogger.info("start getIncludeOptionResult");
    String dsname = dto.getDsname();

    Query query = new Query(
            Criteria.where(SERVERSTATUS_REGTIME).gt(dto.getSearch_sdate()).lte(dto.getSearch_edate()));
    query.addCriteria(Criteria.where(COL_DEVICECODE).is(dto.getDeviceCode()));
    if (dto.getCollname().equals(COLL_DBSTATUS))
        query.addCriteria(Criteria.where(DBSTATUS_DBNAME).is(dto.getDbname()));
    query.sort().on(SERVERSTATUS_REGTIME, Order.ASCENDING);
    query.fields().include("_id").include(SERVERSTATUS_REGTIME).include(dsname).include(COL_DEVICECODE);

    List<Map<String, Object>> result = new ArrayList<Map<String, Object>>();

    long start = System.currentTimeMillis();
    List<Object> serverStatusList = monadService.getListWithStrCollName(query, Map.class, dto.getCollname());
    double old = -1;
    for (Object obj : serverStatusList) {
        Map<String, Object> setInfo = new HashMap<String, Object>();
        Map<String, Object> statusInfo = (Map<String, Object>) obj;
        double recent = CriticalHelper.convertToDouble(statusInfo.get(dsname));
        String regtime = (String) statusInfo.get(SERVERSTATUS_REGTIME);
        int deviceCode = (Integer) statusInfo.get(COL_DEVICECODE);
        if (old == -1) {
            setInfo.put(dsname, 0);/*from  w ww  .ja v a  2 s  .c om*/
        } else {
            setInfo.put(dsname, recent - old);
        }
        setInfo.put(COL_DEVICECODE, deviceCode);
        setInfo.put(SERVERSTATUS_REGTIME, regtime);
        old = recent;
        result.add(setInfo);
    }
    long end = System.currentTimeMillis();
    dhtmlxLogger.info("    getDiff Data : " + (end - start));
    String collname = "temp_" + TimestampUtil.readTimestamp();
    start = System.currentTimeMillis();
    monadService.insert(result, collname);
    end = System.currentTimeMillis();
    dhtmlxLogger.info("    insertDiff Data : " + (end - start));
    dto.setCollname(collname);
    Object obj = getCurrentResult(dto);

    //   
    dhtmlxLogger.info("drop temp collection!");
    monadService.dropCollection(collname);
    dhtmlxLogger.info("end getIncludeOptionResult");
    return obj;
}

From source file:net.cit.tetrad.resource.SubResource.java

/**
 * ?  ? /*from  ww  w . j  a v  a2s.  co  m*/
 * @param dto
 * @return
 * @throws Exception
 */
@RequestMapping("/subPageView.do")
public ModelAndView subPageView(CommonDto dto) throws Exception {
    log.debug("start - subPageView()");
    ModelAndView mav = commMav();
    Query query = new Query();
    query.sort().on("groupBind", Order.ASCENDING);
    List<Object> groupLst = monadService.getList(query, Group.class);
    List<Object> typeLst = new ArrayList<Object>();
    typeLst = adminDao.typeList();

    mav.addObject("type", typeLst);
    mav.addObject("group", groupLst);
    mav.addObject("comm", dto);

    mav.setViewName("sub_page");

    log.debug("end - subPageView()");
    return mav;
}

From source file:net.cit.tetrad.resource.ManagementResource.java

private String getSmallRegTime() {
    Query query = new Query();
    query.sort().on("regtime", Order.ASCENDING);
    query.limit(1);//from w w  w .  ja va 2  s.c  o  m
    ServerStatus status = (ServerStatus) monadService.getFind(query, ServerStatus.class);
    DbStatus dbStatus = (DbStatus) monadService.getFind(query, DbStatus.class);
    String resultDate = "";
    if (status == null && dbStatus != null) {
        resultDate = Utility.isNull(dbStatus.getRegtime());
    } else if (status != null && dbStatus == null) {
        resultDate = Utility.isNull(status.getRegtime());
    } else if (status != null && dbStatus != null) {
        String serverRegTime = Utility.isNull(status.getRegtime());
        String dbRegTime = Utility.isNull(dbStatus.getRegtime());
        try {
            int result = DateUtil.getCompareDate(serverRegTime, dbRegTime, "yyyyMMddHHmmssSSS");
            if (result == -1 || result == 0) {
                resultDate = serverRegTime;
            } else {
                resultDate = dbRegTime;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    return resultDate;
}

From source file:net.cit.tetrad.resource.ManagementResource.java

private PersonJson setPersonGroupJson(int sEcho, CommonDto dto, String tablenm, int pageNumber, int nPerPage) {
    Class<?> classname = managementDao.getDtoClassNm(tablenm);
    String searchGubun = dto.getSearch_gubun();
    String searchText = dto.getSearch_text();

    Query query = new Query();
    if (isSearch(searchGubun, searchText)) {
        query = getSearchQuery(searchGubun, searchText);
    } else {// w  w w.  j  a v a2s .  com
        query.sort().on("groupBind", Order.ASCENDING);
        //         query.sort().on("reg_date", Order.DESCENDING);
        query.sort().on("groupCode", Order.ASCENDING);
        query.sort().on("deviceCode", Order.ASCENDING);
        query.sort().on("reg_date", Order.DESCENDING);
        //         query = sortDate(dto.getLoginAuth(),dto.getLoginUserCode(),tablenm);
    }

    int cnt = (int) monadService.getCount(query, classname);
    List<Object> resultList = monadService.getList(query.skip(pageNumber).limit(nPerPage), classname);

    PersonJson result = new PersonJson();
    result.setsEcho(sEcho);
    result.setiTotalRecords(cnt);
    result.setiTotalDisplayRecords(cnt);
    result.setAaData(resultList);

    return result;
}

From source file:net.cit.tetrad.resource.ManagementResource.java

private PersonJson setPersonJson(int sEcho, CommonDto dto, String tablenm, int pageNumber, int nPerPage) {
    Class<?> classname = managementDao.getDtoClassNm(tablenm);
    String searchGubun = dto.getSearch_gubun();
    String searchText = dto.getSearch_text();

    Query query = new Query();
    if (isSearch(searchGubun, searchText)) {
        query = getSearchQuery(searchGubun, searchText);
    } else {//from   w  w w  .j  a va 2s .  c  om
        query = sortDate(dto.getLoginAuth(), dto.getLoginUserCode(), tablenm);
    }

    int cnt = (int) monadService.getCount(query, classname);
    query.sort().on("groupBind", Order.ASCENDING);
    List<Object> resultList = monadService.getList(query.skip(pageNumber).limit(nPerPage), classname);

    PersonJson result = new PersonJson();
    result.setsEcho(sEcho);
    result.setiTotalRecords(cnt);
    result.setiTotalDisplayRecords(cnt);
    result.setAaData(resultList);

    return result;
}

From source file:org.springframework.data.mongodb.core.mapping.MappingTests.java

@Test
public void testNoMappingAnnotationsUsingStringAsId() {
    // Assign the String Id in code
    PersonPojoStringId p = new PersonPojoStringId("1", "Text");
    template.insert(p);//from   w  ww .  j a  v a 2  s  .  co  m
    template.updateFirst(query(where("id").is("1")), update("text", "New Text"), PersonPojoStringId.class);

    PersonPojoStringId p2 = template.findOne(query(where("id").is("1")), PersonPojoStringId.class);
    assertEquals("New Text", p2.getText());

    p.setText("Different Text");
    template.save(p);

    PersonPojoStringId p3 = template.findOne(query(where("id").is("1")), PersonPojoStringId.class);
    assertEquals("Different Text", p3.getText());

    PersonPojoStringId p4 = new PersonPojoStringId("2", "Text-2");
    template.insert(p4);

    Query q = query(where("id").in("1", "2"));
    q.sort().on("id", Order.ASCENDING);
    List<PersonPojoStringId> people = template.find(q, PersonPojoStringId.class);
    assertEquals(2, people.size());

}