com.omnisci.jdbc.OmniSciEscapeFunctions Class Reference

Collaboration diagram for com.omnisci.jdbc.OmniSciEscapeFunctions:

Static Public Member Functions
static Method	getFunction (String functionName)
static void	sqlceiling (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqldayofmonth (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqldayofweek (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqldayofyear (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlhour (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlminute (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlmonth (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlquarter (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlsecond (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlweek (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	sqlyear (StringBuilder buf, List<?extends CharSequence > parsedArgs) throws SQLException
static void	appendCall (StringBuilder sb, String begin, String separator, String end, List<?extends CharSequence > args)

Static Private Member Functions
static ConcurrentMap< String, Method >	createFunctionMap (String prefix)
static void	singleArgumentFunctionCall (StringBuilder buf, String call, String functionName, List<?extends CharSequence > parsedArgs)

Static Private Attributes
static final ConcurrentMap < String, Method >	FUNCTION_MAP

Detailed Description

Definition at line 10 of file OmniSciEscapeFunctions.java.

Member Function Documentation

static void com.omnisci.jdbc.OmniSciEscapeFunctions.appendCall ( StringBuilder  sb, String  begin, String  separator, String  end, List<?extends CharSequence >  args  )

inlinestatic

Appends

begin arg0 separator arg1 separator end 

sequence to the input StringBuilder

Parameters

sb	destination StringBuilder
begin	begin string
separator	separator string
end	end string
args	arguments

Definition at line 220 of file OmniSciEscapeFunctions.java.

References i.

Referenced by com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofweek().

                                             {
    int size = begin.length();
    // Typically just-in-time compiler would eliminate Iterator in case foreach is used,
    // however the code below uses indexed iteration to keep the conde independent from
    // various JIT implementations (== avoid Iterator allocations even for not-so-smart
    // JITs) see https://bugs.openjdk.java.net/browse/JDK-8166840 see
    // http://2016.jpoint.ru/talks/cheremin/ (video and slides)
    int numberOfArguments = args.size();
    for (int i = 0; i < numberOfArguments; i++) {
      size += args.get(i).length();
    }
    size += separator.length() * (numberOfArguments - 1);
    sb.ensureCapacity(sb.length() + size + 1);
    sb.append(begin);
    for (int i = 0; i < numberOfArguments; i++) {
      if (i > 0) {
        sb.append(separator);
      }
      sb.append(args.get(i));
    }
    sb.append(end);
  }

Here is the caller graph for this function:

static ConcurrentMap<String, Method> com.omnisci.jdbc.OmniSciEscapeFunctions.createFunctionMap ( String  prefix )

inlinestaticprivate

Definition at line 17 of file OmniSciEscapeFunctions.java.

                                                                                {
    Method[] methods = OmniSciEscapeFunctions.class.getMethods();
    ConcurrentMap<String, Method> functionMap =
            new ConcurrentHashMap<String, Method>(methods.length * 2);
    for (Method method : methods) {
      if (method.getName().startsWith(prefix)) {
        functionMap.put(
                method.getName().substring(prefix.length()).toLowerCase(Locale.US),
                method);
      }
    }
    return functionMap;
  }

static Method com.omnisci.jdbc.OmniSciEscapeFunctions.getFunction ( String  functionName )

inlinestatic

get Method object implementing the given function

Parameters

functionName

name of the searched function

Returns

a Method object or null if not found

Definition at line 37 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.FUNCTION_MAP.

                                                        {
    Method method = FUNCTION_MAP.get(functionName);
    if (method != null) {
      return method;
    }
    // FIXME: this probably should not use the US locale
    String nameLower = functionName.toLowerCase(Locale.US);
    if (nameLower.equals(functionName)) {
      // Input name was in lower case, the function is not there
      return null;
    }
    method = FUNCTION_MAP.get(nameLower);
    if (method != null && FUNCTION_MAP.size() < 1000) {
      // Avoid OutOfMemoryError in case input function names are randomized
      // The number of methods is finite, however the number of upper-lower case
      // combinations is quite a few (e.g. substr, Substr, sUbstr, SUbstr, etc).
      FUNCTION_MAP.putIfAbsent(functionName, method);
    }
    return method;
  }

static void com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall ( StringBuilder  buf, String  call, String  functionName, List<?extends CharSequence >  parsedArgs  )

inlinestaticprivate

Definition at line 197 of file OmniSciEscapeFunctions.java.

References File_Namespace.append().

Referenced by com.omnisci.jdbc.OmniSciEscapeFunctions.sqlceiling(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofmonth(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofyear(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlhour(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlminute(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlmonth(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlquarter(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlsecond(), com.omnisci.jdbc.OmniSciEscapeFunctions.sqlweek(), and com.omnisci.jdbc.OmniSciEscapeFunctions.sqlyear().

                                                   {
    if (parsedArgs.size() != 1) {
      throw new RuntimeException(
              "Syntax error " + functionName + " takes one and only one argument.");
    }
    CharSequence arg0 = parsedArgs.get(0);
    buf.ensureCapacity(buf.length() + call.length() + arg0.length() + 1);
    buf.append(call).append(arg0).append(')');
  }

Here is the call graph for this function:

Here is the caller graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlceiling ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

ceiling to ceil translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 67 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                                                                       {
    singleArgumentFunctionCall(buf, "ceil(", "ceiling", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofmonth ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

dayofmonth translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 79 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                                                                       {
    singleArgumentFunctionCall(buf, "extract(day from ", "dayofmonth", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofweek ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 92 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.appendCall().

                                                                       {
    if (parsedArgs.size() != 1) {
      throw new RuntimeException(
              "Syntax error function 'dayofweek' takes one and only one argument.");
    }
    appendCall(buf, "extract(dow from ", ",", ")+1", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqldayofyear ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

dayofyear translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 108 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                                                                       {
    singleArgumentFunctionCall(buf, "extract(doy from ", "dayofyear", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlhour ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

hour translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 120 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(hour from ", "hour", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlminute ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

minute translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 132 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(minute from ", "minute", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlmonth ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

month translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 144 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(month from ", "month", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlquarter ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

quarter translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 156 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                                                                       {
    singleArgumentFunctionCall(buf, "extract(quarter from ", "quarter", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlsecond ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

second translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 168 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(second from ", "second", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlweek ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

week translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 180 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(week from ", "week", parsedArgs);
  }

Here is the call graph for this function:

static void com.omnisci.jdbc.OmniSciEscapeFunctions.sqlyear ( StringBuilder  buf, List<?extends CharSequence >  parsedArgs  ) throws SQLException

inlinestatic

year translation

Parameters

buf	The buffer to append into
parsedArgs	arguments

Exceptions

SQLException

if something wrong happens

Definition at line 192 of file OmniSciEscapeFunctions.java.

References com.omnisci.jdbc.OmniSciEscapeFunctions.singleArgumentFunctionCall().

                              {
    singleArgumentFunctionCall(buf, "extract(year from ", "year", parsedArgs);
  }

Here is the call graph for this function:

Member Data Documentation

final ConcurrentMap<String, Method> com.omnisci.jdbc.OmniSciEscapeFunctions.FUNCTION_MAP

staticprivate

Initial value:

=
          createFunctionMap("sql")

storage for functions implementations

Definition at line 14 of file OmniSciEscapeFunctions.java.

Referenced by com.omnisci.jdbc.OmniSciEscapeFunctions.getFunction().

---

The documentation for this class was generated from the following file:

• /home/jenkins-slave/workspace/core-os-doxygen/java/omniscijdbc/src/main/java/com/omnisci/jdbc/OmniSciEscapeFunctions.java