// Get access to your secondDB EbeanServer secondDB = Ebean.getServer("secondDB"); // Get all users in secondDB List<User> userList = secondDB.find(User.class).findList();
private List<Object> findIdsByParentIdList(List<Object> parentIdist, Transaction t) { String rawWhere = deriveWhereParentIdSql(true); String inClause = targetIdBinder.getIdInValueExpr(parentIdist.size()); String expr = rawWhere+inClause; EbeanServer server = getBeanDescriptor().getEbeanServer(); Query<?> q = (Query<?>)server.find(getPropertyType()) .where().raw(expr); for (int i = 0; i < parentIdist.size(); i++) { bindWhereParendId(q, parentIdist.get(i)); } return server.findIds(q, t); }
/** * find by fluent query */ public Query<T> find() throws PragmatachException { return ebeanServer.find(this.typeClazz); }
private List<Object> findIdsByParentId(Object parentId, Transaction t) { String rawWhere = deriveWhereParentIdSql(false); List<Object> bindValues = new ArrayList<>(); bindWhereParentId(bindValues, parentId); EbeanServer server = getBeanDescriptor().getEbeanServer(); Query<?> q = server.find(getPropertyType()) .where() .raw(rawWhere, bindValues.toArray()) .query(); return server.findIds(q, t); }
@Override public Integer getProjectsCount() { return ebean.find(ProjectEntity.class).findCount(); } }
private List<Object> findIdsByParentId(Object parentId, Transaction t) { String rawWhere = deriveWhereParentIdSql(false); EbeanServer server = getBeanDescriptor().getEbeanServer(); Query<?> q = server.find(getPropertyType()) .where().raw(rawWhere).query(); bindWhereParendId(q, parentId); return server.findIds(q, t); }
/** * Creates a query. */ public Query<T> query() { return server().find(type); }
private List<Object> findIdsByParentId(Object parentId, Transaction t) { String rawWhere = deriveWhereParentIdSql(false); EbeanServer server = getBeanDescriptor().getEbeanServer(); Query<?> q = server.find(getPropertyType()) .where().raw(rawWhere).query(); bindWhereParendId(q, parentId); return server.findIds(q, t); }
/** * Creates a query. * <p> * Equivalent to {@link EbeanServer#find(Class)} */ public Query<T> query() { return db().find(type); }
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); }
/** * Retrieves an entity by ID. * <p> * Equivalent to {@link EbeanServer#find(Class, Object)} */ @Nullable public T byId(I id) { return db().find(type, id); }
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); }
/** * Retrieves an entity by ID. */ public T byId(I id) { return server().find(type, id); }
/** * find by id */ @Override public T findById(I i) throws PragmatachException { try { return ebeanServer.find(typeClazz, i); } catch (final Exception e) { throw new PragmatachException("Exception in findById", e); } }
/** * Retrieves all entities of the given type. */ public List<T> all() { return server().find(type).findList(); }
public MetaAutoFetchStatistic getMetaAutoFetchStatistic() { if (parentNode != null && server != null){ ObjectGraphOrigin origin = parentNode.getOriginQueryPoint(); return server.find(MetaAutoFetchStatistic.class, origin.getKey()); } return null; }
@Override public synchronized long getCents(GringottsAccount account) { // can this NPE? (probably doesn't) return db.find(EBeanAccount.class) .where() .ieq("type", account.owner.getType()) .ieq("owner", account.owner.getId()) .findUnique().cents; }
@Override public Company findCompany(Integer pid) { CompanyEntity companyEntity = ebean.find(CompanyEntity.class, pid); Company result = new Company(); result.setPid(companyEntity.getPid()); result.setName(companyEntity.getName()); result.setAddress(companyEntity.getAddress()); return result; }
@Override public Department findDepartment(Integer pid) { DepartmentEntity departmentEntity = ebean.find(DepartmentEntity.class, pid); Department result = new Department(); result.setPid(departmentEntity.getPid()); result.setName(departmentEntity.getName()); result.setCompanyPid(departmentEntity.getCompanyPid()); return result; }
@Override public Project findProject(Integer pid) { ProjectEntity projectEntity = ebean.find(ProjectEntity.class, pid); Project result = new Project(); result.setPid(projectEntity.getPid()); result.setName(projectEntity.getName()); result.setDate(projectEntity.getDateStarted()); return result; }