com.github.drinkjava2.jdialects

Class FunctionUtils

java.lang.Object

com.github.drinkjava2.jdialects.FunctionUtils

public class FunctionUtils
extends Object

Guess Dialect Utils

Since:

1.0.2

Author:

Yong Zhu

Constructor Summary

Constructors

Constructor and Description
FunctionUtils()

Method Summary

Methods

Modifier and Type	Method and Description
protected static String	render(Dialect d, String functionName, Object... args) The render method translate function template to real SQL piece

Methods inherited from class java.lang.Object

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

Constructor Detail

FunctionUtils

public FunctionUtils()

Method Detail

render

protected static String render(Dialect d,
            String functionName,
            Object... args)

The render method translate function template to real SQL piece

 Template can be:
 "*": standard SQL function, identical to abc($Params)
 "abc($Params)": template with special parameter format:  
                                        "$P1, $P2, $P3, $P4, $P5, $P6..."="$Params"
                                        "$P1,$P2,$P3,$P4,$P5,$P6..."="$Compact_Params"
                                        "$P1||$P2||$P3||$P4||$P5||$P6..."="$Lined_Params"
                                        "$P1+$P2+$P3+$P4+$P5+$P6..."="$Add_Params");
                                        "$P1 in $P2 in $P3 in $P4 in $P5 in $P6..."="$IN_Params"
                                "$P1%pattern$P2%pattern$P3%pattern$P4%pattern$P5%pattern$P6..."="$Pattern_Params"
                                        "11%startswith$P2%startswith$P3%startswith$P4%startswith$P5%startswith$P6..."= "$Startswith_Params");
                                         "nvl($P1, nvl($P2, nvl($P3, nvl($P4, nvl($P5, $P6...)))))"="$NVL_Params");
 
 "0=abc()": function do not support parameter
 "1=abc($P1)": function only support 1 parameter
 "2=abc($P1,$P2)": function only support 2 parameters
 "0=abc()|1=abc($P1)|3=abc($P1,$P2,$P3)": function support 0 or 1 or 3 parameters
 
 

Parameters:

functionName - function name

args - function parameters

Returns:

A SQL function piece