Module litebridge.db.postgres

Package org.litebridgedb.db.postgres

Class PostgresDatabaseProvider

java.lang.Object

org.litebridgedb.db.spi.impl.AbstractDatabaseProvider

org.litebridgedb.db.postgres.PostgresDatabaseProvider

All Implemented Interfaces:

DatabaseProvider

public final class PostgresDatabaseProvider
extends AbstractDatabaseProvider

PostgresqlDatabaseProvider is a concrete implementation of AbstractDatabaseProvider specifically designed to interact with PostgreSQL database instances.

Field Summary

Fields inherited from class org.litebridgedb.db.spi.impl.AbstractDatabaseProvider

columnIdentifierGenerator, deleteSqlGenerator, insertSqlGenerator, selectSqlGenerator, typeConverter, updateSqlGenerator

Constructor Summary

Constructors

Constructor	Description
PostgresDatabaseProvider()

Method Summary

Modifier and Type	Method	Description
protected AliasTransformer	createAliasTransformer()
protected PreparedStatement	createPreparedStatementUsingConnection(PreparedSql preparedSql, boolean returnGeneratedKeys, TableMetaData tableMetaData, ManagedConnection connection)
protected org.slf4j.Logger	getLogger()	Return the logger instance for this database provider.
SequenceColumnValueGenerator	getSequenceColumnValueGenerator(String sequence)	Retrieves a SequenceColumnValueGenerator instance for generating SQL fragments that fetch the next value from a specified database sequence.

Methods inherited from class org.litebridgedb.db.spi.impl.AbstractDatabaseProvider

createColumnIdentifierGenerator, createDeleteSqlGenerator, createInsertSqlGenerator, createSelectSqlGenerator, createSqlFunctionRegistryFactory, createUpdateSqlGenerator, delete, ensureTableMetaData, executeSqlInsert, executeSqlUpdate, extractGeneratedKeys, fetchTableMetaData, getAliasTransformer, getColumnMetaData, getGeneratedPrimaryKeyColumns, getPrimaryKeyColumnNames, getSqlFunctionRegistry, getTypeConverter, insert, prepareStatement, select, tableMetaData, toSql, update, verifySchemaAndTableExists

Methods inherited from class java.lang.Object

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

Constructor Details

PostgresDatabaseProvider

public PostgresDatabaseProvider()

Method Details

createPreparedStatementUsingConnection

protected PreparedStatement createPreparedStatementUsingConnection(PreparedSql preparedSql,
 boolean returnGeneratedKeys,
 TableMetaData tableMetaData,
 ManagedConnection connection)
                                                            throws SQLException

Overrides:

createPreparedStatementUsingConnection in class AbstractDatabaseProvider

Throws:

SQLException

getSequenceColumnValueGenerator

public SequenceColumnValueGenerator getSequenceColumnValueGenerator(String sequence)
                                                             throws UnsupportedOperationException

Description copied from interface: DatabaseProvider

Retrieves a SequenceColumnValueGenerator instance for generating SQL fragments that fetch the next value from a specified database sequence. This is typically used in SQL statements such as INSERT or UPDATE to generate unique values from a sequence.

Specified by:

getSequenceColumnValueGenerator in interface DatabaseProvider

Overrides:

getSequenceColumnValueGenerator in class AbstractDatabaseProvider

Parameters:

sequence - the name of the database sequence from which the values will be generated. It is used to create the SQL fragment to retrieve the next value in the sequence.

Returns:

a SequenceColumnValueGenerator instance that generates SQL fragments for retrieving sequence values.

Throws:

UnsupportedOperationException - if the database provider does not support sequence-based value generation.

createAliasTransformer

protected AliasTransformer createAliasTransformer()

Overrides:

createAliasTransformer in class AbstractDatabaseProvider

getLogger

protected org.slf4j.Logger getLogger()

Description copied from class: AbstractDatabaseProvider

Return the logger instance for this database provider.

Overrides:

getLogger in class AbstractDatabaseProvider

Returns:

the logger instance