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.ContentPageDetailPK; 008import com.echothree.model.data.content.common.pk.ContentPageLayoutPK; 009import com.echothree.model.data.content.common.pk.ContentPagePK; 010import com.echothree.model.data.content.common.pk.ContentSectionPK; 011import com.echothree.model.jooq.server.KeyRegistry; 012import com.echothree.model.jooq.server.tables.content.ContentPageLayouts.ContentPageLayoutsPath; 013import com.echothree.model.jooq.server.tables.content.ContentPages.ContentPagesPath; 014import com.echothree.model.jooq.server.tables.content.ContentSections.ContentSectionsPath; 015 016import java.util.Arrays; 017import java.util.Collection; 018import java.util.List; 019 020import org.jooq.Condition; 021import org.jooq.Converter; 022import org.jooq.Field; 023import org.jooq.ForeignKey; 024import org.jooq.InverseForeignKey; 025import org.jooq.Name; 026import org.jooq.Path; 027import org.jooq.PlainSQL; 028import org.jooq.QueryPart; 029import org.jooq.Record; 030import org.jooq.SQL; 031import org.jooq.Stringly; 032import org.jooq.Table; 033import org.jooq.TableField; 034import org.jooq.TableLike; 035import org.jooq.TableOptions; 036import org.jooq.UniqueKey; 037import org.jooq.impl.DSL; 038import org.jooq.impl.Internal; 039import org.jooq.impl.SQLDataType; 040import org.jooq.impl.TableImpl; 041 042 043/** 044 * This class is generated by jOOQ. 045 */ 046@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 047public class ContentPageDetails extends TableImpl<com.echothree.model.jooq.server.records.content.ContentPageDetails> { 048 049 private static final long serialVersionUID = 1L; 050 051 /** 052 * The reference instance of <code>contentpagedetails</code> 053 */ 054 public static final ContentPageDetails ContentPageDetails = new ContentPageDetails(); 055 056 /** 057 * The class holding records for this type 058 */ 059 @Override 060 public Class<com.echothree.model.jooq.server.records.content.ContentPageDetails> getRecordType() { 061 return com.echothree.model.jooq.server.records.content.ContentPageDetails.class; 062 } 063 064 /** 065 * The column <code>contentpagedetails.cntpdt_contentpagedetailid</code>. 066 */ 067 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, ContentPageDetailPK> CONTENT_PAGE_DETAIL = createField(DSL.name("cntpdt_contentpagedetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContentPageDetailPK.class, id -> new com.echothree.model.data.content.common.pk.ContentPageDetailPK(id), primaryKey -> primaryKey.getEntityId())); 068 069 /** 070 * The column <code>contentpagedetails.cntpdt_cntp_contentpageid</code>. 071 */ 072 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, ContentPagePK> CONTENT_PAGE = createField(DSL.name("cntpdt_cntp_contentpageid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContentPagePK.class, id -> new com.echothree.model.data.content.common.pk.ContentPagePK(id), primaryKey -> primaryKey.getEntityId())); 073 074 /** 075 * The column <code>contentpagedetails.cntpdt_cnts_contentsectionid</code>. 076 */ 077 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, ContentSectionPK> CONTENT_SECTION = createField(DSL.name("cntpdt_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())); 078 079 /** 080 * The column <code>contentpagedetails.cntpdt_contentpagename</code>. 081 */ 082 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, String> CONTENT_PAGE_NAME = createField(DSL.name("cntpdt_contentpagename"), SQLDataType.VARCHAR(40).nullable(false), this, ""); 083 084 /** 085 * The column 086 * <code>contentpagedetails.cntpdt_cntpl_contentpagelayoutid</code>. 087 */ 088 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, ContentPageLayoutPK> CONTENT_PAGE_LAYOUT = createField(DSL.name("cntpdt_cntpl_contentpagelayoutid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContentPageLayoutPK.class, id -> new com.echothree.model.data.content.common.pk.ContentPageLayoutPK(id), primaryKey -> primaryKey.getEntityId())); 089 090 /** 091 * The column <code>contentpagedetails.cntpdt_isdefault</code>. 092 */ 093 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, Boolean> IS_DEFAULT = createField(DSL.name("cntpdt_isdefault"), SQLDataType.BIT.nullable(false), this, ""); 094 095 /** 096 * The column <code>contentpagedetails.cntpdt_sortorder</code>. 097 */ 098 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, Integer> SORT_ORDER = createField(DSL.name("cntpdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, ""); 099 100 /** 101 * The column <code>contentpagedetails.cntpdt_fromtime</code>. 102 */ 103 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, Long> FROM_TIME = createField(DSL.name("cntpdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 104 105 /** 106 * The column <code>contentpagedetails.cntpdt_thrutime</code>. 107 */ 108 public final TableField<com.echothree.model.jooq.server.records.content.ContentPageDetails, Long> THRU_TIME = createField(DSL.name("cntpdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 109 110 private ContentPageDetails(Name alias, Table<com.echothree.model.jooq.server.records.content.ContentPageDetails> aliased) { 111 this(alias, aliased, (Field<?>[]) null, null); 112 } 113 114 private ContentPageDetails(Name alias, Table<com.echothree.model.jooq.server.records.content.ContentPageDetails> aliased, Field<?>[] parameters, Condition where) { 115 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 116 } 117 118 /** 119 * Create an aliased <code>contentpagedetails</code> table reference 120 */ 121 public ContentPageDetails(String alias) { 122 this(DSL.name(alias), ContentPageDetails); 123 } 124 125 /** 126 * Create an aliased <code>contentpagedetails</code> table reference 127 */ 128 public ContentPageDetails(Name alias) { 129 this(alias, ContentPageDetails); 130 } 131 132 /** 133 * Create a <code>contentpagedetails</code> table reference 134 */ 135 public ContentPageDetails() { 136 this(DSL.name("contentpagedetails"), null); 137 } 138 139 public <O extends Record> ContentPageDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.content.ContentPageDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.content.ContentPageDetails> parentPath) { 140 super(path, childPath, parentPath, ContentPageDetails); 141 } 142 143 /** 144 * A subtype implementing {@link Path} for simplified path-based joins. 145 */ 146 public static class ContentPageDetailsPath extends ContentPageDetails implements Path<com.echothree.model.jooq.server.records.content.ContentPageDetails> { 147 148 private static final long serialVersionUID = 1L; 149 public <O extends Record> ContentPageDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.content.ContentPageDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.content.ContentPageDetails> parentPath) { 150 super(path, childPath, parentPath); 151 } 152 private ContentPageDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.content.ContentPageDetails> aliased) { 153 super(alias, aliased); 154 } 155 156 @Override 157 public ContentPageDetailsPath as(String alias) { 158 return new ContentPageDetailsPath(DSL.name(alias), this); 159 } 160 161 @Override 162 public ContentPageDetailsPath as(Name alias) { 163 return new ContentPageDetailsPath(alias, this); 164 } 165 166 @Override 167 public ContentPageDetailsPath as(Table<?> alias) { 168 return new ContentPageDetailsPath(alias.getQualifiedName(), this); 169 } 170 } 171 172 @Override 173 public UniqueKey<com.echothree.model.jooq.server.records.content.ContentPageDetails> getPrimaryKey() { 174 return KeyRegistry.CONTENT_PAGE_DETAILS_PK; 175 } 176 177 @Override 178 public List<ForeignKey<com.echothree.model.jooq.server.records.content.ContentPageDetails, ?>> getReferences() { 179 return Arrays.asList(KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_PAGE_FK, KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_PAGE_LAYOUT_FK, KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_SECTION_FK); 180 } 181 182 private transient ContentPagesPath _cntpdt_cntp_contentpageid_fk; 183 184 /** 185 * Get the implicit join path to the <code>contentpages</code> table. 186 */ 187 public ContentPagesPath cntpdt_cntp_contentpageid_fk() { 188 if (_cntpdt_cntp_contentpageid_fk == null) 189 _cntpdt_cntp_contentpageid_fk = new ContentPagesPath(this, KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_PAGE_FK, null); 190 191 return _cntpdt_cntp_contentpageid_fk; 192 } 193 194 private transient ContentPageLayoutsPath _cntpdt_cntpl_contentpagelayoutid_fk; 195 196 /** 197 * Get the implicit join path to the <code>contentpagelayouts</code> table. 198 */ 199 public ContentPageLayoutsPath cntpdt_cntpl_contentpagelayoutid_fk() { 200 if (_cntpdt_cntpl_contentpagelayoutid_fk == null) 201 _cntpdt_cntpl_contentpagelayoutid_fk = new ContentPageLayoutsPath(this, KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_PAGE_LAYOUT_FK, null); 202 203 return _cntpdt_cntpl_contentpagelayoutid_fk; 204 } 205 206 private transient ContentSectionsPath _cntpdt_cnts_contentsectionid_fk; 207 208 /** 209 * Get the implicit join path to the <code>contentsections</code> table. 210 */ 211 public ContentSectionsPath cntpdt_cnts_contentsectionid_fk() { 212 if (_cntpdt_cnts_contentsectionid_fk == null) 213 _cntpdt_cnts_contentsectionid_fk = new ContentSectionsPath(this, KeyRegistry.CONTENT_PAGE_DETAILS_CONTENT_SECTION_FK, null); 214 215 return _cntpdt_cnts_contentsectionid_fk; 216 } 217 218 @Override 219 public ContentPageDetails as(String alias) { 220 return new ContentPageDetails(DSL.name(alias), this); 221 } 222 223 @Override 224 public ContentPageDetails as(Name alias) { 225 return new ContentPageDetails(alias, this); 226 } 227 228 @Override 229 public ContentPageDetails as(Table<?> alias) { 230 return new ContentPageDetails(alias.getQualifiedName(), this); 231 } 232 233 /** 234 * Rename this table 235 */ 236 @Override 237 public ContentPageDetails rename(String name) { 238 return new ContentPageDetails(DSL.name(name), null); 239 } 240 241 /** 242 * Rename this table 243 */ 244 @Override 245 public ContentPageDetails rename(Name name) { 246 return new ContentPageDetails(name, null); 247 } 248 249 /** 250 * Rename this table 251 */ 252 @Override 253 public ContentPageDetails rename(Table<?> name) { 254 return new ContentPageDetails(name.getQualifiedName(), null); 255 } 256 257 /** 258 * Create an inline derived table from this table 259 */ 260 @Override 261 public ContentPageDetails where(Condition condition) { 262 return new ContentPageDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 263 } 264 265 /** 266 * Create an inline derived table from this table 267 */ 268 @Override 269 public ContentPageDetails where(Collection<? extends Condition> conditions) { 270 return where(DSL.and(conditions)); 271 } 272 273 /** 274 * Create an inline derived table from this table 275 */ 276 @Override 277 public ContentPageDetails where(Condition... conditions) { 278 return where(DSL.and(conditions)); 279 } 280 281 /** 282 * Create an inline derived table from this table 283 */ 284 @Override 285 public ContentPageDetails where(Field<Boolean> condition) { 286 return where(DSL.condition(condition)); 287 } 288 289 /** 290 * Create an inline derived table from this table 291 */ 292 @Override 293 @PlainSQL 294 public ContentPageDetails where(SQL condition) { 295 return where(DSL.condition(condition)); 296 } 297 298 /** 299 * Create an inline derived table from this table 300 */ 301 @Override 302 @PlainSQL 303 public ContentPageDetails where(@Stringly.SQL String condition) { 304 return where(DSL.condition(condition)); 305 } 306 307 /** 308 * Create an inline derived table from this table 309 */ 310 @Override 311 @PlainSQL 312 public ContentPageDetails where(@Stringly.SQL String condition, Object... binds) { 313 return where(DSL.condition(condition, binds)); 314 } 315 316 /** 317 * Create an inline derived table from this table 318 */ 319 @Override 320 @PlainSQL 321 public ContentPageDetails where(@Stringly.SQL String condition, QueryPart... parts) { 322 return where(DSL.condition(condition, parts)); 323 } 324 325 /** 326 * Create an inline derived table from this table 327 */ 328 @Override 329 public ContentPageDetails whereExists(TableLike<?> select) { 330 return where(DSL.exists(select)); 331 } 332 333 /** 334 * Create an inline derived table from this table 335 */ 336 @Override 337 public ContentPageDetails whereNotExists(TableLike<?> select) { 338 return where(DSL.notExists(select)); 339 } 340}