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