public final class FunctionMethods extends Object
Modifier and Type | Field and Description |
---|---|
static String |
AT |
static String |
SPACE_CHAR |
Constructor and Description |
---|
FunctionMethods() |
Modifier and Type | Method and Description |
---|---|
static Object |
abs(BigDecimal x) |
static Object |
abs(BigInteger x) |
static double |
abs(double x) |
static float |
abs(float x) |
static int |
abs(int x) |
static long |
abs(long x) |
static Object |
acos(Number number) |
static BinaryType |
aes_decrypt(BinaryType dataBytes,
BinaryType keyBytes) |
static BinaryType |
aes_encrypt(BinaryType dataBytes,
BinaryType keyBytes) |
static Object |
array_get(Object array,
int index) |
static int |
array_length(Object array) |
static Integer |
ascii(Character ch) |
static Integer |
ascii(String ch) |
static Object |
asin(Number number) |
static Object |
atan(Number number) |
static Object |
atan2(Number number1,
Number number2) |
static Object |
bitand(int x,
int y) |
static int |
bitnot(int x) |
static Object |
bitor(int x,
int y) |
static Object |
bitxor(int x,
int y) |
static Object |
ceiling(Number x) |
static Object |
chr(int intValue) |
static Object |
coalesce(Object value,
Object value1,
Object... other) |
static Object |
commandPayload(CommandContext context) |
static Object |
commandPayload(CommandContext context,
String param) |
static ClobType |
concat(CommandContext context,
ClobType str1,
ClobType str2) |
static String |
concat(String str1,
String str2) |
static ClobType |
concat2(CommandContext context,
ClobType str1,
ClobType str2) |
static String |
concat2(String str1,
String str2) |
static Object |
convert(CommandContext context,
Object src,
String type) |
static Object |
cos(Number number) |
static Object |
cot(Number number) |
static Object |
current_database(CommandContext context) |
static Time |
current_time(CommandContext context,
int precision) |
static Timestamp |
current_timestamp(CommandContext context,
int precision) |
static Object |
currentDate(CommandContext context) |
static Object |
currentTime(CommandContext context) |
static Object |
currentTimestamp(CommandContext context) |
static Object |
dayName(Date x) |
static Object |
dayOfMonth(Date x) |
static int |
dayOfWeek(Date x) |
static Object |
dayOfYear(Date x) |
static Object |
degrees(Number number) |
static BinaryType |
digest(byte[] plainText,
String algorithm) |
static Object |
divide(BigDecimal x,
BigDecimal y) |
static Object |
divide(BigInteger x,
BigInteger y) |
static double |
divide(double x,
double y) |
static float |
divide(float x,
float y) |
static int |
divide(int x,
int y) |
static long |
divide(long x,
long y) |
static Object |
endsWith(String sub,
String str) |
static Object |
env_var(String propertyName) |
static Object |
env(String propertyName) |
static Object |
exp(Number x) |
static Object |
floor(Number x) |
static String |
format(CommandContext context,
Date date,
String format) |
static String |
format(CommandContext context,
Number number,
String format) |
static Timestamp |
from_millis(long millis) |
static String |
from_unixtime(long count) |
static Charset |
getCharset(String encoding) |
static Object |
hour(Date x) |
static Object |
ifnull(Object value,
Object ifNullValue) |
static Object |
initCap(String s) |
static Object |
insert(String string1,
Integer start,
Integer length,
String str2) |
static Object |
left(String string,
Integer count) |
static String |
leftTrim(String string) |
static String |
leftTrim(String string,
char trimChar) |
static Object |
length(String str) |
static Object |
locate(String sub,
String str) |
static Object |
locate(String sub,
String str,
Integer start)
TODO: The treatment of negative start indexes is inconsistent here.
|
static Object |
log(Number x) |
static Object |
log10(Number x) |
static Object |
lookup(Object codeTable,
Object returnElement,
Object keyElement,
Object keyValue)
This function should never actually be called - it is here solely so the
lookup function can be resolved properly.
|
static ClobType |
lowerCase(ClobType str) |
static Object |
lowerCase(String str) |
static Object |
lpad(String inputString,
Integer padLength) |
static Object |
lpad(String inputString,
Integer padLength,
String padStr) |
static BinaryType |
md5(BinaryType plainText) |
static BinaryType |
md5(String plainText) |
static Object |
minus(BigDecimal x,
BigDecimal y) |
static Object |
minus(BigInteger x,
BigInteger y) |
static double |
minus(double x,
double y) |
static float |
minus(float x,
float y) |
static int |
minus(int x,
int y) |
static long |
minus(long x,
long y) |
static Object |
minute(Date x) |
static Object |
mod(BigDecimal x,
BigDecimal y) |
static Object |
mod(BigInteger x,
BigInteger y) |
static double |
mod(double x,
double y) |
static float |
mod(float x,
float y) |
static int |
mod(int x,
int y) |
static long |
mod(long x,
long y) |
static Object |
modifyTimeZone(CommandContext context,
Timestamp value,
String targetTimezoneString) |
static Object |
modifyTimeZone(Timestamp value,
String originalTimezoneString,
String targetTimezoneString) |
static Object |
month(Date x) |
static Object |
monthName(Date x) |
static Object |
multiply(BigDecimal x,
BigDecimal y) |
static Object |
multiply(BigInteger x,
BigInteger y) |
static double |
multiply(double x,
double y) |
static float |
multiply(float x,
float y) |
static int |
multiply(int x,
int y) |
static long |
multiply(long x,
long y) |
static int |
mvstatus(CommandContext context,
String schemaName,
String viewName) |
static String |
node_id() |
static Object |
pad(String str,
Integer padLength,
String padStr,
boolean left) |
static BigDecimal |
parseBigDecimal(CommandContext context,
String number,
String format) |
static Object |
parseBigInteger(CommandContext context,
String number,
String format) |
static Object |
parseDouble(CommandContext context,
String number,
String format) |
static Object |
parseFloat(CommandContext context,
String number,
String format) |
static Object |
parseInteger(CommandContext context,
String number,
String format) |
static Object |
parseLong(CommandContext context,
String number,
String format) |
static Timestamp |
parseTimestamp(CommandContext context,
String timestamp,
String format) |
static Object |
pi() |
static Object |
plus(BigDecimal x,
BigDecimal y) |
static Object |
plus(BigInteger x,
BigInteger y) |
static double |
plus(double x,
double y) |
static float |
plus(float x,
float y) |
static int |
plus(int x,
int y) |
static long |
plus(long x,
long y) |
static BigDecimal |
power(BigDecimal x,
int y) |
static BigInteger |
power(BigInteger x,
int y) |
static double |
power(double x,
double y) |
static Object |
quarter(Date date) |
static Object |
radians(Number number) |
static Object |
rand(CommandContext context) |
static Object |
rand(CommandContext context,
Integer seed) |
static String |
regexpReplace(CommandContext context,
CharSequence source,
String regex,
String replacement,
String flags)
Perform find-replace operation on a string using regular expressions.
|
static ClobType |
regexpReplace(CommandContext context,
ClobType source,
String regex,
String replacement) |
static ClobType |
regexpReplace(CommandContext context,
ClobType source,
String regex,
String replacement,
String flags) |
static String |
regexpReplace(CommandContext context,
String source,
String regex,
String replacement)
Perform find-replace operation on a string using regular expressions.
|
static String |
regexpReplace(CommandContext context,
String source,
String regex,
String replacement,
String flags) |
static Object |
repeat(String str,
Integer count) |
static Object |
replace(String string,
String subString,
String replaceString) |
static Object |
right(String string,
Integer count) |
static Object |
rightTrim(String string) |
static String |
rightTrim(String string,
char trimChar) |
static String |
rightTrim(String string,
char trimChar,
boolean newString) |
static BigDecimal |
round(BigDecimal bigDecimalNumber,
int places) |
static double |
round(double number,
int places) |
static float |
round(float number,
int places) |
static int |
round(int number,
int places) |
static Object |
rpad(String inputString,
Integer padLength) |
static Object |
rpad(String inputString,
Integer padLength,
String padStr) |
static Object |
second(Date x) |
static Object |
session_id(CommandContext context) |
static BinaryType |
sha1(BinaryType plainText) |
static BinaryType |
sha1(String plainText) |
static BinaryType |
sha2_256(BinaryType plainText) |
static BinaryType |
sha2_256(String plainText) |
static BinaryType |
sha2_512(BinaryType plainText) |
static BinaryType |
sha2_512(String plainText) |
static Object |
sign(BigDecimal x) |
static Object |
sign(BigInteger x) |
static Object |
sign(double x) |
static Object |
sign(float x) |
static Object |
sign(int x) |
static Object |
sign(long x) |
static Object |
sin(Number number) |
static Object |
sqrt(Number x) |
static Object |
substring(String string,
Integer start) |
static Object |
substring(String string,
Integer startVal,
Integer lengthVal) |
static Object |
sys_prop(String propertyName) |
static Object |
tan(Number number) |
static Object |
timestampAdd(String intervalType,
Integer count,
Timestamp timestamp) |
static Object |
timestampCreate(Date date,
Time time)
This method truncates (ignores) figures
|
static Long |
timestampDiff(String intervalType,
Timestamp ts1Obj,
Timestamp ts2Obj) |
static Long |
timestampDiff(String intervalType,
Timestamp ts1Obj,
Timestamp ts2Obj,
boolean calendarBased) |
static Long |
to_millis(Timestamp date) |
static BlobType |
toBytes(ClobType value,
String encoding) |
static BlobType |
toBytes(ClobType value,
String encoding,
boolean wellFormed) |
static ClobType |
toChars(BlobType value,
String encoding) |
static ClobType |
toChars(BlobType value,
String encoding,
boolean wellFormed) |
static String[] |
tokenize(String str,
char delimiter) |
static Object |
translate(String str,
String in,
String out) |
static String |
trim(String trimSpec,
String trimChar,
String string) |
static String |
unescape(String string) |
static Long |
unix_timestamp(String date) |
static ClobType |
upperCase(ClobType str) |
static Object |
upperCase(String str) |
static Object |
user(CommandContext context) |
static Object |
user(CommandContext context,
boolean includeSecurityDomain) |
static String |
uuid() |
static int |
week(Date x) |
static Object |
year(Date x) |
public static final String AT
public static final String SPACE_CHAR
public static int plus(int x, int y) throws FunctionExecutionException
FunctionExecutionException
public static long plus(long x, long y) throws FunctionExecutionException
FunctionExecutionException
public static float plus(float x, float y)
public static double plus(double x, double y)
public static Object plus(BigInteger x, BigInteger y)
public static Object plus(BigDecimal x, BigDecimal y)
public static int minus(int x, int y) throws FunctionExecutionException
FunctionExecutionException
public static long minus(long x, long y) throws FunctionExecutionException
FunctionExecutionException
public static float minus(float x, float y)
public static double minus(double x, double y)
public static Object minus(BigInteger x, BigInteger y)
public static Object minus(BigDecimal x, BigDecimal y)
public static int multiply(int x, int y) throws FunctionExecutionException
FunctionExecutionException
public static long multiply(long x, long y) throws FunctionExecutionException
FunctionExecutionException
public static float multiply(float x, float y)
public static double multiply(double x, double y)
public static Object multiply(BigInteger x, BigInteger y)
public static Object multiply(BigDecimal x, BigDecimal y)
public static int divide(int x, int y) throws FunctionExecutionException
FunctionExecutionException
public static long divide(long x, long y) throws FunctionExecutionException
FunctionExecutionException
public static float divide(float x, float y)
public static double divide(double x, double y)
public static Object divide(BigInteger x, BigInteger y)
public static Object divide(BigDecimal x, BigDecimal y)
public static int abs(int x) throws FunctionExecutionException
FunctionExecutionException
public static long abs(long x) throws FunctionExecutionException
FunctionExecutionException
public static float abs(float x)
public static double abs(double x)
public static Object abs(BigInteger x)
public static Object abs(BigDecimal x)
public static Object rand(CommandContext context, Integer seed)
public static Object rand(CommandContext context)
public static int mod(int x, int y)
public static long mod(long x, long y)
public static float mod(float x, float y)
public static double mod(double x, double y)
public static Object mod(BigInteger x, BigInteger y)
public static Object mod(BigDecimal x, BigDecimal y)
public static double power(double x, double y)
public static BigInteger power(BigInteger x, int y)
public static BigDecimal power(BigDecimal x, int y)
public static int round(int number, int places)
public static float round(float number, int places)
public static double round(double number, int places)
public static BigDecimal round(BigDecimal bigDecimalNumber, int places)
public static Object sign(int x)
public static Object sign(long x)
public static Object sign(float x)
public static Object sign(double x)
public static Object sign(BigInteger x)
public static Object sign(BigDecimal x)
public static Object currentDate(CommandContext context)
public static Object currentTime(CommandContext context)
public static Object currentTimestamp(CommandContext context)
public static int dayOfWeek(Date x)
public static int week(Date x)
@TeiidFunction(category="Datetime", pushdown=CAN_PUSHDOWN) public static String from_unixtime(long count) throws FunctionExecutionException
FunctionExecutionException
@TeiidFunction(category="Datetime", nullOnNull=true, pushdown=CAN_PUSHDOWN) public static Long unix_timestamp(String date)
@TeiidFunction(category="Datetime", pushdown=CAN_PUSHDOWN) public static Timestamp from_millis(long millis)
@TeiidFunction(category="Datetime", nullOnNull=true, pushdown=CAN_PUSHDOWN) public static Long to_millis(Timestamp date)
public static Object timestampAdd(String intervalType, Integer count, Timestamp timestamp)
public static Long timestampDiff(String intervalType, Timestamp ts1Obj, Timestamp ts2Obj) throws FunctionExecutionException
FunctionExecutionException
public static Long timestampDiff(String intervalType, Timestamp ts1Obj, Timestamp ts2Obj, boolean calendarBased) throws FunctionExecutionException
FunctionExecutionException
public static Object timestampCreate(Date date, Time time)
interval
- timestamp1
- timestamp2
- FunctionExecutionException
public static ClobType concat(CommandContext context, ClobType str1, ClobType str2) throws IOException, SQLException
IOException
SQLException
public static ClobType concat2(CommandContext context, ClobType str1, ClobType str2) throws IOException, SQLException
IOException
SQLException
public static Object left(String string, Integer count) throws FunctionExecutionException
FunctionExecutionException
public static Object right(String string, Integer count) throws FunctionExecutionException
FunctionExecutionException
public static Object locate(String sub, String str, Integer start)
public static String trim(String trimSpec, String trimChar, String string) throws FunctionExecutionException
FunctionExecutionException
public static Object insert(String string1, Integer start, Integer length, String str2) throws FunctionExecutionException
FunctionExecutionException
public static Object chr(int intValue)
public static Object lpad(String inputString, Integer padLength, String padStr) throws FunctionExecutionException
FunctionExecutionException
public static Object pad(String str, Integer padLength, String padStr, boolean left) throws FunctionExecutionException
FunctionExecutionException
public static Object lpad(String inputString, Integer padLength) throws FunctionExecutionException
FunctionExecutionException
public static Object rpad(String inputString, Integer padLength, String padStr) throws FunctionExecutionException
FunctionExecutionException
public static Object rpad(String inputString, Integer padLength) throws FunctionExecutionException
FunctionExecutionException
public static Object translate(String str, String in, String out) throws FunctionExecutionException
FunctionExecutionException
public static Object convert(CommandContext context, Object src, String type) throws FunctionExecutionException
FunctionExecutionException
public static Object lookup(Object codeTable, Object returnElement, Object keyElement, Object keyValue)
codeTable
- returnElement
- keyElement
- keyValue
- public static String format(CommandContext context, Date date, String format) throws FunctionExecutionException
FunctionExecutionException
public static Timestamp parseTimestamp(CommandContext context, String timestamp, String format) throws FunctionExecutionException
FunctionExecutionException
public static String format(CommandContext context, Number number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object parseInteger(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object parseLong(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object parseDouble(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object parseFloat(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object parseBigInteger(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static BigDecimal parseBigDecimal(CommandContext context, String number, String format) throws FunctionExecutionException
FunctionExecutionException
public static Object pi()
public static Object bitand(int x, int y)
public static Object bitor(int x, int y)
public static Object bitxor(int x, int y)
public static int bitnot(int x)
public static Object user(CommandContext context)
public static Object user(CommandContext context, boolean includeSecurityDomain)
public static Object current_database(CommandContext context)
public static Object commandPayload(CommandContext context)
public static Object commandPayload(CommandContext context, String param) throws ExpressionEvaluationException, FunctionExecutionException
public static Object session_id(CommandContext context)
@TeiidFunction(category="Miscellaneous", pushdown=CANNOT_PUSHDOWN) public static String node_id()
public static Object modifyTimeZone(Timestamp value, String originalTimezoneString, String targetTimezoneString)
public static Object modifyTimeZone(CommandContext context, Timestamp value, String targetTimezoneString)
@TeiidFunction(category="Conversion", name="to_chars", nullOnNull=true) public static ClobType toChars(BlobType value, String encoding) throws SQLException, IOException
SQLException
IOException
@TeiidFunction(category="Conversion", name="to_chars") public static ClobType toChars(BlobType value, String encoding, boolean wellFormed) throws SQLException, IOException
SQLException
IOException
@TeiidFunction(category="Conversion", name="to_bytes", nullOnNull=true) public static BlobType toBytes(ClobType value, String encoding) throws IOException, SQLException
IOException
SQLException
@TeiidFunction(category="Conversion", name="to_bytes") public static BlobType toBytes(ClobType value, String encoding, boolean wellFormed) throws IOException, SQLException
IOException
SQLException
public static String uuid()
public static Object array_get(Object array, int index) throws FunctionExecutionException, SQLException
public static int array_length(Object array) throws FunctionExecutionException, SQLException
@TeiidFunction(category="System", determinism=COMMAND_DETERMINISTIC, pushdown=CANNOT_PUSHDOWN) public static int mvstatus(CommandContext context, String schemaName, String viewName) throws FunctionExecutionException, SQLException, QueryMetadataException, TeiidComponentException
@TeiidFunction(category="System") public static String[] tokenize(String str, char delimiter)
@TeiidFunction(name="regexp_replace", category="String", nullOnNull=true) public static String regexpReplace(CommandContext context, String source, String regex, String replacement) throws FunctionExecutionException
Pattern
for more information.context
- source
- Value to perform replacement on.regex
- Regular expression pattern.replacement
- Replacement string.FunctionExecutionException
- If regex pattern was invalid.@TeiidFunction(name="regexp_replace", category="String", nullOnNull=true) public static ClobType regexpReplace(CommandContext context, ClobType source, String regex, String replacement) throws FunctionExecutionException
FunctionExecutionException
@TeiidFunction(name="regexp_replace", category="String", nullOnNull=true) public static String regexpReplace(CommandContext context, String source, String regex, String replacement, String flags) throws FunctionExecutionException
FunctionExecutionException
@TeiidFunction(name="regexp_replace", category="String", nullOnNull=true) public static ClobType regexpReplace(CommandContext context, ClobType source, String regex, String replacement, String flags) throws FunctionExecutionException
FunctionExecutionException
public static String regexpReplace(CommandContext context, CharSequence source, String regex, String replacement, String flags) throws FunctionExecutionException
Pattern
for more information.
Flags can be used to modify the matching behavior of the regular expression.
context
- source
- Value to perform replacement on.regex
- Regular expression pattern.replacement
- Replacement string.flags
- Flags to modify behavior of the pattern.FunctionExecutionException
- If an invalid flag was supplied or if the
regex pattern was invalid.@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType md5(String plainText) throws NoSuchAlgorithmException, UnsupportedEncodingException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha1(String plainText) throws NoSuchAlgorithmException, UnsupportedEncodingException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha2_256(String plainText) throws NoSuchAlgorithmException, UnsupportedEncodingException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha2_512(String plainText) throws NoSuchAlgorithmException, UnsupportedEncodingException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType md5(BinaryType plainText) throws NoSuchAlgorithmException
NoSuchAlgorithmException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha1(BinaryType plainText) throws NoSuchAlgorithmException
NoSuchAlgorithmException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha2_256(BinaryType plainText) throws NoSuchAlgorithmException
NoSuchAlgorithmException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType sha2_512(BinaryType plainText) throws NoSuchAlgorithmException
NoSuchAlgorithmException
public static BinaryType digest(byte[] plainText, String algorithm) throws NoSuchAlgorithmException
NoSuchAlgorithmException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType aes_encrypt(BinaryType dataBytes, BinaryType keyBytes) throws FunctionExecutionException
FunctionExecutionException
@TeiidFunction(category="Security", nullOnNull=true) public static BinaryType aes_decrypt(BinaryType dataBytes, BinaryType keyBytes) throws FunctionExecutionException
FunctionExecutionException
@TeiidFunction(category="Datetime", pushdown=CAN_PUSHDOWN) public static Time current_time(CommandContext context, int precision)
@TeiidFunction(category="Datetime", pushdown=CAN_PUSHDOWN) public static Timestamp current_timestamp(CommandContext context, int precision)
Copyright © 2018 JBoss by Red Hat. All rights reserved.