Package hendrey.orm

Examples of hendrey.orm.Query

51
52
53
54
55
56
57
58
59
60
61
  public Contact load(long id) {
    Connection con = null;
    try {
      con = dataSource.getConnection();
      Query q = dict.getQuery("byId");
      dbSess.setParameter("id", new Long(id));
      return (Contact) dbSess.executeQuery(con, q).populateNext(
          new Contact());
    } catch (SQLException ex) {
      throw new RuntimeException(ex);
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
    }
  }

  public Iterator<Contact> find(QueryParam qp, Contact filter) {
    System.out.println("looking for contacts like " + filter);
    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
153
154
155
156
157
158
159
160
161
162
163
    }
  }

  public int count(Contact filter) {
    dbSess.clear();
    Query q = dict.getQuery("byResemblance");
    ShadesORMDictionary.filterCandidate.resembles(filter, orm
        .getColumnSet("nonKeyFields"));
    Connection con = null;
    try {
      return dbSess.count(con = dataSource.getConnection(), q);
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
      }
    }
  }

  public List<String> getUniqueLastNames() {
    Query q = dict.getQuery("selectDistinctLastnameOnly");
    RecordSet rs;
    Connection con = null;
    try {
      rs = dbSess.executeQuery(con = dataSource.getConnection(), q);
      List<String> lastnames = new ArrayList<String>();
View Full Code Here
50
51
52
53
54
55
56
57
58
59
    defineQueryByResemblanceWithFilter(orm);
    defineQueryforDistinctLastname(orm);
  }

  private static void defineQueryforDistinctLastname(ORMapping orm) {
    Query q = QueryFactory
        .newImmutableQuery("SELECT DISTINCT LASTNAME AS \"CONTACT.LASTNAME\" FROM CONTACT");
    q.candidate(orm).setFetchColumns(new String[] { "LASTNAME" });
    dict.defineQuery("selectDistinctLastnameOnly", q);
  }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
    q.candidate(orm).setFetchColumns(new String[] { "LASTNAME" });
    dict.defineQuery("selectDistinctLastnameOnly", q);
  }

  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);
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
        "${order} ${direction} LIMIT ${count} OFFSET ${first}");
    dict.defineQuery("byOrderedResemblance", q);
  }

  private static void defineQueryByResemblance(ORMapping orm) {
    Query q = QueryFactory.newQuery(dict);
    q.candidate(orm, "CONTACT");
    dict.defineQuery("byResemblance", q);
  }
View Full Code Here
71
72
73
74
75
76
77
78
79
    q.candidate(orm, "CONTACT");
    dict.defineQuery("byResemblance", q);
  }

  private static void defineQueryById(ORMapping orm) {
    Query q = QueryFactory.newQuery(dict);
    q.candidate(orm).where("ID=${id}", new String[] {});
    dict.defineQuery("byId", q);
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
  {
    Connection con = null;
    try
    {
      con = dataSource.getConnection();
      Query q = dict.getQuery("byId");
      dbSess.setParameter("id", Long.valueOf(id));
      return (Contact)dbSess.executeQuery(con, q).populateNext(new Contact());
    }
    catch (SQLException ex)
    {
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
  }

  public Iterator<Contact> find(QueryParam qp, Contact filter)
  {
    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
TOP

Related Classes of hendrey.orm.Query

  • wicket.contrib.phonebook.ShadesContactDao
  • wicket.contrib.phonebook.ShadesORMDictionary
    • Copyright © 2018 www.massapicom. 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.