org.apache.derbyTesting.functionTests.tests.lang

Class TimeHandlingTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.TimeHandlingTest

All Implemented Interfaces:

junit.framework.Test

public class TimeHandlingTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private java.util.Calendar	cal Calendar for testing returned values.
private static java.lang.String[]	CURRENT_TIME_FUNCTIONS All the functions or expressions that result in a TIME value with the same value as CURRENT_TIME.
private static java.lang.String[]	CURRENT_TIMESTAMP_FUNCTIONS All the functions or expressions that result in a TIMESTAMP value with the same value as CURRENT_TIMESTAMP.
private static long	SLEEP_TIME Time to sleep that will result in different TIME values.

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
TimeHandlingTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private void	assertTime1970(java.sql.Time t) Javadoc for java.sql.Time states the components of date for a java.sql.Time value must be set to January 1, 1970.
private void	assertTimeEqual(java.util.Date tv1, java.util.Date tv2) Assert the SQL time portion of two SQL JDBC type types are equal.
private java.lang.Object	checkCurrentMultiple(int jdbcType, long start, long end, java.sql.ResultSet rs, int[] columns, int expectedCount) Check the validity of all CURRENT time values returned and that they are identical.
private void	checkCurrentQuery(int sqlType, java.sql.Statement s, java.lang.String sql, int[] columns, int expectedCount) Execute a query that uses CURRENT expressions directly.
private java.sql.Time	checkCurrentTimeMultiple(long start, long end, java.sql.ResultSet rs, int[] columns, int expectedCount) Check a set of rows and columns with values set to CURRENT TIME in a single statement are the same.
private java.sql.Timestamp	checkCurrentTimestampMultiple(long start, long end, java.sql.ResultSet rs, int[] columns, int expectedCount) Check a set of rows and columns with values set to CURRENT TIMESTAMP in a single statement are the same.
private java.sql.Timestamp	checkCurrentTimestampValue(long start, long end, java.sql.ResultSet rs, int column) Check the consistency of a ResultSet column that returns CURRENT TIMESTAMP or a value set from CURRENT TIMESTAMP.
private java.sql.Time	checkCurrentTimeValue(long start, long end, java.sql.ResultSet rs, int column) Check the consistency of a ResultSet column that returns CURRENT TIME or a value set from CURRENT TIME.
private java.sql.Timestamp	checkTimestampValue(java.sql.ResultSet rs, int column) Check the consistency of a ResultSet column that returns a TIMESTAMP value.
private java.sql.Time	checkTimeValue(java.sql.ResultSet rs, int column) Check the consistency of a ResultSet column that returns a TIME value.
private void	currentFunctionTests(int jdbcType, java.lang.String[] functions) Test all the current timedate functions passed in that return the specified type.
private java.sql.Time	getCodedTime(int id) Return a time simply encoded from an integer identifier and a set of fixed encoding keys, each a prime number.
private java.sql.Time	getTime19700101(int hour, int min, int sec) Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by h, m and s.
private java.sql.Time	getTime19700101(long t, java.util.Calendar cal) Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by t and cal.
private java.sql.Time	getTime19700101(java.lang.String s, java.util.Calendar cal) Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by t and cal.
private boolean	isDateEqual(long d, java.sql.Timestamp tsv) Check if the date portion of a Timestamp value is equal to the date portion of a time value represented in milli-seconds since 1970.
protected void	setUp() Simple set up, just get a Calendar and ensure the table T_ALL is empty.
static int	sleep() Method for SQL SLEEP function.
static junit.framework.Test	suite() Runs the tests in the default embedded configuration and then the client server configuration.
void	testCurrentTime() Tests for CURRENT TIME and CURRENT_TIME.
void	testCurrentTimestamp() Tests for CURRENT TIMESTAMP functions.
void	testInsertTime() Test inserting and selecting of TIME values.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

CURRENT_TIME_FUNCTIONS

private static final java.lang.String[] CURRENT_TIME_FUNCTIONS

All the functions or expressions that result in a TIME value with the same value as CURRENT_TIME.

CURRENT_TIMESTAMP_FUNCTIONS

private static final java.lang.String[] CURRENT_TIMESTAMP_FUNCTIONS

All the functions or expressions that result in a TIMESTAMP value with the same value as CURRENT_TIMESTAMP.

SLEEP_TIME

private static final long SLEEP_TIME

Time to sleep that will result in different TIME values.

See Also:

Constant Field Values

cal

private java.util.Calendar cal

Calendar for testing returned values.

Constructor Detail

TimeHandlingTest

public TimeHandlingTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Runs the tests in the default embedded configuration and then the client server configuration.

sleep

public static int sleep()
                 throws java.lang.InterruptedException

Method for SQL SLEEP function. Sleeps for the time that will result in a change in System.currentTimeMillis and a Derby TIME value.

Throws:

java.lang.InterruptedException

setUp

protected void setUp()
              throws java.sql.SQLException

Simple set up, just get a Calendar and ensure the table T_ALL is empty.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

testInsertTime

public void testInsertTime()
                    throws java.sql.SQLException

Test inserting and selecting of TIME values. A set of random TIME values are inserted along with an identifier that encodes the time value. The values are then fetched and compared to a value calculated from the identifier. The returned values are fetched using checkTimeValue thus inheriting all the checks within that method.

Throws:

java.sql.SQLException

getCodedTime

private java.sql.Time getCodedTime(int id)

Return a time simply encoded from an integer identifier and a set of fixed encoding keys, each a prime number. This allows a random value to be inserted into a table as a TIME and an INTEGER and thus checked for consistency on a SELECT.

Parameters:

id -

testCurrentTime

public void testCurrentTime()
                     throws java.sql.SQLException,
                            java.lang.InterruptedException

Tests for CURRENT TIME and CURRENT_TIME. A set of tests that ensure the CURRENT TIME maintains a single value for the life time of a statement and that (subject to the resolution) the returned value is correctly between the start time of the statement execution and the first fetch or completion.

Throws:

java.sql.SQLException

java.lang.InterruptedException

testCurrentTimestamp

public void testCurrentTimestamp()
                          throws java.sql.SQLException,
                                 java.lang.InterruptedException

Tests for CURRENT TIMESTAMP functions. A set of tests that ensure the CURRENT TIMESTAMP maintains a single value for the life time of a statement and that (subject to the resolution) the returned value is correctly between the start time of the statement execution and the first fetch or completion.

Throws:

java.sql.SQLException

java.lang.InterruptedException

currentFunctionTests

private void currentFunctionTests(int jdbcType,
                                  java.lang.String[] functions)
                           throws java.sql.SQLException,
                                  java.lang.InterruptedException

Test all the current timedate functions passed in that return the specified type. Generic function that checks the functions' are all identical in various situations and that the have the correct value, and change across executions.

Parameters:

jdbcType - JDBC type, Types.TIME, DATE or TIMESTAMP.

functions - List of functions or expressions that map to the current time date value and return the specified type.

Throws:

java.sql.SQLException

java.lang.InterruptedException

checkCurrentQuery

private void checkCurrentQuery(int sqlType,
                               java.sql.Statement s,
                               java.lang.String sql,
                               int[] columns,
                               int expectedCount)
                        throws java.sql.SQLException

Execute a query that uses CURRENT expressions directly. The time returned for these values should be between the start of execution and after the return from the first rs.next().

Parameters:

sqlType -

s -

sql -

columns -

expectedCount -

Throws:

java.sql.SQLException

checkCurrentMultiple

private java.lang.Object checkCurrentMultiple(int jdbcType,
                                              long start,
                                              long end,
                                              java.sql.ResultSet rs,
                                              int[] columns,
                                              int expectedCount)
                                       throws java.sql.SQLException

Check the validity of all CURRENT time values returned and that they are identical.

Parameters:

jdbcType - Types.TIME or TIMESTAMP

start - Start of window for valid value.

end - End of window for valid value.

rs - Result set positioned on row.

columns - Columns holding current values.

expectedCount - Total number of values exected to see (row count times column count)

Throws:

java.sql.SQLException

checkCurrentTimeMultiple

private java.sql.Time checkCurrentTimeMultiple(long start,
                                               long end,
                                               java.sql.ResultSet rs,
                                               int[] columns,
                                               int expectedCount)
                                        throws java.sql.SQLException

Check a set of rows and columns with values set to CURRENT TIME in a single statement are the same.

Parameters:

start - Start time for the statement that set the values.

end - End time for the statement that set the values.

rs - ResultSet positioned on the first row.

columns - Set of columns holding the TIME values

expectedCount - Number of values we are execpted to check.

Throws:

java.sql.SQLException

checkCurrentTimestampMultiple

private java.sql.Timestamp checkCurrentTimestampMultiple(long start,
                                                         long end,
                                                         java.sql.ResultSet rs,
                                                         int[] columns,
                                                         int expectedCount)
                                                  throws java.sql.SQLException

Check a set of rows and columns with values set to CURRENT TIMESTAMP in a single statement are the same.

Parameters:

start - Start time for the statement that set the values.

end - End time for the statement that set the values.

rs - ResultSet positioned on the first row.

columns - Set of columns holding the TIME values

expectedCount - Number of values we are execpted to check.

Throws:

java.sql.SQLException

checkTimeValue

private java.sql.Time checkTimeValue(java.sql.ResultSet rs,
                                     int column)
                              throws java.sql.SQLException

Check the consistency of a ResultSet column that returns a TIME value. Can be used for any column of type TIME.

Parameters:

rs - ResultSet holding the column, positioned on a row

column - Column with the TIME value.

Returns:

Returns the Time object obtained from the column.

Throws:

java.sql.SQLException

checkTimestampValue

private java.sql.Timestamp checkTimestampValue(java.sql.ResultSet rs,
                                               int column)
                                        throws java.sql.SQLException

Check the consistency of a ResultSet column that returns a TIMESTAMP value. Can be used for any column of type TIMESTAMP.

Parameters:

rs - ResultSet holding the column, positioned on a row

column - Column with the TIMESTAMP value.

Returns:

Returns the Time object obtained from the column.

Throws:

java.sql.SQLException

checkCurrentTimeValue

private java.sql.Time checkCurrentTimeValue(long start,
                                            long end,
                                            java.sql.ResultSet rs,
                                            int column)
                                     throws java.sql.SQLException

Check the consistency of a ResultSet column that returns CURRENT TIME or a value set from CURRENT TIME.

Parameters:

start - Time the statement settng the value was executed

end - Time after first rs.next() or update statement was executed

rs - ResultSet holding the column, positioned on a row

column - Column with the timestamp.

Returns:

Returns the Time object obtained from the column.

Throws:

java.sql.SQLException

checkCurrentTimestampValue

private java.sql.Timestamp checkCurrentTimestampValue(long start,
                                                      long end,
                                                      java.sql.ResultSet rs,
                                                      int column)
                                               throws java.sql.SQLException

Check the consistency of a ResultSet column that returns CURRENT TIMESTAMP or a value set from CURRENT TIMESTAMP.

Parameters:

start - Time the statement settng the value was executed

end - Time after first rs.next() or update statement was executed

rs - ResultSet holding the column, positioned on a row

column - Column with the timestamp.

Returns:

Returns the Timestamp object obtained from the column.

Throws:

java.sql.SQLException

getTime19700101

private java.sql.Time getTime19700101(int hour,
                                      int min,
                                      int sec)

Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by h, m and s. This matches Derby by setting the milli-second component to zero.
Note that the Time(long) constructor for java.sql.Time does *not* set the date component to 1970/01/01. This is a requirement for JDBC java.sql.Time values though

getTime19700101

private java.sql.Time getTime19700101(long t,
                                      java.util.Calendar cal)

Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by t and cal. This matches Derby by setting the milli-second component to zero.
Note that the Time(long) constructor for java.sql.Time does *not* set the date component to 1970/01/01. This is a requirement for JDBC java.sql.Time values though

getTime19700101

private java.sql.Time getTime19700101(java.lang.String s,
                                      java.util.Calendar cal)

Create a Time object that has its date components set to 1970/01/01 and its time to match the time represented by t and cal. This matches Derby by setting the milli-second component to zero.
Note that the Time(long) constructor for java.sql.Time does *not* set the date component to 1970/01/01. This is a requirement for JDBC java.sql.Time values though

assertTime1970

private void assertTime1970(java.sql.Time t)

Javadoc for java.sql.Time states the components of date for a java.sql.Time value must be set to January 1, 1970. Note that the java.sql.Time class does not enforce this, it is up to the driver.

Parameters:

t -

assertTimeEqual

private void assertTimeEqual(java.util.Date tv1,
                             java.util.Date tv2)

Assert the SQL time portion of two SQL JDBC type types are equal.

Parameters:

tv1 - the first time to compare

tv2 - the second time to compare

isDateEqual

private boolean isDateEqual(long d,
                            java.sql.Timestamp tsv)

Check if the date portion of a Timestamp value is equal to the date portion of a time value represented in milli-seconds since 1970.