Package io.debezium.pipeline.source.snapshot.incremental

Class RowValueConstructorChunkQueryBuilder<T extends DataCollectionId>

java.lang.Object

io.debezium.pipeline.source.snapshot.incremental.AbstractChunkQueryBuilder<T>

io.debezium.pipeline.source.snapshot.incremental.RowValueConstructorChunkQueryBuilder<T>

All Implemented Interfaces:

ChunkQueryBuilder<T>

public class RowValueConstructorChunkQueryBuilder<T extends DataCollectionId>
extends AbstractChunkQueryBuilder<T>

Builds queries for reading incremental snapshot chunks from a table using row value constructors.

On some database engines, these queries result in the most efficient query plans when a suitable index exists, but are only compatible with databases that support ROW() syntax.

Field Summary

Fields inherited from class io.debezium.pipeline.source.snapshot.incremental.AbstractChunkQueryBuilder

columnFilter, connectorConfig, jdbcConnection

Constructor Summary

Constructors

Constructor	Description
RowValueConstructorChunkQueryBuilder(RelationalDatabaseConnectorConfig config, JdbcConnection jdbcConnection)

Method Summary

Modifier and Type	Method	Description
protected void	addLowerBound(IncrementalSnapshotContext<T> context, Table table, Object[] boundaryKey, StringBuilder sql)
protected void	addUpperBound(IncrementalSnapshotContext<T> context, Table table, Object[] boundaryKey, StringBuilder sql)
private boolean	fallbackToSuper(List<Column> pkColumns)
PreparedStatement	readTableChunkStatement(IncrementalSnapshotContext<T> context, Table table, String sql)	Prepares a statement for reading the next incremental snapshot chunk from a table using the SQL statement returned by buildChunkQuery.
private void	rowValueComparison(List<Column> pkColumns, String operator, StringBuilder sql)

Methods inherited from class io.debezium.pipeline.source.snapshot.incremental.AbstractChunkQueryBuilder

buildChunkQuery, buildChunkQuery, buildMaxPrimaryKeyQuery, buildProjection, getQueryColumns

Methods inherited from class java.lang.Object

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

Constructor Details

RowValueConstructorChunkQueryBuilder

public RowValueConstructorChunkQueryBuilder(RelationalDatabaseConnectorConfig config,
 JdbcConnection jdbcConnection)

Method Details

fallbackToSuper

private boolean fallbackToSuper(List<Column> pkColumns)

rowValueComparison

private void rowValueComparison(List<Column> pkColumns,
 String operator,
 StringBuilder sql)

addLowerBound

protected void addLowerBound(IncrementalSnapshotContext<T> context,
 Table table,
 Object[] boundaryKey,
 StringBuilder sql)

Overrides:

addLowerBound in class AbstractChunkQueryBuilder<T extends DataCollectionId>

addUpperBound

protected void addUpperBound(IncrementalSnapshotContext<T> context,
 Table table,
 Object[] boundaryKey,
 StringBuilder sql)

Overrides:

addUpperBound in class AbstractChunkQueryBuilder<T extends DataCollectionId>

readTableChunkStatement

public PreparedStatement readTableChunkStatement(IncrementalSnapshotContext<T> context,
 Table table,
 String sql)
                                          throws SQLException

Description copied from interface: ChunkQueryBuilder

Prepares a statement for reading the next incremental snapshot chunk from a table using the SQL statement returned by buildChunkQuery.

Specified by:

readTableChunkStatement in interface ChunkQueryBuilder<T extends DataCollectionId>

Overrides:

readTableChunkStatement in class AbstractChunkQueryBuilder<T extends DataCollectionId>

Throws:

SQLException