testsuite.simple

Class DateTimeTest

java.lang.Object

testsuite.BaseTestCase

testsuite.simple.DateTimeTest

public class DateTimeTest
extends BaseTestCase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) static class	DateTimeTest.UseMethod

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields

Modifier and Type	Field and Description
(package private) java.lang.String[]	connectionTimeZones
private static java.lang.String	dataTruncatedErr
private static java.time.format.DateTimeFormatter	DATETIME_FORMATTER_WITH_MICROS_NO_OFFCET
private static int	id
private static java.lang.String	incorrectDateErr
private static java.lang.String	incorrectDatetimeErr
private static java.lang.String	incorrectTimeErr
private static java.time.LocalDate	ld_19700101
private static java.time.LocalDate	ld_20191231
private static java.time.LocalDate	ld_20200101
private static java.time.LocalDateTime	ldt_19700101_0000
private static java.time.LocalDateTime	ldt_19700101_020000_123000
private static java.time.LocalDateTime	ldt_19700101_020000_123456
private static java.time.LocalDateTime	ldt_19700101_120000_123456
private static java.time.LocalDateTime	ldt_20191231_0000
private static java.time.LocalDateTime	ldt_20200101_0000
private static java.time.LocalDateTime	ldt_20200101_120000_123456
private static java.time.LocalTime	lt_000000
private static java.time.LocalTime	lt_120000
private static java.time.LocalTime	lt_120000_123456
private static java.lang.String	s_000000
private static java.lang.String	s_000000_000000
private static java.lang.String	s_120000
private static java.lang.String	s_120000_123456
private static java.lang.String	s_1970
private static java.lang.String	s_19700101
private static java.lang.String	s_20191231
private static java.lang.String	s_2020
private static java.lang.String	s_20200101
(package private) java.util.TimeZone[]	senderTimeZones
private static java.lang.String	tDate
private static java.lang.String	tDatetime
private static java.time.format.DateTimeFormatter	TIME_FORMATTER_WITH_MICROS_NO_OFFCET
private static java.time.format.DateTimeFormatter	TIME_FORMATTER_WITH_MILLIS_NO_OFFCET
private static java.lang.String	tTime
private static java.lang.String	tTimestamp
private static java.lang.String	tVarchar
private static java.lang.String	tYear
private static java.util.TimeZone	tz_minus_10_00
private static java.util.TimeZone	tz_plus_02_00
private static java.util.TimeZone	tz_plus_05_00
private static java.util.TimeZone	tz_UTC
private java.util.Hashtable<java.lang.String,java.sql.Connection>	tzConnections
private java.util.Hashtable<java.lang.String,java.sql.Connection>	utcConnections
private static java.time.format.DateTimeFormatter	YEAR_FORMATTER

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
DateTimeTest()

Method Summary

Modifier and Type	Method and Description
(package private) void	assertThrows(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String err)
(package private) void	assertThrows(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedValue, java.lang.String expectedUnixTimestamp, DateTimeTest.UseMethod useMethod, java.util.Calendar calendar, java.lang.String err)
(package private) void	assertThrows(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedValue, java.lang.String expectedUnixTimestamp, DateTimeTest.UseMethod useMethod, java.lang.String err)
private void	checkSymmetricSetAndGet(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, DateTimeTest.UseMethod useSetter, java.util.Calendar calendar, DateTimeTest.UseMethod useGetter, java.lang.Class<?> targetClass, java.lang.Object expResult)
private void	closeConnections()
private java.lang.String	getKey(java.util.Properties props)
private void	initConnections(java.util.TimeZone senderTz, java.lang.String connectionTZ)
(package private) void	setObjectFromTz(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz)
(package private) void	setObjectFromTz(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedUTCValue)
(package private) void	setObjectFromTz(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedUTCValue, java.lang.String expectedUnixTimestamp)
(package private) void	setObjectFromTz(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedUTCValue, java.lang.String expectedUnixTimestamp, DateTimeTest.UseMethod useMethod)
(package private) void	setObjectFromTz(java.util.Properties props, java.lang.String tableName, java.lang.Object parameter, java.sql.SQLType targetSqlType, java.util.TimeZone senderTz, java.lang.String expectedUTCValue, java.lang.String expectedUnixTimestamp, DateTimeTest.UseMethod useMethod, java.util.Calendar calendar)
void	testDateGetters()
void	testDatetimeGetters()
void	testDurationSetters()
void	testLocalDateSetters()
void	testLocalDateTimeSetters()
void	testLocalTimeSetters()
void	testOffsetDatetimeSetters()
void	testOffsetTimeSetters()
void	testSqlDateSetters()
void	testSqlTimeSetters()
void	testSqlTimestampSetters()
void	testSymmetricInstantRetrieval()
void	testTimeGetters()
void	testTimestampGetters()
void	testUtilCalendarSetters()
void	testUtilDateSetters()
void	testYearGetters()
void	testZonedDatetimeSetters()

Methods inherited from class testsuite.BaseTestCase

appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object

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

Field Detail

tYear

private static java.lang.String tYear

tDate

private static java.lang.String tDate

tTime

private static java.lang.String tTime

tDatetime

private static java.lang.String tDatetime

tTimestamp

private static java.lang.String tTimestamp

tVarchar

private static java.lang.String tVarchar

tz_minus_10_00

private static java.util.TimeZone tz_minus_10_00

tz_plus_02_00

private static java.util.TimeZone tz_plus_02_00

tz_plus_05_00

private static java.util.TimeZone tz_plus_05_00

tz_UTC

private static java.util.TimeZone tz_UTC

senderTimeZones

java.util.TimeZone[] senderTimeZones

connectionTimeZones

java.lang.String[] connectionTimeZones

ld_19700101

private static java.time.LocalDate ld_19700101

ld_20191231

private static java.time.LocalDate ld_20191231

ld_20200101

private static java.time.LocalDate ld_20200101

lt_120000

private static java.time.LocalTime lt_120000

lt_120000_123456

private static java.time.LocalTime lt_120000_123456

lt_000000

private static java.time.LocalTime lt_000000

ldt_20191231_0000

private static java.time.LocalDateTime ldt_20191231_0000

ldt_20200101_0000

private static java.time.LocalDateTime ldt_20200101_0000

ldt_20200101_120000_123456

private static java.time.LocalDateTime ldt_20200101_120000_123456

ldt_19700101_0000

private static java.time.LocalDateTime ldt_19700101_0000

ldt_19700101_120000_123456

private static java.time.LocalDateTime ldt_19700101_120000_123456

ldt_19700101_020000_123000

private static java.time.LocalDateTime ldt_19700101_020000_123000

ldt_19700101_020000_123456

private static java.time.LocalDateTime ldt_19700101_020000_123456

s_2020

private static java.lang.String s_2020

s_20200101

private static java.lang.String s_20200101

s_20191231

private static java.lang.String s_20191231

s_1970

private static java.lang.String s_1970

s_19700101

private static java.lang.String s_19700101

s_120000

private static java.lang.String s_120000

s_120000_123456

private static java.lang.String s_120000_123456

s_000000

private static java.lang.String s_000000

s_000000_000000

private static java.lang.String s_000000_000000

dataTruncatedErr

private static java.lang.String dataTruncatedErr

incorrectDateErr

private static java.lang.String incorrectDateErr

incorrectTimeErr

private static java.lang.String incorrectTimeErr

incorrectDatetimeErr

private static java.lang.String incorrectDatetimeErr

YEAR_FORMATTER

private static java.time.format.DateTimeFormatter YEAR_FORMATTER

TIME_FORMATTER_WITH_MILLIS_NO_OFFCET

private static java.time.format.DateTimeFormatter TIME_FORMATTER_WITH_MILLIS_NO_OFFCET

TIME_FORMATTER_WITH_MICROS_NO_OFFCET

private static java.time.format.DateTimeFormatter TIME_FORMATTER_WITH_MICROS_NO_OFFCET

DATETIME_FORMATTER_WITH_MICROS_NO_OFFCET

private static java.time.format.DateTimeFormatter DATETIME_FORMATTER_WITH_MICROS_NO_OFFCET

tzConnections

private java.util.Hashtable<java.lang.String,java.sql.Connection> tzConnections

utcConnections

private java.util.Hashtable<java.lang.String,java.sql.Connection> utcConnections

id

private static int id

Constructor Detail

DateTimeTest

public DateTimeTest()

Method Detail

getKey

private java.lang.String getKey(java.util.Properties props)

initConnections

private void initConnections(java.util.TimeZone senderTz,
                             java.lang.String connectionTZ)
                      throws java.lang.Exception

Throws:

java.lang.Exception

closeConnections

private void closeConnections()
                       throws java.lang.Exception

Throws:

java.lang.Exception

testSqlDateSetters

@Test
public void testSqlDateSetters()
                              throws java.lang.Exception

Throws:

java.lang.Exception

testSqlTimeSetters

@Test
public void testSqlTimeSetters()
                              throws java.lang.Exception

Throws:

java.lang.Exception

testSqlTimestampSetters

@Test
public void testSqlTimestampSetters()
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testUtilCalendarSetters

@Test
public void testUtilCalendarSetters()
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testUtilDateSetters

@Test
public void testUtilDateSetters()
                               throws java.lang.Exception

Throws:

java.lang.Exception

testLocalDateSetters

@Test
public void testLocalDateSetters()
                                throws java.lang.Exception

Throws:

java.lang.Exception

testLocalTimeSetters

@Test
public void testLocalTimeSetters()
                                throws java.lang.Exception

Throws:

java.lang.Exception

testLocalDateTimeSetters

@Test
public void testLocalDateTimeSetters()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testOffsetTimeSetters

@Test
public void testOffsetTimeSetters()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testOffsetDatetimeSetters

@Test
public void testOffsetDatetimeSetters()
                                     throws java.lang.Exception

Throws:

java.lang.Exception

testZonedDatetimeSetters

@Test
public void testZonedDatetimeSetters()
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testDurationSetters

@Test
public void testDurationSetters()
                               throws java.lang.Exception

Throws:

java.lang.Exception

assertThrows

void assertThrows(java.util.Properties props,
                  java.lang.String tableName,
                  java.lang.Object parameter,
                  java.sql.SQLType targetSqlType,
                  java.util.TimeZone senderTz,
                  java.lang.String err)
           throws java.lang.Exception

Throws:

java.lang.Exception

assertThrows

void assertThrows(java.util.Properties props,
                  java.lang.String tableName,
                  java.lang.Object parameter,
                  java.sql.SQLType targetSqlType,
                  java.util.TimeZone senderTz,
                  java.lang.String expectedValue,
                  java.lang.String expectedUnixTimestamp,
                  DateTimeTest.UseMethod useMethod,
                  java.lang.String err)
           throws java.lang.Exception

Throws:

java.lang.Exception

assertThrows

void assertThrows(java.util.Properties props,
                  java.lang.String tableName,
                  java.lang.Object parameter,
                  java.sql.SQLType targetSqlType,
                  java.util.TimeZone senderTz,
                  java.lang.String expectedValue,
                  java.lang.String expectedUnixTimestamp,
                  DateTimeTest.UseMethod useMethod,
                  java.util.Calendar calendar,
                  java.lang.String err)
           throws java.lang.Exception

Throws:

java.lang.Exception

setObjectFromTz

void setObjectFromTz(java.util.Properties props,
                     java.lang.String tableName,
                     java.lang.Object parameter,
                     java.sql.SQLType targetSqlType,
                     java.util.TimeZone senderTz)
              throws java.lang.Exception

Throws:

java.lang.Exception

setObjectFromTz

void setObjectFromTz(java.util.Properties props,
                     java.lang.String tableName,
                     java.lang.Object parameter,
                     java.sql.SQLType targetSqlType,
                     java.util.TimeZone senderTz,
                     java.lang.String expectedUTCValue)
              throws java.lang.Exception

Throws:

java.lang.Exception

setObjectFromTz

void setObjectFromTz(java.util.Properties props,
                     java.lang.String tableName,
                     java.lang.Object parameter,
                     java.sql.SQLType targetSqlType,
                     java.util.TimeZone senderTz,
                     java.lang.String expectedUTCValue,
                     java.lang.String expectedUnixTimestamp)
              throws java.lang.Exception

Throws:

java.lang.Exception

setObjectFromTz

void setObjectFromTz(java.util.Properties props,
                     java.lang.String tableName,
                     java.lang.Object parameter,
                     java.sql.SQLType targetSqlType,
                     java.util.TimeZone senderTz,
                     java.lang.String expectedUTCValue,
                     java.lang.String expectedUnixTimestamp,
                     DateTimeTest.UseMethod useMethod)
              throws java.lang.Exception

Throws:

java.lang.Exception

setObjectFromTz

void setObjectFromTz(java.util.Properties props,
                     java.lang.String tableName,
                     java.lang.Object parameter,
                     java.sql.SQLType targetSqlType,
                     java.util.TimeZone senderTz,
                     java.lang.String expectedUTCValue,
                     java.lang.String expectedUnixTimestamp,
                     DateTimeTest.UseMethod useMethod,
                     java.util.Calendar calendar)
              throws java.lang.Exception

Throws:

java.lang.Exception

testDateGetters

@Test
public void testDateGetters()
                           throws java.lang.Exception

Throws:

java.lang.Exception

testTimeGetters

@Test
public void testTimeGetters()
                           throws java.lang.Exception

Throws:

java.lang.Exception

testTimestampGetters

@Test
public void testTimestampGetters()
                                throws java.lang.Exception

Throws:

java.lang.Exception

testDatetimeGetters

@Test
public void testDatetimeGetters()
                               throws java.lang.Exception

Throws:

java.lang.Exception

testYearGetters

@Test
public void testYearGetters()
                           throws java.lang.Exception

Throws:

java.lang.Exception

testSymmetricInstantRetrieval

@Test
public void testSymmetricInstantRetrieval()
                                         throws java.lang.Exception

Throws:

java.lang.Exception

checkSymmetricSetAndGet

private void checkSymmetricSetAndGet(java.util.Properties props,
                                     java.lang.String tableName,
                                     java.lang.Object parameter,
                                     java.sql.SQLType targetSqlType,
                                     java.util.TimeZone senderTz,
                                     DateTimeTest.UseMethod useSetter,
                                     java.util.Calendar calendar,
                                     DateTimeTest.UseMethod useGetter,
                                     java.lang.Class<?> targetClass,
                                     java.lang.Object expResult)
                              throws java.lang.Exception

Throws:

java.lang.Exception