Package io.github.torand.fastersql.dialect

Class HsqldbDialect

java.lang.Object

io.github.torand.fastersql.dialect.HsqldbDialect

All Implemented Interfaces:

Dialect

public class HsqldbDialect
extends Object
implements Dialect

Defines the HyperSQL (HSQLDB) SQL dialect.

Constructor Summary

Constructors

Constructor	Description
HsqldbDialect()	Creates a HyperSQL (HSQLDB) Dialect implementation.

Method Summary

Modifier and Type	Method	Description
String	formatLengthFunction(String operand)	Returns the 'length' function formatted for a specific SQL dialect.
Optional<String>	formatRowLimitClause()	Returns the row limit clause formatted for a specific SQL dialect.
Optional<String>	formatRowNumLiteral()	Returns the row number literal formatted for a specific SQL dialect.
Optional<String>	formatRowOffsetClause()	Returns the row offset clause formatted for a specific SQL dialect.
String	formatSubstringFunction(String operand, int startPos, int length)	Returns the 'substring' function formatted for a specific SQL dialect.
Optional<String>	getDataType(DataType dataType)	Returns the data type for a specific SQL dialect.
String	getProductName()	Gets the name of the RDBMS product associated with this SQL dialect.
boolean	offsetBeforeLimit()	Indicates whether offset clause must be specified before limit clause; if supported.
boolean	supports(Capability capability)	Indicates whether a capability is supported by a specific SQL dialect.

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.torand.fastersql.dialect.Dialect

formatCastFunction, formatCeilFunction, formatConcatFunction, formatCurrentDateFunction, formatLnFunction, formatModuloFunction, formatPowerFunction, formatRoundFunction, formatSetOperator, formatToCharFunction, formatToNumberFunction, getConcatOperator

Constructor Details

HsqldbDialect

public HsqldbDialect()

Creates a HyperSQL (HSQLDB) Dialect implementation.

Method Details

getProductName

public String getProductName()

Description copied from interface: Dialect

Gets the name of the RDBMS product associated with this SQL dialect.

Specified by:

getProductName in interface Dialect

Returns:

the name of the RDBMS product.

offsetBeforeLimit

public boolean offsetBeforeLimit()

Description copied from interface: Dialect

Indicates whether offset clause must be specified before limit clause; if supported.

Specified by:

offsetBeforeLimit in interface Dialect

Returns:

whether offset clause must be specified before limit clause; if supported.

formatRowOffsetClause

public Optional<String> formatRowOffsetClause()

Description copied from interface: Dialect

Returns the row offset clause formatted for a specific SQL dialect.

Specified by:

formatRowOffsetClause in interface Dialect

Returns:

the row offset clause formatted for a specific SQL dialect.

formatRowLimitClause

public Optional<String> formatRowLimitClause()

Description copied from interface: Dialect

Returns the row limit clause formatted for a specific SQL dialect.

Specified by:

formatRowLimitClause in interface Dialect

Returns:

the row limit clause formatted for a specific SQL dialect.

formatRowNumLiteral

public Optional<String> formatRowNumLiteral()

Description copied from interface: Dialect

Returns the row number literal formatted for a specific SQL dialect.

Specified by:

formatRowNumLiteral in interface Dialect

Returns:

the row number literal formatted for a specific SQL dialect.

formatSubstringFunction

public String formatSubstringFunction(String operand,
 int startPos,
 int length)

Description copied from interface: Dialect

Returns the 'substring' function formatted for a specific SQL dialect.

Specified by:

formatSubstringFunction in interface Dialect

Parameters:

operand - the string expression to get substring from

startPos - the start position (1-based) of the substring

length - the length of the substring

Returns:

the 'substring' function for a specific SQL dialect.

formatLengthFunction

public String formatLengthFunction(String operand)

Description copied from interface: Dialect

Returns the 'length' function formatted for a specific SQL dialect.

Specified by:

formatLengthFunction in interface Dialect

Parameters:

operand - the string expression to get length of

Returns:

the 'length' function for a specific SQL dialect.

getDataType

public Optional<String> getDataType(DataType dataType)

Description copied from interface: Dialect

Returns the data type for a specific SQL dialect.

Specified by:

getDataType in interface Dialect

Parameters:

dataType - the ISO data type

Returns:

the data type for a specific SQL dialect.

supports

public boolean supports(Capability capability)

Description copied from interface: Dialect

Indicates whether a capability is supported by a specific SQL dialect.

Specified by:

supports in interface Dialect

Parameters:

capability - the capability to check support for

Returns:

true if specified capability is supported; else false