Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder

Package org.openrdf.sail.rdbms.evaluation

Examples of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder

org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder
Facilitates the building of a JOIN or FROM clause in SQL. @author James Leigh

    }
    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();
    open.close();

View Full Code Here

        "CASE WHEN ou.value IS NOT NULL THEN ou.value" + " WHEN olu.value IS NOT NULL THEN olu.value"
            + " WHEN ob.value IS NOT NULL THEN ob.value"
            + " WHEN ol.value IS NOT NULL THEN ol.value ELSE oll.value END");
    query.select().column("od", "value");
    query.select().column("og", "value");
    SqlJoinBuilder join;
    if (pred != null) {
      join = query.from(uris.getShortTableName(), "pu");
      // TODO what about long predicate URIs?
      join = join.join(tableName, "t");
    }
    else {
      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");
    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");
    join.leftjoin(literals.getLongLabelTable().getName(), "oll").on("id", "t.obj");
    join.leftjoin(literals.getLanguageTable().getName(), "og").on("id", "t.obj");
    join.leftjoin(literals.getDatatypeTable().getName(), "od").on("id", "t.obj");
    if (ctxs != null && ctxs.length > 0) {
      Number[] ids = new Number[ctxs.length];
      for (int i = 0; i < ids.length; i++) {
        ids[i] = vf.getInternalId(ctxs[i]);
      }

View Full Code Here

    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

        " WHEN ob.value IS NOT NULL THEN ob.value" +
        " WHEN ol.value IS NOT NULL THEN ol.value ELSE oll.value END");
    query.select().column("od", "value");
    query.select().column("og", "value");
    query.select().column("t", "expl");
    SqlJoinBuilder join;
    if (pred != null) {
      join = query.from(uris.getShortTableName(), "pu");
      // TODO what about long predicate URIs? 
      join = join.join(tableName, "t");
    } else {
      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");
    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");
    join.leftjoin(literals.getLongLabelTable().getName(), "oll").on("id", "t.obj");
    join.leftjoin(literals.getLanguageTable().getName(), "og").on("id", "t.obj");
    join.leftjoin(literals.getDatatypeTable().getName(), "od").on("id", "t.obj");
    if (ctxIds != null) {
      query.filter().and().columnIn("t", "ctx", ctxIds);
    }
    if (subjId != null) {
      query.filter().and().columnEquals("t", "subj", subjId);

View Full Code Here

TOP

Related Classes of org.openrdf.sail.rdbms.evaluation.SqlJoinBuilder

org.openrdf.sail.rdbms.RdbmsTripleRepository

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.