@Override public List<? extends Service> findServicesFor(Instance instance) { 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(instance.getId())) .fetchInto(ServiceRecord.class); }
protected String get(String name) { return create() .select(DATA.VALUE) .from(DATA) .where(DATA.NAME.eq(name)) .fetchOne(DATA.VALUE); }
@Override public String getPublicCA() { Record1<String> r = create().select(CERTIFICATE.CERT_CHAIN) .from(CERTIFICATE) .join(ACCOUNT) .on(ACCOUNT.ID.eq(CERTIFICATE.ACCOUNT_ID)) .where(CERTIFICATE.STATE.eq(CommonStatesConstants.ACTIVE) .and(ACCOUNT.UUID.like("system-ha-%"))) .fetchAny(); return r == null ? null : r.value1(); }
@Override public void setIfOlder(Client client, String itemName, Long version) { create() .update(CONFIG_ITEM_STATUS) .set(CONFIG_ITEM_STATUS.REQUESTED_VERSION, version) .set(CONFIG_ITEM_STATUS.REQUESTED_UPDATED, new Timestamp(System.currentTimeMillis())) .where( CONFIG_ITEM_STATUS.REQUESTED_VERSION.lt(version) .and(CONFIG_ITEM_STATUS.NAME.eq(itemName)) .and(targetObjectCondition(client))).execute(); }
@Override public boolean isAssigned(Client client, String itemName) { ConfigItemStatus status = create() .selectFrom(CONFIG_ITEM_STATUS) .where( CONFIG_ITEM_STATUS.NAME.eq(itemName) .and(targetObjectCondition(client))) .fetchAny(); return status != null; }
@Override public Agent getAgentByUri(String uri) { return create() .selectFrom(AGENT) .where(AGENT.URI.eq(uri) .and(AGENT.REMOVED.isNull())) .fetchAny(); }
@Override public List<? extends ProjectMember> findBadProjectMembers(int count) { return create().select(PROJECT_MEMBER.fields()) .from(PROJECT_MEMBER) .join(ACCOUNT) .on(ACCOUNT.ID.eq(PROJECT_MEMBER.PROJECT_ID)) .where(ACCOUNT.STATE.eq(CommonStatesConstants.PURGED) .and(PROJECT_MEMBER.REMOVED.isNull()) .and(PROJECT_MEMBER.STATE.notIn(CommonStatesConstants.DEACTIVATING, CommonStatesConstants.REMOVING))) .limit(count) .fetchInto(ProjectMemberRecord.class); }
@Override public List<? extends Volume> findBadVolumes(int count) { return create().select(VOLUME.fields()) .from(VOLUME) .join(ACCOUNT) .on(ACCOUNT.ID.eq(VOLUME.ACCOUNT_ID)) .where(VOLUME.REMOVED.isNull() .and(ACCOUNT.STATE.eq(CommonStatesConstants.PURGED)) .and(VOLUME.STATE.notIn(CommonStatesConstants.DEACTIVATING, CommonStatesConstants.REMOVING))) .limit(count) .fetchInto(VolumeRecord.class); }
@Override public List<? extends Network> findBadNetworks(int count) { return create().select(NETWORK.fields()) .from(NETWORK) .join(ACCOUNT) .on(ACCOUNT.ID.eq(NETWORK.ACCOUNT_ID)) .where(NETWORK.REMOVED.isNull() .and(ACCOUNT.STATE.eq(CommonStatesConstants.PURGED)) .and(NETWORK.STATE.notIn(CommonStatesConstants.REMOVING))) .limit(count) .fetchInto(NetworkRecord.class); }
@Override public List<? extends UserPreference> findBadUserPreference(int count) { return create().select(USER_PREFERENCE.fields()) .from(USER_PREFERENCE) .join(ACCOUNT) .on(ACCOUNT.ID.eq(USER_PREFERENCE.ACCOUNT_ID)) .where(USER_PREFERENCE.REMOVED.isNull() .and(ACCOUNT.STATE.eq(CommonStatesConstants.PURGED)) .and(USER_PREFERENCE.STATE.notIn(CommonStatesConstants.REMOVING, CommonStatesConstants.DEACTIVATING))) .limit(count) .fetchInto(UserPreferenceRecord.class); }
@Override public Long getRequestedVersion(Client client, String itemName) { return create() .select(CONFIG_ITEM_STATUS.REQUESTED_VERSION) .from(CONFIG_ITEM_STATUS) .where( CONFIG_ITEM_STATUS.NAME.eq(itemName) .and(targetObjectCondition(client))) .fetchOneInto(Long.class); }
@Override public List<? extends Host> getNonPurgedHosts(long accountId) { return create() .select(HOST.fields()) .from(HOST) .where(HOST.ACCOUNT_ID.eq(accountId) .and(HOST.STATE.notEqual(CommonStatesConstants.PURGED))) .fetchInto(Host.class); }
@Override public List<? extends Host> getHosts(Long accountId, List<String> uuids) { return create() .selectFrom(HOST) .where(HOST.ACCOUNT_ID.eq(accountId) .and(HOST.STATE.notIn(CommonStatesConstants.REMOVED, CommonStatesConstants.REMOVING)) .and(HOST.UUID.in(uuids))).fetch(); }
@Override public Account getAccountById(Long id) { return create() .selectFrom(ACCOUNT) .where( ACCOUNT.ID.eq(id) .and(ACCOUNT.STATE.ne(CommonStatesConstants.PURGED)) .and(ACCOUNT.REMOVED.isNull()) ).fetchOne(); }
@Override public Map<String, Host> getHosts(long agentId) { List<? extends Host> hostList = create() .select(HOST.fields()) .from(HOST) .where( HOST.AGENT_ID.eq(agentId) .and(HOST.REMOVED.isNull())) .fetchInto(HostRecord.class); return groupByReportedUUid(hostList); }
@Override public Account getAccountByUuid(String uuid) { return create() .selectFrom(ACCOUNT) .where(ACCOUNT.UUID.eq(uuid) .and(ACCOUNT.STATE.in(getActiveStates()))) .orderBy(ACCOUNT.ID.asc()).limit(1).fetchOne(); }
@Override public List<? extends Service> getSkipServices(long accountId) { return create() .select(SERVICE.fields()) .from(SERVICE) .where(SERVICE.ACCOUNT_ID.eq(accountId) .and(SERVICE.REMOVED.isNull()) .and(SERVICE.SKIP.isTrue())) .fetchInto(ServiceRecord.class); }