/**
* Retrieves a view information from the database, in the INFORMATION_SCHEMA format.
*
* @throws SQLException On a SQL exception
*/
void retrieveViewInformation() throws SQLException {
final InformationSchemaViews informationSchemaViews =
getRetrieverConnection().getInformationSchemaViews();
if (!informationSchemaViews.hasViewsSql()) {
LOGGER.log(Level.FINE, "Views SQL statement was not provided");
return;
}
final String viewInformationSql = informationSchemaViews.getViewsSql();
final Connection connection = getDatabaseConnection();
try (final Statement statement = connection.createStatement();
final MetadataResultSet results =
new MetadataResultSet(statement.executeQuery(viewInformationSql)); ) {
while (results.next()) {
final String catalogName = quotedName(results.getString("TABLE_CATALOG"));
final String schemaName = quotedName(results.getString("TABLE_SCHEMA"));
final String viewName = quotedName(results.getString("TABLE_NAME"));
final MutableView view = (MutableView) lookupTable(catalogName, schemaName, viewName);
if (view == null) {
LOGGER.log(
Level.FINE,
String.format("Cannot find table, %s.%s.%s", catalogName, schemaName, viewName));
continue;
}
LOGGER.log(Level.FINER, "Retrieving view information: " + viewName);
final String definition = results.getString("VIEW_DEFINITION");
final CheckOptionType checkOption =
results.getEnum("CHECK_OPTION", CheckOptionType.unknown);
final boolean updatable = results.getBoolean("IS_UPDATABLE");
view.appendDefinition(definition);
view.setCheckOption(checkOption);
view.setUpdatable(updatable);
view.addAttributes(results.getAttributes());
}
} catch (final Exception e) {
LOGGER.log(Level.WARNING, "Could not retrieve views", e);
}
}
