Module litebridge.db.sqlite

Package org.litebridge.db.sqlite

Class SQLiteDatabaseProvider

java.lang.Object

org.litebridge.db.spi.impl.AbstractDatabaseProvider

org.litebridge.db.sqlite.SQLiteDatabaseProvider

All Implemented Interfaces:

DatabaseProvider

public final class SQLiteDatabaseProvider
extends AbstractDatabaseProvider

SQLite Database Provider for Litebridge.

This class provides SQLite-specific implementations for database interactions.

Field Summary

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

columnIdentifierGenerator, deleteSqlGenerator, insertSqlGenerator, selectSqlGenerator, typeConverter, updateSqlGenerator

Constructor Summary

Constructors

Constructor	Description
SQLiteDatabaseProvider()

Method Summary

Modifier and Type	Method	Description
protected PreparedStatement	createPreparedStatementUsingConnection(PreparedSql preparedSql, boolean returnGeneratedKeys, TableMetaData tableMetaData, ManagedConnection connection)	Creates a PreparedStatement using the provided connection and prepared SQL.
protected Map<ColumnMetaData,Object>	extractGeneratedKeys(TableMetaData tableMetaData, PreparedStatement preparedStatement)	Extract the generated primary key values from the provided prepared statement.
protected TableMetaData	fetchTableMetaData(Table table, ConnectionProvider connectionProvider)	Retrieve metadata for the specified table, including its primary keys and expressions.
protected List<ColumnMetaData>	getColumnMetaData(Table table, DatabaseMetaData databaseMetaData)	Retrieve column metadata for the specified table.
protected org.slf4j.Logger	getLogger()	Return the logger instance for this database provider.
SequenceColumnValueGenerator	getSequenceColumnValueGenerator(String sequence)	SQLite does not support sequences.

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

createAliasTransformer, createColumnIdentifierGenerator, createDeleteSqlGenerator, createInsertSqlGenerator, createSelectSqlGenerator, createSqlFunctionRegistryFactory, createUpdateSqlGenerator, delete, ensureTableMetaData, executeSqlInsert, executeSqlUpdate, getAliasTransformer, 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

SQLiteDatabaseProvider

public SQLiteDatabaseProvider()

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

extractGeneratedKeys

protected Map<ColumnMetaData,Object> extractGeneratedKeys(TableMetaData tableMetaData,
 PreparedStatement preparedStatement)
                                                   throws SQLException

Description copied from class: AbstractDatabaseProvider

Extract the generated primary key values from the provided prepared statement.

Overrides:

extractGeneratedKeys in class AbstractDatabaseProvider

Parameters:

tableMetaData - the TableMetaData object containing the metadata of the target table

preparedStatement - the executed PreparedStatement containing any generated keys

Returns:

a map of ColumnMetaData to the generated key value

Throws:

SQLException - if an error occurs while retrieving the generated keys

fetchTableMetaData

protected TableMetaData fetchTableMetaData(Table table,
 ConnectionProvider connectionProvider)
                                    throws SQLException

Description copied from class: AbstractDatabaseProvider

Retrieve metadata for the specified table, including its primary keys and expressions.

This executes a database query to fetch database metadata.

Overrides:

fetchTableMetaData in class AbstractDatabaseProvider

Parameters:

table - the table for which metadata is being fetched, containing schema, catalog, and table name details

connectionProvider - the ConnectionProvider used to obtain a database connection.

Returns:

a TableMetaData object containing details about the table's structure, primary keys, and column metadata

Throws:

SQLException - if an error occurs while fetching database metadata

getColumnMetaData

protected List<ColumnMetaData> getColumnMetaData(Table table,
 DatabaseMetaData databaseMetaData)
                                          throws SQLException

Description copied from class: AbstractDatabaseProvider

Retrieve column metadata for the specified table.

Overrides:

getColumnMetaData in class AbstractDatabaseProvider

Parameters:

table - the Table object representing the table

databaseMetaData - the DatabaseMetaData object used to retrieve column information

Returns:

a list of ColumnMetaData objects representing the table's columns

Throws:

SQLException - if an error occurs while retrieving column metadata

getSequenceColumnValueGenerator

public SequenceColumnValueGenerator getSequenceColumnValueGenerator(String sequence)
                                                             throws UnsupportedOperationException

SQLite does not support sequences. Throws an UnsupportedOperationException if called.

Specified by:

getSequenceColumnValueGenerator in interface DatabaseProvider

Overrides:

getSequenceColumnValueGenerator in class AbstractDatabaseProvider

Parameters:

sequence - the sequence name

Returns:

N/A; throws an UnsupportedOperationException

Throws:

UnsupportedOperationException - if called

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