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.party.common.pk.PartyRelationshipPK; 009import com.echothree.model.data.user.common.pk.UserSessionPK; 010import com.echothree.model.data.user.common.pk.UserVisitPK; 011import com.echothree.model.jooq.server.KeyRegistry; 012import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath; 013import com.echothree.model.jooq.server.tables.party.PartyRelationships.PartyRelationshipsPath; 014import com.echothree.model.jooq.server.tables.user.UserVisits.UserVisitsPath; 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.Name; 025import org.jooq.PlainSQL; 026import org.jooq.QueryPart; 027import org.jooq.SQL; 028import org.jooq.Stringly; 029import org.jooq.Table; 030import org.jooq.TableField; 031import org.jooq.TableLike; 032import org.jooq.TableOptions; 033import org.jooq.UniqueKey; 034import org.jooq.impl.DSL; 035import org.jooq.impl.Internal; 036import org.jooq.impl.SQLDataType; 037import org.jooq.impl.TableImpl; 038 039 040/** 041 * This class is generated by jOOQ. 042 */ 043@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 044public class UserSessions extends TableImpl<com.echothree.model.jooq.server.records.user.UserSessions> { 045 046 private static final long serialVersionUID = 1L; 047 048 /** 049 * The reference instance of <code>usersessions</code> 050 */ 051 public static final UserSessions UserSessions = new UserSessions(); 052 053 /** 054 * The class holding records for this type 055 */ 056 @Override 057 public Class<com.echothree.model.jooq.server.records.user.UserSessions> getRecordType() { 058 return com.echothree.model.jooq.server.records.user.UserSessions.class; 059 } 060 061 /** 062 * The column <code>usersessions.usess_usersessionid</code>. 063 */ 064 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, UserSessionPK> USER_SESSION = createField(DSL.name("usess_usersessionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserSessionPK.class, id -> new com.echothree.model.data.user.common.pk.UserSessionPK(id), primaryKey -> primaryKey.getEntityId())); 065 066 /** 067 * The column <code>usersessions.usess_uvis_uservisitid</code>. 068 */ 069 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, UserVisitPK> USER_VISIT = createField(DSL.name("usess_uvis_uservisitid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserVisitPK.class, id -> new com.echothree.model.data.user.common.pk.UserVisitPK(id), primaryKey -> primaryKey.getEntityId())); 070 071 /** 072 * The column <code>usersessions.usess_par_partyid</code>. 073 */ 074 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, PartyPK> PARTY = createField(DSL.name("usess_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())); 075 076 /** 077 * The column <code>usersessions.usess_prel_partyrelationshipid</code>. 078 */ 079 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, PartyRelationshipPK> PARTY_RELATIONSHIP = createField(DSL.name("usess_prel_partyrelationshipid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyRelationshipPK.class, id -> new com.echothree.model.data.party.common.pk.PartyRelationshipPK(id), primaryKey -> primaryKey.getEntityId())); 080 081 /** 082 * The column <code>usersessions.usess_identityverifiedtime</code>. 083 */ 084 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, Long> IDENTITY_VERIFIED_TIME = createField(DSL.name("usess_identityverifiedtime"), SQLDataType.BIGINT, this, ""); 085 086 /** 087 * The column <code>usersessions.usess_fromtime</code>. 088 */ 089 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, Long> FROM_TIME = createField(DSL.name("usess_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 090 091 /** 092 * The column <code>usersessions.usess_thrutime</code>. 093 */ 094 public final TableField<com.echothree.model.jooq.server.records.user.UserSessions, Long> THRU_TIME = createField(DSL.name("usess_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 095 096 private UserSessions(Name alias, Table<com.echothree.model.jooq.server.records.user.UserSessions> aliased) { 097 this(alias, aliased, (Field<?>[]) null, null); 098 } 099 100 private UserSessions(Name alias, Table<com.echothree.model.jooq.server.records.user.UserSessions> aliased, Field<?>[] parameters, Condition where) { 101 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 102 } 103 104 /** 105 * Create an aliased <code>usersessions</code> table reference 106 */ 107 public UserSessions(String alias) { 108 this(DSL.name(alias), UserSessions); 109 } 110 111 /** 112 * Create an aliased <code>usersessions</code> table reference 113 */ 114 public UserSessions(Name alias) { 115 this(alias, UserSessions); 116 } 117 118 /** 119 * Create a <code>usersessions</code> table reference 120 */ 121 public UserSessions() { 122 this(DSL.name("usersessions"), null); 123 } 124 125 @Override 126 public UniqueKey<com.echothree.model.jooq.server.records.user.UserSessions> getPrimaryKey() { 127 return KeyRegistry.USER_SESSIONS_PK; 128 } 129 130 @Override 131 public List<UniqueKey<com.echothree.model.jooq.server.records.user.UserSessions>> getUniqueKeys() { 132 return Arrays.asList(KeyRegistry.USER_SESSIONS_USER_VISIT_AND_THRU_TIME_UK); 133 } 134 135 @Override 136 public List<ForeignKey<com.echothree.model.jooq.server.records.user.UserSessions, ?>> getReferences() { 137 return Arrays.asList(KeyRegistry.USER_SESSIONS_PARTY_FK, KeyRegistry.USER_SESSIONS_PARTY_RELATIONSHIP_FK, KeyRegistry.USER_SESSIONS_USER_VISIT_FK); 138 } 139 140 private transient PartiesPath _usess_par_partyid_fk; 141 142 /** 143 * Get the implicit join path to the <code>parties</code> table. 144 */ 145 public PartiesPath usess_par_partyid_fk() { 146 if (_usess_par_partyid_fk == null) 147 _usess_par_partyid_fk = new PartiesPath(this, KeyRegistry.USER_SESSIONS_PARTY_FK, null); 148 149 return _usess_par_partyid_fk; 150 } 151 152 private transient PartyRelationshipsPath _usess_prel_partyrelationshipid_fk; 153 154 /** 155 * Get the implicit join path to the <code>partyrelationships</code> table. 156 */ 157 public PartyRelationshipsPath usess_prel_partyrelationshipid_fk() { 158 if (_usess_prel_partyrelationshipid_fk == null) 159 _usess_prel_partyrelationshipid_fk = new PartyRelationshipsPath(this, KeyRegistry.USER_SESSIONS_PARTY_RELATIONSHIP_FK, null); 160 161 return _usess_prel_partyrelationshipid_fk; 162 } 163 164 private transient UserVisitsPath _usess_uvis_uservisitid_fk; 165 166 /** 167 * Get the implicit join path to the <code>uservisits</code> table. 168 */ 169 public UserVisitsPath usess_uvis_uservisitid_fk() { 170 if (_usess_uvis_uservisitid_fk == null) 171 _usess_uvis_uservisitid_fk = new UserVisitsPath(this, KeyRegistry.USER_SESSIONS_USER_VISIT_FK, null); 172 173 return _usess_uvis_uservisitid_fk; 174 } 175 176 @Override 177 public UserSessions as(String alias) { 178 return new UserSessions(DSL.name(alias), this); 179 } 180 181 @Override 182 public UserSessions as(Name alias) { 183 return new UserSessions(alias, this); 184 } 185 186 @Override 187 public UserSessions as(Table<?> alias) { 188 return new UserSessions(alias.getQualifiedName(), this); 189 } 190 191 /** 192 * Rename this table 193 */ 194 @Override 195 public UserSessions rename(String name) { 196 return new UserSessions(DSL.name(name), null); 197 } 198 199 /** 200 * Rename this table 201 */ 202 @Override 203 public UserSessions rename(Name name) { 204 return new UserSessions(name, null); 205 } 206 207 /** 208 * Rename this table 209 */ 210 @Override 211 public UserSessions rename(Table<?> name) { 212 return new UserSessions(name.getQualifiedName(), null); 213 } 214 215 /** 216 * Create an inline derived table from this table 217 */ 218 @Override 219 public UserSessions where(Condition condition) { 220 return new UserSessions(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 221 } 222 223 /** 224 * Create an inline derived table from this table 225 */ 226 @Override 227 public UserSessions where(Collection<? extends Condition> conditions) { 228 return where(DSL.and(conditions)); 229 } 230 231 /** 232 * Create an inline derived table from this table 233 */ 234 @Override 235 public UserSessions where(Condition... conditions) { 236 return where(DSL.and(conditions)); 237 } 238 239 /** 240 * Create an inline derived table from this table 241 */ 242 @Override 243 public UserSessions where(Field<Boolean> condition) { 244 return where(DSL.condition(condition)); 245 } 246 247 /** 248 * Create an inline derived table from this table 249 */ 250 @Override 251 @PlainSQL 252 public UserSessions where(SQL condition) { 253 return where(DSL.condition(condition)); 254 } 255 256 /** 257 * Create an inline derived table from this table 258 */ 259 @Override 260 @PlainSQL 261 public UserSessions where(@Stringly.SQL String condition) { 262 return where(DSL.condition(condition)); 263 } 264 265 /** 266 * Create an inline derived table from this table 267 */ 268 @Override 269 @PlainSQL 270 public UserSessions where(@Stringly.SQL String condition, Object... binds) { 271 return where(DSL.condition(condition, binds)); 272 } 273 274 /** 275 * Create an inline derived table from this table 276 */ 277 @Override 278 @PlainSQL 279 public UserSessions where(@Stringly.SQL String condition, QueryPart... parts) { 280 return where(DSL.condition(condition, parts)); 281 } 282 283 /** 284 * Create an inline derived table from this table 285 */ 286 @Override 287 public UserSessions whereExists(TableLike<?> select) { 288 return where(DSL.exists(select)); 289 } 290 291 /** 292 * Create an inline derived table from this table 293 */ 294 @Override 295 public UserSessions whereNotExists(TableLike<?> select) { 296 return where(DSL.notExists(select)); 297 } 298}