private Select<? extends Record> getAllTimestampsQuerySomeColumns(DSLContext ctx, TableReference tableRef, Select<Record1<byte[]>> subQuery, Collection<byte[]> cols, long timestamp) { return ctx.select(A_ROW_NAME, A_COL_NAME, A_TIMESTAMP) .from(atlasTable(tableRef).as(ATLAS_TABLE)) .where(A_ROW_NAME.in(subQuery) .and(A_COL_NAME.in(cols))) .and(A_TIMESTAMP.lessThan(timestamp)); }
private Select<? extends Record> getLatestTimestampQuerySomeColumns(DSLContext ctx, TableReference tableRef, Collection<byte[]> rows, Collection<byte[]> cols, long timestamp) { return ctx.select(A_ROW_NAME, A_COL_NAME, DSL.max(A_TIMESTAMP).as(MAX_TIMESTAMP)) .from(atlasTable(tableRef).as(ATLAS_TABLE)) .where(A_ROW_NAME.in(rows) .and(A_COL_NAME.in(cols))) .and(A_TIMESTAMP.lessThan(timestamp)) .groupBy(A_ROW_NAME, A_COL_NAME); }
private Select<? extends Record> getLatestTimestampQuerySomeColumnsSubQuery(DSLContext ctx, TableReference tableRef, Select<Record1<byte[]>> subQuery, Collection<byte[]> cols, long timestamp) { return ctx.select(A_ROW_NAME, A_COL_NAME, DSL.max(A_TIMESTAMP).as(MAX_TIMESTAMP)) .from(atlasTable(tableRef).as(ATLAS_TABLE)) .where(A_ROW_NAME.in(subQuery) .and(A_COL_NAME.in(cols))) .and(A_TIMESTAMP.lessThan(timestamp)) .groupBy(A_ROW_NAME, A_COL_NAME); }
@Override public AuthToken getTokenByAccountId(long accountId) { return create() .selectFrom(AUTH_TOKEN) .where(AUTH_TOKEN.ACCOUNT_ID.eq(accountId)) .and(AUTH_TOKEN.VERSION.eq(SecurityConstants.TOKEN_VERSION)) .and(AUTH_TOKEN.PROVIDER.eq(SecurityConstants.AUTH_PROVIDER.get())) .and(AUTH_TOKEN.EXPIRES.greaterThan(new Date())) .orderBy(AUTH_TOKEN.EXPIRES.desc()).fetchAny(); }
@Override public List<? extends ServiceExposeMap> getInstancesSetForUpgrade(long serviceId) { return create() .select(SERVICE_EXPOSE_MAP.fields()) .from(SERVICE_EXPOSE_MAP) .where(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(serviceId)) .and(SERVICE_EXPOSE_MAP.MANAGED.eq(false)) .and(SERVICE_EXPOSE_MAP.UPGRADE.eq(true)) .and(SERVICE_EXPOSE_MAP.STATE.in(CommonStatesConstants.ACTIVATING, CommonStatesConstants.ACTIVE, CommonStatesConstants.REQUESTED)) .fetchInto(ServiceExposeMapRecord.class); } }
@Override public List<? extends ProjectMember> getActiveProjectMembers(long id) { return create() .selectFrom(PROJECT_MEMBER) .where(PROJECT_MEMBER.PROJECT_ID.eq(id)) .and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE)) .and(PROJECT_MEMBER.REMOVED.isNull()) .orderBy(PROJECT_MEMBER.ID.asc()).fetch(); }
@Override public List<? extends StoragePool> findStoragePoolByDriverName(Long accountId, String driverName) { return create().selectFrom(STORAGE_POOL) .where(STORAGE_POOL.ACCOUNT_ID.eq(accountId)) .and((STORAGE_POOL.REMOVED.isNull().or(STORAGE_POOL.STATE.eq(CommonStatesConstants.REMOVING)))) .and(STORAGE_POOL.DRIVER_NAME.eq(driverName)) .fetchInto(StoragePoolRecord.class); }
@Override public PM_R withConnection(final Connection conn) throws SQLException { return DSL.using(conn, dialect, settings) .selectFrom(paymentMethodsTable) .where(DSL.field(KB_PAYMENT_METHOD_ID).equal(kbPaymentMethodId.toString())) .and(DSL.field(IS_DELETED).equal(FALSE)) .and(DSL.field(KB_TENANT_ID).equal(kbTenantId.toString())) .orderBy(DSL.field(recordIdFieldName).desc()) .fetchOne(); } });
@Override public List<PM_R> withConnection(final Connection conn) throws SQLException { return DSL.using(conn, dialect, settings) .selectFrom(paymentMethodsTable) .where(DSL.field(KB_ACCOUNT_ID).equal(kbAccountId.toString())) .and(DSL.field(IS_DELETED).equal(FALSE)) .and(DSL.field(KB_TENANT_ID).equal(kbTenantId.toString())) .orderBy(DSL.field(recordIdFieldName).asc()) .fetch(); } });
@Override public List<? extends Service> findServicesForInstanceId(long instanceId){ return create().select(SERVICE.fields()) .from(SERVICE) .join(SERVICE_EXPOSE_MAP) .on(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(SERVICE.ID)) .where(SERVICE_EXPOSE_MAP.INSTANCE_ID.eq(instanceId)) .and(SERVICE_EXPOSE_MAP.REMOVED.isNull()) .and(SERVICE.REMOVED.isNull()) .fetchInto(ServiceRecord.class); }
@Override public List<RESP_R> withConnection(final Connection conn) throws SQLException { return DSL.using(conn, dialect, settings) .selectFrom(responsesTable) .where(DSL.field(KB_PAYMENT_ID).equal(kbPaymentId.toString())) .and(DSL.field(KB_TENANT_ID).equal(kbTenantId.toString())) .orderBy(DSL.field(recordIdFieldName).asc()) .fetch(); } });
@Override public List<Label> getLabelsForHost(Long hostId) { return create() .select(LABEL.fields()) .from(LABEL) .join(HOST_LABEL_MAP) .on(HOST_LABEL_MAP.LABEL_ID.eq(LABEL.ID)) .where(HOST_LABEL_MAP.HOST_ID.eq(hostId)) .and(LABEL.REMOVED.isNull()) .and(HOST_LABEL_MAP.REMOVED.isNull()) .fetchInto(Label.class); } }
public boolean hasUser(DSLContext tx, UUID teamId, UUID userId, TeamRole... roles) { SelectConditionStep<UserTeamsRecord> q = tx.selectFrom(USER_TEAMS) .where(USER_TEAMS.TEAM_ID.eq(teamId) .and(USER_TEAMS.USER_ID.eq(userId))); if (roles != null && roles.length != 0) { q.and(USER_TEAMS.TEAM_ROLE.in(Utils.toString(roles))); } return tx.fetchExists(q); }
@Override public List<? extends ServiceExposeMap> getNonRemovedServiceIpMaps(long serviceId) { return create() .select(SERVICE_EXPOSE_MAP.fields()) .from(SERVICE_EXPOSE_MAP) .where(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(serviceId)) .and(SERVICE_EXPOSE_MAP.REMOVED.isNull() .and(SERVICE_EXPOSE_MAP.STATE.notIn(CommonStatesConstants.REMOVED, CommonStatesConstants.REMOVING)) .and(SERVICE_EXPOSE_MAP.IP_ADDRESS.isNotNull())) .fetchInto(ServiceExposeMapRecord.class); }
@Override public List<? extends ServiceExposeMap> getNonRemovedServiceHostnameMaps(long serviceId) { return create() .select(SERVICE_EXPOSE_MAP.fields()) .from(SERVICE_EXPOSE_MAP) .where(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(serviceId)) .and(SERVICE_EXPOSE_MAP.REMOVED.isNull() .and(SERVICE_EXPOSE_MAP.STATE.notIn(CommonStatesConstants.REMOVED, CommonStatesConstants.REMOVING)) .and(SERVICE_EXPOSE_MAP.HOST_NAME.isNotNull())) .fetchInto(ServiceExposeMapRecord.class); }
private List<String> enumLabels(String nspname, String typname, Field<?> orderBy) { return create().select(PG_ENUM.ENUMLABEL) .from(PG_ENUM) .join(PG_TYPE).on(PG_ENUM.ENUMTYPID.eq(oid(PG_TYPE))) .join(PG_NAMESPACE).on(PG_TYPE.TYPNAMESPACE.eq(oid(PG_NAMESPACE))) .where(PG_NAMESPACE.NSPNAME.eq(nspname)) .and(PG_TYPE.TYPNAME.eq(typname)) .orderBy(orderBy) .fetch(PG_ENUM.ENUMLABEL); } }