Package com.totvs.tjf.repository.aggregate.statement

Interface AggregateStatement

All Known Implementing Classes:

AggregateStatementGeneric

public interface AggregateStatement

Implementation for the classes responsible to return the specific database prepared statements.

Author:

Rubens dos Santos Filho

Method Summary

Modifier and Type	Method	Description
String	getByIdSqlStatement()	Returns the prepared SQL statement to query a specific id.
String	getCountSqlStatement(String clause)	Returns the prepared SQL statement for an SELECT COUNT(*) command.
String	getDeleteSqlStatement()	Returns the prepared SQL statement for an DELETE command.
String	getExistsByIdSqlStatement()	Returns the prepared SQL statement to query the existance of a specific id.
String	getExistsSqlStatement(String clause)	Returns the prepared SQL statement to query the existance of one or more records.
default String	getFindSqlStatement(String clause, javax.persistence.LockModeType lockModeType, String orderby)	Returns the prepared SQL statement to query one or more records.
String	getFindSqlStatement(String clause, javax.persistence.LockModeType lockModeType, String orderby, Integer limit, Integer offset)	Returns the prepared SQL statement to query one or more records.
String	getInsertSqlStatement()	Returns the prepared SQL statement for an INSERT command.
String	getMetadataById()	Returns the prepared SQL statement to query the metadata field by a specific id.
String	getUpdateSqlStatement()	Returns the prepared SQL statement for an UPDATE command.

Method Detail

getInsertSqlStatement

String getInsertSqlStatement()

Returns the prepared SQL statement for an INSERT command.

Returns:

INSERT SQL statement.

getUpdateSqlStatement

String getUpdateSqlStatement()

Returns the prepared SQL statement for an UPDATE command.

Returns:

UPDATE SQL statement.

getDeleteSqlStatement

String getDeleteSqlStatement()

Returns the prepared SQL statement for an DELETE command.

Returns:

DELETE SQL statement.

getByIdSqlStatement

String getByIdSqlStatement()

Returns the prepared SQL statement to query a specific id.

Returns:

Query SQL statement.

getExistsByIdSqlStatement

String getExistsByIdSqlStatement()

Returns the prepared SQL statement to query the existance of a specific id.

Returns:

Query SQL statement.

getExistsSqlStatement

String getExistsSqlStatement(@Nullable
                             String clause)

Returns the prepared SQL statement to query the existance of one or more records.

Returns:

Query SQL statement.

getFindSqlStatement

String getFindSqlStatement(@Nullable
                           String clause,
                           @Nullable
                           javax.persistence.LockModeType lockModeType,
                           @Nullable
                           String orderby,
                           Integer limit,
                           Integer offset)
                    throws NotImplementedLockModeTypeException

Returns the prepared SQL statement to query one or more records.

Returns:

Query SQL statement.

Throws:

NotImplementedLockModeTypeException

getFindSqlStatement

default String getFindSqlStatement(@Nullable
                                   String clause,
                                   @Nullable
                                   javax.persistence.LockModeType lockModeType,
                                   @Nullable
                                   String orderby)
                            throws NotImplementedLockModeTypeException

Returns the prepared SQL statement to query one or more records.

Returns:

Query SQL statement.

Throws:

NotImplementedLockModeTypeException

getMetadataById

String getMetadataById()

Returns the prepared SQL statement to query the metadata field by a specific id.

Returns:

metadata query SQL statement.

getCountSqlStatement

String getCountSqlStatement(@Nullable
                            String clause)

Returns the prepared SQL statement for an SELECT COUNT(*) command.

Returns:

SELECT COUNT(*) SQL statement.