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