Examples with TestDate org.h2.test.unit.TestDate used on opensource projects

Example 1 with TestDate

use of org.h2.test.unit.TestDate in project h2database by h2database.

the class TestAll method testUnit.

private void testUnit() {
    // mv store
    addTest(new TestCacheConcurrentLIRS());
    addTest(new TestCacheLIRS());
    addTest(new TestCacheLongKeyLIRS());
    addTest(new TestConcurrentLinkedList());
    addTest(new TestDataUtils());
    addTest(new TestFreeSpace());
    addTest(new TestKillProcessWhileWriting());
    addTest(new TestMVRTree());
    addTest(new TestMVStore());
    addTest(new TestMVStoreBenchmark());
    addTest(new TestMVStoreStopCompact());
    addTest(new TestMVStoreTool());
    addTest(new TestMVTableEngine());
    addTest(new TestObjectDataType());
    addTest(new TestRandomMapOps());
    addTest(new TestSpinLock());
    addTest(new TestStreamStore());
    addTest(new TestTransactionStore());
    // unit
    addTest(new TestAnsCompression());
    addTest(new TestAutoReconnect());
    addTest(new TestBinaryArithmeticStream());
    addTest(new TestBitStream());
    addTest(new TestBnf());
    addTest(new TestCache());
    addTest(new TestCharsetCollator());
    addTest(new TestClearReferences());
    addTest(new TestCollation());
    addTest(new TestCompress());
    addTest(new TestConnectionInfo());
    addTest(new TestDataPage());
    addTest(new TestDateIso8601());
    addTest(new TestExit());
    addTest(new TestFile());
    addTest(new TestFileLock());
    addTest(new TestFtp());
    addTest(new TestIntArray());
    addTest(new TestIntIntHashMap());
    addTest(new TestIntPerfectHash());
    addTest(new TestJmx());
    addTest(new TestMathUtils());
    addTest(new TestMode());
    addTest(new TestModifyOnWrite());
    addTest(new TestOldVersion());
    addTest(new TestObjectDeserialization());
    addTest(new TestMultiThreadedKernel());
    addTest(new TestOverflow());
    addTest(new TestPageStore());
    addTest(new TestPageStoreCoverage());
    addTest(new TestPerfectHash());
    addTest(new TestPgServer());
    addTest(new TestReader());
    addTest(new TestRecovery());
    addTest(new TestScriptReader());
    addTest(new RecoverLobTest());
    addTest(createTest("org.h2.test.unit.TestServlet"));
    addTest(new TestSecurity());
    addTest(new TestShell());
    addTest(new TestSort());
    addTest(new TestStreams());
    addTest(new TestStringUtils());
    addTest(new TestTimeStampWithTimeZone());
    addTest(new TestTraceSystem());
    addTest(new TestUpgrade());
    addTest(new TestUsingIndex());
    addTest(new TestUtils());
    addTest(new TestValue());
    addTest(new TestValueHashMap());
    addTest(new TestWeb());
    runAddedTests();
    // serial
    addTest(new TestDate());
    addTest(new TestDateTimeUtils());
    addTest(new TestCluster());
    addTest(new TestConcurrent());
    addTest(new TestFileLockSerialized());
    addTest(new TestFileLockProcess());
    addTest(new TestFileSystem());
    addTest(new TestNetUtils());
    addTest(new TestPattern());
    addTest(new TestTools());
    addTest(new TestSampleApps());
    addTest(new TestStringCache());
    addTest(new TestValueMemory());
    runAddedTests(1);
}

Example 2 with TestDate

use of org.h2.test.unit.TestDate in project h2database by h2database.

the class TestCompatibilityOracle method testDate.

private void testDate() throws SQLException {
    deleteDb("oracle");
    Connection conn = getConnection("oracle;MODE=Oracle");
    Statement stat = conn.createStatement();
    Timestamp t1 = Timestamp.valueOf("2011-02-03 12:11:10");
    Timestamp t2 = Timestamp.valueOf("1999-10-15 13:14:15");
    Timestamp t3 = Timestamp.valueOf("2030-11-22 11:22:33");
    Timestamp t4 = Timestamp.valueOf("2018-01-10 22:10:01");
    stat.execute("CREATE TABLE TEST (ID INT PRIMARY KEY, D DATE)");
    stat.executeUpdate("INSERT INTO TEST VALUES(1, TIMESTAMP '2011-02-03 12:11:10')");
    stat.executeUpdate("INSERT INTO TEST VALUES(2, CAST ('1999-10-15 13:14:15' AS DATE))");
    stat.executeUpdate("INSERT INTO TEST VALUES(3, '2030-11-22 11:22:33')");
    PreparedStatement ps = conn.prepareStatement("INSERT INTO TEST VALUES (?, ?)");
    ps.setInt(1, 4);
    ps.setTimestamp(2, t4);
    ps.executeUpdate();
    ResultSet rs = stat.executeQuery("SELECT D FROM TEST ORDER BY ID");
    rs.next();
    assertEquals(t1, rs.getTimestamp(1));
    rs.next();
    assertEquals(t2, rs.getTimestamp(1));
    rs.next();
    assertEquals(t3, rs.getTimestamp(1));
    rs.next();
    assertEquals(t4, rs.getTimestamp(1));
    assertFalse(rs.next());
    conn.close();
}