Package io.github.torand.fastersql.dialect

Class AccessDialect

java.lang.Object
io.github.torand.fastersql.dialect.AccessDialect
All Implemented Interfaces:
Dialect
public class AccessDialect extends Object implements Dialect
Defines the Microsoft Access SQL dialect.

  • Constructor Details

    • AccessDialect

      public AccessDialect()
      Creates a Microsoft Access 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.

    • 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.

    • formatConcatFunction

      public String formatConcatFunction(List<String> operands)
      Description copied from interface: Dialect
      Returns the 'concat' function formatted for a specific SQL dialect.
      Specified by:
      formatConcatFunction in interface Dialect
      Parameters:
      operands - the string expressions to concatenate
      Returns:
      the 'concat' 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.

    • formatPowerFunction

      public String formatPowerFunction(String base, String exponent)
      Description copied from interface: Dialect
      Returns the 'pow' function formatted for a specific SQL dialect.
      Specified by:
      formatPowerFunction in interface Dialect
      Parameters:
      base - the numeric expression for base operand
      exponent - the numeric expression for exponent operand
      Returns:
      the 'pow' function for a specific SQL dialect.

    • formatRoundFunction

      public String formatRoundFunction(String operand)
      Description copied from interface: Dialect
      Returns the 'round' function formatted for a specific SQL dialect.
      Specified by:
      formatRoundFunction in interface Dialect
      Parameters:
      operand - the numeric expression to perform rounding on
      Returns:
      the 'round' function for a specific SQL dialect.

    • formatCastFunction

      public String formatCastFunction(String operand, DataType targetType)
      Description copied from interface: Dialect
      Returns the 'cast' function formatted for a specific SQL dialect.
      Specified by:
      formatCastFunction in interface Dialect
      Parameters:
      operand - the expression to cast.
      targetType - the data type to cast to.
      Returns:
      the 'cast' function formatted 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.

    • getConcatOperator

      public Optional<String> getConcatOperator()
      Description copied from interface: Dialect
      Returns the string concatenation operator for a specific SQL Dialect.
      Specified by:
      getConcatOperator in interface Dialect
      Returns:
      the string concatenation operator 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