jsonRoot.accumulate("routines", jsonRoutine); jsonRoutine.put("name", routine.getName()); if (!options.isShowUnqualifiedNames()) jsonRoutine.put("fullName", routine.getFullName()); jsonRoutine.put("type", routine.getRoutineType()); jsonRoutine.put("returnType", routine.getReturnType()); printRemarks(routine, jsonRoutine); .getColumns(); columns.sort(NamedObjectSort .getNamedObjectSort(options.isAlphabeticalSortForRoutineColumns())); jsonRoutine.put("specificName", routine.getSpecificName());
for (final RoutineColumn<?> column: routine.getColumns()) if (grepDefinitionInclusionRule.test(routine.getRemarks())) if (grepDefinitionInclusionRule.test(routine.getDefinition()))
/** * {@inheritDoc} */ @Override public void handle(final Routine routine) { final String routineTypeDetail = String .format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) { routineName = identifiers.quoteName(routine); } else { routineName = identifiers.quoteFullName(routine); } final String routineType = "[" + routineTypeDetail + "]"; formattingHelper.writeNameRow(routineName, routineType); printRemarks(routine); }
jsonRoot.accumulate("routines", jsonRoutine); jsonRoutine.put("name", routine.getName()); if (!options.isShowUnqualifiedNames()) jsonRoutine.put("fullName", routine.getFullName()); jsonRoutine.put("type", routine.getRoutineType()); jsonRoutine.put("returnType", routine.getReturnType()); .getColumns(); Collections.sort(columns, NamedObjectSort.getNamedObjectSort(options .isAlphabeticalSortForRoutineColumns())); if (routine.hasDefinition()) jsonRoutine.put("definition", routine.getDefinition()); jsonRoutine.put("specificName", routine.getSpecificName()); jsonRoutine.put("remarks", routine.getRemarks());
.format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) printRoutineColumns(routine.getColumns()); final String specificName = routine.getSpecificName(); if (!isBlank(specificName))
for (final Routine routine: routines) out.println(" routine: " + routine.getFullName()); final RoutineColumn[] columns = routine.getColumns() .toArray(new RoutineColumn[0]); for (final RoutineColumn column: columns)
/** * Check for routine limiting rules. * * @param routine * Routine to check * @return Whether the routine should be included */ @Override public boolean test(final Routine routine) { final boolean include; if (routineTypes != null) { include = routineTypes.contains(routine.getRoutineType()); } else { include = true; } return include; }
@Override public String getDefinition() { return routine.getDefinition(); }
@Override public String getName() { return routine.getName(); }
@Override public String getSpecificName() { return routine.getSpecificName(); }
@Override public DaSchema getSchema() { return new DaSchemaImpl(routine.getSchema(), schemaStrategy); }
.format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) printRoutineColumns(routine.getColumns()); final String specificName = routine.getSpecificName(); if (!isBlank(specificName))
/** * {@inheritDoc} */ @Override public void handle(final Routine routine) { final String routineTypeDetail = String .format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) { routineName = identifiers.quoteName(routine); } else { routineName = identifiers.quoteFullName(routine); } final String routineType = "[" + routineTypeDetail + "]"; formattingHelper.writeNameRow(routineName, routineType); printRemarks(routine); }
/** * Check for routine limiting rules. * * @param routine * Routine to check * @return Whether the routine should be included */ @Override public boolean test(final Routine routine) { final boolean include; if (routineTypes != null) { include = routineTypes.contains(routine.getRoutineType()); } else { include = true; } return include; }
@Test public void routineDefinitions(final TestContext testContext, final Connection connection) throws Exception { final Config config = loadHsqldbConfig(); final SchemaRetrievalOptions schemaRetrievalOptions = SchemaRetrievalOptionsBuilder .newSchemaRetrievalOptions(config); final SchemaCrawlerOptionsBuilder schemaCrawlerOptionsBuilder = SchemaCrawlerOptionsBuilder .builder().withSchemaInfoLevel(SchemaInfoLevelBuilder.maximum()) .includeAllRoutines(); final SchemaCrawlerOptions schemaCrawlerOptions = schemaCrawlerOptionsBuilder .toOptions(); final Catalog catalog = getCatalog(connection, schemaRetrievalOptions, schemaCrawlerOptions); final Schema schema = new SchemaReference("PUBLIC", "BOOKS"); final Routine[] routines = catalog.getRoutines(schema) .toArray(new Routine[0]); assertThat("Wrong number of routines", routines, arrayWithSize(4)); for (final Routine routine: routines) { assertThat("Routine definition not found, for " + routine, isBlank(routine.getDefinition()), is(false)); } }
/** * {@inheritDoc} * * @see schemacrawler.schema.Schema#getRoutines() */ @Override public Collection<Routine> getRoutines(final Schema schema) { final List<Routine> values = new ArrayList<Routine>(routines.values()); for (final Iterator<Routine> iterator = values.iterator(); iterator .hasNext();) { final Routine routine = iterator.next(); if (!routine.getSchema().equals(schema)) { iterator.remove(); } } return values; }
routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) routineName = routine.getName(); routineName = routine.getFullName(); out.println(formattingHelper.createNameRow("", routineType)); printRoutineColumns(routine.getColumns()); printDefinition(routine); printDefinition("specific name", "", routine.getSpecificName()); printDefinition("remarks", "", routine.getRemarks());
.format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) printRoutineColumns(routine.getColumns()); final String specificName = routine.getSpecificName(); if (!isBlank(specificName))
for (final RoutineColumn<?> column: routine.getColumns()) if (grepDefinitionInclusionRule.test(routine.getRemarks())) if (grepDefinitionInclusionRule.test(routine.getDefinition()))
/** * {@inheritDoc} */ @Override public void handle(final Routine routine) { final String routineTypeDetail = String .format("%s, %s", routine.getRoutineType(), routine.getReturnType()); final String routineName; if (options.isShowUnqualifiedNames()) { routineName = identifiers.quoteName(routine); } else { routineName = identifiers.quoteFullName(routine); } final String routineType = "[" + routineTypeDetail + "]"; formattingHelper.writeNameRow(routineName, routineType); printRemarks(routine); }