001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.workflow; 005 006 007import com.echothree.model.data.selector.common.pk.SelectorKindPK; 008import com.echothree.model.data.workflow.common.pk.WorkflowPK; 009import com.echothree.model.data.workflow.common.pk.WorkflowSelectorKindPK; 010import com.echothree.model.jooq.server.KeyRegistry; 011import com.echothree.model.jooq.server.tables.selector.SelectorKinds.SelectorKindsPath; 012import com.echothree.model.jooq.server.tables.workflow.Workflows.WorkflowsPath; 013 014import java.util.Arrays; 015import java.util.Collection; 016import java.util.List; 017 018import org.jooq.Condition; 019import org.jooq.Converter; 020import org.jooq.Field; 021import org.jooq.ForeignKey; 022import org.jooq.Name; 023import org.jooq.PlainSQL; 024import org.jooq.QueryPart; 025import org.jooq.SQL; 026import org.jooq.Stringly; 027import org.jooq.Table; 028import org.jooq.TableField; 029import org.jooq.TableLike; 030import org.jooq.TableOptions; 031import org.jooq.UniqueKey; 032import org.jooq.impl.DSL; 033import org.jooq.impl.Internal; 034import org.jooq.impl.SQLDataType; 035import org.jooq.impl.TableImpl; 036 037 038/** 039 * This class is generated by jOOQ. 040 */ 041@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 042public class WorkflowSelectorKinds extends TableImpl<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds> { 043 044 private static final long serialVersionUID = 1L; 045 046 /** 047 * The reference instance of <code>workflowselectorkinds</code> 048 */ 049 public static final WorkflowSelectorKinds WorkflowSelectorKinds = new WorkflowSelectorKinds(); 050 051 /** 052 * The class holding records for this type 053 */ 054 @Override 055 public Class<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds> getRecordType() { 056 return com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds.class; 057 } 058 059 /** 060 * The column 061 * <code>workflowselectorkinds.wkflslk_selectorkindworkflowid</code>. 062 */ 063 public final TableField<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, WorkflowSelectorKindPK> SELECTOR_KIND_WORKFLOW = createField(DSL.name("wkflslk_selectorkindworkflowid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkflowSelectorKindPK.class, id -> new com.echothree.model.data.workflow.common.pk.WorkflowSelectorKindPK(id), primaryKey -> primaryKey.getEntityId())); 064 065 /** 066 * The column <code>workflowselectorkinds.wkflslk_wkfl_workflowid</code>. 067 */ 068 public final TableField<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, WorkflowPK> WORKFLOW = createField(DSL.name("wkflslk_wkfl_workflowid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkflowPK.class, id -> new com.echothree.model.data.workflow.common.pk.WorkflowPK(id), primaryKey -> primaryKey.getEntityId())); 069 070 /** 071 * The column <code>workflowselectorkinds.wkflslk_slk_selectorkindid</code>. 072 */ 073 public final TableField<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, SelectorKindPK> SELECTOR_KIND = createField(DSL.name("wkflslk_slk_selectorkindid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, SelectorKindPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorKindPK(id), primaryKey -> primaryKey.getEntityId())); 074 075 /** 076 * The column <code>workflowselectorkinds.wkflslk_fromtime</code>. 077 */ 078 public final TableField<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, Long> FROM_TIME = createField(DSL.name("wkflslk_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 079 080 /** 081 * The column <code>workflowselectorkinds.wkflslk_thrutime</code>. 082 */ 083 public final TableField<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, Long> THRU_TIME = createField(DSL.name("wkflslk_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 084 085 private WorkflowSelectorKinds(Name alias, Table<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds> aliased) { 086 this(alias, aliased, (Field<?>[]) null, null); 087 } 088 089 private WorkflowSelectorKinds(Name alias, Table<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds> aliased, Field<?>[] parameters, Condition where) { 090 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 091 } 092 093 /** 094 * Create an aliased <code>workflowselectorkinds</code> table reference 095 */ 096 public WorkflowSelectorKinds(String alias) { 097 this(DSL.name(alias), WorkflowSelectorKinds); 098 } 099 100 /** 101 * Create an aliased <code>workflowselectorkinds</code> table reference 102 */ 103 public WorkflowSelectorKinds(Name alias) { 104 this(alias, WorkflowSelectorKinds); 105 } 106 107 /** 108 * Create a <code>workflowselectorkinds</code> table reference 109 */ 110 public WorkflowSelectorKinds() { 111 this(DSL.name("workflowselectorkinds"), null); 112 } 113 114 @Override 115 public UniqueKey<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds> getPrimaryKey() { 116 return KeyRegistry.WORKFLOW_SELECTOR_KINDS_PK; 117 } 118 119 @Override 120 public List<UniqueKey<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds>> getUniqueKeys() { 121 return Arrays.asList(KeyRegistry.WORKFLOW_SELECTOR_KINDS_WORKFLOW_AND_SELECTOR_KIND_AND_THRU_TIME_UK); 122 } 123 124 @Override 125 public List<ForeignKey<com.echothree.model.jooq.server.records.workflow.WorkflowSelectorKinds, ?>> getReferences() { 126 return Arrays.asList(KeyRegistry.WORKFLOW_SELECTOR_KINDS_SELECTOR_KIND_FK, KeyRegistry.WORKFLOW_SELECTOR_KINDS_WORKFLOW_FK); 127 } 128 129 private transient SelectorKindsPath _wkflslk_slk_selectorkindid_fk; 130 131 /** 132 * Get the implicit join path to the <code>selectorkinds</code> table. 133 */ 134 public SelectorKindsPath wkflslk_slk_selectorkindid_fk() { 135 if (_wkflslk_slk_selectorkindid_fk == null) 136 _wkflslk_slk_selectorkindid_fk = new SelectorKindsPath(this, KeyRegistry.WORKFLOW_SELECTOR_KINDS_SELECTOR_KIND_FK, null); 137 138 return _wkflslk_slk_selectorkindid_fk; 139 } 140 141 private transient WorkflowsPath _wkflslk_wkfl_workflowid_fk; 142 143 /** 144 * Get the implicit join path to the <code>workflows</code> table. 145 */ 146 public WorkflowsPath wkflslk_wkfl_workflowid_fk() { 147 if (_wkflslk_wkfl_workflowid_fk == null) 148 _wkflslk_wkfl_workflowid_fk = new WorkflowsPath(this, KeyRegistry.WORKFLOW_SELECTOR_KINDS_WORKFLOW_FK, null); 149 150 return _wkflslk_wkfl_workflowid_fk; 151 } 152 153 @Override 154 public WorkflowSelectorKinds as(String alias) { 155 return new WorkflowSelectorKinds(DSL.name(alias), this); 156 } 157 158 @Override 159 public WorkflowSelectorKinds as(Name alias) { 160 return new WorkflowSelectorKinds(alias, this); 161 } 162 163 @Override 164 public WorkflowSelectorKinds as(Table<?> alias) { 165 return new WorkflowSelectorKinds(alias.getQualifiedName(), this); 166 } 167 168 /** 169 * Rename this table 170 */ 171 @Override 172 public WorkflowSelectorKinds rename(String name) { 173 return new WorkflowSelectorKinds(DSL.name(name), null); 174 } 175 176 /** 177 * Rename this table 178 */ 179 @Override 180 public WorkflowSelectorKinds rename(Name name) { 181 return new WorkflowSelectorKinds(name, null); 182 } 183 184 /** 185 * Rename this table 186 */ 187 @Override 188 public WorkflowSelectorKinds rename(Table<?> name) { 189 return new WorkflowSelectorKinds(name.getQualifiedName(), null); 190 } 191 192 /** 193 * Create an inline derived table from this table 194 */ 195 @Override 196 public WorkflowSelectorKinds where(Condition condition) { 197 return new WorkflowSelectorKinds(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 198 } 199 200 /** 201 * Create an inline derived table from this table 202 */ 203 @Override 204 public WorkflowSelectorKinds where(Collection<? extends Condition> conditions) { 205 return where(DSL.and(conditions)); 206 } 207 208 /** 209 * Create an inline derived table from this table 210 */ 211 @Override 212 public WorkflowSelectorKinds where(Condition... conditions) { 213 return where(DSL.and(conditions)); 214 } 215 216 /** 217 * Create an inline derived table from this table 218 */ 219 @Override 220 public WorkflowSelectorKinds where(Field<Boolean> condition) { 221 return where(DSL.condition(condition)); 222 } 223 224 /** 225 * Create an inline derived table from this table 226 */ 227 @Override 228 @PlainSQL 229 public WorkflowSelectorKinds where(SQL condition) { 230 return where(DSL.condition(condition)); 231 } 232 233 /** 234 * Create an inline derived table from this table 235 */ 236 @Override 237 @PlainSQL 238 public WorkflowSelectorKinds where(@Stringly.SQL String condition) { 239 return where(DSL.condition(condition)); 240 } 241 242 /** 243 * Create an inline derived table from this table 244 */ 245 @Override 246 @PlainSQL 247 public WorkflowSelectorKinds where(@Stringly.SQL String condition, Object... binds) { 248 return where(DSL.condition(condition, binds)); 249 } 250 251 /** 252 * Create an inline derived table from this table 253 */ 254 @Override 255 @PlainSQL 256 public WorkflowSelectorKinds where(@Stringly.SQL String condition, QueryPart... parts) { 257 return where(DSL.condition(condition, parts)); 258 } 259 260 /** 261 * Create an inline derived table from this table 262 */ 263 @Override 264 public WorkflowSelectorKinds whereExists(TableLike<?> select) { 265 return where(DSL.exists(select)); 266 } 267 268 /** 269 * Create an inline derived table from this table 270 */ 271 @Override 272 public WorkflowSelectorKinds whereNotExists(TableLike<?> select) { 273 return where(DSL.notExists(select)); 274 } 275}