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