@Override public final void addJoinOnKey(TableLike<?> table, JoinType type) throws DataAccessException { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: case LEFT_OUTER_JOIN: case RIGHT_OUTER_JOIN: case FULL_OUTER_JOIN: case LEFT_SEMI_JOIN: case LEFT_ANTI_JOIN: joined = getFrom().get(index).join(table, type).onKey(); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
@Override public final void addJoinOnKey(TableLike<?> table, JoinType type, TableField<?, ?>... keyFields) throws DataAccessException { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: case LEFT_OUTER_JOIN: case RIGHT_OUTER_JOIN: case FULL_OUTER_JOIN: case LEFT_SEMI_JOIN: case LEFT_ANTI_JOIN: joined = getFrom().get(index).join(table, type).onKey(keyFields); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
@Override public final void addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields) { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: case LEFT_OUTER_JOIN: case RIGHT_OUTER_JOIN: case FULL_OUTER_JOIN: case LEFT_SEMI_JOIN: case LEFT_ANTI_JOIN: joined = getFrom().get(index).join(table, type).using(fields); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinUsing() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
@Override public final void addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?, ?> key) { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: case LEFT_OUTER_JOIN: case RIGHT_OUTER_JOIN: case FULL_OUTER_JOIN: case LEFT_SEMI_JOIN: case LEFT_ANTI_JOIN: joined = getFrom().get(index).join(table, type).onKey(key); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
static Table<?> join(Table<?> table, ZipkinAnnotations joinTable, String key, int type) { return table.join(joinTable) .on(ZIPKIN_SPANS.TRACE_ID.eq(joinTable.TRACE_ID)) .and(ZIPKIN_SPANS.ID.eq(joinTable.SPAN_ID)) .and(joinTable.A_TYPE.eq(type)) .and(joinTable.A_KEY.eq(key)); }
static Table<?> join(Table<?> table, ZipkinAnnotations joinTable, String key, int type) { return table.join(joinTable) .on(ZIPKIN_SPANS.TRACE_ID.eq(joinTable.TRACE_ID)) .and(ZIPKIN_SPANS.ID.eq(joinTable.SPAN_ID)) .and(joinTable.A_TYPE.eq(type)) .and(joinTable.A_KEY.eq(key)); }
static Table<?> join(Table<?> table, ZipkinAnnotations joinTable, String key, int type) { return table.join(joinTable) .on(ZIPKIN_SPANS.TRACE_ID.eq(joinTable.TRACE_ID)) .and(ZIPKIN_SPANS.ID.eq(joinTable.SPAN_ID)) .and(joinTable.A_TYPE.eq(type)) .and(joinTable.A_KEY.eq(key)); } }
TableOnConditionStep<Record> joinPointPermissions(Table<Record> table, Field<Integer> dataPointIdField, User user) { Condition userHasPermission = DataPointDao.getInstance().userHasPermission(user); return table .join(DataPointDao.DATA_POINTS).on(dataPointIdField.eq(DataPointDao.ID)) .join(DataSourceDao.DATA_SOURCES).on(DSL.and(DataPointDao.DATA_SOURCE_ID.eq(DataSourceDao.ID), userHasPermission)); }
@Override public final void addJoinOnKey(TableLike<?> table, JoinType type, TableField<?, ?>... keyFields) throws DataAccessException { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: joined = getFrom().get(index).join(table).onKey(keyFields); break; case LEFT_OUTER_JOIN: joined = getFrom().get(index).leftOuterJoin(table).onKey(keyFields); break; case RIGHT_OUTER_JOIN: joined = getFrom().get(index).rightOuterJoin(table).onKey(keyFields); break; case FULL_OUTER_JOIN: joined = getFrom().get(index).fullOuterJoin(table).onKey(keyFields); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
@Override public final void addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields) { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: joined = getFrom().get(index).join(table).using(fields); break; case LEFT_OUTER_JOIN: joined = getFrom().get(index).leftOuterJoin(table).using(fields); break; case RIGHT_OUTER_JOIN: joined = getFrom().get(index).rightOuterJoin(table).using(fields); break; case FULL_OUTER_JOIN: joined = getFrom().get(index).fullOuterJoin(table).using(fields); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinUsing() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
@Override public final void addJoinOnKey(TableLike<?> table, JoinType type) throws DataAccessException { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: joined = getFrom().get(index).join(table).onKey(); break; case LEFT_OUTER_JOIN: joined = getFrom().get(index).leftOuterJoin(table).onKey(); break; case RIGHT_OUTER_JOIN: joined = getFrom().get(index).rightOuterJoin(table).onKey(); break; case FULL_OUTER_JOIN: joined = getFrom().get(index).fullOuterJoin(table).onKey(); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
TablePartitionByStep<?> s1; TableOnStep<?> s2; s2 = s1 = (TablePartitionByStep<?>) (s0 = left.join(right, joinType));
@Override public final void addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?, ?> key) { // TODO: This and similar methods should be refactored, patterns extracted... int index = getFrom().size() - 1; Table<?> joined = null; switch (type) { case JOIN: joined = getFrom().get(index).join(table).onKey(key); break; case LEFT_OUTER_JOIN: joined = getFrom().get(index).leftOuterJoin(table).onKey(key); break; case RIGHT_OUTER_JOIN: joined = getFrom().get(index).rightOuterJoin(table).onKey(key); break; case FULL_OUTER_JOIN: joined = getFrom().get(index).fullOuterJoin(table).onKey(key); break; default: throw new IllegalArgumentException("JoinType " + type + " is not supported with the addJoinOnKey() method. Use INNER or OUTER JOINs only"); } getFrom().set(index, joined); }
joined = getFrom().get(index).join(table).on(conditions); break; case LEFT_OUTER_JOIN: {