@Override public ProjectMember getProjectMember(long id) { return create() .selectFrom(PROJECT_MEMBER) .where(PROJECT_MEMBER.ID.eq(id)).fetchOne(); }
@Override public Account findByUuid(String uuid) { return create() .selectFrom(ACCOUNT) .where(ACCOUNT.UUID.eq(uuid)) .fetchOne(); }
protected Task getTask(String name) { return create() .selectFrom(TASK) .where(TASK.NAME.eq(name)) .fetchOne(); }
@Override public List<? extends ServiceConsumeMap> findConsumingServices(long serviceId) { return create() .selectFrom(SERVICE_CONSUME_MAP) .where( SERVICE_CONSUME_MAP.CONSUMED_SERVICE_ID.eq(serviceId) .and(SERVICE_CONSUME_MAP.REMOVED.isNull())).fetchInto(ServiceConsumeMapRecord.class); }
@Override public List<? extends Agent> findAgentsToPing() { Condition c = AGENT.STATE.eq(CommonStatesConstants.ACTIVE); for (String prefix : AgentConstants.AGENT_IGNORE_PREFIXES) { c = c.and(AGENT.URI.notLike(prefix + "%")); } return create() .selectFrom(AGENT) .where(c) .fetch(); }
@Override public Agent findNonRemovedByUri(String uri) { return create() .selectFrom(AGENT) .where( AGENT.URI.eq(uri) .and(AGENT.REMOVED.isNull())) .fetchOne(); }
@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 AuthTokenRecord getTokenByKey(String key) { return create() .selectFrom(AUTH_TOKEN) .where(AUTH_TOKEN.KEY.eq(key)) .and(AUTH_TOKEN.VERSION.eq(SecurityConstants.TOKEN_VERSION)) .and(AUTH_TOKEN.EXPIRES.greaterThan(new Date())) .orderBy(AUTH_TOKEN.ID.asc()).fetchOne(); }
@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 List<? extends StoragePoolHostMap> findMapsToRemove(Long storagePoolId) { return create() .selectFrom(STORAGE_POOL_HOST_MAP) .where(STORAGE_POOL_HOST_MAP.STORAGE_POOL_ID.eq(storagePoolId) .and((STORAGE_POOL_HOST_MAP.REMOVED.isNull() .or(STORAGE_POOL_HOST_MAP.STATE.eq(CommonStatesConstants.REMOVING))))) .fetchInto(StoragePoolHostMap.class); }
@Override public List<? extends ServiceConsumeMap> findConsumedServices(long serviceId) { return create() .selectFrom(SERVICE_CONSUME_MAP) .where( SERVICE_CONSUME_MAP.SERVICE_ID.eq(serviceId) .and(SERVICE_CONSUME_MAP.REMOVED.isNull()) .and(SERVICE_CONSUME_MAP.STATE.notIn(CommonStatesConstants.REMOVING))) .fetchInto(ServiceConsumeMapRecord.class); }
@Override public Stack getStackByExternalId(Long accountId, String externalId) { return create().selectFrom(STACK) .where(STACK.ACCOUNT_ID.eq(accountId)) .and(STACK.REMOVED.isNull()) .and(STACK.EXTERNAL_ID.eq(externalId)) .fetchAny(); }
@Override public Service getServiceByExternalId(Long accountId, String externalId) { return create().selectFrom(SERVICE) .where(SERVICE.ACCOUNT_ID.eq(accountId)) .and(SERVICE.REMOVED.isNull()) .and(SERVICE.EXTERNAL_ID.eq(externalId)) .fetchAny(); }
@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 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 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 Account getAccountByExternalId(String externalId, String externalType) { return create() .selectFrom(ACCOUNT) .where( ACCOUNT.EXTERNAL_ID.eq(externalId) .and(ACCOUNT.EXTERNAL_ID_TYPE.eq(externalType)) .and(ACCOUNT.STATE.ne("purged")) ).orderBy(ACCOUNT.ID.asc()).fetchOne(); }
@Override public Account getAdminAccountExclude(long accountId) { return create() .selectFrom(ACCOUNT) .where(ACCOUNT.STATE.in(getAccountActiveStates()) .and(ACCOUNT.KIND.eq(AccountConstants.ADMIN_KIND)) .and(ACCOUNT.ID.ne(accountId))) .orderBy(ACCOUNT.ID.asc()).limit(1).fetchOne(); }