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