public List<History> fetchHistoryRecords() { this.open(); List<History> history = History.findAll().orderBy("ID desc").limit(FETCH_LIMIT); history.size(); this.close(); return history; }
public List<History> fetchHistoryRecordsByNode(String historyNode) { this.open(); List<History> history = History.where("CHANGE_SUMMARY like ?", historyNode).orderBy("ID desc").limit(FETCH_LIMIT); history.size(); this.close(); return history; }
public static <T extends Model> T findByCompositeKeys(Class<T> clazz, Object...values) { if (values == null || values.length == 0) { return null; } MetaModel metaModel = metaModelOf(clazz); String[] compositeKeys = metaModel.getCompositeKeys(); if (compositeKeys == null || compositeKeys.length != values.length){ return null; } StringBuilder sb = new StringBuilder(); for (int i = 0; i < compositeKeys.length; i++) { sb.append(i == 0 ? "" : " AND ").append(compositeKeys[i]) .append(" = ?"); } LazyList<T> list = new LazyList<T>(sb.toString(), metaModel, values).limit(1); return list.isEmpty() ? null : list.get(0); }
/** * This method will return a list of records for a specific page. * * @param pageNumber page number to return. This is indexed at 1, not 0. Any value below 1 is illegal and will * be rejected. * @return list of records that match a query make up a "page". */ public LazyList<T> getPage(int pageNumber) { if (pageNumber < 1) throw new IllegalArgumentException("minimum page index == 1"); try { LazyList<T> list = find(query, params).offset((pageNumber - 1) * pageSize).limit(pageSize); if (orderBys != null) { list.orderBy(orderBys); } currentPageIndex = pageNumber; return list; } catch (Exception mustNeverHappen) { throw new InternalException(mustNeverHappen); } }
public static <T extends Model> T findFirst(Class<T> clazz, String subQuery, Object... params) { LazyList<T> list = new LazyList<T>(subQuery, metaModelOf(clazz), params).limit(1); return list.isEmpty() ? null : list.get(0); }
public static <T extends Model> T findById(Class<T> clazz, Object id) { if (id == null) { return null; } MetaModel metaModel = metaModelOf(clazz); LazyList<T> list = new LazyList<T>(metaModel.getIdName() + " = ?", metaModel, id).limit(1); return list.isEmpty() ? null : list.get(0); }
public static <T extends Model> T findByCompositeKeys(Class<T> clazz, Object...values) { if (values == null || values.length == 0) { return null; } MetaModel metaModel = metaModelOf(clazz); String[] compositeKeys = metaModel.getCompositeKeys(); if (compositeKeys == null || compositeKeys.length != values.length){ return null; } StringBuilder sb = new StringBuilder(); for (int i = 0; i < compositeKeys.length; i++) { sb.append(i == 0 ? "" : " AND ").append(compositeKeys[i]) .append(" = ?"); } LazyList<T> list = new LazyList<T>(sb.toString(), metaModel, values).limit(1); return list.isEmpty() ? null : list.get(0); }
/** * This method will return a list of records for a specific page. * * @param pageNumber page number to return. This is indexed at 1, not 0. Any value below 1 is illegal and will * be rejected. * @return list of records that match a query make up a "page". */ public LazyList<T> getPage(int pageNumber) { if (pageNumber < 1) throw new IllegalArgumentException("minimum page index == 1"); try { LazyList<T> list = find(query, params).offset((pageNumber - 1) * pageSize).limit(pageSize); if (orderBys != null) { list.orderBy(orderBys); } currentPage = pageNumber; return list; } catch (Exception mustNeverHappen) { throw new InternalException(mustNeverHappen); } }
/** * This method will return a list of records for a specific page. * * @param pageNumber page number to return. This is indexed at 1, not 0. Any value below 1 is illegal and will * be rejected. * @return list of records that match a query make up a "page". */ public LazyList<T> getPage(int pageNumber) { if (pageNumber < 1) throw new IllegalArgumentException("minimum page index == 1"); try { LazyList<T> list = find(query, params).offset((pageNumber - 1) * pageSize).limit(pageSize); if (orderBys != null) { list.orderBy(orderBys); } currentPageIndex = pageNumber; return list; } catch (Exception mustNeverHappen) { throw new InternalException(mustNeverHappen); } }
public static <T extends Model> T findFirst(Class<T> clazz, String subQuery, Object... params) { LazyList<T> list = new LazyList<T>(subQuery, metaModelOf(clazz), params).limit(1); return list.isEmpty() ? null : list.get(0); }
public static <T extends Model> T findFirst(Class<T> clazz, String subQuery, Object... params) { LazyList<T> list = new LazyList<T>(subQuery, metaModelOf(clazz), params).limit(1); return list.isEmpty() ? null : list.get(0); }
public static <T extends Model> T findById(Class<T> clazz, Object id) { if (id == null) { return null; } MetaModel metaModel = metaModelOf(clazz); LazyList<T> list = new LazyList<T>(metaModel.getIdName() + " = ?", metaModel, id).limit(1); return list.isEmpty() ? null : list.get(0); }
public static <T extends Model> T findById(Class<T> clazz, Object id) { if (id == null) { return null; } MetaModel metaModel = metaModelOf(clazz); LazyList<T> list = new LazyList<T>(metaModel.getIdName() + " = ?", metaModel, id).limit(1); return list.isEmpty() ? null : list.get(0); }