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