Module litebridge.db.postgres

Package org.litebridge.db.postgres

Class PostgresDatabaseProvider

java.lang.Object

org.litebridge.db.spi.impl.AbstractDatabaseProvider

org.litebridge.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.litebridge.db.spi.impl.AbstractDatabaseProvider

columnIdentifierGenerator, deleteSqlGenerator, insertSqlGenerator, selectSqlGenerator, typeConverter, updateSqlGenerator

Constructor Summary

Constructors

Constructor	Description
PostgresDatabaseProvider()	Constructs a new PostgresDatabaseProvider using a default type converter.

Method Summary

Modifier and Type	Method	Description
protected AliasTransformer	createAliasTransformer()	Create an AliasTransformer instance for the database provider.
protected PreparedStatement	createPreparedStatementUsingConnection(PreparedSql preparedSql, boolean returnGeneratedKeys, TableMetaData tableMetaData, ManagedConnection connection)	Creates a PreparedStatement using the provided connection and prepared SQL.
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.litebridge.db.spi.impl.AbstractDatabaseProvider

createColumnIdentifierGenerator, createDeleteSqlGenerator, createInsertSqlGenerator, createSelectSqlGenerator, createSqlFunctionRegistryFactory, createUpdateSqlGenerator, delete, ensureTableMetaData, executeSqlInsert, executeSqlUpdate, extractGeneratedKeys, fetchTableMetaData, getAliasTransformer, getColumnMetaData, getGeneratedPrimaryKeyColumns, getPrimaryKeyColumnNames, getSqlFunctionRegistry, getTypeConverter, insert, nativeSqlQuery, nativeSqlUpdate, prepareNativeStatement, 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()

Constructs a new PostgresDatabaseProvider using a default type converter.

Method Details

createPreparedStatementUsingConnection

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

Description copied from class: AbstractDatabaseProvider

Creates a PreparedStatement using the provided connection and prepared SQL.

Overrides:

createPreparedStatementUsingConnection in class AbstractDatabaseProvider

Parameters:

preparedSql - the SQL and bind values to use

returnGeneratedKeys - whether to return generated keys

tableMetaData - the metadata for the table, required if returnGeneratedKeys is true

connection - the connection to use for preparing the statement

Returns:

the created prepared statement

Throws:

SQLException - if a database access error occurs

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()

Description copied from class: AbstractDatabaseProvider

Create an AliasTransformer instance for the database provider.

Overrides:

createAliasTransformer in class AbstractDatabaseProvider

Returns:

an AliasTransformer instance

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