001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.user; 005 006 007import com.echothree.model.data.party.common.pk.PartyPK; 008import com.echothree.model.data.user.common.pk.UserLoginStatusPK; 009import com.echothree.model.jooq.server.KeyRegistry; 010import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath; 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 UserLoginStatuses extends TableImpl<com.echothree.model.jooq.server.records.user.UserLoginStatuses> { 041 042 private static final long serialVersionUID = 1L; 043 044 /** 045 * The reference instance of <code>userloginstatuses</code> 046 */ 047 public static final UserLoginStatuses UserLoginStatuses = new UserLoginStatuses(); 048 049 /** 050 * The class holding records for this type 051 */ 052 @Override 053 public Class<com.echothree.model.jooq.server.records.user.UserLoginStatuses> getRecordType() { 054 return com.echothree.model.jooq.server.records.user.UserLoginStatuses.class; 055 } 056 057 /** 058 * The column <code>userloginstatuses.ulogst_userloginstatusid</code>. 059 */ 060 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, UserLoginStatusPK> USER_LOGIN_STATUS = createField(DSL.name("ulogst_userloginstatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserLoginStatusPK.class, id -> new com.echothree.model.data.user.common.pk.UserLoginStatusPK(id), primaryKey -> primaryKey.getEntityId())); 061 062 /** 063 * The column <code>userloginstatuses.ulogst_par_partyid</code>. 064 */ 065 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, PartyPK> PARTY = createField(DSL.name("ulogst_par_partyid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyPK.class, id -> new com.echothree.model.data.party.common.pk.PartyPK(id), primaryKey -> primaryKey.getEntityId())); 066 067 /** 068 * The column <code>userloginstatuses.ulogst_lastlogintime</code>. 069 */ 070 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Long> LAST_LOGIN_TIME = createField(DSL.name("ulogst_lastlogintime"), SQLDataType.BIGINT, this, ""); 071 072 /** 073 * The column <code>userloginstatuses.ulogst_failurecount</code>. 074 */ 075 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Integer> FAILURE_COUNT = createField(DSL.name("ulogst_failurecount"), SQLDataType.INTEGER.nullable(false), this, ""); 076 077 /** 078 * The column <code>userloginstatuses.ulogst_firstfailuretime</code>. 079 */ 080 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Long> FIRST_FAILURE_TIME = createField(DSL.name("ulogst_firstfailuretime"), SQLDataType.BIGINT, this, ""); 081 082 /** 083 * The column <code>userloginstatuses.ulogst_lastfailuretime</code>. 084 */ 085 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Long> LAST_FAILURE_TIME = createField(DSL.name("ulogst_lastfailuretime"), SQLDataType.BIGINT, this, ""); 086 087 /** 088 * The column <code>userloginstatuses.ulogst_expiredcount</code>. 089 */ 090 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Integer> EXPIRED_COUNT = createField(DSL.name("ulogst_expiredcount"), SQLDataType.INTEGER.nullable(false), this, ""); 091 092 /** 093 * The column <code>userloginstatuses.ulogst_forcechange</code>. 094 */ 095 public final TableField<com.echothree.model.jooq.server.records.user.UserLoginStatuses, Boolean> FORCE_CHANGE = createField(DSL.name("ulogst_forcechange"), SQLDataType.BIT.nullable(false), this, ""); 096 097 private UserLoginStatuses(Name alias, Table<com.echothree.model.jooq.server.records.user.UserLoginStatuses> aliased) { 098 this(alias, aliased, (Field<?>[]) null, null); 099 } 100 101 private UserLoginStatuses(Name alias, Table<com.echothree.model.jooq.server.records.user.UserLoginStatuses> aliased, Field<?>[] parameters, Condition where) { 102 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 103 } 104 105 /** 106 * Create an aliased <code>userloginstatuses</code> table reference 107 */ 108 public UserLoginStatuses(String alias) { 109 this(DSL.name(alias), UserLoginStatuses); 110 } 111 112 /** 113 * Create an aliased <code>userloginstatuses</code> table reference 114 */ 115 public UserLoginStatuses(Name alias) { 116 this(alias, UserLoginStatuses); 117 } 118 119 /** 120 * Create a <code>userloginstatuses</code> table reference 121 */ 122 public UserLoginStatuses() { 123 this(DSL.name("userloginstatuses"), null); 124 } 125 126 @Override 127 public UniqueKey<com.echothree.model.jooq.server.records.user.UserLoginStatuses> getPrimaryKey() { 128 return KeyRegistry.USER_LOGIN_STATUSES_PK; 129 } 130 131 @Override 132 public List<UniqueKey<com.echothree.model.jooq.server.records.user.UserLoginStatuses>> getUniqueKeys() { 133 return Arrays.asList(KeyRegistry.USER_LOGIN_STATUSES_PARTY_UK); 134 } 135 136 @Override 137 public List<ForeignKey<com.echothree.model.jooq.server.records.user.UserLoginStatuses, ?>> getReferences() { 138 return Arrays.asList(KeyRegistry.USER_LOGIN_STATUSES_PARTY_FK); 139 } 140 141 private transient PartiesPath _ulogst_par_partyid_fk; 142 143 /** 144 * Get the implicit join path to the <code>parties</code> table. 145 */ 146 public PartiesPath ulogst_par_partyid_fk() { 147 if (_ulogst_par_partyid_fk == null) 148 _ulogst_par_partyid_fk = new PartiesPath(this, KeyRegistry.USER_LOGIN_STATUSES_PARTY_FK, null); 149 150 return _ulogst_par_partyid_fk; 151 } 152 153 @Override 154 public UserLoginStatuses as(String alias) { 155 return new UserLoginStatuses(DSL.name(alias), this); 156 } 157 158 @Override 159 public UserLoginStatuses as(Name alias) { 160 return new UserLoginStatuses(alias, this); 161 } 162 163 @Override 164 public UserLoginStatuses as(Table<?> alias) { 165 return new UserLoginStatuses(alias.getQualifiedName(), this); 166 } 167 168 /** 169 * Rename this table 170 */ 171 @Override 172 public UserLoginStatuses rename(String name) { 173 return new UserLoginStatuses(DSL.name(name), null); 174 } 175 176 /** 177 * Rename this table 178 */ 179 @Override 180 public UserLoginStatuses rename(Name name) { 181 return new UserLoginStatuses(name, null); 182 } 183 184 /** 185 * Rename this table 186 */ 187 @Override 188 public UserLoginStatuses rename(Table<?> name) { 189 return new UserLoginStatuses(name.getQualifiedName(), null); 190 } 191 192 /** 193 * Create an inline derived table from this table 194 */ 195 @Override 196 public UserLoginStatuses where(Condition condition) { 197 return new UserLoginStatuses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 198 } 199 200 /** 201 * Create an inline derived table from this table 202 */ 203 @Override 204 public UserLoginStatuses where(Collection<? extends Condition> conditions) { 205 return where(DSL.and(conditions)); 206 } 207 208 /** 209 * Create an inline derived table from this table 210 */ 211 @Override 212 public UserLoginStatuses where(Condition... conditions) { 213 return where(DSL.and(conditions)); 214 } 215 216 /** 217 * Create an inline derived table from this table 218 */ 219 @Override 220 public UserLoginStatuses where(Field<Boolean> condition) { 221 return where(DSL.condition(condition)); 222 } 223 224 /** 225 * Create an inline derived table from this table 226 */ 227 @Override 228 @PlainSQL 229 public UserLoginStatuses where(SQL condition) { 230 return where(DSL.condition(condition)); 231 } 232 233 /** 234 * Create an inline derived table from this table 235 */ 236 @Override 237 @PlainSQL 238 public UserLoginStatuses where(@Stringly.SQL String condition) { 239 return where(DSL.condition(condition)); 240 } 241 242 /** 243 * Create an inline derived table from this table 244 */ 245 @Override 246 @PlainSQL 247 public UserLoginStatuses where(@Stringly.SQL String condition, Object... binds) { 248 return where(DSL.condition(condition, binds)); 249 } 250 251 /** 252 * Create an inline derived table from this table 253 */ 254 @Override 255 @PlainSQL 256 public UserLoginStatuses where(@Stringly.SQL String condition, QueryPart... parts) { 257 return where(DSL.condition(condition, parts)); 258 } 259 260 /** 261 * Create an inline derived table from this table 262 */ 263 @Override 264 public UserLoginStatuses whereExists(TableLike<?> select) { 265 return where(DSL.exists(select)); 266 } 267 268 /** 269 * Create an inline derived table from this table 270 */ 271 @Override 272 public UserLoginStatuses whereNotExists(TableLike<?> select) { 273 return where(DSL.notExists(select)); 274 } 275}