java.time.LocalDateTime#minusDays

Source File: TestExportProfiles.java From dremio-oss with Apache License 2.0

6 votes

/**
 * Test export-profiles display message when no profiles were found.
 */
@Test
public void testRetrieveExportProfileStats() throws Exception {
  final String tmpPath = folder0.newFolder("testStats").getAbsolutePath();
  final LocalDateTime toDate = LocalDateTime.now();
  final LocalDateTime fromDate = toDate.minusDays(30);
  ExportProfilesStats stats = new ExportProfilesStats(0, 0, 0, tmpPath);

  String expect = String.format("Defaulting to %s to %s. No profiles were found for the duration.", fromDate, toDate);
  assertEquals(expect, stats.retrieveStats(fromDate, toDate, false));

  expect = String.format("No profiles were found from %s to %s.", fromDate, toDate);
  assertEquals(expect, stats.retrieveStats(fromDate, toDate, true));

  expect = String.format("No profiles were found.");
  assertEquals(expect, stats.retrieveStats(null, null, false));
}

Source File: ImportDateTime.java From axelor-open-suite with GNU Affero General Public License v3.0

6 votes

public LocalDateTime updateDay(LocalDateTime datetime, String day) {
  if (!Strings.isNullOrEmpty(day)) {
    Matcher matcher = patternMonth.matcher(day);
    if (matcher.find()) {
      Long days = Long.parseLong(matcher.group());
      if (day.startsWith("+")) datetime = datetime.plusDays(days);
      else if (day.startsWith("-")) datetime = datetime.minusDays(days);
      else {
        if (days > datetime.toLocalDate().lengthOfMonth()) {
          days = Long.valueOf(datetime.toLocalDate().lengthOfMonth());
        }
        datetime = datetime.withDayOfMonth(days.intValue());
      }
    }
  }
  return datetime;
}

Source File: FuzzyValues.java From icure-backend with GNU General Public License v2.0

6 votes

public static long getFuzzyDateTime(LocalDateTime dateTime, TemporalUnit precision) {
	int seconds = dateTime.getSecond();
	/*if (seconds == 0 && precision==ChronoUnit.SECONDS) {
		seconds = 60;
		dateTime = dateTime.minusMinutes(1);
	}*/

	int minutes = dateTime.getMinute();
	if (minutes == 0 && precision == ChronoUnit.MINUTES) {
		minutes = 60;
		dateTime = dateTime.minusHours(1);
	}

	int hours = dateTime.getHour();
	if (hours == 0 && precision == ChronoUnit.HOURS) {
		hours = 24;
		dateTime = dateTime.minusDays(1);
	}


	return getFuzzyDate(dateTime, precision) * 1000000l + (precision == ChronoUnit.DAYS ? 0 : (
			hours * 10000l + (precision == ChronoUnit.HOURS ? 0 : (
					minutes * 100l + (precision == ChronoUnit.MINUTES ? 0 : seconds)))));
}

Source File: StringCode.java From java-tutorial with MIT License

6 votes

private static void stringTest() {
    String str0 = "123";
    String str1 = "123";
    //"=="在Java比较的不是两个对象的值，而是比较两个对象的引用是否相等
    System.out.println(str0 == str1);

    String str2 = "234";
    String str3 = "234";
    //Java虚拟机的解释器每遇到一个new关键字，都会在堆内存中开辟一块内存来存放一个String对象,不同的引用 false
    System.out.println(str2 == str3);
    //对比值相等
    System.out.println(str2.equals(str3));

    //昨天的当前时刻
    LocalDateTime today = LocalDateTime.now();
    var yesterday = today.minusDays(1);
    System.out.println(yesterday);


}

Source File: TimeUtil.java From game-server with MIT License

5 votes

/**@
 * 获取与今日相差天数的日期格式，负为日期前，正为日期后。如yyyy-MM-dd HH
 *
 * @param days
 * @param formatter
 * @return
 */
public static String getOffToDay(int days, DateTimeFormatter formatter) {
    LocalDateTime ldt = LocalDateTime.ofInstant(Instant.ofEpochMilli(currentTimeMillis()), ZoneId.systemDefault());
    if (days < 0) {
        ldt = ldt.minusDays(-days);
    } else {
        ldt = ldt.plusDays(days);
    }
    return ldt.format(formatter);
}

Source File: StorageTTLE2E.java From skywalking with Apache License 2.0

5 votes

@RetryableTest
public void dayMetricsDataShouldBeRemovedAfterTTL() throws Exception {
    final ServiceMeshMetric.Builder builder =
        ServiceMeshMetric.newBuilder()
                         .setSourceServiceName("e2e-test-source-service")
                         .setSourceServiceInstance("e2e-test-source-service-instance")
                         .setDestServiceName("e2e-test-dest-service")
                         .setDestServiceInstance("e2e-test-dest-service-instance")
                         .setEndpoint("e2e/test")
                         .setLatency(2000)
                         .setResponseCode(200)
                         .setStatus(SUCCESS)
                         .setProtocol(Protocol.HTTP)
                         .setDetectPoint(DetectPoint.server);

    final LocalDateTime now = now();
    final LocalDateTime startTime = now.minusDays(SW_CORE_RECORD_DATA_TTL + 1);
    final LocalDateTime endTime = startTime.plusMinutes(1);

    final LocalDateTime queryEnd = now.minusDays(SW_CORE_RECORD_DATA_TTL);

    ensureSendingMetricsWorks(
        builder, startTime.toEpochSecond(ZoneOffset.UTC) * 1000, endTime.toEpochSecond(ZoneOffset.UTC) * 1000,
        startTime, queryEnd, "DAY"
    );

    shouldBeEmptyBetweenTimeRange(startTime, queryEnd, "DAY");
}

Source File: TimeOfDayOfWeek.java From SmartApplianceEnabler with GNU General Public License v2.0

5 votes

public LocalDateTime toLastOccurrence(LocalDateTime now) {
    LocalDateTime dateTime = LocalDateTime.of(now.getYear(), now.getMonth(), now.getDayOfMonth(),
            getHour(), getMinute(), getSecond());
    while(dateTime.getDayOfWeek().getValue() != dayOfWeek) {
        dateTime = dateTime.minusDays(1);
    }
    return dateTime;
}

Source File: LitemallOrderServiceImpl.java From BigDataPlatform with GNU General Public License v3.0

5 votes

public List<LitemallOrder> queryUnconfirm(int days) {
    LocalDateTime now = LocalDateTime.now();
    LocalDateTime expired = now.minusDays(days);
    LitemallOrderExample example = new LitemallOrderExample();
    example.or().andOrderStatusEqualTo(OrderUtil.STATUS_SHIP).andShipTimeLessThan(expired).andDeletedEqualTo(false);
    return litemallOrderMapper.selectByExample(example);
}

Source File: LitemallOrderService.java From litemall with MIT License

5 votes

public List<LitemallOrder> queryComment(int days) {
    LocalDateTime now = LocalDateTime.now();
    LocalDateTime expired = now.minusDays(days);
    LitemallOrderExample example = new LitemallOrderExample();
    example.or().andCommentsGreaterThan((short) 0).andConfirmTimeLessThan(expired).andDeletedEqualTo(false);
    return litemallOrderMapper.selectByExample(example);
}

Source File: LitemallOrderService.java From litemall with MIT License

5 votes

public List<LitemallOrder> queryUnconfirm(int days) {
    LocalDateTime now = LocalDateTime.now();
    LocalDateTime expired = now.minusDays(days);
    LitemallOrderExample example = new LitemallOrderExample();
    example.or().andOrderStatusEqualTo(OrderUtil.STATUS_SHIP).andShipTimeLessThan(expired).andDeletedEqualTo(false);
    return litemallOrderMapper.selectByExample(example);
}

Source File: Lesson1_1.java From java-interview with Apache License 2.0

5 votes

public static void main(String[] args) {
    // 获取明天此刻时间
    Calendar calendar = Calendar.getInstance();
    calendar.add(Calendar.DATE, 1);
    System.out.println(calendar.getTime());
    LocalDateTime today = LocalDateTime.now();
    LocalDateTime tomorrow = today.minusDays(-1);
    //LocalDateTime tomorrow = today.plusDays(1);
    System.out.println(tomorrow);
}

Source File: ColorDisplayService.java From android_9.0.0_r45 with Apache License 2.0

5 votes

/**
 * Returns the first date time corresponding to the local time that occurs before the
 * provided date time.
 *
 * @param compareTime the LocalDateTime to compare against
 * @return the prior LocalDateTime corresponding to this local time
 */
public static LocalDateTime getDateTimeBefore(LocalTime localTime, LocalDateTime compareTime) {
    final LocalDateTime ldt = LocalDateTime.of(compareTime.getYear(), compareTime.getMonth(),
            compareTime.getDayOfMonth(), localTime.getHour(), localTime.getMinute());

    // Check if the local time has passed, if so return the same time yesterday.
    return ldt.isAfter(compareTime) ? ldt.minusDays(1) : ldt;
}

Source File: HdfsOffsetComputerTest.java From garmadon with Apache License 2.0

4 votes

@Test
public void actualFileSystem() throws IOException {
    final java.nio.file.Path tmpDir = Files.createTempDirectory("hdfs-reader-test-");

    try {
        final Path rootPath = new Path(tmpDir.toString());
        // Make sure we can read from subdirectories
        final Path basePath = new Path(rootPath, "embedded");
        final FileSystem localFs = FileSystem.getLocal(new Configuration());

        final HdfsOffsetComputer hdfsOffsetComputer = new HdfsOffsetComputer(localFs, basePath, 2);

        final LocalDateTime today = LocalDateTime.now();
        final LocalDateTime yesterday = today.minusDays(1);
        final LocalDateTime twoDaysAgo = today.minusDays(2);

        /*
            /tmp/hdfs-reader-test-1234
            └── embedded
                ├── <today>
                │   ├── 1.index=0
                │   └── 2.index=0
                └── <yesterday>
                │   ├── 1.index=0
                │   └── 1.index=1
                └── <2 days ago> # Should be ignored
                    └── 1.index=0
         */
        localFs.mkdirs(rootPath);
        localFs.mkdirs(basePath);

        writeParquetFile(new Path(basePath, hdfsOffsetComputer.computePath(today, 0L, 1)), 1);
        writeParquetFile(new Path(basePath, hdfsOffsetComputer.computePath(today, 0L, 2)), 12);
        writeParquetFile(new Path(basePath, hdfsOffsetComputer.computePath(yesterday, 0L, 1)), 2);
        writeParquetFile(new Path(basePath, hdfsOffsetComputer.computePath(yesterday, 1L, 1)), 3);
        writeParquetFile(new Path(basePath, hdfsOffsetComputer.computePath(twoDaysAgo, 0L, 1)), 42);

        Map<Integer, Long> offsets = hdfsOffsetComputer.computeOffsets(Arrays.asList(1, 2, 3));

        Assert.assertEquals(3, offsets.get(1).longValue());
        Assert.assertEquals(12, offsets.get(2).longValue());
        Assert.assertEquals(-1, offsets.get(3).longValue());
    } finally {
        FileUtils.deleteDirectory(tmpDir.toFile());
    }
}

Source File: GraphDataProvider.java From testgrid with Apache License 2.0

4 votes

/**
 * Provide history of the test execution summary for a given build job.
 *
 * @param productId product id.
 */
public Map<String, BuildExecutionSummary> getTestExecutionHistory(String productId) {

    Map<String, BuildExecutionSummary> buildExecutionSummariesHistory = new TreeMap<>();

    LocalTime midnight = LocalTime.MIDNIGHT;
    LocalDate timeZone = LocalDate.now(ZoneId.of("UTC"));
    LocalDateTime todayMidnight = LocalDateTime.of(timeZone, midnight);

    for (int i = 0; i < MAXIMUM_TIME_RANGE; i++) {
        if (TEST_EXECUTION_HISTORY_RANGE == buildExecutionSummariesHistory.size()) {
            break;
        }
        String from = todayMidnight.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
        String to = todayMidnight.plusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
        BuildExecutionSummary buildExecutionSummary = new BuildExecutionSummary();
        List<TestPlan> filteredTestPlanHistory;

        int passedTestPlans = 0;
        int failedTestPlans = 0;
        int skippedTestPlans = 0;

        List<TestPlan> testPlanHistory = testPlanUOW.getTestExecutionHistory(productId, from, to);
        if (testPlanHistory.isEmpty()) {
            todayMidnight = todayMidnight.minusDays(1);
            continue;
        }
        filteredTestPlanHistory = filterTestPlanHistory(testPlanHistory);

        for (TestPlan testplan : filteredTestPlanHistory) {
            if (TestPlanStatus.SUCCESS.equals(testplan.getStatus())) {
                passedTestPlans++;
            } else if (TestPlanStatus.FAIL.equals(testplan.getStatus())) {
                failedTestPlans++;
            } else {
                skippedTestPlans++;
            }
        }
        buildExecutionSummary.setPassedTestPlans(passedTestPlans);
        buildExecutionSummary.setFailedTestPlans(failedTestPlans);
        buildExecutionSummary.setSkippedTestPlans(skippedTestPlans);
        buildExecutionSummariesHistory.put(from.replace(" 00:00:00", ""), buildExecutionSummary);
        todayMidnight = todayMidnight.minusDays(1);
    }
    return buildExecutionSummariesHistory;
}

Source File: HdfsOffsetComputer.java From garmadon with Apache License 2.0

4 votes

@Override
public Map<Integer, Long> computeOffsets(Collection<Integer> partitionIds) throws IOException {
    Set<Integer> partitionIdsSet = new HashSet<>(partitionIds);

    final Map<Integer, Long> result = partitionIds.stream().collect(Collectors.toMap(Function.identity(), i -> NO_OFFSET));
    final Map<Integer, Map<String, FinalEventPartitionFile>> resultFile = new HashMap<>();

    LocalDateTime today = LocalDateTime.now();
    for (int i = 0; i < backlogDays; ++i) {
        LocalDateTime day = today.minusDays(i);
        String listedDay = day.format(DateTimeFormatter.ISO_DATE);

        String dirsPattern = String.format("%s/*", computeDirName(day));
        FileStatus[] fileStatuses = fs.globStatus(new Path(basePath, dirsPattern));

        for (FileStatus status : fileStatuses) {
            String fileName = status.getPath().getName();
            Matcher matcher = offsetFilePatternGenerator.matcher(fileName);
            if (matcher.matches()) {
                try {
                    int partitionId = Integer.parseInt(matcher.group("partitionId"));
                    long index = Long.parseLong(matcher.group("index"));
                    if (isPartitionComputedByThisReader(partitionId, partitionIdsSet) &&
                        checkCurrentFileIndexBiggerTheOneInHashPartitionDay(partitionId, listedDay, index, resultFile)) {
                        HashMap<String, FinalEventPartitionFile> dateFinalEventPartitionFile =
                            (HashMap<String, FinalEventPartitionFile>) resultFile.computeIfAbsent(partitionId, HashMap::new);
                        dateFinalEventPartitionFile.put(listedDay,
                            new FinalEventPartitionFile(index, status.getPath()));
                        resultFile.put(partitionId, dateFinalEventPartitionFile);
                    }
                } catch (NumberFormatException e) {
                    LOGGER.info("Couldn't deviate a valid offset from '{}'", fileName);
                }
            }
        }
    }

    // Get last offset
    for (Map.Entry<Integer, Map<String, FinalEventPartitionFile>> partitionIdDateFile : resultFile.entrySet()) {
        result.put(partitionIdDateFile.getKey(), getMaxOffset(partitionIdDateFile.getValue()));
    }

    return result;
}

Source File: DateTimeFiltersTest.java From tablesaw with Apache License 2.0

4 votes

@Test
public void testComparison() {
  LocalDate date = LocalDate.of(2015, 1, 25);
  LocalDateTime dateTime = LocalDate.of(2015, 1, 25).atStartOfDay();
  DateTimeColumn dateTimeColumn = DateTimeColumn.create("test");

  LocalDateTime beforeDate = dateTime.minusDays(1);
  LocalDateTime afterDate = dateTime.plusDays(1);

  dateTimeColumn.append(beforeDate);
  dateTimeColumn.append(dateTime);
  dateTimeColumn.append(afterDate);

  IntColumn index = IntColumn.indexColumn("index", dateTimeColumn.size(), 0);
  Table t = Table.create("test", dateTimeColumn, index);

  assertTrue(dateTimeColumn.isOnOrBefore(date).contains(0));
  assertTrue(dateTimeColumn.isOnOrBefore(date).contains(1));

  assertTrue(dateTimeColumn.isOnOrAfter(date).contains(1));
  assertTrue(dateTimeColumn.isOnOrAfter(date).contains(2));

  assertTrue(dateTimeColumn.isBefore(dateTime).contains(0));
  assertTrue(dateTimeColumn.isBefore(date).contains(0));
  assertTrue(t.where(t.dateTimeColumn("test").isBefore(dateTime)).intColumn("index").contains(0));
  assertTrue(t.where(t.dateTimeColumn("test").isBefore(date)).intColumn("index").contains(0));

  assertTrue(dateTimeColumn.isEqualTo(dateTime).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isEqualTo(dateTime)).intColumn("index").contains(1));

  assertTrue(dateTimeColumn.isAfter(dateTime).contains(2));
  assertTrue(dateTimeColumn.isAfter(date).contains(2));
  assertTrue(t.where(t.dateTimeColumn("test").isAfter(dateTime)).intColumn("index").contains(2));
  assertTrue(t.where(t.dateTimeColumn("test").isAfter(date)).intColumn("index").contains(2));

  assertTrue(dateTimeColumn.isNotEqualTo(dateTime).contains(2));
  assertTrue(
      t.where(t.dateTimeColumn("test").isNotEqualTo(dateTime)).intColumn("index").contains(2));

  assertTrue(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(1));
  assertTrue(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(1));

  assertTrue(dateTimeColumn.isBetweenIncluding(beforeDate, afterDate).contains(2));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenIncluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(2));

  assertTrue(dateTimeColumn.isBetweenIncluding(beforeDate, afterDate).contains(0));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenIncluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(0));

  assertFalse(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(2));
  assertFalse(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(2));

  assertFalse(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(0));
  assertFalse(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(0));
}

Source File: DateTimeFiltersTest.java From tablesaw with Apache License 2.0

4 votes

@Test
public void testComparison2() {
  LocalDateTime dateTime = LocalDate.of(2015, 1, 25).atStartOfDay();
  DateTimeColumn dateTimeColumn = DateTimeColumn.create("test");

  LocalDateTime beforeDate = dateTime.minusDays(1);
  LocalDateTime afterDate = dateTime.plusDays(1);

  dateTimeColumn.append(beforeDate);
  dateTimeColumn.append(dateTime);
  dateTimeColumn.append(afterDate);

  DateTimeColumn same = DateTimeColumn.create("same");
  same.append(beforeDate);
  same.append(dateTime);
  same.append(afterDate);

  DateTimeColumn before = DateTimeColumn.create("before");
  before.append(beforeDate.minusDays(1));
  before.append(dateTime.minusDays(1));
  before.append(afterDate.minusDays(1));

  DateTimeColumn after = DateTimeColumn.create("after");
  after.append(beforeDate.plusDays(1));
  after.append(dateTime.plusDays(1));
  after.append(afterDate.plusDays(1));

  Table t = Table.create("test", dateTimeColumn, same, before, after);

  assertTrue(dateTimeColumn.isEqualTo(same).contains(0));
  assertTrue(t.dateTimeColumn("test").isEqualTo(same).contains(0));
  assertTrue(t.dateTimeColumn("test").isEqualTo(t.dateTimeColumn("same")).contains(0));

  assertTrue(dateTimeColumn.isBefore(after).contains(0));
  assertTrue(t.dateTimeColumn("test").isBefore(after).contains(0));
  assertTrue(t.dateTimeColumn("test").isBefore(t.dateTimeColumn("after")).contains(0));

  assertTrue(dateTimeColumn.isAfter(before).contains(0));
  assertTrue(t.dateTimeColumn("test").isAfter(before).contains(0));
  assertTrue(t.dateTimeColumn("test").isAfter(t.dateTimeColumn("before")).contains(0));

  assertFalse(dateTimeColumn.isNotEqualTo(same).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(same).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("same")).contains(0));

  assertTrue(dateTimeColumn.isOnOrBefore(same).contains(0));
  assertTrue(dateTimeColumn.isOnOrBefore(after).contains(0));
  assertFalse(dateTimeColumn.isOnOrBefore(before).contains(0));
  assertTrue(dateTimeColumn.isNotEqualTo(before).contains(0));

  assertTrue(dateTimeColumn.isOnOrAfter(same).contains(1));
  assertTrue(dateTimeColumn.isOnOrAfter(before).contains(2));
  assertFalse(dateTimeColumn.isOnOrAfter(after).contains(2));
  assertTrue(dateTimeColumn.isNotEqualTo(after).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrAfter(t.dateTimeColumn("same")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrAfter(same).contains(0));

  assertFalse(t.dateTimeColumn("test").isOnOrAfter(t.dateTimeColumn("after")).contains(0));
  assertFalse(t.dateTimeColumn("test").isOnOrAfter(after).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("same")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrBefore(same).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("after")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrBefore(after).contains(0));

  assertFalse(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("before")).contains(0));
  assertFalse(t.dateTimeColumn("test").isOnOrBefore(before).contains(0));

  assertTrue(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("before")).contains(0));
  assertTrue(t.dateTimeColumn("test").isNotEqualTo(before).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("same")).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(same).contains(0));
}

Source File: DateTimeFiltersTest.java From tablesaw with Apache License 2.0

4 votes

@Test
public void testComparison2() {
  LocalDateTime dateTime = LocalDate.of(2015, 1, 25).atStartOfDay();
  DateTimeColumn dateTimeColumn = DateTimeColumn.create("test");

  LocalDateTime beforeDate = dateTime.minusDays(1);
  LocalDateTime afterDate = dateTime.plusDays(1);

  dateTimeColumn.append(beforeDate);
  dateTimeColumn.append(dateTime);
  dateTimeColumn.append(afterDate);

  DateTimeColumn same = DateTimeColumn.create("same");
  same.append(beforeDate);
  same.append(dateTime);
  same.append(afterDate);

  DateTimeColumn before = DateTimeColumn.create("before");
  before.append(beforeDate.minusDays(1));
  before.append(dateTime.minusDays(1));
  before.append(afterDate.minusDays(1));

  DateTimeColumn after = DateTimeColumn.create("after");
  after.append(beforeDate.plusDays(1));
  after.append(dateTime.plusDays(1));
  after.append(afterDate.plusDays(1));

  Table t = Table.create("test", dateTimeColumn, same, before, after);

  assertTrue(dateTimeColumn.isEqualTo(same).contains(0));
  assertTrue(t.dateTimeColumn("test").isEqualTo(same).contains(0));
  assertTrue(t.dateTimeColumn("test").isEqualTo(t.dateTimeColumn("same")).contains(0));

  assertTrue(dateTimeColumn.isBefore(after).contains(0));
  assertTrue(t.dateTimeColumn("test").isBefore(after).contains(0));
  assertTrue(t.dateTimeColumn("test").isBefore(t.dateTimeColumn("after")).contains(0));

  assertTrue(dateTimeColumn.isAfter(before).contains(0));
  assertTrue(t.dateTimeColumn("test").isAfter(before).contains(0));
  assertTrue(t.dateTimeColumn("test").isAfter(t.dateTimeColumn("before")).contains(0));

  assertFalse(dateTimeColumn.isNotEqualTo(same).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(same).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("same")).contains(0));

  assertTrue(dateTimeColumn.isOnOrBefore(same).contains(0));
  assertTrue(dateTimeColumn.isOnOrBefore(after).contains(0));
  assertFalse(dateTimeColumn.isOnOrBefore(before).contains(0));
  assertTrue(dateTimeColumn.isNotEqualTo(before).contains(0));

  assertTrue(dateTimeColumn.isOnOrAfter(same).contains(1));
  assertTrue(dateTimeColumn.isOnOrAfter(before).contains(2));
  assertFalse(dateTimeColumn.isOnOrAfter(after).contains(2));
  assertTrue(dateTimeColumn.isNotEqualTo(after).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrAfter(t.dateTimeColumn("same")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrAfter(same).contains(0));

  assertFalse(t.dateTimeColumn("test").isOnOrAfter(t.dateTimeColumn("after")).contains(0));
  assertFalse(t.dateTimeColumn("test").isOnOrAfter(after).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("same")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrBefore(same).contains(0));

  assertTrue(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("after")).contains(0));
  assertTrue(t.dateTimeColumn("test").isOnOrBefore(after).contains(0));

  assertFalse(t.dateTimeColumn("test").isOnOrBefore(t.dateTimeColumn("before")).contains(0));
  assertFalse(t.dateTimeColumn("test").isOnOrBefore(before).contains(0));

  assertTrue(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("before")).contains(0));
  assertTrue(t.dateTimeColumn("test").isNotEqualTo(before).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(t.dateTimeColumn("same")).contains(0));
  assertFalse(t.dateTimeColumn("test").isNotEqualTo(same).contains(0));
}

Source File: DateTimeFiltersTest.java From tablesaw with Apache License 2.0

4 votes

@Test
public void testComparison() {
  LocalDate date = LocalDate.of(2015, 1, 25);
  LocalDateTime dateTime = LocalDate.of(2015, 1, 25).atStartOfDay();
  DateTimeColumn dateTimeColumn = DateTimeColumn.create("test");

  LocalDateTime beforeDate = dateTime.minusDays(1);
  LocalDateTime afterDate = dateTime.plusDays(1);

  dateTimeColumn.append(beforeDate);
  dateTimeColumn.append(dateTime);
  dateTimeColumn.append(afterDate);

  IntColumn index = IntColumn.indexColumn("index", dateTimeColumn.size(), 0);
  Table t = Table.create("test", dateTimeColumn, index);

  assertTrue(dateTimeColumn.isOnOrBefore(date).contains(0));
  assertTrue(dateTimeColumn.isOnOrBefore(date).contains(1));

  assertTrue(dateTimeColumn.isOnOrAfter(date).contains(1));
  assertTrue(dateTimeColumn.isOnOrAfter(date).contains(2));

  assertTrue(dateTimeColumn.isBefore(dateTime).contains(0));
  assertTrue(dateTimeColumn.isBefore(date).contains(0));
  assertTrue(t.where(t.dateTimeColumn("test").isBefore(dateTime)).intColumn("index").contains(0));
  assertTrue(t.where(t.dateTimeColumn("test").isBefore(date)).intColumn("index").contains(0));

  assertTrue(dateTimeColumn.isEqualTo(dateTime).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isEqualTo(dateTime)).intColumn("index").contains(1));

  assertTrue(dateTimeColumn.isAfter(dateTime).contains(2));
  assertTrue(dateTimeColumn.isAfter(date).contains(2));
  assertTrue(t.where(t.dateTimeColumn("test").isAfter(dateTime)).intColumn("index").contains(2));
  assertTrue(t.where(t.dateTimeColumn("test").isAfter(date)).intColumn("index").contains(2));

  assertTrue(dateTimeColumn.isNotEqualTo(dateTime).contains(2));
  assertTrue(
      t.where(t.dateTimeColumn("test").isNotEqualTo(dateTime)).intColumn("index").contains(2));

  assertTrue(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(1));
  assertTrue(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(1));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(1));

  assertTrue(dateTimeColumn.isBetweenIncluding(beforeDate, afterDate).contains(2));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenIncluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(2));

  assertTrue(dateTimeColumn.isBetweenIncluding(beforeDate, afterDate).contains(0));
  assertTrue(
      t.where(t.dateTimeColumn("test").isBetweenIncluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(0));

  assertFalse(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(2));
  assertFalse(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(2));

  assertFalse(dateTimeColumn.isBetweenExcluding(beforeDate, afterDate).contains(0));
  assertFalse(
      t.where(t.dateTimeColumn("test").isBetweenExcluding(beforeDate, afterDate))
          .intColumn("index")
          .contains(0));
}

Source File: SearchServiceAggsIT.java From elastic-rest-spring-wrapper with BSD 3-Clause "New" or "Revised" License

3 votes

private Date createDate(int numDaysToSubtract) {
    LocalDateTime date = LocalDateTime.now();

    LocalDateTime newDate = date.minusDays(numDaysToSubtract);

    return Date.from(newDate.atZone(ZoneId.systemDefault()).toInstant());
}

Java Code Examples for java.time.LocalDateTime#minusDays()