Example usage for org.joda.time DateTime getMillis

Introduction

In this page you can find the example usage for org.joda.time DateTime getMillis.

Prototype

public long getMillis() 

Source Link

Document

Gets the milliseconds of the datetime instant from the Java epoch of 1970-01-01T00:00:00Z.

Usage

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure timelog(SwagrOptionsPB req) throws Exception {
    Date start;/*from w w  w  .j  a va  2s.co m*/
    Date end;
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String request = TIMELOG_DAY;
    if (req.hasStartDt() && req.hasEndDt()) {
        //    if((req.getStartDt()-req.getEndDt())<=604800)
        //        request = TIMELOG_HOUR;
        start = new Date(req.getStartDt());
        end = new Date(req.getEndDt());
    } else {
        start = new Date(startdt.getMillis());
        end = new Date(enddt.getMillis());
    }

    try (JdbcService jdbc = drjJdbcFac.newService(request)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, start);
        ps.setDate(2, end);
        ps.setInt(3, req.getHostTypeId());
        ResultSet rs = jdbc.executeQuery();
        return timelogResSet(rs, req.getHostTypeId());
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure systemTotals(SwagrOptionsPB req) throws Exception {
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String dtype = "%";
    String loc = "%";
    String systemTotals = SYSTEM_TOTALS_COUNT;

    if (req.hasDataType())
        if (req.getDataType() != 0)
            dtype = Integer.toString(req.getDataType());
    if (req.hasLocation())
        if (!"ALL".equals(req.getLocation()))
            loc = req.getLocation();/*from   w ww.  j  a va 2 s .c  o  m*/

    int valType = req.getValType();
    if (valType == 2)
        systemTotals = SYSTEM_TOTALS_LOAD;
    else if (valType == 3)
        systemTotals = SYSTEM_TOTALS_DURATION;

    try (JdbcService jdbc = swagrJdbcFac.newService(systemTotals)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, dtype);
        ps.setString(4, loc);
        ps.setInt(5, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        return systemTotalsResultSet(rs, req.getSystemId());
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure serviceTotals(SwagrOptionsPB req) throws Exception {
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String dtype = "%";
    String loc = "%";
    String serviceQuery = SERVICE_TOTALS_COUNT;

    if (req.hasDataType())
        if (req.getDataType() != 0)
            dtype = Integer.toString(req.getDataType());
    if (req.hasLocation())
        if (!"ALL".equals(req.getLocation()))
            loc = req.getLocation();/*from   w  w w  .  j  a  v  a  2 s .  c o  m*/

    int valType = req.getValType();
    if (valType == 2)
        serviceQuery = SERVICE_TOTALS_LOAD;
    else if (valType == 3)
        serviceQuery = SERVICE_TOTALS_DURATION;

    try (JdbcService jdbc = swagrJdbcFac.newService(serviceQuery)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, dtype);
        ps.setString(4, loc);
        ps.setInt(5, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        return serviceResultSet(rs);
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure singleReq(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String tempLoc;/*w  w w . j a  va 2s.c  o m*/
    String tempDType;
    if ("ALL".equals(req.getLocation()))
        tempLoc = "%";
    else
        tempLoc = req.getLocation();
    if (req.getDataType() == 0)
        tempDType = "%";
    else
        tempDType = Integer.toString(req.getDataType());

    try (JdbcService jdbc = swagrJdbcFac.newService(SINGLE_REQ)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(3, req.getId());
        ps.setString(4, tempLoc);
        ps.setString(5, tempDType);
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SINGLE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure singleQuery(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    try (JdbcService jdbc = swagrJdbcFac.newService(SINGLE_QUERY)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(3, req.getId());/*  w  w  w. j a v a  2 s . c  om*/
        ResultSet rs = jdbc.executeQuery();
        queryStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(DRJ_SINGLE_STRING)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        qStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure movingAvg(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct;//from  www.ja v  a2 s .c  om
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    String tempLoc;
    if ("ALL".equals(req.getLocation()))
        tempLoc = "%";
    else
        tempLoc = req.getLocation();

    String tempDType;
    if (req.getDataType() == 0)
        tempDType = "%";
    else
        tempDType = Integer.toString(req.getDataType());

    //where start,end,loc,dtype,rid,valtype
    try (JdbcService jdbc = swagrJdbcFac.newService(MOVING_AVG)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, tempLoc);
        ps.setString(4, tempDType);
        ps.setInt(5, req.getId());
        ps.setInt(6, req.getValType());
        ResultSet rs = jdbc.executeQuery();
        struct = movingAvgResSet(rs, req.getValType());
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SINGLE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }

}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure topXSys(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String temploc;/*www .j  a  v a  2  s .c o  m*/
    if ("ALL".equals(req.getLocation()))
        temploc = "%";
    else
        temploc = req.getLocation();
    if (req.getDataType() == 0) {

        //start,end,loc,start,end,topnum,loc,sysid,type
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_TOP_SYS_DISTINCT)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setString(3, temploc);
            ps.setDate(4, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(5, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(6, req.getTopNum());
            ps.setString(7, req.getLocation());
            ps.setInt(8, req.getSystemId());
            ps.setInt(9, req.getValType());
            ResultSet rs = jdbc.executeQuery();
            sysStatsDailyResSet(rs, struct);
            jdbc.close();
        }
    } else {
        //start,end,dtype,loc,start,end,topnum,loc,sysid,dtype,valtype
        try (JdbcService jdbc = swagrJdbcFac.newService(S_TOP_DATA_DISTINCT)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getDataType());
            ps.setString(4, temploc);
            ps.setDate(5, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(6, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(7, req.getTopNum());
            ps.setString(8, req.getLocation());
            ps.setInt(9, req.getSystemId());
            ps.setInt(10, req.getDataType());
            ps.setInt(11, req.getValType());
            ResultSet rs = jdbc.executeQuery();
            sysStatsDailyResSet(rs, struct);
            jdbc.close();
        }
    }

    if (req.getDataType() == 0) {
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_STRINGS_SYS)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getTopNum());
            ps.setString(4, req.getLocation());
            ps.setInt(5, req.getSystemId());
            ResultSet rs = jdbc.executeQuery();
            reqStrings(rs, struct);
            return struct;
        }
    } else {
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_STRINGS_DATA)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getTopNum());
            ps.setString(4, req.getLocation());
            ps.setInt(5, req.getSystemId());
            ps.setInt(6, req.getDataType());
            ResultSet rs = jdbc.executeQuery();
            reqStrings(rs, struct);
            return struct;
        }
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure topXQ(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();

    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    try (JdbcService jdbc = drjJdbcFac.newService(DRJ_TOP_STATS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getHostTypeId());
        ps.setDate(2, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(3, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setDate(4, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(5, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(6, req.getTopNum());// ww  w.  j av a  2s. c  om
        ps.setInt(7, req.getHostTypeId());
        ResultSet rs = jdbc.executeQuery();
        queryStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = drjJdbcFac.newService(DRJ_STRINGS)) {
        PreparedStatement ps2 = jdbc.getPreparedStatement();
        ps2.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps2.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps2.setInt(3, req.getTopNum());
        ps2.setInt(4, req.getHostTypeId());
        ResultSet rs2 = jdbc.executeQuery();
        qStrings(rs2, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure service(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();

    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    //start,end,location,service
    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICES)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, req.hasLocation() ? req.getLocation() : "%");
        ps.setString(4, req.getDataType() == 0 ? "%" : Integer.toString(req.getDataType()));
        ps.setString(5, req.getService());
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }//from  w  w  w. ja v a  2  s .co m

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setString(1, req.getService());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure deprecatedService(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    Map<RequestKey, Integer> requestIDMap = new HashMap<>();

    try (JdbcService jdbc = swagrJdbcFac.newService(SELECT_SYSTEM_REQUESTS)) {
        jdbc.getPreparedStatement().setInt(1, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        while (rs.next()) {
            int id = rs.getInt(1);
            requestIDMap.put(new RequestKey(rs.getString(2), rs.getString(3), rs.getString(4)), id);
        }//from   w w  w.  j  a va2  s  . co  m
    }

    List<Integer> depReqIds = new ArrayList<>();

    InfoClient infoClient = InfoClientFactory.getClient(LouieConnectionFactory.getSharedConnection());

    List<ServicePB> services;
    if (req.getService().equals("ALL")) {
        services = infoClient.getAllServices();
    } else {
        services = Collections.singletonList(infoClient.getService(req.getService()));
    }

    for (ServicePB serviceData : services) {
        for (MethodPB method : serviceData.getMethodsList()) {
            if (method.getDeprecated()) {
                StringBuilder paramList = new StringBuilder();
                for (ParamPB param : method.getParamsList()) {
                    paramList.append(param.getType()).append(",");
                }
                if (paramList.length() != 0) {
                    paramList.deleteCharAt(paramList.length() - 1);
                }
                RequestKey rkey = new RequestKey(serviceData.getName(), method.getName(), paramList.toString());
                Integer rid = requestIDMap.get(rkey);
                if (rid != null) {
                    depReqIds.add(rid);
                }
            }
        }
    }

    if (depReqIds.isEmpty()) {
        return struct;
    }
    StringBuilder depQuery = new StringBuilder();
    for (int i = 0; i < depReqIds.size(); i++) {
        depQuery.append("?");
        if (i < depReqIds.size() - 1) {
            depQuery.append(",");
        }
    }
    depQuery.append(")");

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICES_DEPRECATED + depQuery.toString())) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, req.hasLocation() ? req.getLocation() : "%");
        ps.setString(4, req.getDataType() == 0 ? "%" : Integer.toString(req.getDataType()));
        int i = 5;
        for (int id : depReqIds) {
            ps.setInt(i++, id);
        }
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }
    try (JdbcService jdbc = swagrJdbcFac
            .newService(SWAGR_STRINGS_PREFIX + " WHERE r.id IN (" + depQuery.toString())) {
        PreparedStatement ps = jdbc.getPreparedStatement();

        int i = 1;
        for (int id : depReqIds) {
            ps.setInt(i++, id);
        }
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »