Source code

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