@SuppressWarnings("unchecked") protected Function<Object, T> keyConverter() { return record->{ Objects.requireNonNull(record, () -> "Failed inserting record or no key"); Record key1 = ((R)record).key(); if(key1.size() == 1){ return ((Record1<T>)key1).value1(); } return (T) key1; }; }
@SuppressWarnings("unchecked") protected Function<Object, T> keyConverter() { return record->{ Objects.requireNonNull(record, () -> "Failed inserting record or no key"); Record key1 = ((R)record).key(); if(key1.size() == 1){ return ((Record1<T>)key1).value1(); } return (T) key1; }; }
private final <T, R extends Record1<T>> T value1(R record) { if (record == null) return null; if (record.size() != 1) throw new InvalidResultException("Record contains more than one value : " + record); return record.value1(); }
private final <T, R extends Record1<T>> T value1(R record) { if (record == null) return null; if (record.size() != 1) throw new InvalidResultException("Record contains more than one value : " + record); return record.value1(); }
@Override public Set<NamedToroIndex> getAllToroIndexes(DSLContext dsl) { Result<Record1<NamedToroIndex>> storedIndexes = dsl .select(toroIndexTable.indexColumn) .from(toroIndexTable) .fetch(); Set<NamedToroIndex> result = Sets.newHashSet(); for (Record1<NamedToroIndex> storedIndex : storedIndexes) { result.add(storedIndex.value1()); } return result; }
public Set<String> getTagKeys(User user) { Table<Record> fromTable = DATA_POINT_TAGS; if (!user.hasAdminPermission()) { fromTable = joinPointPermissions(fromTable, DATA_POINT_ID, user); } Select<Record1<String>> query = this.create.selectDistinct(TAG_KEY) .from(fromTable); try (Stream<Record1<String>> stream = query.stream()) { return stream.map(r -> r.value1()).collect(Collectors.toSet()); } }
@Override public int numPreferences() { return dsl .selectCount() .from(DATA) .fetchOne().value1(); }
@Override public int numUsers() { return dsl .selectCount() .from(USERS) .fetchOne().value1(); }
@Override public int numItems() { return dsl .selectCount() .from(ITEMS) .fetchOne().value1(); }
@Override public int numUsersWithPreferences() { return dsl .select(DSL.countDistinct(UIDX)) .from(DATA) .fetchOne().value1(); }
@Override public int numItemsWithPreferences() { return dsl .select(DSL.countDistinct(IIDX)) .from(DATA) .fetchOne().value1(); }
@Override public int numItems(int uidx) { return dsl .selectCount() .from(DATA) .where(UIDX.eq(uidx)) .fetchOne().value1(); }
@Override public int numUsers(int iidx) { return dsl .selectCount() .from(DATA) .where(IIDX.eq(iidx)) .fetchOne().value1(); }
@Override public int numUsers(String i) { return dsl .selectCount() .from(DATA).naturalJoin(ITEMS) .where(ITEM_ID.eq(i)) .fetchOne().value1(); }
@Override public int numItems(String u) { return dsl .selectCount() .from(DATA).naturalJoin(USERS) .where(USER_ID.eq(u)).fetchOne().value1(); }
@Override public boolean canCreate(Long hostId, String event) { if (!ContainerEventConstants.EVENT_START.equals(event)) { return true; } Record1<Integer> count = create().select(DSL.count()) .from(CONTAINER_EVENT) .where(CONTAINER_EVENT.HOST_ID.eq(hostId) .and(CONTAINER_EVENT.STATE.notEqual(CommonStatesConstants.CREATED))) .fetchAny(); return count.value1() < MAX_EVENTS.get(); }
public ProcessKey getKey(UUID instanceId) { try (DSLContext tx = DSL.using(cfg)) { return tx.select(PROCESS_QUEUE.CREATED_AT) .from(PROCESS_QUEUE) .where(PROCESS_QUEUE.INSTANCE_ID.eq(instanceId)) .fetchOne(r -> new ProcessKey(instanceId, r.value1())); } }
@Override public String getAgentState(long agentId) { Record1<String> r = create().select(AGENT.STATE) .from(AGENT) .where(AGENT.ID.eq(agentId) .and(AGENT.REMOVED.isNull())).fetchAny(); return r == null ? null : r.value1(); }
@SuppressWarnings("unchecked") public Map<String, Object> getConfiguration(UUID orgId) { try (DSLContext tx = DSL.using(cfg)) { return tx.select(ORGANIZATIONS.ORG_CFG.cast(String.class)) .from(ORGANIZATIONS) .where(ORGANIZATIONS.ORG_ID.eq(orgId)) .fetchOne(e -> deserialize(e.value1())); } }
@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(); }