public static void prepareReportingInsert(PreparedStatement ps, String email, int dashId, int deviceId, short pin, PinType pinType, long ts, double value) throws SQLException { ps.setString(1, email); ps.setInt(2, dashId); ps.setInt(3, deviceId); ps.setShort(4, pin); ps.setInt(5, pinType.ordinal()); ps.setTimestamp(6, new Timestamp(ts), DateTimeUtils.UTC_CALENDAR); ps.setDouble(7, value); }
ps.setInt(2, key.getDashId()); ps.setInt(3, key.getDeviceId()); ps.setShort(4, key.getPin()); ps.setString(5, key.getPinType().pinTypeString); ps.setTimestamp(6, new Timestamp(key.ts), DateTimeUtils.UTC_CALENDAR);
keyToRemove.getDeviceId(), keyToRemove.getPinType(), keyToRemove.getPin(), type); Path filePath = Paths.get(userReportFolder.toString(), fileName);