/** * {@inheritDoc} */ @Override public boolean exists(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { return super.exists(context, getSnowflakeName(name)); }
/** * {@inheritDoc} */ @Override public List<TableInfo> list( @Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name, @Nullable final QualifiedName prefix, @Nullable final Sort sort, @Nullable final Pageable pageable ) { log.debug("Beginning to list table metadata for {} for request {}", name, context); final ImmutableList.Builder<TableInfo> builder = ImmutableList.builder(); for (final QualifiedName tableName : this.listNames(context, name, prefix, sort, pageable)) { builder.add(this.get(context, tableName)); } log.debug("Finished listing table metadata for {} for request {}", name, context); return builder.build(); }
/** * {@inheritDoc} */ @Override public void delete(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { final String databaseName = name.getDatabaseName(); final String tableName = name.getTableName(); log.debug("Attempting to delete table {} from database {} for request {}", tableName, databaseName, context); try (Connection connection = this.getConnection(name.getDatabaseName())) { JdbcConnectorUtils.executeUpdate(connection, this.getDropTableSql(name, tableName)); log.debug("Deleted table {} from database {} for request {}", tableName, databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, name); } }
log.debug("Beginning to get table metadata for qualified name {} for request {}", name, context); try (Connection connection = this.getConnection(name.getDatabaseName())) { final ImmutableList.Builder<FieldInfo> fields = ImmutableList.builder(); try (ResultSet columns = this.getColumns(connection, name)) { while (columns.next()) { final String type = columns.getString("TYPE_NAME"); final String size = columns.getString("COLUMN_SIZE"); final String precision = columns.getString("DECIMAL_DIGITS"); final String sourceType = this.buildSourceType(type, size, precision); final FieldInfo.FieldInfoBuilder fieldInfo = FieldInfo.builder() .name(columns.getString("COLUMN_NAME")) if (fieldInfos.isEmpty() && !exists(context, name)) { throw new TableNotFoundException(name); setTableInfoDetails(connection, result); log.debug("Finished getting table metadata for qualified name {} for request {}", name, context); return result;
final String database = name.getDatabaseName(); try (Connection connection = this.getConnection(database)) { final List<QualifiedName> names = Lists.newArrayList(); try (ResultSet tables = this.getTables(connection, name, prefix)) { while (tables.next()) { names.add(QualifiedName.ofTable(catalog, database, tables.getString("TABLE_NAME")));
); try (Connection connection = this.getConnection(oldDatabaseName)) { connection.setSchema(oldDatabaseName); JdbcConnectorUtils.executeUpdate( connection, this.getRenameTableSql(oldName, oldTableName, newTableName) ); log.debug(
/** * {@inheritDoc} */ @Override public TableInfo get(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { return super.get(context, getSnowflakeName(name)); }
/** * {@inheritDoc} */ @Override public List<QualifiedName> listNames(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name, @Nullable final QualifiedName prefix, @Nullable final Sort sort, @Nullable final Pageable pageable) { return super.listNames(context, name.cloneWithUpperCase(), prefix, sort, pageable); }
log.debug("Beginning to get table metadata for qualified name {} for request {}", name, context); try (Connection connection = this.getConnection(name.getDatabaseName())) { final ImmutableList.Builder<FieldInfo> fields = ImmutableList.builder(); try (ResultSet columns = this.getColumns(connection, name)) { while (columns.next()) { final String type = columns.getString("TYPE_NAME"); final String size = columns.getString("COLUMN_SIZE"); final String precision = columns.getString("DECIMAL_DIGITS"); final String sourceType = this.buildSourceType(type, size, precision); final FieldInfo.FieldInfoBuilder fieldInfo = FieldInfo.builder() .name(columns.getString("COLUMN_NAME")) if (fieldInfos.isEmpty() && !exists(context, name)) { throw new TableNotFoundException(name); setTableInfoDetails(connection, result); log.debug("Finished getting table metadata for qualified name {} for request {}", name, context); return result;
final String database = name.getDatabaseName(); try (Connection connection = this.getConnection(database)) { final List<QualifiedName> names = Lists.newArrayList(); try (ResultSet tables = this.getTables(connection, name, prefix)) { while (tables.next()) { names.add(QualifiedName.ofTable(catalog, database, tables.getString("TABLE_NAME")));
); try (Connection connection = this.getConnection(oldDatabaseName)) { connection.setSchema(oldDatabaseName); JdbcConnectorUtils.executeUpdate( connection, this.getRenameTableSql(oldName, oldTableName, newTableName) ); log.debug(
/** * {@inheritDoc} */ @Override public List<TableInfo> list( @Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name, @Nullable final QualifiedName prefix, @Nullable final Sort sort, @Nullable final Pageable pageable ) { log.debug("Beginning to list table metadata for {} for request {}", name, context); final ImmutableList.Builder<TableInfo> builder = ImmutableList.builder(); for (final QualifiedName tableName : this.listNames(context, name, prefix, sort, pageable)) { builder.add(this.get(context, tableName)); } log.debug("Finished listing table metadata for {} for request {}", name, context); return builder.build(); }
/** * {@inheritDoc} */ @Override public void delete(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { final String databaseName = name.getDatabaseName(); final String tableName = name.getTableName(); log.debug("Attempting to delete table {} from database {} for request {}", tableName, databaseName, context); try (Connection connection = this.getConnection(name.getDatabaseName())) { JdbcConnectorUtils.executeUpdate(connection, this.getDropTableSql(name, tableName)); log.debug("Deleted table {} from database {} for request {}", tableName, databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, name); } }