Package io.debezium.connector.mysql.jdbc

Class MySqlValueConverters

java.lang.Object

io.debezium.jdbc.JdbcValueConverters

io.debezium.connector.binlog.jdbc.BinlogValueConverters

io.debezium.connector.mysql.jdbc.MySqlValueConverters

All Implemented Interfaces:

ValueConverterProvider

@Immutable
public class MySqlValueConverters
extends BinlogValueConverters

MySQL-specific customization of the conversions from JDBC values obtained from the MySQL binlog client library.

This class always uses UTC for the default time zone when converting values without timezone information to values that require timezones. This is because MySQL TIMESTAMP values are always stored in UTC (unlike DATETIME values) and are replicated in this form. Meanwhile, the MySQL Binlog Client library will deserialize these as Timestamp values that have no timezone and, therefore, are presumed to be in UTC. When the column is properly marked with a Types.TIMESTAMP_WITH_TIMEZONE type, the converters will need to convert that Timestamp value into an OffsetDateTime using the default time zone, which always is UTC.

Author:

Randall Hauch

Nested Class Summary

Nested classes/interfaces inherited from class io.debezium.jdbc.JdbcValueConverters

JdbcValueConverters.BigIntUnsignedMode, JdbcValueConverters.DecimalMode

Field Summary

Fields inherited from class io.debezium.jdbc.JdbcValueConverters

adaptiveTimeMicrosecondsPrecisionMode, adaptiveTimePrecisionMode, adjuster, bigIntUnsignedMode, binaryMode, decimalMode, defaultOffset, fallbackTimestampWithTimeZone, logger

Constructor Summary

Constructors

Constructor	Description
MySqlValueConverters(JdbcValueConverters.DecimalMode decimalMode, TemporalPrecisionMode temporalPrecisionMode, JdbcValueConverters.BigIntUnsignedMode bigIntUnsignedMode, CommonConnectorConfig.BinaryHandlingMode binaryMode, TemporalAdjuster adjuster, CommonConnectorConfig.EventConvertingFailureHandlingMode eventConvertingFailureHandlingMode, ServiceRegistry serviceRegistry)	Create a new instance that always uses UTC for the default time zone when converting values without timezone information to values that require timezones.

Method Summary

Modifier and Type	Method	Description
protected List<String>	extractEnumAndSetOptions(Column column)

Methods inherited from class io.debezium.connector.binlog.jdbc.BinlogValueConverters

adjustTemporal, byteOrderOfBitType, charsetFor, containsZeroValuesInDatePart, convertBigInt, convertBinary, convertDurationToMicroseconds, convertEnumToString, converter, convertFloat, convertGeometry, convertInteger, convertJson, convertPoint, convertSetToString, convertSetValue, convertSmallInt, convertString, convertTimestampToLocalDateTime, convertUnsignedBigint, convertUnsignedInt, convertUnsignedMediumint, convertUnsignedSmallint, convertUnsignedTinyint, convertYearToInt, extractEnumAndSetOptionsAsString, getJavaEncodingForCharSet, handleUnknownData, isGeometryCollection, matches, normalizeBinaryData, schemaBuilder, stringToDuration, stringToLocalDate

Methods inherited from class io.debezium.jdbc.JdbcValueConverters

convertBinaryToBase64, convertBinaryToBase64UrlSafe, convertBinaryToBytes, convertBinaryToHex, convertBit, convertBits, convertBits, convertBoolean, convertDateToEpochDays, convertDateToEpochDaysAsDate, convertDecimal, convertDouble, convertNumeric, convertReal, convertRowId, convertString, convertTime, convertTimestampToEpochMicros, convertTimestampToEpochMillis, convertTimestampToEpochMillisAsDate, convertTimestampToEpochNanos, convertTimestampWithZone, convertTimeToMicrosPastMidnight, convertTimeToMillisPastMidnight, convertTimeToMillisPastMidnightAsDate, convertTimeToNanosPastMidnight, convertTimeWithZone, convertTinyInt, convertValue, getTimePrecision, padLittleEndian, toBigDecimal, toByteBuffer, unexpectedBinary, withScaleAdjustedIfNeeded

Methods inherited from class java.lang.Object

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

Constructor Details

MySqlValueConverters

public MySqlValueConverters(JdbcValueConverters.DecimalMode decimalMode,
 TemporalPrecisionMode temporalPrecisionMode,
 JdbcValueConverters.BigIntUnsignedMode bigIntUnsignedMode,
 CommonConnectorConfig.BinaryHandlingMode binaryMode,
 TemporalAdjuster adjuster,
 CommonConnectorConfig.EventConvertingFailureHandlingMode eventConvertingFailureHandlingMode,
 ServiceRegistry serviceRegistry)

Create a new instance that always uses UTC for the default time zone when converting values without timezone information to values that require timezones.

Parameters:

decimalMode - how DECIMAL and NUMERIC values should be treated; may be null if JdbcValueConverters.DecimalMode.PRECISE is to be used

temporalPrecisionMode - temporal precision mode based on TemporalPrecisionMode

bigIntUnsignedMode - how BIGINT UNSIGNED values should be treated; may be null if JdbcValueConverters.BigIntUnsignedMode.PRECISE is to be used

binaryMode - how binary columns should be represented

adjuster - a temporal adjuster to make a database specific time modification before conversion

eventConvertingFailureHandlingMode - how handle when converting failure

serviceRegistry - the service registry, should not be null

Method Details

extractEnumAndSetOptions

protected List<String> extractEnumAndSetOptions(Column column)

Specified by:

extractEnumAndSetOptions in class BinlogValueConverters