Package org.openrdf.sail.rdbms.evaluation

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

386
387
388
389
390
391
392
393
394
395
396
    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();
    query.groupBy("t.ctx");
View Full Code Here
408
409
410
411
412
413
414
415
416
417
418
    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]);
      }
      query.filter().and().columnIn("t", "ctx", ids);
    }
    if (subj != null) {
      Number id = vf.getInternalId(subj);
      query.filter().and().columnEquals("t", "subj", id);
    }
View Full Code Here
412
413
414
415
416
417
418
419
420
421
422
      }
      query.filter().and().columnIn("t", "ctx", ids);
    }
    if (subj != null) {
      Number id = vf.getInternalId(subj);
      query.filter().and().columnEquals("t", "subj", id);
    }
    if (pred != null) {
      Number id = vf.getInternalId(pred);
      if (statements.isPredColumnPresent(id)) {
        query.filter().and().columnEquals("t", "pred", id);
View Full Code Here
417
418
419
420
421
422
423
424
425
426
427
      query.filter().and().columnEquals("t", "subj", id);
    }
    if (pred != null) {
      Number id = vf.getInternalId(pred);
      if (statements.isPredColumnPresent(id)) {
        query.filter().and().columnEquals("t", "pred", id);
      }
    }
    if (obj != null) {
      Number id = vf.getInternalId(obj);
      query.filter().and().columnEquals("t", "obj", id);
View Full Code Here
422
423
424
425
426
427
428
429
430
431
432
        query.filter().and().columnEquals("t", "pred", id);
      }
    }
    if (obj != null) {
      Number id = vf.getInternalId(obj);
      query.filter().and().columnEquals("t", "obj", id);
    }
    return query;
  }

  private String buildDeleteQuery(String tableName, RdbmsResource subj, RdbmsURI pred, RdbmsValue obj,
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
    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]);
      }
      query.filter().and().columnIn("t", "ctx", ids);
    }
    if (subj != null) {
      Number id = vf.getInternalId(subj);
      query.filter().and().columnEquals("t", "subj", id);
    }
View Full Code Here
491
492
493
494
495
496
497
498
499
500
501
      }
      query.filter().and().columnIn("t", "ctx", ids);
    }
    if (subj != null) {
      Number id = vf.getInternalId(subj);
      query.filter().and().columnEquals("t", "subj", id);
    }
    if (pred != null) {
      Number id = vf.getInternalId(pred);
      query.filter().and().columnEquals("pu", "id", id);
      if (statements.isPredColumnPresent(id)) {
View Full Code Here
495
496
497
498
499
500
501
502
503
504
505
      Number id = vf.getInternalId(subj);
      query.filter().and().columnEquals("t", "subj", id);
    }
    if (pred != null) {
      Number id = vf.getInternalId(pred);
      query.filter().and().columnEquals("pu", "id", id);
      if (statements.isPredColumnPresent(id)) {
        query.filter().and().columnEquals("t", "pred", id);
      }
    }
    if (obj != null) {
View Full Code Here
497
498
499
500
501
502
503
504
505
506
507
    }
    if (pred != null) {
      Number id = vf.getInternalId(pred);
      query.filter().and().columnEquals("pu", "id", id);
      if (statements.isPredColumnPresent(id)) {
        query.filter().and().columnEquals("t", "pred", id);
      }
    }
    if (obj != null) {
      Number id = vf.getInternalId(obj);
      query.filter().and().columnEquals("t", "obj", id);
View Full Code Here
502
503
504
505
506
507
508
509
510
511
512
        query.filter().and().columnEquals("t", "pred", id);
      }
    }
    if (obj != null) {
      Number id = vf.getInternalId(obj);
      query.filter().and().columnEquals("t", "obj", id);
    }
    return query;
  }

  private String buildWhere(StringBuilder sb, RdbmsResource subj, RdbmsURI pred, RdbmsValue obj,
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.