Module litebridge.db.spi.impl

Package org.litebridge.db.spi.impl.sql

Class UpdateSqlGenerator

java.lang.Object

org.litebridge.db.spi.impl.sql.AbstractSqlGenerator

org.litebridge.db.spi.impl.sql.UpdateSqlGenerator

public class UpdateSqlGenerator
extends AbstractSqlGenerator

SQL generator for UPDATE statements.

Field Summary

Fields inherited from class org.litebridge.db.spi.impl.sql.AbstractSqlGenerator

columnIdentifierGenerator, typeConverter

Constructor Summary

Constructors

Constructor	Description
UpdateSqlGenerator(TypeConverter typeConverter, ColumnIdentifierGenerator columnIdentifierGenerator, BiFunction<Table,ConnectionProvider,TableMetaData> ensureTableMetaData)	Creates a new UpdateSqlGenerator.

Method Summary

Modifier and Type	Method	Description
protected String	createMathOperation(ColumnMetaData column, MathOperation mathOperation)	Creates a SQL representation of a math operation.
PreparedSql	prepareSql(Update update, ConnectionProvider connectionProvider)	Prepare a SQL UPDATE statement along with its bind values for execution.

Methods inherited from class org.litebridge.db.spi.impl.sql.AbstractSqlGenerator

appendConditionsAndSubgroups, appendTable, appendTable, createBindValue, createCondition, ensureColumnMetaData, ensureTableMetaData, getExpressionValue, mapOperator

Methods inherited from class java.lang.Object

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

Constructor Details

UpdateSqlGenerator

public UpdateSqlGenerator(TypeConverter typeConverter,
 ColumnIdentifierGenerator columnIdentifierGenerator,
 BiFunction<Table,ConnectionProvider,TableMetaData> ensureTableMetaData)

Creates a new UpdateSqlGenerator.

Parameters:

typeConverter - the type converter

columnIdentifierGenerator - the column identifier generator

ensureTableMetaData - a function to ensure table metadata

Method Details

prepareSql

public PreparedSql prepareSql(Update update,
 ConnectionProvider connectionProvider)

Prepare a SQL UPDATE statement along with its bind values for execution.

This method constructs the SQL query string based on the provided Update object, which contains the table's metadata, column-value pairs, and conditions for the WHERE clause. It ensures proper formatting of the SQL query and converts values as needed using a type converter. The resulting SQL query and its associated bind values are encapsulated in a PreparedSql object.

Parameters:

update - the Update object containing table metadata, column-value pairs for the SET clause, and conditions for the WHERE clause to specify target rows.

connectionProvider - the connection provider

Returns:

a PreparedSql object containing the generated SQL query string and the list of bind values.

createMathOperation

protected String createMathOperation(ColumnMetaData column,
 MathOperation mathOperation)

Creates a SQL representation of a math operation.

Parameters:

column - the column

mathOperation - the math operation

Returns:

the SQL representation of the math operation