Tabnine Logo
TableOnConditionStep
Code IndexAdd Tabnine to your IDE (free)

How to use
TableOnConditionStep
in
org.jooq

Best Java code snippets using org.jooq.TableOnConditionStep (Showing top 13 results out of 315)

origin: io.zipkin.java/zipkin-storage-mysql

static TableOnConditionStep<?> maybeOnService(TableOnConditionStep<Record> table,
  ZipkinAnnotations aTable, String serviceName) {
 if (serviceName == null) return table;
 return table.and(aTable.ENDPOINT_SERVICE_NAME.eq(serviceName));
}
origin: io.zipkin.java/zipkin-storage-mysql

for (String key : request.annotations) {
 ZipkinAnnotations aTable = ZIPKIN_ANNOTATIONS.as("a" + i++);
 table = maybeOnService(table.join(aTable)
   .on(schema.joinCondition(aTable))
   .and(aTable.A_KEY.eq(key)), aTable, request.serviceName);
 table = maybeOnService(table.join(aTable)
   .on(schema.joinCondition(aTable))
   .and(aTable.A_TYPE.eq(STRING.value))
   .and(aTable.A_KEY.eq(kv.getKey()))
   .and(aTable.A_VALUE.eq(kv.getValue().getBytes(UTF_8))), aTable, request.serviceName);
origin: infiniteautomation/ma-core-public

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));
}
origin: org.jooq/jooq-meta

.leftJoin(ad)
  .on(a.ATTRELID.eq(ad.ADRELID))
  .and(a.ATTNUM.eq(ad.ADNUM))
.join(c
  .join(nc)
    .on(c.RELNAMESPACE.eq(oid(nc))))
  .on(a.ATTRELID.eq(oid(c)))
.join(t
  .join(nt)
    .on(t.TYPNAMESPACE.eq(oid(nt))))
origin: io.zipkin.java/spanstore-jdbc

 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));
 }
}
origin: io.zipkin.java/zipkin-storage-jdbc

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));
}
origin: io.zipkin.java/storage-jdbc

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));
}
origin: io.zipkin.java/spanstore-jdbc

  .on(ZIPKIN_SPANS.TRACE_ID.eq(ZIPKIN_ANNOTATIONS.TRACE_ID).and(
    ZIPKIN_SPANS.ID.eq(ZIPKIN_ANNOTATIONS.SPAN_ID)))
  .and(ZIPKIN_ANNOTATIONS.A_KEY.in(CLIENT_ADDR, SERVER_RECV, SERVER_ADDR)))
.where(lookback == null ?
  ZIPKIN_SPANS.START_TS.lessOrEqual(endTs) :
origin: io.zipkin.java/storage-jdbc

  .on(ZIPKIN_SPANS.TRACE_ID.eq(ZIPKIN_ANNOTATIONS.TRACE_ID).and(
    ZIPKIN_SPANS.ID.eq(ZIPKIN_ANNOTATIONS.SPAN_ID)))
  .and(ZIPKIN_ANNOTATIONS.A_KEY.in(CLIENT_ADDR, SERVER_RECV, SERVER_ADDR)))
.where(lookback == null ?
  ZIPKIN_SPANS.START_TS.lessOrEqual(endTs) :
origin: io.zipkin.java/zipkin-storage-jdbc

  .on(ZIPKIN_SPANS.TRACE_ID.eq(ZIPKIN_ANNOTATIONS.TRACE_ID).and(
    ZIPKIN_SPANS.ID.eq(ZIPKIN_ANNOTATIONS.SPAN_ID)))
  .and(ZIPKIN_ANNOTATIONS.A_KEY.in(CLIENT_ADDR, SERVER_RECV, SERVER_ADDR)))
.where(lookback == null ?
  ZIPKIN_SPANS.START_TS.lessOrEqual(endTs) :
origin: perfectsense/dari

table = table.join(join.table, forceLeftJoins || join.isLeftOuter() ? JoinType.LEFT_OUTER_JOIN : JoinType.JOIN)
    .on(join.idField.eq(recordIdField))
    .and(join.typeIdField.eq(recordTypeIdField))
    .and(join.symbolIdField.in(join.symbolIds));
origin: io.zipkin.java/zipkin-storage-mysql

  .and(ZIPKIN_ANNOTATIONS.A_KEY.in(CLIENT_SEND, CLIENT_ADDR, SERVER_RECV, SERVER_ADDR, ERROR)))
.where(lookback == null ?
  ZIPKIN_SPANS.START_TS.lessOrEqual(endTs) :
origin: org.jooq/jooq-meta

private Result<Record4<String, String, String, String>> fetchKeys(String constraintType) {
  return create()
    .select(
      KEY_COLUMN_USAGE.TABLE_SCHEMA,
      KEY_COLUMN_USAGE.CONSTRAINT_NAME,
      KEY_COLUMN_USAGE.TABLE_NAME,
      KEY_COLUMN_USAGE.COLUMN_NAME)
    .from(TABLE_CONSTRAINTS
      .join(KEY_COLUMN_USAGE)
      .on(TABLE_CONSTRAINTS.CONSTRAINT_SCHEMA.equal(KEY_COLUMN_USAGE.CONSTRAINT_SCHEMA))
      .and(TABLE_CONSTRAINTS.CONSTRAINT_NAME.equal(KEY_COLUMN_USAGE.CONSTRAINT_NAME)))
    .where(TABLE_CONSTRAINTS.CONSTRAINT_TYPE.equal(constraintType))
    .and(TABLE_CONSTRAINTS.TABLE_SCHEMA.in(getInputSchemata()))
    .orderBy(
      KEY_COLUMN_USAGE.TABLE_SCHEMA.asc(),
      KEY_COLUMN_USAGE.TABLE_NAME.asc(),
      KEY_COLUMN_USAGE.CONSTRAINT_NAME.asc(),
      KEY_COLUMN_USAGE.ORDINAL_POSITION.asc())
    .fetch();
}
org.jooqTableOnConditionStep

Javadoc

An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition. This type can be used as a convenience type for connecting more conditions.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

  • They're operating on mutable implementations (as of jOOQ 3.x)
  • They're less composable and not easy to get right when dynamic SQL gets complex
  • They're less readable
  • They might have binary incompatible changes between minor releases

Most used methods

  • and
    Combine the currently assembled conditions with another one using the Operator#AND operator.NOTE: Wh
  • join

Popular in Java

  • Making http requests using okhttp
  • getSharedPreferences (Context)
  • setRequestProperty (URLConnection)
  • getApplicationContext (Context)
  • PrintStream (java.io)
    Fake signature of an existing Java class.
  • KeyStore (java.security)
    KeyStore is responsible for maintaining cryptographic keys and their owners. The type of the syste
  • Manifest (java.util.jar)
    The Manifest class is used to obtain attribute information for a JarFile and its entries.
  • JButton (javax.swing)
  • JOptionPane (javax.swing)
  • Logger (org.apache.log4j)
    This is the central class in the log4j package. Most logging operations, except configuration, are d
  • Top plugins for Android Studio
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now