Package org.firebirdsql.jdbc.escape
Class FBEscapedFunctionHelper
- java.lang.Object
-
- org.firebirdsql.jdbc.escape.FBEscapedFunctionHelper
-
public class FBEscapedFunctionHelper extends java.lang.ObjectHelper class for escaped functions.- Author:
- Roman Rokytskyy, Mark Rotteveel
-
-
Constructor Summary
Constructors Constructor Description FBEscapedFunctionHelper()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static java.lang.Stringabs(java.lang.String[] params)Produce a function call for theabsUDF function.static java.lang.Stringacos(java.lang.String[] params)Produce a function call for theacosUDF function.static java.lang.Stringasin(java.lang.String[] params)Produce a function call for theasinUDF function.static java.lang.Stringatan(java.lang.String[] params)Produce a function call for theatanUDF function.static java.lang.Stringatan2(java.lang.String[] params)Produce a function call for theatan2UDF function.static java.lang.Stringceiling(java.lang.String[] params)Produce a function call for theceilingUDF function.static java.lang.StringconvertTemplate(java.lang.String functionCall, FBEscapedParser.EscapeParserMode mode)Convert escaped function call using function template.static java.lang.Stringcos(java.lang.String[] params)Produce a function call for thecosUDF function.static java.lang.Stringcot(java.lang.String[] params)Produce a function call for thecotUDF function.static java.lang.Stringfloor(java.lang.String[] params)Produce a function call for thefloorUDF function.static java.util.Set<java.lang.String>getSupportedNumericFunctions()static java.util.Set<java.lang.String>getSupportedStringFunctions()static java.util.Set<java.lang.String>getSupportedSystemFunctions()static java.util.Set<java.lang.String>getSupportedTimeDateFunctions()static java.lang.Stringlog10(java.lang.String[] params)Produce a function call for thelog10UDF function.static java.lang.Stringmod(java.lang.String[] params)Produce a function call for themodUDF function.static java.util.List<java.lang.String>parseArguments(java.lang.String functionCall)Extract function arguments from the function call.static java.lang.StringparseFunction(java.lang.String functionCall)Extract function name from the function call.static java.lang.Stringpi(java.lang.String[] params)Produce a function call for thepiUDF function.static java.lang.Stringrand(java.lang.String[] params)Produce a function call for therandUDF function.static java.lang.Stringsign(java.lang.String[] params)Produce a function call for thesignUDF function.static java.lang.Stringsin(java.lang.String[] params)Produce a function call for thesinUDF function.static java.lang.Stringsqrt(java.lang.String[] params)Produce a function call for thesqrtUDF function.static java.lang.Stringtan(java.lang.String[] params)Produce a function call for thetan UDF function.
-
-
-
Method Detail
-
parseFunction
public static java.lang.String parseFunction(java.lang.String functionCall) throws FBSQLParseExceptionExtract function name from the function call.- Parameters:
functionCall- escaped function call.- Returns:
- name of the function.
- Throws:
FBSQLParseException- if parse error occurs.
-
parseArguments
public static java.util.List<java.lang.String> parseArguments(java.lang.String functionCall) throws FBSQLParseExceptionExtract function arguments from the function call. This method parses escaped function call string and extracts function parameters from it.- Parameters:
functionCall- escaped function call.- Returns:
- list of parameters of the function.
- Throws:
FBSQLParseException- if parse error occurs.
-
convertTemplate
public static java.lang.String convertTemplate(java.lang.String functionCall, FBEscapedParser.EscapeParserMode mode) throws FBSQLParseExceptionConvert escaped function call using function template.- Parameters:
functionCall- escaped function call.- Returns:
- server-side representation of the function call or
nullif no template found. - Throws:
FBSQLParseException- if escaped function call has incorrect syntax.
-
abs
public static java.lang.String abs(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theabsUDF function. The syntax of theabsfunction is{fn abs(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
acos
public static java.lang.String acos(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theacosUDF function. The syntax of theacosfunction is{fn acos(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
asin
public static java.lang.String asin(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theasinUDF function. The syntax of theasinfunction is{fn asin(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
atan
public static java.lang.String atan(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theatanUDF function. The syntax of theatanfunction is{fn atan(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
atan2
public static java.lang.String atan2(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theatan2UDF function. The syntax of theatan2function is{fn atan2(float1, float2)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
ceiling
public static java.lang.String ceiling(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for theceilingUDF function. The syntax of theceilingfunction is{fn ceiling(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
cos
public static java.lang.String cos(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thecosUDF function. The syntax of thecosfunction is{fn cos(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
cot
public static java.lang.String cot(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thecotUDF function. The syntax of thecotfunction is{fn cot(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
floor
public static java.lang.String floor(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thefloorUDF function. The syntax of thefloorfunction is{fn floor(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
log10
public static java.lang.String log10(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thelog10UDF function. The syntax of thelog10function is{fn log10(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
mod
public static java.lang.String mod(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for themodUDF function. The syntax of themodfunction is{fn mod(integer1, integer2)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
pi
public static java.lang.String pi(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thepiUDF function. The syntax of thepifunction is{fn pi()}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
rand
public static java.lang.String rand(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for therandUDF function. The syntax for therandfunction is{fn rand()}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
sign
public static java.lang.String sign(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thesignUDF function. The syntax for thesignfunction is{fn sign(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
sin
public static java.lang.String sin(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thesinUDF function. The syntax for thesinfunction is{fn sin(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
sqrt
public static java.lang.String sqrt(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thesqrtUDF function. The syntax for thesqrtfunction is{fn sqrt(number)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
tan
public static java.lang.String tan(java.lang.String[] params) throws FBSQLParseExceptionProduce a function call for thetan UDF function. The syntax for thetanfunction is{fn tan(float)}.- Parameters:
params- The parameters to be used in the call- Throws:
FBSQLParseException- if there is an error with the parameters
-
getSupportedNumericFunctions
public static java.util.Set<java.lang.String> getSupportedNumericFunctions()
- Returns:
- Set of JDBC numeric functions supported (as defined in appendix D.1 of JDBC 4.1)
-
getSupportedStringFunctions
public static java.util.Set<java.lang.String> getSupportedStringFunctions()
- Returns:
- Set of JDBC string functions supported (as defined in appendix D.2 of JDBC 4.1)
-
getSupportedTimeDateFunctions
public static java.util.Set<java.lang.String> getSupportedTimeDateFunctions()
- Returns:
- Set of JDBC time and date functions supported (as defined in appendix D.3 of JDBC 4.1)
-
getSupportedSystemFunctions
public static java.util.Set<java.lang.String> getSupportedSystemFunctions()
- Returns:
- Set of JDBC system functions supported (as defined in appendix D.4 of JDBC 4.1)
-
-