org.turro.elephant.db.SQLHelper Class Reference

Static Public Member Functions
static String	convertToLike (String value)
static String	convertToPartialLike (String value)
static String	convertToIn (Collection collection)
static String	quoteTokensForIn (String inValue)
static WhereClause	getWhereClause (String[] fields, String value)
static WhereClause	getWhereClause (WhereClause wc, String[] fields, String value)
static WhereClause	getWhereClause (String[] fields, String value, String regexp)
static WhereClause	getWhereClause (WhereClause wc, String[] fields, String value, String regexp)
static WhereClause	getWhereClause (String[] fields, String[] values)
static WhereClause	getWhereClause (WhereClause wc, String[] fields, String[] values)
static WhereClause	getWhereClause (String[] fields, String[] values, boolean namedValues)
static WhereClause	getWhereClause (WhereClause wc, String[] fields, String[] values, boolean namedValues)

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 27 of file SQLHelper.java.

Member Function Documentation

convertToIn()

static String org.turro.elephant.db.SQLHelper.convertToIn ( Collection  collection )

static

Definition at line 43 of file SQLHelper.java.

                                                          {
    String result = null;
    for(Object o : collection) {
      if(o instanceof String) {
        result = (result == null) ? ("'" + o + "'") : (result + ",'" + o + "'");
      } else {
        result = (String) ((result == null) ? o + "" : (result + "," + o));
      }
    }
    return result;
  }

convertToLike()

static String org.turro.elephant.db.SQLHelper.convertToLike ( String  value )

static

Definition at line 33 of file SQLHelper.java.

                                                   {
    if(value == null) return null;
    return value.replaceAll("\\*", "%").replaceAll("\\?", "_");
  }

Here is the caller graph for this function:

convertToPartialLike()

static String org.turro.elephant.db.SQLHelper.convertToPartialLike ( String  value )

static

Definition at line 38 of file SQLHelper.java.

                                                          {
    if(value == null) return null;
    return "%" + value.replaceAll("\\*", "%").replaceAll("\\?", "_") + "%";
  }

Here is the caller graph for this function:

getWhereClause() [1/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( String[]  fields, String  value  )

static

Definition at line 64 of file SQLHelper.java.

                                                                          {
    return getWhereClause(null, fields, value);
  }

Here is the caller graph for this function:

getWhereClause() [2/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( String[]  fields, String  value, String  regexp  )

static

Definition at line 84 of file SQLHelper.java.

                                                                                         {
    return getWhereClause(null, fields, value, regexp);
  }

Here is the call graph for this function:

getWhereClause() [3/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( String[]  fields, String[]  values  )

static

Definition at line 99 of file SQLHelper.java.

                                                                             {
    return getWhereClause(fields, values, true);
  }

getWhereClause() [4/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( String[]  fields, String[]  values, boolean  namedValues  )

static

Definition at line 107 of file SQLHelper.java.

                                                                                                  {
    return getWhereClause(null, fields, values, namedValues);
  }

getWhereClause() [5/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( WhereClause  wc, String[]  fields, String  value  )

static

Definition at line 68 of file SQLHelper.java.

                                                                                          {
    if(wc == null) wc = new WhereClause();
    if(value != null) {
      if(value.startsWith("=")) {
        // value must be equal
        value = value.substring(1);
        return /*"%".equals(value) ? wc :*/ getWhereClause(wc, fields, value, null);
      } else if(value.startsWith("?")) {
        // where portion as is
        wc.addClause(value.substring(1));
        return wc;
      }
    }
    return /*"%".equals(value) ? wc :*/ getWhereClause(wc, fields, value, " ");
  }

Here is the call graph for this function:

getWhereClause() [6/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( WhereClause  wc, String[]  fields, String  value, String  regexp  )

static

Definition at line 88 of file SQLHelper.java.

                                                                                                         {
    if(value != null) {
      if(regexp != null) {
        return getWhereClause(wc, fields, value.split(regexp));
      } else {
        return getWhereClause(wc, fields, new String[] { value });
      }
    }
    return new WhereClause();
  }

Here is the call graph for this function:

getWhereClause() [7/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( WhereClause  wc, String[]  fields, String[]  values  )

static

Definition at line 103 of file SQLHelper.java.

                                                                                             {
    return getWhereClause(wc, fields, values, true);
  }

getWhereClause() [8/8]

static WhereClause org.turro.elephant.db.SQLHelper.getWhereClause ( WhereClause  wc, String[]  fields, String[]  values, boolean  namedValues  )

static

Definition at line 111 of file SQLHelper.java.

                                                                                                                  {
    if(wc == null) wc = new WhereClause();
    
    String result = "", partial, param;
    
    for(int f = 0; f < fields.length; f++) {
      partial = "";
      for(int v = 0; v < values.length; v++) {
        if(!Strings.isBlank(values[v])) {
          if(partial.length() > 0) {
            partial += " " + wc.getFieldOcurrence() + " ";
          }
          if(namedValues) {
            param = fields[f].replaceAll("\\.", "_") + wc.getUniqueSuffix();
            partial += "UCASE(" + fields[f] + ") like :" + param;
            if("%".equals(values[v])) {
              wc.addNamedValue(param, "%");
            } else {
              wc.addNamedValue(param, "%" + values[v].toUpperCase() + "%");
            }
          } else {
            partial += "UCASE(" + fields[f] + ") like ?";
            if("%".equals(values[v])) {
              wc.addValue("%");
            } else {
              wc.addValue("%" + values[v].toUpperCase() + "%");
            }
          }
        }
      }
 
      if(partial.length() > 0) {
        if(result.length() > 0) {
          result += " or ";
        }
        result += "(" + partial + ")";
      }
    }
    
    if(result.length() > 0) {
      result = wc.getPrefix() + " (" + result + ") ";
    }
    
    wc.addClause(result);
    
    return wc;
  }

quoteTokensForIn()

static String org.turro.elephant.db.SQLHelper.quoteTokensForIn ( String  inValue )

static

Definition at line 55 of file SQLHelper.java.

                                                        {
    String[] tokens = inValue.split(",");
    String result = null;
    for(String s : tokens) {
      result = (result == null) ? ("'" + s + "'") : (result + ",'" + s + "'");
    }
    return result;
  }

Here is the caller graph for this function:

---

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

• SQLHelper.java