Package org.openrdf.sail.rdbms.evaluation

Examples of org.openrdf.sail.rdbms.evaluation.SqlBracketBuilder.column()

387
388
389
390
391
392
393
394
395
396
397
    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");
    return query.toString();
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
    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");
    return query.toString();
  }
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
            "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");
    return query.toString();
View Full Code Here
353
354
355
356
357
358
359
360
361
362
363
    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");
    return query.toString();
  }
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.