private Set<TableReference> getAllTableNames(DSLContext ctx) { Result<? extends Record> records = ctx .select(TABLE_NAME) .from(METADATA_TABLE) .fetch(); Set<TableReference> tableRefs = Sets.newHashSetWithExpectedSize(records.size()); for (Record record : records) { tableRefs.add(TableReference.createUnsafe(record.getValue(TABLE_NAME))); } return tableRefs; }
@Override public Map<TableReference, byte[]> getMetadataForTables() { return run(ctx -> { Result<? extends Record> records = ctx .select(TABLE_NAME, METADATA) .from(METADATA_TABLE) .fetch(); Map<TableReference, byte[]> metadata = Maps.newHashMapWithExpectedSize(records.size()); for (Record record : records) { metadata.put(TableReference.createUnsafe(record.getValue(TABLE_NAME)), record.getValue(METADATA)); } return metadata; }); }
@Override public Stream<Reader> entityStates() { return dsl.select( stateColumn ) .from( table ) .fetch( stateColumn ) .stream() .map( StringReader::new ); }
public List<RepositoryEntry> list() { try (DSLContext tx = DSL.using(cfg)) { return selectRepositoryEntry(tx) .fetch(this::toEntry); } }
@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; }
@Override public IntStream getIidxWithPreferences() { return dsl .selectDistinct(IIDX) .from(DATA) .fetch().stream() .mapToInt(Record1::value1); }
@Override public IntStream getUidxWithPreferences() { return dsl .selectDistinct(UIDX) .from(DATA) .fetch().stream() .mapToInt(Record1::value1); }
@Override public IntStream getAllUidx() { return dsl .select(UIDX) .from(USERS) .fetch().stream() .mapToInt(Record1::value1); }
@Override public Stream<String> getAllUsers() { return dsl .select(USER_ID) .from(USERS) .fetch().stream() .map(Record1::value1); }
@Override public Stream<String> getAllItems() { return dsl .select(ITEM_ID) .from(ITEMS) .fetch().stream() .map(Record1::value1); }
@Override public IntStream getAllIidx() { return dsl .select(IIDX) .from(ITEMS) .fetch().stream() .mapToInt(Record1::value1); }
@Override protected List<SchemaDefinition> getSchemata0() throws SQLException { List<SchemaDefinition> result = new ArrayList<SchemaDefinition>(); for (String name : create() .select(Sysschemas.SCHEMANAME) .from(SYSSCHEMAS) .fetch(Sysschemas.SCHEMANAME)) { result.add(new SchemaDefinition(this, name, "")); } return result; }
@Override protected List<SchemaDefinition> getSchemata0() throws SQLException { List<SchemaDefinition> result = new ArrayList<SchemaDefinition>(); for (String name : create() .select(SCHEMATA.SCHEMA_NAME) .from(SCHEMATA) .fetch(SCHEMATA.SCHEMA_NAME)) { result.add(new SchemaDefinition(this, name, "")); } return result; }
@Override protected List<SchemaDefinition> getSchemata0() throws SQLException { List<SchemaDefinition> result = new ArrayList<SchemaDefinition>(); for (String name : create() .select(Schemata.SCHEMA_NAME) .from(SCHEMATA) .fetch(Schemata.SCHEMA_NAME)) { result.add(new SchemaDefinition(this, name, "")); } return result; }
@Override public Stream<String> getItemsWithPreferences() { return dsl .selectDistinct(ITEM_ID) .from(DATA).naturalJoin(ITEMS) .fetch().stream() .map(Record1::value1); }
@Override public Stream<String> getUsersWithPreferences() { return dsl .selectDistinct(USER_ID) .from(DATA).naturalJoin(USERS) .fetch().stream().map(Record1::value1); }
public List<TemplateAliasEntry> list() { try (DSLContext tx = DSL.using(cfg)) { return tx.select(TEMPLATE_ALIASES.TEMPLATE_ALIAS, TEMPLATE_ALIASES.TEMPLATE_URL) .from(TEMPLATE_ALIASES) .fetch(TemplateAliasDao::toEntry); } }
@Override protected List<SchemaDefinition> getSchemata0() throws SQLException { List<SchemaDefinition> result = new ArrayList<SchemaDefinition>(); for (Record record : create().select( Schemata.SCHEMA_NAME, Schemata.REMARKS) .from(SCHEMATA) .fetch()) { result.add(new SchemaDefinition(this, record.get(Schemata.SCHEMA_NAME), record.get(Schemata.REMARKS))); } return result; }
public List<PolicyEntry> list() { try (DSLContext tx = DSL.using(cfg)) { return tx.select(POLICIES.POLICY_ID, POLICIES.PARENT_POLICY_ID, POLICIES.POLICY_NAME, POLICIES.RULES.cast(String.class)) .from(POLICIES) .fetch(this::toEntry); } }
private final int executeSelectFromPOSTGRES() { DSLContext create = create(configuration); List<Field<?>> fields = new ArrayList<Field<?>>(1 + outParameters.size()); if (returnParameter != null) fields.add(DSL.field(DSL.name(getName()), returnParameter.getDataType())); for (Parameter<?> p : outParameters) fields.add(DSL.field(DSL.name(p.getName()), p.getDataType())); Result<?> result = create.select(fields).from("{0}", asField()).fetch(); int i = 0; if (returnParameter != null) outValues.put(returnParameter, returnParameter.getDataType().convert(result.getValue(0, i++))); for (Parameter<?> p : outParameters) outValues.put(p, p.getDataType().convert(result.getValue(0, i++))); return 0; }