Module litebridge.orm

Package org.litebridgedb.orm.persistence

Class TransactionalDatabaseProvider

java.lang.Object

org.litebridgedb.orm.persistence.TransactionalDatabaseProvider

All Implemented Interfaces:

DatabaseProvider

public final class TransactionalDatabaseProvider
extends Object
implements DatabaseProvider

Constructor Summary

Constructors

Constructor	Description
TransactionalDatabaseProvider(TransactionManager transactionManager, DatabaseProvider databaseProvider)

Method Summary

Modifier and Type	Method	Description
UpdateResult	delete(Delete delete, ConnectionProvider connectionProvider)	Execute a DELETE operation in the database using the provided Delete statement.
AliasTransformer	getAliasTransformer()
SequenceColumnValueGenerator	getSequenceColumnValueGenerator(String sequenceName)	Retrieves a SequenceColumnValueGenerator instance for generating SQL fragments that fetch the next value from a specified database sequence.
SqlFunctionRegistry	getSqlFunctionRegistry()	Retrieve the SqlFunctionRegistry instance associated with the database provider.
TypeConverter	getTypeConverter()	Retrieve the TypeConverter instance associated with the database provider.
InsertResult	insert(Insert insert, ConnectionProvider connectionProvider)	Execute an INSERT operation in the database using the provided Insert statement.
List<Row>	select(Select select, ConnectionProvider connectionProvider)	Execute a SELECT operation in the database using the provided Select statement.
TableMetaData	tableMetaData(Table table, ConnectionProvider connectionProvider)	Retrieve metadata for the specified table.
String	toSql(Operation operation, ConnectionProvider connectionProvider)	Converts the given Operation into its corresponding SQL representation.
TransactionManager	transactionManager()
UpdateResult	update(Update update, ConnectionProvider connectionProvider)	Execute an UPDATE operation in the database using the provided Update statement.

Methods inherited from class java.lang.Object

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

Constructor Details

TransactionalDatabaseProvider

public TransactionalDatabaseProvider(TransactionManager transactionManager,
 DatabaseProvider databaseProvider)

Method Details

transactionManager

public TransactionManager transactionManager()

tableMetaData

public TableMetaData tableMetaData(Table table,
 ConnectionProvider connectionProvider)
                            throws SQLException

Description copied from interface: DatabaseProvider

Retrieve metadata for the specified table.

Specified by:

tableMetaData in interface DatabaseProvider

Parameters:

table - the Table object representing the table for which metadata is to be retrieved.

connectionProvider - the ConnectionProvider used to get a database connection.

Returns:

a TableMetaData object containing metadata information about the specified table, including its columns, primary key, and other details.

Throws:

SQLException - if any SQL error occurs while retrieving the metadata.

insert

public InsertResult insert(Insert insert,
 ConnectionProvider connectionProvider)
                    throws SQLException

Description copied from interface: DatabaseProvider

Execute an INSERT operation in the database using the provided Insert statement.

Specified by:

insert in interface DatabaseProvider

Parameters:

insert - the Insert statement containing the table, columns, and rows to insert.

connectionProvider - the ConnectionProvider used to get a database connection.

Returns:

an InsertResult containing the number of rows affected and any generated keys.

Throws:

SQLException - if any SQL error occurs during the execution of the insert operation.

update

public UpdateResult update(Update update,
 ConnectionProvider connectionProvider)
                    throws SQLException

Description copied from interface: DatabaseProvider

Execute an UPDATE operation in the database using the provided Update statement.

Specified by:

update in interface DatabaseProvider

Parameters:

update - the Update statement containing the table, columns, and rows to update.

connectionProvider - the ConnectionProvider used to get a database connection.

Returns:

an UpdateResult containing the number of rows affected.

Throws:

SQLException - if any SQL error occurs during the execution of the update operation.

delete

public UpdateResult delete(Delete delete,
 ConnectionProvider connectionProvider)
                    throws SQLException

Description copied from interface: DatabaseProvider

Execute a DELETE operation in the database using the provided Delete statement.

Specified by:

delete in interface DatabaseProvider

Parameters:

delete - the Delete statement containing the table and rows to delete.

connectionProvider - the ConnectionProvider used to get a database connection.

Returns:

an UpdateResult containing the number of rows affected.

Throws:

SQLException - if any SQL error occurs during the execution of the delete operation.

select

public List<Row> select(Select select,
 ConnectionProvider connectionProvider)
                 throws SQLException

Description copied from interface: DatabaseProvider

Execute a SELECT operation in the database using the provided Select statement.

Specified by:

select in interface DatabaseProvider

Parameters:

select - the Select statement containing information about the table, expressions, joins, conditions, ordering, and optional limits for the query.

connectionProvider - the ConnectionProvider used to get a database connection.

Returns:

a List of Row objects representing the results of the SELECT operation.

Throws:

SQLException - if any SQL error occurs during the execution of the SELECT operation.

toSql

public String toSql(Operation operation,
 ConnectionProvider connectionProvider)

Description copied from interface: DatabaseProvider

Converts the given Operation into its corresponding SQL representation.

This does not execute the operation, it only generates the SQL string.

Specified by:

toSql in interface DatabaseProvider

Parameters:

operation - the Operation object representing the database operation (e.g., SELECT, INSERT, UPDATE, DELETE) to be converted to a SQL string.

connectionProvider - the ConnectionProvider used to obtain database-specific context or information required for SQL generation, such as metadata or dialect.

Returns:

a String containing the SQL representation of the given Operation.

getSequenceColumnValueGenerator

public SequenceColumnValueGenerator getSequenceColumnValueGenerator(String sequenceName)

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

Parameters:

sequenceName - 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.

getSqlFunctionRegistry

public SqlFunctionRegistry getSqlFunctionRegistry()

Description copied from interface: DatabaseProvider

Retrieve the SqlFunctionRegistry instance associated with the database provider.

The SqlFunctionRegistry is used for registering and managing SQL functions that can be used in SQL queries executed by the database provider.

Specified by:

getSqlFunctionRegistry in interface DatabaseProvider

Returns:

the SqlFunctionRegistry instance for managing SQL functions

getTypeConverter

public TypeConverter getTypeConverter()

Description copied from interface: DatabaseProvider

Retrieve the TypeConverter instance associated with the database provider.

The TypeConverter is used for converting objects between different types, typically for database data type conversions and mapping domain-specific representations.

Specified by:

getTypeConverter in interface DatabaseProvider

Returns:

the TypeConverter instance for handling data type conversions

getAliasTransformer

public AliasTransformer getAliasTransformer()

Specified by:

getAliasTransformer in interface DatabaseProvider