Package hendrey.orm

Examples of hendrey.orm.Query.clause()

118
119
120
121
122
123
124
125
126
127
128
    Query q = dict.getQuery("byOrderedResemblance");
    ShadesORMDictionary.filterCandidate.resembles(filter, orm
        .getColumnSet("nonKeyFields"));
    dbSess.setParameter("first", new Integer(qp.getFirst()));
    dbSess.setParameter("count", new Integer(qp.getCount()));
    q.clause("ORDER BY").enable(qp.hasSort());
    dbSess.setParameter("order", qp.getSort());
    if (qp.isSortAsc()) {
      dbSess.setParameter("direction", "ASC");
    } else {
      dbSess.setParameter("direction", "DESC");
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
  }

  private static void defineQueryByResemblanceWithFilter(ORMapping orm) {
    Query q = QueryFactory.newQuery(dict);
    filterCandidate = q.candidate(orm, "CONTACT");
    q.clause("ORDER BY").append(
        "${order} ${direction} LIMIT ${count} OFFSET ${first}");
    dict.defineQuery("byOrderedResemblance", q);
  }

  private static void defineQueryByResemblance(ORMapping orm) {
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    System.out.println("looking for contacts like " + filter);
    Query q = dict.getQuery("byOrderedResemblance");
    ShadesORMDictionary.filterCandidate.resembles(filter, orm.getColumnSet("nonKeyFields"));
    dbSess.setParameter("first", Long.valueOf(qp.getFirst()));
    dbSess.setParameter("count", Long.valueOf(qp.getCount()));
    q.clause("ORDER BY").enable(qp.hasSort());
    dbSess.setParameter("order", qp.getSort());
    if (qp.isSortAsc())
    {
      dbSess.setParameter("direction", "ASC");
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
  private static void defineQueryByResemblanceWithFilter(ORMapping orm)
  {
    Query q = QueryFactory.newQuery(dict);
    filterCandidate = q.candidate(orm, "CONTACT");
    q.clause("ORDER BY").append("${order} ${direction} LIMIT ${count} OFFSET ${first}");
    dict.defineQuery("byOrderedResemblance", q);
  }

  private static void defineQueryByResemblance(ORMapping orm)
  {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.