Examples with Select com.bluenimble.platform.db.query.Select used on opensource projects

Example 1 with Select

use of com.bluenimble.platform.db.query.Select in project serverless by bluenimble.

the class OrientDatabase method compile.

private CompiledQuery compile(String entity, Query.Construct construct, final Query query, final boolean returnBefore) throws DatabaseException {
    final String fEntity = entity;
    QueryCompiler compiler = new SqlQueryCompiler(construct) {

        private static final long serialVersionUID = -1248971549807669897L;

        @Override
        protected void onQuery(Timing timing, Query query) throws DatabaseException {
            super.onQuery(timing, query);
            if (Timing.start.equals(timing)) {
                return;
            }
            if (query.start() > 0) {
                buff.append(Lang.SPACE).append(Sql.Skip).append(Lang.SPACE).append(query.start());
            }
            if (query.count() > 0) {
                buff.append(Lang.SPACE).append(Sql.Limit).append(Lang.SPACE).append(query.count());
            }
        }

        @Override
        protected void onSelect(Timing timing, Select select) throws DatabaseException {
            super.onSelect(timing, select);
            if (Timing.end.equals(timing) && returnBefore) {
                buff.append(Lang.SPACE).append(Sql.ReturnBefore);
            }
        }

        @Override
        protected String operatorFor(Operator operator) {
            if (Operator.ftq.equals(operator)) {
                return Lucene;
            } else if (Operator.regex.equals(operator)) {
                return Maches;
            }
            return super.operatorFor(operator);
        }

        @Override
        protected void entity() {
            buff.append(fEntity);
        }
    };
    return compiler.compile(query);
}

Example 2 with Select

use of com.bluenimble.platform.db.query.Select in project serverless by bluenimble.

the class MongoDatabaseImpl method _query.

private Object _query(String type, Query.Construct construct, final Query query) throws DatabaseException {
    if (query == null) {
        return null;
    }
    boolean queryHasEntity = true;
    String entity = query.entity();
    if (Lang.isNullOrEmpty(entity)) {
        queryHasEntity = false;
        entity = type;
    }
    entity = checkNotNull(entity);
    tracer.log(Tracer.Level.Debug, "Query Entity {0}", entity);
    String cacheKey = construct.name() + query.name();
    BasicDBObject mQuery = null;
    Map<String, Object> bindings = query.bindings();
    boolean cacheable = queryHasEntity && query.caching().cache(Target.meta) && !Lang.isNullOrEmpty(query.name());
    if (cacheable) {
        mQuery = (BasicDBObject) QueriesCache.get(cacheKey);
        tracer.log(Tracer.Level.Debug, "Query meta loaded from cache {0}", mQuery);
    }
    if (mQuery == null) {
        CompiledQuery cQuery = compile(entity, construct, query);
        mQuery = (BasicDBObject) cQuery.query();
        bindings = cQuery.bindings();
        if (cacheable && mQuery != null) {
            QueriesCache.put(cacheKey, mQuery);
            tracer.log(Tracer.Level.Debug, "Query meta stored in cache {0}", mQuery);
        }
    }
    mQuery = cacheable ? applyBindings(mQuery, bindings) : mQuery;
    tracer.log(Tracer.Level.Debug, "       Query {0}", mQuery);
    tracer.log(Tracer.Level.Debug, "    Bindings {0}", bindings);
    if (Query.Construct.select.equals(construct)) {
        FindIterable<Document> cursor = db.getCollection(entity).find(mQuery);
        // start / skip
        if (query.start() > 0) {
            cursor.skip(query.start());
        }
        // count / limit
        if (query.count() > 0) {
            cursor.limit(query.count());
        }
        // orderBy
        OrderBy orderBy = query.orderBy();
        if (orderBy != null && orderBy.count() > 0) {
            List<Bson> sorts = new ArrayList<Bson>();
            Iterator<String> oFields = orderBy.fields();
            while (oFields.hasNext()) {
                String field = oFields.next();
                OrderByField of = orderBy.get(field);
                Bson sort = null;
                if (of.direction().equals(Direction.asc)) {
                    sort = Sorts.ascending(field);
                } else {
                    sort = Sorts.descending(field);
                }
                sorts.add(sort);
            }
            cursor.sort(Sorts.orderBy(sorts));
        }
        Select select = query.select();
        if (select != null && select.count() > 0) {
            String[] pFields = new String[select.count()];
            for (int i = 0; i < select.count(); i++) {
                System.out.println(select.get(i));
                pFields[i] = select.get(i);
            }
            cursor.projection(Projections.include(pFields));
        }
        return cursor;
    } else if (Query.Construct.delete.equals(construct)) {
        return db.getCollection(entity).deleteMany(mQuery);
    }
    return null;
}