001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.core; 005 006 007import com.echothree.model.data.core.common.pk.CommandMessageDetailPK; 008import com.echothree.model.data.core.common.pk.CommandMessagePK; 009import com.echothree.model.data.core.common.pk.CommandMessageTypePK; 010import com.echothree.model.jooq.server.KeyRegistry; 011import com.echothree.model.jooq.server.tables.core.CommandMessageTypes.CommandMessageTypesPath; 012import com.echothree.model.jooq.server.tables.core.CommandMessages.CommandMessagesPath; 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.InverseForeignKey; 023import org.jooq.Name; 024import org.jooq.Path; 025import org.jooq.PlainSQL; 026import org.jooq.QueryPart; 027import org.jooq.Record; 028import org.jooq.SQL; 029import org.jooq.Stringly; 030import org.jooq.Table; 031import org.jooq.TableField; 032import org.jooq.TableLike; 033import org.jooq.TableOptions; 034import org.jooq.UniqueKey; 035import org.jooq.impl.DSL; 036import org.jooq.impl.Internal; 037import org.jooq.impl.SQLDataType; 038import org.jooq.impl.TableImpl; 039 040 041/** 042 * This class is generated by jOOQ. 043 */ 044@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 045public class CommandMessageDetails extends TableImpl<com.echothree.model.jooq.server.records.core.CommandMessageDetails> { 046 047 private static final long serialVersionUID = 1L; 048 049 /** 050 * The reference instance of <code>commandmessagedetails</code> 051 */ 052 public static final CommandMessageDetails CommandMessageDetails = new CommandMessageDetails(); 053 054 /** 055 * The class holding records for this type 056 */ 057 @Override 058 public Class<com.echothree.model.jooq.server.records.core.CommandMessageDetails> getRecordType() { 059 return com.echothree.model.jooq.server.records.core.CommandMessageDetails.class; 060 } 061 062 /** 063 * The column 064 * <code>commandmessagedetails.cmdmssgdt_commandmessagedetailid</code>. 065 */ 066 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, CommandMessageDetailPK> COMMAND_MESSAGE_DETAIL = createField(DSL.name("cmdmssgdt_commandmessagedetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CommandMessageDetailPK.class, id -> new com.echothree.model.data.core.common.pk.CommandMessageDetailPK(id), primaryKey -> primaryKey.getEntityId())); 067 068 /** 069 * The column 070 * <code>commandmessagedetails.cmdmssgdt_cmdmssg_commandmessageid</code>. 071 */ 072 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, CommandMessagePK> COMMAND_MESSAGE = createField(DSL.name("cmdmssgdt_cmdmssg_commandmessageid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CommandMessagePK.class, id -> new com.echothree.model.data.core.common.pk.CommandMessagePK(id), primaryKey -> primaryKey.getEntityId())); 073 074 /** 075 * The column 076 * <code>commandmessagedetails.cmdmssgdt_cmdmssgty_commandmessagetypeid</code>. 077 */ 078 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, CommandMessageTypePK> COMMAND_MESSAGE_TYPE = createField(DSL.name("cmdmssgdt_cmdmssgty_commandmessagetypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CommandMessageTypePK.class, id -> new com.echothree.model.data.core.common.pk.CommandMessageTypePK(id), primaryKey -> primaryKey.getEntityId())); 079 080 /** 081 * The column 082 * <code>commandmessagedetails.cmdmssgdt_commandmessagekey</code>. 083 */ 084 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, String> COMMAND_MESSAGE_KEY = createField(DSL.name("cmdmssgdt_commandmessagekey"), SQLDataType.VARCHAR(80).nullable(false), this, ""); 085 086 /** 087 * The column <code>commandmessagedetails.cmdmssgdt_fromtime</code>. 088 */ 089 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, Long> FROM_TIME = createField(DSL.name("cmdmssgdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 090 091 /** 092 * The column <code>commandmessagedetails.cmdmssgdt_thrutime</code>. 093 */ 094 public final TableField<com.echothree.model.jooq.server.records.core.CommandMessageDetails, Long> THRU_TIME = createField(DSL.name("cmdmssgdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 095 096 private CommandMessageDetails(Name alias, Table<com.echothree.model.jooq.server.records.core.CommandMessageDetails> aliased) { 097 this(alias, aliased, (Field<?>[]) null, null); 098 } 099 100 private CommandMessageDetails(Name alias, Table<com.echothree.model.jooq.server.records.core.CommandMessageDetails> aliased, Field<?>[] parameters, Condition where) { 101 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 102 } 103 104 /** 105 * Create an aliased <code>commandmessagedetails</code> table reference 106 */ 107 public CommandMessageDetails(String alias) { 108 this(DSL.name(alias), CommandMessageDetails); 109 } 110 111 /** 112 * Create an aliased <code>commandmessagedetails</code> table reference 113 */ 114 public CommandMessageDetails(Name alias) { 115 this(alias, CommandMessageDetails); 116 } 117 118 /** 119 * Create a <code>commandmessagedetails</code> table reference 120 */ 121 public CommandMessageDetails() { 122 this(DSL.name("commandmessagedetails"), null); 123 } 124 125 public <O extends Record> CommandMessageDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.core.CommandMessageDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.core.CommandMessageDetails> parentPath) { 126 super(path, childPath, parentPath, CommandMessageDetails); 127 } 128 129 /** 130 * A subtype implementing {@link Path} for simplified path-based joins. 131 */ 132 public static class CommandMessageDetailsPath extends CommandMessageDetails implements Path<com.echothree.model.jooq.server.records.core.CommandMessageDetails> { 133 134 private static final long serialVersionUID = 1L; 135 public <O extends Record> CommandMessageDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.core.CommandMessageDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.core.CommandMessageDetails> parentPath) { 136 super(path, childPath, parentPath); 137 } 138 private CommandMessageDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.core.CommandMessageDetails> aliased) { 139 super(alias, aliased); 140 } 141 142 @Override 143 public CommandMessageDetailsPath as(String alias) { 144 return new CommandMessageDetailsPath(DSL.name(alias), this); 145 } 146 147 @Override 148 public CommandMessageDetailsPath as(Name alias) { 149 return new CommandMessageDetailsPath(alias, this); 150 } 151 152 @Override 153 public CommandMessageDetailsPath as(Table<?> alias) { 154 return new CommandMessageDetailsPath(alias.getQualifiedName(), this); 155 } 156 } 157 158 @Override 159 public UniqueKey<com.echothree.model.jooq.server.records.core.CommandMessageDetails> getPrimaryKey() { 160 return KeyRegistry.COMMAND_MESSAGE_DETAILS_PK; 161 } 162 163 @Override 164 public List<UniqueKey<com.echothree.model.jooq.server.records.core.CommandMessageDetails>> getUniqueKeys() { 165 return Arrays.asList(KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_AND_THRU_TIME_UK, KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_TYPE_AND_COMMAND_MESSAGE_KEY_AND_THRU_TIME_UK); 166 } 167 168 @Override 169 public List<ForeignKey<com.echothree.model.jooq.server.records.core.CommandMessageDetails, ?>> getReferences() { 170 return Arrays.asList(KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_FK, KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_TYPE_FK); 171 } 172 173 private transient CommandMessagesPath _cmdmssgdt_cmdmssg_commandmessageid_fk; 174 175 /** 176 * Get the implicit join path to the <code>commandmessages</code> table. 177 */ 178 public CommandMessagesPath cmdmssgdt_cmdmssg_commandmessageid_fk() { 179 if (_cmdmssgdt_cmdmssg_commandmessageid_fk == null) 180 _cmdmssgdt_cmdmssg_commandmessageid_fk = new CommandMessagesPath(this, KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_FK, null); 181 182 return _cmdmssgdt_cmdmssg_commandmessageid_fk; 183 } 184 185 private transient CommandMessageTypesPath _cmdmssgdt_cmdmssgty_commandmessagetypeid_fk; 186 187 /** 188 * Get the implicit join path to the <code>commandmessagetypes</code> table. 189 */ 190 public CommandMessageTypesPath cmdmssgdt_cmdmssgty_commandmessagetypeid_fk() { 191 if (_cmdmssgdt_cmdmssgty_commandmessagetypeid_fk == null) 192 _cmdmssgdt_cmdmssgty_commandmessagetypeid_fk = new CommandMessageTypesPath(this, KeyRegistry.COMMAND_MESSAGE_DETAILS_COMMAND_MESSAGE_TYPE_FK, null); 193 194 return _cmdmssgdt_cmdmssgty_commandmessagetypeid_fk; 195 } 196 197 @Override 198 public CommandMessageDetails as(String alias) { 199 return new CommandMessageDetails(DSL.name(alias), this); 200 } 201 202 @Override 203 public CommandMessageDetails as(Name alias) { 204 return new CommandMessageDetails(alias, this); 205 } 206 207 @Override 208 public CommandMessageDetails as(Table<?> alias) { 209 return new CommandMessageDetails(alias.getQualifiedName(), this); 210 } 211 212 /** 213 * Rename this table 214 */ 215 @Override 216 public CommandMessageDetails rename(String name) { 217 return new CommandMessageDetails(DSL.name(name), null); 218 } 219 220 /** 221 * Rename this table 222 */ 223 @Override 224 public CommandMessageDetails rename(Name name) { 225 return new CommandMessageDetails(name, null); 226 } 227 228 /** 229 * Rename this table 230 */ 231 @Override 232 public CommandMessageDetails rename(Table<?> name) { 233 return new CommandMessageDetails(name.getQualifiedName(), null); 234 } 235 236 /** 237 * Create an inline derived table from this table 238 */ 239 @Override 240 public CommandMessageDetails where(Condition condition) { 241 return new CommandMessageDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 242 } 243 244 /** 245 * Create an inline derived table from this table 246 */ 247 @Override 248 public CommandMessageDetails where(Collection<? extends Condition> conditions) { 249 return where(DSL.and(conditions)); 250 } 251 252 /** 253 * Create an inline derived table from this table 254 */ 255 @Override 256 public CommandMessageDetails where(Condition... conditions) { 257 return where(DSL.and(conditions)); 258 } 259 260 /** 261 * Create an inline derived table from this table 262 */ 263 @Override 264 public CommandMessageDetails where(Field<Boolean> condition) { 265 return where(DSL.condition(condition)); 266 } 267 268 /** 269 * Create an inline derived table from this table 270 */ 271 @Override 272 @PlainSQL 273 public CommandMessageDetails where(SQL condition) { 274 return where(DSL.condition(condition)); 275 } 276 277 /** 278 * Create an inline derived table from this table 279 */ 280 @Override 281 @PlainSQL 282 public CommandMessageDetails where(@Stringly.SQL String condition) { 283 return where(DSL.condition(condition)); 284 } 285 286 /** 287 * Create an inline derived table from this table 288 */ 289 @Override 290 @PlainSQL 291 public CommandMessageDetails where(@Stringly.SQL String condition, Object... binds) { 292 return where(DSL.condition(condition, binds)); 293 } 294 295 /** 296 * Create an inline derived table from this table 297 */ 298 @Override 299 @PlainSQL 300 public CommandMessageDetails where(@Stringly.SQL String condition, QueryPart... parts) { 301 return where(DSL.condition(condition, parts)); 302 } 303 304 /** 305 * Create an inline derived table from this table 306 */ 307 @Override 308 public CommandMessageDetails whereExists(TableLike<?> select) { 309 return where(DSL.exists(select)); 310 } 311 312 /** 313 * Create an inline derived table from this table 314 */ 315 @Override 316 public CommandMessageDetails whereNotExists(TableLike<?> select) { 317 return where(DSL.notExists(select)); 318 } 319}