List of leftjoin() Examples

Examples of leftjoin()

Examples of com.mysema.query.jpa.JPQLQuery.leftJoin()

        if (fetchFields == null || fetchFields.isEmpty()) {
            return super.findAll(predicate, pageable);
        }
        JPQLQuery fetchQuery = createQuery(predicate);
        for (String fetchField : fetchFields) {
            fetchQuery.leftJoin(builder.get(fetchField)).fetch();
        }
        JPQLQuery query = querydsl.applyPagination(pageable, fetchQuery);


        return new PageImpl<T>(query.list(path), pageable, createQuery(predicate).count());
    }

View Full Code Here

Examples of com.mysema.query.jpa.JPQLQuery.leftJoin()

        if (fetchFields == null || fetchFields.isEmpty()) {
            return super.findAll(predicate, pageable);
        }
        JPQLQuery fetchQuery = createQuery(predicate);
        for (String fetchField : fetchFields) {
            fetchQuery.leftJoin(builder.get(fetchField)).fetch();
        }
        JPQLQuery query = querydsl.applyPagination(pageable, fetchQuery);


        return new PageImpl<T>(query.list(path), pageable, createQuery(predicate).count());
    }

View Full Code Here

Examples of com.mysema.query.jpa.hibernate.HibernateQuery.leftJoin()

          or.not();
        }
        query.where(or);
      }
    }
    query.leftJoin(entry.statuses, status).on(status.subscription.id.eq(sub.getId()));


    if (unreadOnly && tag == null) {
      BooleanBuilder or = new BooleanBuilder();
      or.or(status.read.isNull());
      or.or(status.read.isFalse());

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

    String tableName = statements.getCombinedTableName();
    SqlQueryBuilder query = factory.createSqlQueryBuilder();
    query.select().column("t", "ctx");
    query.select().append("CASE WHEN MIN(u.value) IS NOT NULL THEN MIN(u.value) ELSE MIN(b.value) END");
    SqlJoinBuilder join = query.from(tableName, "t");
    join.leftjoin(bnodes.getName(), "b").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "u").on("id", "t.ctx");
    SqlBracketBuilder open = query.filter().and().open();
    open.column("u", "value").isNotNull();
    open.or();
    open.column("b", "value").isNotNull();

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

    SqlQueryBuilder query = factory.createSqlQueryBuilder();
    query.select().column("t", "ctx");
    query.select().append("CASE WHEN MIN(u.value) IS NOT NULL THEN MIN(u.value) ELSE MIN(b.value) END");
    SqlJoinBuilder join = query.from(tableName, "t");
    join.leftjoin(bnodes.getName(), "b").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "u").on("id", "t.ctx");
    SqlBracketBuilder open = query.filter().and().open();
    open.column("u", "value").isNotNull();
    open.or();
    open.column("b", "value").isNotNull();
    open.close();

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

      join = query.from(tableName, "t");
    }
    if (pred == null) {
      join.join(uris.getShortTableName(), "pu").on("id", "t.pred");
    }
    join.leftjoin(uris.getShortTableName(), "cu").on("id", "t.ctx");
    join.leftjoin(uris.getLongTableName(), "clu").on("id", "t.ctx");
    join.leftjoin(bnodes.getName(), "cb").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "su").on("id", "t.subj");
    join.leftjoin(uris.getLongTableName(), "slu").on("id", "t.subj");
    join.leftjoin(bnodes.getName(), "sb").on("id", "t.subj");

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

    }
    if (pred == null) {
      join.join(uris.getShortTableName(), "pu").on("id", "t.pred");
    }
    join.leftjoin(uris.getShortTableName(), "cu").on("id", "t.ctx");
    join.leftjoin(uris.getLongTableName(), "clu").on("id", "t.ctx");
    join.leftjoin(bnodes.getName(), "cb").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "su").on("id", "t.subj");
    join.leftjoin(uris.getLongTableName(), "slu").on("id", "t.subj");
    join.leftjoin(bnodes.getName(), "sb").on("id", "t.subj");
    join.leftjoin(uris.getShortTableName(), "ou").on("id", "t.obj");

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

    if (pred == null) {
      join.join(uris.getShortTableName(), "pu").on("id", "t.pred");
    }
    join.leftjoin(uris.getShortTableName(), "cu").on("id", "t.ctx");
    join.leftjoin(uris.getLongTableName(), "clu").on("id", "t.ctx");
    join.leftjoin(bnodes.getName(), "cb").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "su").on("id", "t.subj");
    join.leftjoin(uris.getLongTableName(), "slu").on("id", "t.subj");
    join.leftjoin(bnodes.getName(), "sb").on("id", "t.subj");
    join.leftjoin(uris.getShortTableName(), "ou").on("id", "t.obj");
    join.leftjoin(uris.getLongTableName(), "olu").on("id", "t.obj");

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

      join.join(uris.getShortTableName(), "pu").on("id", "t.pred");
    }
    join.leftjoin(uris.getShortTableName(), "cu").on("id", "t.ctx");
    join.leftjoin(uris.getLongTableName(), "clu").on("id", "t.ctx");
    join.leftjoin(bnodes.getName(), "cb").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "su").on("id", "t.subj");
    join.leftjoin(uris.getLongTableName(), "slu").on("id", "t.subj");
    join.leftjoin(bnodes.getName(), "sb").on("id", "t.subj");
    join.leftjoin(uris.getShortTableName(), "ou").on("id", "t.obj");
    join.leftjoin(uris.getLongTableName(), "olu").on("id", "t.obj");
    join.leftjoin(bnodes.getName(), "ob").on("id", "t.obj");

View Full Code Here

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder.leftjoin()

    }
    join.leftjoin(uris.getShortTableName(), "cu").on("id", "t.ctx");
    join.leftjoin(uris.getLongTableName(), "clu").on("id", "t.ctx");
    join.leftjoin(bnodes.getName(), "cb").on("id", "t.ctx");
    join.leftjoin(uris.getShortTableName(), "su").on("id", "t.subj");
    join.leftjoin(uris.getLongTableName(), "slu").on("id", "t.subj");
    join.leftjoin(bnodes.getName(), "sb").on("id", "t.subj");
    join.leftjoin(uris.getShortTableName(), "ou").on("id", "t.obj");
    join.leftjoin(uris.getLongTableName(), "olu").on("id", "t.obj");
    join.leftjoin(bnodes.getName(), "ob").on("id", "t.obj");
    join.leftjoin(literals.getLabelTable().getName(), "ol").on("id", "t.obj");

View Full Code Here

0 1 2 3

TOP

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.