org.turro.elephant.db.WhereClause Class Reference

Public Member Functions
	WhereClause ()
	WhereClause (String prefix)
Map< String, Object >	getAttributes ()
void	addClause (String clause)
void	addClauseIfNotExists (String clause)
void	addInRange (String operator, String startField, String endField, String attribute, Date date)
void	addValue (Object value)
void	addNamedValue (String name, Object value)
void	addLikeFields (String[] fields, String value)
Map< String, Object >	getNamedValues ()
List< Object >	getNamedValues (String ... name)
int	getValueCount ()
Object	getValue (int index)
String	getClause ()
void	setClause (String clause)
void	setOrderByClause (String orderByClause)
void	setGroupByClause (String groupByClause)
boolean	isUseNative ()
void	setUseNative (boolean useNative)
Class	getResultClass ()
void	setResultClass (Class resultClass)
int	getUniqueSuffix ()
Object[]	getValues ()
void	setParameters (Query q, int start)
void	setNamedParameters (Query q)
String	getFieldOcurrence ()
void	setFieldOcurrence (String fieldOcurrence)
String	getPrefix ()
void	setPrefix (String prefix)
void	addNotIn (String operator, String field, List values)
void	addIn (String operator, String field, List values)
String	getUniqueVariable (String prefix)

Static Public Member Functions
static WhereClause	getFromClause (String clause)

Detailed Description

Author

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

Definition at line 32 of file WhereClause.java.

Constructor & Destructor Documentation

WhereClause() [1/2]

org.turro.elephant.db.WhereClause.WhereClause

(

)

Definition at line 45 of file WhereClause.java.

                       {
  }

Here is the caller graph for this function:

WhereClause() [2/2]

org.turro.elephant.db.WhereClause.WhereClause

(

String

prefix

)

Definition at line 48 of file WhereClause.java.

                                    {
    this.prefix = prefix;
  }

Member Function Documentation

addClause()

void org.turro.elephant.db.WhereClause.addClause

(

String

clause

)

Definition at line 56 of file WhereClause.java.

                                       {
    this.clause += " " + clause;
  }

addClauseIfNotExists()

void org.turro.elephant.db.WhereClause.addClauseIfNotExists

(

String

clause

)

Definition at line 60 of file WhereClause.java.

                                                  {
    if(this.clause == null || !this.clause.contains(clause)) {
      this.clause += " " + clause;
    }
  }

addIn()

void org.turro.elephant.db.WhereClause.addIn	(	String	operator,
		String	field,
		List	values
	)

Definition at line 204 of file WhereClause.java.

                                                                {
    if(values == null || values.isEmpty()) {
      addClause((operator != null ? operator + " 1=2" : "1=2"));
    } else {
      int listSize = values.size();
      if(listSize <= IN_LIMIT) {
        String var = getUniqueVariable("intids");
        addClause((operator != null ? operator + " " : "") + field + " in (:"+ var + ")");
        addNamedValue(var, values);
      } else {
        addClause((operator != null ? operator + " (" : "("));
        String sep = "";
        for (int i = 0; i < listSize; i += IN_LIMIT) {
          String var = getUniqueVariable("intids");
          List subList = (listSize > i + IN_LIMIT) ?
                          values.subList(i, (i + IN_LIMIT)) :
                          values.subList(i, listSize);
          addClause(sep + field + " in (:" + var + ")");
          addNamedValue(var, subList);
          sep = "or ";
        }
        addClause(")");
      }
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

addInRange()

void org.turro.elephant.db.WhereClause.addInRange	(	String	operator,
		String	startField,
		String	endField,
		String	attribute,
		Date	date
	)

Definition at line 66 of file WhereClause.java.

                                                                                                           {
    addClause(operator + "(");
    addClause("(" + startField + " is null or " + startField + " >= :" + attribute + ")");
    addClause("and (" + endField + " is null or " + endField + " <= :" + attribute + ")");
    addClause(")");
    addNamedValue(attribute, date);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

addLikeFields()

void org.turro.elephant.db.WhereClause.addLikeFields	(	String[]	fields,
		String	value
	)

Definition at line 82 of file WhereClause.java.

                                                           {
    if(value == null) return;
    if(value.startsWith("=") || value.startsWith("?")) {
      SQLHelper.getWhereClause(this, fields, value);
    } else if(value.startsWith("\"") && value.endsWith("\"")) {
      value = value.substring(1, value.length() - 1);
      SQLHelper.getWhereClause(this, fields,
              (value == null ? "" : value.replaceAll("\\*", "%").replaceAll("\\?", "_")), null);
    } else {
      SQLHelper.getWhereClause(this, fields,
              (value == null ? "" : value.replaceAll("\\*", "%").replaceAll("\\?", "_")), " +");
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

addNamedValue()

void org.turro.elephant.db.WhereClause.addNamedValue	(	String	name,
		Object	value
	)

Definition at line 78 of file WhereClause.java.

                                                       {
    namedValues.put(name, value);
  }

addNotIn()

void org.turro.elephant.db.WhereClause.addNotIn	(	String	operator,
		String	field,
		List	values
	)

Definition at line 200 of file WhereClause.java.

                                                                   {
    addIn(operator, field + " not", values);
  }

Here is the call graph for this function:

addValue()

void org.turro.elephant.db.WhereClause.addValue

(

Object

value

)

Definition at line 74 of file WhereClause.java.

                                     {
    values.add(value);
  }

getAttributes()

Map<String, Object> org.turro.elephant.db.WhereClause.getAttributes

(

)

Definition at line 52 of file WhereClause.java.

                                             {
    return attributes;
  }

Here is the caller graph for this function:

getClause()

String org.turro.elephant.db.WhereClause.getClause

(

)

Definition at line 116 of file WhereClause.java.

                            {
    if(!Strings.isBlank(clause)) {
      if(!Strings.isBlank(groupByClause) && clause.toLowerCase().contains("group by")) {
        clause += " " + groupByClause;
      }
      if(!Strings.isBlank(orderByClause) && clause.toLowerCase().contains("order by")) {
        clause += " " + orderByClause;
      }
    }
    if(clause.matches(".*\\{[^\\}]+\\}.*")) {
      clause = clause.replaceAll("\\{([^\\}]+)\\}", useNative ? "*" : "$1");
    }
    return clause;
  }

Here is the caller graph for this function:

getFieldOcurrence()

String org.turro.elephant.db.WhereClause.getFieldOcurrence

(

)

Definition at line 180 of file WhereClause.java.

                                    {
    return fieldOcurrence;
  }

getFromClause()

static WhereClause org.turro.elephant.db.WhereClause.getFromClause ( String  clause )

static

Definition at line 236 of file WhereClause.java.

                                                         {
    WhereClause wc = new WhereClause();
    wc.addClause(clause);
    return wc;
  }

Here is the call graph for this function:

getNamedValues() [1/2]

Map<String, Object> org.turro.elephant.db.WhereClause.getNamedValues

(

)

Definition at line 96 of file WhereClause.java.

                                              {
    return namedValues;
  }

getNamedValues() [2/2]

List<Object> org.turro.elephant.db.WhereClause.getNamedValues

(

String ...

name

)

Definition at line 100 of file WhereClause.java.

                                                      {
    ArrayList<Object> list = new ArrayList<>();
    for(String n : name) {
      if(namedValues.containsKey(n)) list.add(namedValues.get(n));
    } 
    return list;
  }

getPrefix()

String org.turro.elephant.db.WhereClause.getPrefix

(

)

Definition at line 189 of file WhereClause.java.

                            {
    return prefix;
  }

Here is the caller graph for this function:

getResultClass()

Class org.turro.elephant.db.WhereClause.getResultClass

(

)

Definition at line 151 of file WhereClause.java.

                                {
    return resultClass;
  }

Here is the caller graph for this function:

getUniqueSuffix()

int org.turro.elephant.db.WhereClause.getUniqueSuffix

(

)

Definition at line 159 of file WhereClause.java.

                               {
    return uniqueSuffix++;
  }

Here is the caller graph for this function:

getUniqueVariable()

String org.turro.elephant.db.WhereClause.getUniqueVariable

(

String

prefix

)

Definition at line 230 of file WhereClause.java.

                                                 {
    return prefix + "wcvar" + getUniqueSuffix();
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getValue()

Object org.turro.elephant.db.WhereClause.getValue

(

int

index

)

Definition at line 112 of file WhereClause.java.

                                    {
    return values.get(index);
  }

Here is the caller graph for this function:

getValueCount()

int org.turro.elephant.db.WhereClause.getValueCount

(

)

Definition at line 108 of file WhereClause.java.

                             {
    return values.size();
  }

Here is the caller graph for this function:

getValues()

Object [] org.turro.elephant.db.WhereClause.getValues

(

)

Definition at line 163 of file WhereClause.java.

                              {
    return values.toArray(new Object[0]);
  }

isUseNative()

boolean org.turro.elephant.db.WhereClause.isUseNative

(

)

Definition at line 143 of file WhereClause.java.

                               {
    return useNative;
  }

Here is the caller graph for this function:

setClause()

void org.turro.elephant.db.WhereClause.setClause

(

String

clause

)

Definition at line 131 of file WhereClause.java.

                                       {
    this.clause = clause;
  }

setFieldOcurrence()

void org.turro.elephant.db.WhereClause.setFieldOcurrence

(

String

fieldOcurrence

)

Definition at line 184 of file WhereClause.java.

                                                       {
    if(fieldOcurrence == null) fieldOcurrence = "and";
    this.fieldOcurrence = fieldOcurrence;
  }

setGroupByClause()

void org.turro.elephant.db.WhereClause.setGroupByClause

(

String

groupByClause

)

Definition at line 139 of file WhereClause.java.

                                                     {
    this.groupByClause = groupByClause;
  }

setNamedParameters()

void org.turro.elephant.db.WhereClause.setNamedParameters

(

Query

q

)

Definition at line 174 of file WhereClause.java.

                                          {
    for (Map.Entry<String, Object> e : namedValues.entrySet()) {
      q.setParameter(e.getKey(), e.getValue());
    }
  }

Here is the caller graph for this function:

setOrderByClause()

void org.turro.elephant.db.WhereClause.setOrderByClause

(

String

orderByClause

)

Definition at line 135 of file WhereClause.java.

                                                     {
    this.orderByClause = orderByClause;
  }

Here is the caller graph for this function:

setParameters()

void org.turro.elephant.db.WhereClause.setParameters	(	Query	q,
		int	start
	)

Definition at line 168 of file WhereClause.java.

                                                {
    for (int i = 0; i < getValueCount(); i++) {
      q.setParameter(i + start, getValue(i));
    }
  }

Here is the call graph for this function:

setPrefix()

void org.turro.elephant.db.WhereClause.setPrefix

(

String

prefix

)

Definition at line 193 of file WhereClause.java.

                                       {
    if(prefix == null) prefix = "and";
    this.prefix = prefix;
  }

Here is the caller graph for this function:

setResultClass()

void org.turro.elephant.db.WhereClause.setResultClass

(

Class

resultClass

)

Definition at line 155 of file WhereClause.java.

                                                {
    this.resultClass = resultClass;
  }

Here is the caller graph for this function:

setUseNative()

void org.turro.elephant.db.WhereClause.setUseNative

(

boolean

useNative

)

Definition at line 147 of file WhereClause.java.

                                              {
    this.useNative = useNative;
  }

Here is the caller graph for this function:

---

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

• WhereClause.java