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.UserLoginPasswordPK;
009import com.echothree.model.data.user.common.pk.UserLoginPasswordTypePK;
010import com.echothree.model.jooq.server.KeyRegistry;
011import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath;
012import com.echothree.model.jooq.server.tables.user.UserLoginPasswordTypes.UserLoginPasswordTypesPath;
013
014import java.util.Arrays;
015import java.util.Collection;
016import java.util.List;
017
018import org.jooq.Condition;
019import org.jooq.Converter;
020import org.jooq.Field;
021import org.jooq.ForeignKey;
022import org.jooq.InverseForeignKey;
023import org.jooq.Name;
024import org.jooq.Path;
025import org.jooq.PlainSQL;
026import org.jooq.QueryPart;
027import org.jooq.Record;
028import org.jooq.SQL;
029import org.jooq.Stringly;
030import org.jooq.Table;
031import org.jooq.TableField;
032import org.jooq.TableLike;
033import org.jooq.TableOptions;
034import org.jooq.UniqueKey;
035import org.jooq.impl.DSL;
036import org.jooq.impl.Internal;
037import org.jooq.impl.SQLDataType;
038import org.jooq.impl.TableImpl;
039
040
041/**
042 * This class is generated by jOOQ.
043 */
044@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
045public class UserLoginPasswords extends TableImpl<com.echothree.model.jooq.server.records.user.UserLoginPasswords> {
046
047    private static final long serialVersionUID = 1L;
048
049    /**
050     * The reference instance of <code>userloginpasswords</code>
051     */
052    public static final UserLoginPasswords UserLoginPasswords = new UserLoginPasswords();
053
054    /**
055     * The class holding records for this type
056     */
057    @Override
058    public Class<com.echothree.model.jooq.server.records.user.UserLoginPasswords> getRecordType() {
059        return com.echothree.model.jooq.server.records.user.UserLoginPasswords.class;
060    }
061
062    /**
063     * The column <code>userloginpasswords.ulogp_userloginpasswordid</code>.
064     */
065    public final TableField<com.echothree.model.jooq.server.records.user.UserLoginPasswords, UserLoginPasswordPK> USER_LOGIN_PASSWORD = createField(DSL.name("ulogp_userloginpasswordid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserLoginPasswordPK.class, id -> new com.echothree.model.data.user.common.pk.UserLoginPasswordPK(id), primaryKey -> primaryKey.getEntityId()));
066
067    /**
068     * The column <code>userloginpasswords.ulogp_par_partyid</code>.
069     */
070    public final TableField<com.echothree.model.jooq.server.records.user.UserLoginPasswords, PartyPK> PARTY = createField(DSL.name("ulogp_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()));
071
072    /**
073     * The column
074     * <code>userloginpasswords.ulogp_ulogpt_userloginpasswordtypeid</code>.
075     */
076    public final TableField<com.echothree.model.jooq.server.records.user.UserLoginPasswords, UserLoginPasswordTypePK> USER_LOGIN_PASSWORD_TYPE = createField(DSL.name("ulogp_ulogpt_userloginpasswordtypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserLoginPasswordTypePK.class, id -> new com.echothree.model.data.user.common.pk.UserLoginPasswordTypePK(id), primaryKey -> primaryKey.getEntityId()));
077
078    /**
079     * The column <code>userloginpasswords.ulogp_fromtime</code>.
080     */
081    public final TableField<com.echothree.model.jooq.server.records.user.UserLoginPasswords, Long> FROM_TIME = createField(DSL.name("ulogp_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
082
083    /**
084     * The column <code>userloginpasswords.ulogp_thrutime</code>.
085     */
086    public final TableField<com.echothree.model.jooq.server.records.user.UserLoginPasswords, Long> THRU_TIME = createField(DSL.name("ulogp_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
087
088    private UserLoginPasswords(Name alias, Table<com.echothree.model.jooq.server.records.user.UserLoginPasswords> aliased) {
089        this(alias, aliased, (Field<?>[]) null, null);
090    }
091
092    private UserLoginPasswords(Name alias, Table<com.echothree.model.jooq.server.records.user.UserLoginPasswords> aliased, Field<?>[] parameters, Condition where) {
093        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
094    }
095
096    /**
097     * Create an aliased <code>userloginpasswords</code> table reference
098     */
099    public UserLoginPasswords(String alias) {
100        this(DSL.name(alias), UserLoginPasswords);
101    }
102
103    /**
104     * Create an aliased <code>userloginpasswords</code> table reference
105     */
106    public UserLoginPasswords(Name alias) {
107        this(alias, UserLoginPasswords);
108    }
109
110    /**
111     * Create a <code>userloginpasswords</code> table reference
112     */
113    public UserLoginPasswords() {
114        this(DSL.name("userloginpasswords"), null);
115    }
116
117    public <O extends Record> UserLoginPasswords(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.user.UserLoginPasswords> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.user.UserLoginPasswords> parentPath) {
118        super(path, childPath, parentPath, UserLoginPasswords);
119    }
120
121    /**
122     * A subtype implementing {@link Path} for simplified path-based joins.
123     */
124    public static class UserLoginPasswordsPath extends UserLoginPasswords implements Path<com.echothree.model.jooq.server.records.user.UserLoginPasswords> {
125
126        private static final long serialVersionUID = 1L;
127        public <O extends Record> UserLoginPasswordsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.user.UserLoginPasswords> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.user.UserLoginPasswords> parentPath) {
128            super(path, childPath, parentPath);
129        }
130        private UserLoginPasswordsPath(Name alias, Table<com.echothree.model.jooq.server.records.user.UserLoginPasswords> aliased) {
131            super(alias, aliased);
132        }
133
134        @Override
135        public UserLoginPasswordsPath as(String alias) {
136            return new UserLoginPasswordsPath(DSL.name(alias), this);
137        }
138
139        @Override
140        public UserLoginPasswordsPath as(Name alias) {
141            return new UserLoginPasswordsPath(alias, this);
142        }
143
144        @Override
145        public UserLoginPasswordsPath as(Table<?> alias) {
146            return new UserLoginPasswordsPath(alias.getQualifiedName(), this);
147        }
148    }
149
150    @Override
151    public UniqueKey<com.echothree.model.jooq.server.records.user.UserLoginPasswords> getPrimaryKey() {
152        return KeyRegistry.USER_LOGIN_PASSWORDS_PK;
153    }
154
155    @Override
156    public List<UniqueKey<com.echothree.model.jooq.server.records.user.UserLoginPasswords>> getUniqueKeys() {
157        return Arrays.asList(KeyRegistry.USER_LOGIN_PASSWORDS_PARTY_AND_USER_LOGIN_PASSWORD_TYPE_AND_THRU_TIME_UK);
158    }
159
160    @Override
161    public List<ForeignKey<com.echothree.model.jooq.server.records.user.UserLoginPasswords, ?>> getReferences() {
162        return Arrays.asList(KeyRegistry.USER_LOGIN_PASSWORDS_PARTY_FK, KeyRegistry.USER_LOGIN_PASSWORDS_USER_LOGIN_PASSWORD_TYPE_FK);
163    }
164
165    private transient PartiesPath _ulogp_par_partyid_fk;
166
167    /**
168     * Get the implicit join path to the <code>parties</code> table.
169     */
170    public PartiesPath ulogp_par_partyid_fk() {
171        if (_ulogp_par_partyid_fk == null)
172            _ulogp_par_partyid_fk = new PartiesPath(this, KeyRegistry.USER_LOGIN_PASSWORDS_PARTY_FK, null);
173
174        return _ulogp_par_partyid_fk;
175    }
176
177    private transient UserLoginPasswordTypesPath _ulogp_ulogpt_userloginpasswordtypeid_fk;
178
179    /**
180     * Get the implicit join path to the <code>userloginpasswordtypes</code>
181     * table.
182     */
183    public UserLoginPasswordTypesPath ulogp_ulogpt_userloginpasswordtypeid_fk() {
184        if (_ulogp_ulogpt_userloginpasswordtypeid_fk == null)
185            _ulogp_ulogpt_userloginpasswordtypeid_fk = new UserLoginPasswordTypesPath(this, KeyRegistry.USER_LOGIN_PASSWORDS_USER_LOGIN_PASSWORD_TYPE_FK, null);
186
187        return _ulogp_ulogpt_userloginpasswordtypeid_fk;
188    }
189
190    @Override
191    public UserLoginPasswords as(String alias) {
192        return new UserLoginPasswords(DSL.name(alias), this);
193    }
194
195    @Override
196    public UserLoginPasswords as(Name alias) {
197        return new UserLoginPasswords(alias, this);
198    }
199
200    @Override
201    public UserLoginPasswords as(Table<?> alias) {
202        return new UserLoginPasswords(alias.getQualifiedName(), this);
203    }
204
205    /**
206     * Rename this table
207     */
208    @Override
209    public UserLoginPasswords rename(String name) {
210        return new UserLoginPasswords(DSL.name(name), null);
211    }
212
213    /**
214     * Rename this table
215     */
216    @Override
217    public UserLoginPasswords rename(Name name) {
218        return new UserLoginPasswords(name, null);
219    }
220
221    /**
222     * Rename this table
223     */
224    @Override
225    public UserLoginPasswords rename(Table<?> name) {
226        return new UserLoginPasswords(name.getQualifiedName(), null);
227    }
228
229    /**
230     * Create an inline derived table from this table
231     */
232    @Override
233    public UserLoginPasswords where(Condition condition) {
234        return new UserLoginPasswords(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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords 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 UserLoginPasswords whereNotExists(TableLike<?> select) {
310        return where(DSL.notExists(select));
311    }
312}