Package org.openrdf.sail.rdbms.evaluation

Examples of org.openrdf.sail.rdbms.evaluation.SqlQueryBuilder.from()

383
384
385
386
387
388
389
390
391
392
393
    }
    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();
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
    throws RdbmsException, SQLException
  {
    String tableName = statements.getTableName(vf.getInternalId(pred));
    SqlQueryBuilder query = factory.createSqlQueryBuilder();
    query.select().append("COUNT(*)");
    query.from(tableName, "t");
    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
459
460
461
462
463
464
465
466
467
468
469
            + " 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");
View Full Code Here
464
465
466
467
468
469
470
471
472
473
474
      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");
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
    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();
View Full Code Here
421
422
423
424
425
426
427
428
429
430
431
    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");
    }
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
    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");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.