Best Java code snippets using com.avaje.ebean.Query (Showing top 20 results out of 315)

@Override
public List<T> findList() {
 return query.findList();
}

 Query q = Search.search("object:dogs", Folder.class);
q.orderBy("object")
  .page(2,5)
  .reverse();

@Override
public EbeanQuery<MODEL_TYPE> fetch(String path) {
  q.fetch(path);
  qReadOnly.fetch(path);
  return this;
}

@Override
public MODEL_TYPE first() {
  List<MODEL_TYPE> list = qReadOnly.setMaxRows(1).findList();
  return list.isEmpty() ? null : list.get(0);
}

/**
 * Return a list of expressions that will be joined by OR's.
 */
public <T> Junction<T> disjunction(Query<T> query) {
 return new JunctionExpression<>(Junction.Type.OR, query, query.where());
}

private void syncEbeanQueries() {
  _sync("detail");
  q.orderBy();
  _sync("orderBy");
  q.text();
  _sync("textExpressions");
  q.where();
  _sync("whereExpressions");
  q.having();
  _sync("havingExpressions");
}

@Override
public List<T> getAll(int start, int count) throws PragmatachException {
 return this.find().setFirstRow(start).setMaxRows(count).findList();
}

public List<SensorData> getLogs() {
  return Ebean.find(SensorData.class).where().eq("uuid", this.uuid).order().desc("logdate").findList();
}

private List<Object> findIdsByParentId(Object parentId, Transaction t, ArrayList<Object> excludeDetailIds) {
  
  String rawWhere = deriveWhereParentIdSql(false);
  
  EbeanServer server = getBeanDescriptor().getEbeanServer();
  Query<?> q = server.find(getPropertyType())
    .where().raw(rawWhere).query();
  
  bindWhereParendId(1, q, parentId);
  
  if (excludeDetailIds != null && !excludeDetailIds.isEmpty()) {
    Expression idIn = q.getExpressionFactory().idIn(excludeDetailIds);
    q.where().not(idIn);
  }
  
  return server.findIds(q, t);
}
 

public List<Pizza> findOrderByIdAsc() {
  List<Pizza> pizzas = server.find(Pizza.class).orderBy("id asc").findList();
  return pizzas;
}

query.select(idNames).setId(id);
ref = query.findUnique();

/**
 * Apply these path properties as fetch paths to the query.
 */
public <T> void apply(Query<T> query) {
 for (Entry<String, Props> entry : pathMap.entrySet()) {
  String path = entry.getKey();
  String props = entry.getValue().getPropertiesAsString();
  if (path == null || path.isEmpty()) {
   query.select(props);
  } else {
   query.fetch(path, props);
  }
 }
}

@Override
public EbeanQuery<MODEL_TYPE> offset(int pos) {
  q.setFirstRow(pos);
  qReadOnly.setFirstRow(pos);
  return this;
}

@Override
public EbeanQuery<MODEL_TYPE> limit(int limit) {
  q.setMaxRows(limit);
  qReadOnly.setMaxRows(limit);
  return this;
}

/**
 * Fetch the destination beans that will be published to.
 */
void fetchDestinationBeans(List<T> sourceBeans, boolean asDraft) {
 List<Object> ids = getBeanIds(desc, sourceBeans);
 Query<T> destQuery = server.find(desc.getBeanType()).where().idIn(ids).query();
 if (asDraft) {
  destQuery.asDraft();
 }
 desc.draftQueryOptimise(destQuery);
 this.destBeans = server.findMap(destQuery, transaction);
}

@Override
public FutureIds<T> findFutureIds() {
 return rootQuery.findFutureIds();
}

@Override
public FutureList<T> findFutureList() {
 return rootQuery.findFutureList();
}

@Override
public ExpressionList<T> filterMany(String prop) {
 return query.filterMany(prop);
}

@Override
public EbeanQuery<MODEL_TYPE> select(String fetchProperties) {
  q.select(fetchProperties);
  qReadOnly.select(fetchProperties);
  return this;
}

/**
 * We need to create and execute a query to get the foreign key values as
 * the delete cascades to them (foreign keys).
 */
private Query<?> deleteRequiresQuery(BeanDescriptor<?> desc, BeanPropertyAssocOne<?>[] propImportDelete) {
  Query<?> q = server.createQuery(desc.getBeanType());
  StringBuilder sb = new StringBuilder(30);
  for (int i = 0; i < propImportDelete.length; i++) {
    sb.append(propImportDelete[i].getName()).append(",");
  }
  q.setAutofetch(false);
  q.select(sb.toString());
  return q;
}