001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.order; 005 006 007import com.echothree.model.data.order.common.pk.OrderLinePK; 008import com.echothree.model.data.order.common.pk.OrderLineStatusPK; 009import com.echothree.model.jooq.server.KeyRegistry; 010import com.echothree.model.jooq.server.tables.order.OrderLines.OrderLinesPath; 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.Name; 021import org.jooq.PlainSQL; 022import org.jooq.QueryPart; 023import org.jooq.SQL; 024import org.jooq.Stringly; 025import org.jooq.Table; 026import org.jooq.TableField; 027import org.jooq.TableLike; 028import org.jooq.TableOptions; 029import org.jooq.UniqueKey; 030import org.jooq.impl.DSL; 031import org.jooq.impl.Internal; 032import org.jooq.impl.SQLDataType; 033import org.jooq.impl.TableImpl; 034 035 036/** 037 * This class is generated by jOOQ. 038 */ 039@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 040public class OrderLineStatuses extends TableImpl<com.echothree.model.jooq.server.records.order.OrderLineStatuses> { 041 042 private static final long serialVersionUID = 1L; 043 044 /** 045 * The reference instance of <code>orderlinestatuses</code> 046 */ 047 public static final OrderLineStatuses OrderLineStatuses = new OrderLineStatuses(); 048 049 /** 050 * The class holding records for this type 051 */ 052 @Override 053 public Class<com.echothree.model.jooq.server.records.order.OrderLineStatuses> getRecordType() { 054 return com.echothree.model.jooq.server.records.order.OrderLineStatuses.class; 055 } 056 057 /** 058 * The column <code>orderlinestatuses.ordlst_orderlinestatusid</code>. 059 */ 060 public final TableField<com.echothree.model.jooq.server.records.order.OrderLineStatuses, OrderLineStatusPK> ORDER_LINE_STATUS = createField(DSL.name("ordlst_orderlinestatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OrderLineStatusPK.class, id -> new com.echothree.model.data.order.common.pk.OrderLineStatusPK(id), primaryKey -> primaryKey.getEntityId())); 061 062 /** 063 * The column <code>orderlinestatuses.ordlst_ordl_orderlineid</code>. 064 */ 065 public final TableField<com.echothree.model.jooq.server.records.order.OrderLineStatuses, OrderLinePK> ORDER_LINE = createField(DSL.name("ordlst_ordl_orderlineid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OrderLinePK.class, id -> new com.echothree.model.data.order.common.pk.OrderLinePK(id), primaryKey -> primaryKey.getEntityId())); 066 067 /** 068 * The column 069 * <code>orderlinestatuses.ordlst_orderlineadjustmentsequence</code>. 070 */ 071 public final TableField<com.echothree.model.jooq.server.records.order.OrderLineStatuses, Integer> ORDER_LINE_ADJUSTMENT_SEQUENCE = createField(DSL.name("ordlst_orderlineadjustmentsequence"), SQLDataType.INTEGER.nullable(false), this, ""); 072 073 private OrderLineStatuses(Name alias, Table<com.echothree.model.jooq.server.records.order.OrderLineStatuses> aliased) { 074 this(alias, aliased, (Field<?>[]) null, null); 075 } 076 077 private OrderLineStatuses(Name alias, Table<com.echothree.model.jooq.server.records.order.OrderLineStatuses> aliased, Field<?>[] parameters, Condition where) { 078 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 079 } 080 081 /** 082 * Create an aliased <code>orderlinestatuses</code> table reference 083 */ 084 public OrderLineStatuses(String alias) { 085 this(DSL.name(alias), OrderLineStatuses); 086 } 087 088 /** 089 * Create an aliased <code>orderlinestatuses</code> table reference 090 */ 091 public OrderLineStatuses(Name alias) { 092 this(alias, OrderLineStatuses); 093 } 094 095 /** 096 * Create a <code>orderlinestatuses</code> table reference 097 */ 098 public OrderLineStatuses() { 099 this(DSL.name("orderlinestatuses"), null); 100 } 101 102 @Override 103 public UniqueKey<com.echothree.model.jooq.server.records.order.OrderLineStatuses> getPrimaryKey() { 104 return KeyRegistry.ORDER_LINE_STATUSES_PK; 105 } 106 107 @Override 108 public List<UniqueKey<com.echothree.model.jooq.server.records.order.OrderLineStatuses>> getUniqueKeys() { 109 return Arrays.asList(KeyRegistry.ORDER_LINE_STATUSES_ORDER_LINE_UK); 110 } 111 112 @Override 113 public List<ForeignKey<com.echothree.model.jooq.server.records.order.OrderLineStatuses, ?>> getReferences() { 114 return Arrays.asList(KeyRegistry.ORDER_LINE_STATUSES_ORDER_LINE_FK); 115 } 116 117 private transient OrderLinesPath _ordlst_ordl_orderlineid_fk; 118 119 /** 120 * Get the implicit join path to the <code>orderlines</code> table. 121 */ 122 public OrderLinesPath ordlst_ordl_orderlineid_fk() { 123 if (_ordlst_ordl_orderlineid_fk == null) 124 _ordlst_ordl_orderlineid_fk = new OrderLinesPath(this, KeyRegistry.ORDER_LINE_STATUSES_ORDER_LINE_FK, null); 125 126 return _ordlst_ordl_orderlineid_fk; 127 } 128 129 @Override 130 public OrderLineStatuses as(String alias) { 131 return new OrderLineStatuses(DSL.name(alias), this); 132 } 133 134 @Override 135 public OrderLineStatuses as(Name alias) { 136 return new OrderLineStatuses(alias, this); 137 } 138 139 @Override 140 public OrderLineStatuses as(Table<?> alias) { 141 return new OrderLineStatuses(alias.getQualifiedName(), this); 142 } 143 144 /** 145 * Rename this table 146 */ 147 @Override 148 public OrderLineStatuses rename(String name) { 149 return new OrderLineStatuses(DSL.name(name), null); 150 } 151 152 /** 153 * Rename this table 154 */ 155 @Override 156 public OrderLineStatuses rename(Name name) { 157 return new OrderLineStatuses(name, null); 158 } 159 160 /** 161 * Rename this table 162 */ 163 @Override 164 public OrderLineStatuses rename(Table<?> name) { 165 return new OrderLineStatuses(name.getQualifiedName(), null); 166 } 167 168 /** 169 * Create an inline derived table from this table 170 */ 171 @Override 172 public OrderLineStatuses where(Condition condition) { 173 return new OrderLineStatuses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 174 } 175 176 /** 177 * Create an inline derived table from this table 178 */ 179 @Override 180 public OrderLineStatuses where(Collection<? extends Condition> conditions) { 181 return where(DSL.and(conditions)); 182 } 183 184 /** 185 * Create an inline derived table from this table 186 */ 187 @Override 188 public OrderLineStatuses where(Condition... conditions) { 189 return where(DSL.and(conditions)); 190 } 191 192 /** 193 * Create an inline derived table from this table 194 */ 195 @Override 196 public OrderLineStatuses where(Field<Boolean> condition) { 197 return where(DSL.condition(condition)); 198 } 199 200 /** 201 * Create an inline derived table from this table 202 */ 203 @Override 204 @PlainSQL 205 public OrderLineStatuses where(SQL condition) { 206 return where(DSL.condition(condition)); 207 } 208 209 /** 210 * Create an inline derived table from this table 211 */ 212 @Override 213 @PlainSQL 214 public OrderLineStatuses where(@Stringly.SQL String condition) { 215 return where(DSL.condition(condition)); 216 } 217 218 /** 219 * Create an inline derived table from this table 220 */ 221 @Override 222 @PlainSQL 223 public OrderLineStatuses where(@Stringly.SQL String condition, Object... binds) { 224 return where(DSL.condition(condition, binds)); 225 } 226 227 /** 228 * Create an inline derived table from this table 229 */ 230 @Override 231 @PlainSQL 232 public OrderLineStatuses where(@Stringly.SQL String condition, QueryPart... parts) { 233 return where(DSL.condition(condition, parts)); 234 } 235 236 /** 237 * Create an inline derived table from this table 238 */ 239 @Override 240 public OrderLineStatuses whereExists(TableLike<?> select) { 241 return where(DSL.exists(select)); 242 } 243 244 /** 245 * Create an inline derived table from this table 246 */ 247 @Override 248 public OrderLineStatuses whereNotExists(TableLike<?> select) { 249 return where(DSL.notExists(select)); 250 } 251}