Package io.github.torand.fastersql.dialect

Class SqliteDialect

java.lang.Object

io.github.torand.fastersql.dialect.SqliteDialect

All Implemented Interfaces:

Dialect

public class SqliteDialect
extends Object
implements Dialect

Defines the SQLite SQL dialect.

Constructor Summary

Constructors

Constructor	Description
SqliteDialect()	Creates a SQLite Dialect implementation.

Method Summary

Modifier and Type	Method	Description
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.
String	formatToCharFunction(String operand, String format)	Returns the 'to_char' function formatted for a specific SQL dialect.
String	formatToNumberFunction(String operand, int precision, int scale)	Returns the 'to_number' 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, formatLengthFunction, formatLnFunction, formatModuloFunction, formatPowerFunction, formatRoundFunction, formatSetOperator, getConcatOperator

Constructor Details

SqliteDialect

public SqliteDialect()

Creates a SQLite 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.

formatToNumberFunction

public String formatToNumberFunction(String operand,
 int precision,
 int scale)

Description copied from interface: Dialect

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

Specified by:

formatToNumberFunction in interface Dialect

Parameters:

operand - the string expression to be evaluated as a number

precision - the precision that represents the number of significant digits

scale - the scale that that represents the number of digits after the decimal point. Must be less than or equal to the precision.

Returns:

the 'to_number' function for a specific SQL dialect.

formatToCharFunction

public String formatToCharFunction(String operand,
 String format)

Description copied from interface: Dialect

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

Specified by:

formatToCharFunction in interface Dialect

Parameters:

operand - the expression to be evaluated as a string

format - the vendor-specific format mask

Returns:

the 'to_char' function 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.

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