org.turro.sql.SQLUtil Class Reference

Static Public Member Functions
static void	applySearchToQuery (String search, WhereClause wc, List< String > fields)
static void	applySearchToQuery (String search, WhereClause wc, List< String > fields, boolean withSynonyms)
static void	applySearchToQuery (String search, WhereClause wc, List< String > fields, boolean withSynonyms, boolean orEd)
static void	applyFullsearchToQuery (String search, WhereClause wc, String fields)
static void	applyFullsearchToQuery (String search, WhereClause wc, String fields, boolean withSynonyms)
static void	applyFullsearchToQuery (String search, WhereClause wc, String fields, boolean withSynonyms, boolean orEd)

Static Public Attributes
static final int	MAX_SYNONIMS = 10

Detailed Description

Author

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

Definition at line 31 of file SQLUtil.java.

Member Function Documentation

applyFullsearchToQuery() [1/3]

static void org.turro.sql.SQLUtil.applyFullsearchToQuery ( String  search, WhereClause  wc, String  fields  )

static

Definition at line 69 of file SQLUtil.java.

                                                                                          {
    applyFullsearchToQuery(search, wc, fields, false, false);
  }

Here is the caller graph for this function:

applyFullsearchToQuery() [2/3]

static void org.turro.sql.SQLUtil.applyFullsearchToQuery ( String  search, WhereClause  wc, String  fields, boolean  withSynonyms  )

static

Definition at line 73 of file SQLUtil.java.

                                                                                                                {
    applyFullsearchToQuery(search, wc, fields, withSynonyms, false);
  }

Here is the call graph for this function:

applyFullsearchToQuery() [3/3]

static void org.turro.sql.SQLUtil.applyFullsearchToQuery ( String  search, WhereClause  wc, String  fields, boolean  withSynonyms, boolean  orEd  )

static

Definition at line 77 of file SQLUtil.java.

                                                                                                                              {
    if(withSynonyms) {
      List<Synonyms> synonyms = Synonyms.getSynonymsByWords(search);
      if(!synonyms.isEmpty() && synonyms.size() <= MAX_SYNONIMS) {
        for(Synonyms s : synonyms) {
          for(String w : s.getWords()) {
            if(!search.toLowerCase().contains(w.toLowerCase())) {
              search += " " + w;
            }
          }
        }
      }
    }
    wc.addClause(orEd ? "or (" : "and (");
    wc.addClause("match(" + fields + ") against (:fsearch01)");
    wc.setOrderByClause("match(" + fields + ") against (:fsearch01) desc");
    wc.addNamedValue("fsearch01", search);
    wc.addClause(")");
    wc.setUseNative(true);
  }

Here is the call graph for this function:

applySearchToQuery() [1/3]

static void org.turro.sql.SQLUtil.applySearchToQuery ( String  search, WhereClause  wc, List< String >  fields  )

static

Definition at line 36 of file SQLUtil.java.

                                                                                            {
    applySearchToQuery(search, wc, fields, false, false);
  }

Here is the caller graph for this function:

applySearchToQuery() [2/3]

static void org.turro.sql.SQLUtil.applySearchToQuery ( String  search, WhereClause  wc, List< String >  fields, boolean  withSynonyms  )

static

Definition at line 40 of file SQLUtil.java.

                                                                                                                  {
    applySearchToQuery(search, wc, fields, withSynonyms, false);
  }

Here is the call graph for this function:

applySearchToQuery() [3/3]

static void org.turro.sql.SQLUtil.applySearchToQuery ( String  search, WhereClause  wc, List< String >  fields, boolean  withSynonyms, boolean  orEd  )

static

Definition at line 44 of file SQLUtil.java.

                                                                                                                                {
    String sep = "";
    wc.addClause(orEd ? "or (" : "and (");
    for(String field : fields) {
      wc.addClause(sep + field + " like :search01");
      sep = "or ";
    }
    wc.addNamedValue("search01", SQLHelper.convertToPartialLike(search));
    if(withSynonyms) {
      List<Synonyms> synonyms = Synonyms.getSynonymsByWords(search);
      if(!synonyms.isEmpty() && synonyms.size() <= MAX_SYNONIMS) {
        for(Synonyms s : synonyms) {
          for(String field : fields) {
            for(String w : s.getWords()) {
              wc.addClause(sep + field + " like :w" + Strings.identifier(w));
              sep = "or ";
              wc.addNamedValue("w" + Strings.identifier(w), SQLHelper.convertToPartialLike(w));
            }
          }
        }
      }
    }
    wc.addClause(")");
  }

Here is the call graph for this function:

Member Data Documentation

MAX_SYNONIMS

final int org.turro.sql.SQLUtil.MAX_SYNONIMS = 10

static

Definition at line 34 of file SQLUtil.java.

---

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

• SQLUtil.java