org.pentaho.di.core.jdbc

Class ThinUtil

java.lang.Object

org.pentaho.di.core.jdbc.ThinUtil

public class ThinUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
ThinUtil()

Method Summary

Methods

Modifier and Type	Method and Description
static ValueMetaAndData	attemptBigNumberValueExtraction(String string)
static ValueMetaAndData	attemptBooleanValueExtraction(String string)
static ValueMetaAndData	attemptDateValueExtraction(String string)
static ValueMetaAndData	attemptIntegerValueExtraction(String string)
static ValueMetaAndData	attemptNumberValueExtraction(String string)
static ValueMetaAndData	attemptStringValueExtraction(String string)
static ValueMetaAndData	extractConstant(String string)
static String	findClause(String sqlString, String startClause, String... endClauses)
static FoundClause	findClauseWithRest(String sqlString, String startClause, String... endClauses)
static int	findNext(String sql, char nextChar, int index)
static int	findNext(String sql, char nextChar, int index, boolean escape)
static int	findNextBracket(String sql, char skipChar, char nextChar, int index)
static int	findNextBracket(String sql, char skipChar, char nextChar, int index, boolean escape)
static int	getSqlType(ValueMetaInterface valueMeta)
static String	getSqlTypeDesc(ValueMetaInterface valueMeta)
static ValueMetaInterface	getValueMeta(String valueName, int sqlType)
static Pattern	like(String pattern)
static boolean	like(String subject, String pattern)
static int	skipChars(String sql, int index, char... skipChars)
static List<String>	splitClause(String fieldClause, char splitChar, char... skipChars)
static String	stripNewlines(String sql)
static String	stripQuotes(String string, char... quoteChars)
static String	stripQuoteTableAlias(String field, String tableAliasPrefix)
static String	stripTableAlias(String field, String tableAliasPrefix)

Methods inherited from class java.lang.Object

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

Constructor Detail

ThinUtil

public ThinUtil()

Method Detail

stripNewlines

public static String stripNewlines(String sql)

getSqlType

public static int getSqlType(ValueMetaInterface valueMeta)

getSqlTypeDesc

public static String getSqlTypeDesc(ValueMetaInterface valueMeta)

getValueMeta

public static ValueMetaInterface getValueMeta(String valueName,
                              int sqlType)
                                       throws SQLException

Throws:

SQLException

attemptDateValueExtraction

public static ValueMetaAndData attemptDateValueExtraction(String string)

attemptIntegerValueExtraction

public static ValueMetaAndData attemptIntegerValueExtraction(String string)

attemptNumberValueExtraction

public static ValueMetaAndData attemptNumberValueExtraction(String string)

attemptBigNumberValueExtraction

public static ValueMetaAndData attemptBigNumberValueExtraction(String string)

attemptStringValueExtraction

public static ValueMetaAndData attemptStringValueExtraction(String string)

attemptBooleanValueExtraction

public static ValueMetaAndData attemptBooleanValueExtraction(String string)

extractConstant

public static ValueMetaAndData extractConstant(String string)

stripQuoteTableAlias

public static String stripQuoteTableAlias(String field,
                          String tableAliasPrefix)

stripTableAlias

public static String stripTableAlias(String field,
                     String tableAliasPrefix)

skipChars

public static int skipChars(String sql,
            int index,
            char... skipChars)
                     throws KettleSQLException

Throws:

KettleSQLException

findNext

public static int findNext(String sql,
           char nextChar,
           int index)
                    throws KettleSQLException

Throws:

KettleSQLException

findNext

public static int findNext(String sql,
           char nextChar,
           int index,
           boolean escape)
                    throws KettleSQLException

Throws:

KettleSQLException

findNextBracket

public static int findNextBracket(String sql,
                  char skipChar,
                  char nextChar,
                  int index)
                           throws KettleSQLException

Throws:

KettleSQLException

findNextBracket

public static int findNextBracket(String sql,
                  char skipChar,
                  char nextChar,
                  int index,
                  boolean escape)
                           throws KettleSQLException

Throws:

KettleSQLException

stripQuotes

public static String stripQuotes(String string,
                 char... quoteChars)

splitClause

public static List<String> splitClause(String fieldClause,
                       char splitChar,
                       char... skipChars)
                                throws KettleSQLException

Throws:

KettleSQLException

findClause

public static String findClause(String sqlString,
                String startClause,
                String... endClauses)
                         throws KettleSQLException

Throws:

KettleSQLException

findClauseWithRest

public static FoundClause findClauseWithRest(String sqlString,
                             String startClause,
                             String... endClauses)
                                      throws KettleSQLException

Throws:

KettleSQLException

like

public static boolean like(String subject,
           String pattern)

like

public static Pattern like(String pattern)