/** * {@inheritDoc} */ @Override public void delete(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { super.delete(context, getSnowflakeName(name)); }
/** * {@inheritDoc} */ @Override public TableInfo get(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { return super.get(context, getSnowflakeName(name)); }
/** * {@inheritDoc} */ @Override public boolean exists(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { return super.exists(context, getSnowflakeName(name)); }
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"))); JdbcConnectorUtils.sort(names, sort, comparator); final List<QualifiedName> results = JdbcConnectorUtils.paginate(names, pageable);
/** * {@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); } }
/** * {@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(); }
); try (Connection connection = this.getConnection(oldDatabaseName)) { connection.setSchema(oldDatabaseName); JdbcConnectorUtils.executeUpdate( connection, this.getRenameTableSql(oldName, oldTableName, newTableName) ); log.debug(
/** * {@inheritDoc} */ @Override public List<DatabaseInfo> list( @Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name, @Nullable final QualifiedName prefix, @Nullable final Sort sort, @Nullable final Pageable pageable ) { final String catalogName = name.getCatalogName(); log.debug("Beginning to list database metadata for catalog {} for request {}", catalogName, context); final ImmutableList.Builder<DatabaseInfo> builder = ImmutableList.builder(); for (final QualifiedName dbName : this.listNames(context, name, prefix, sort, pageable)) { builder.add(this.get(context, dbName)); } log.debug("Finished listing database metadata for catalog {} for request {}", catalogName, context); return builder.build(); }
/** * {@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); }
/** * {@inheritDoc} */ @Override public void delete(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { final String databaseName = name.getDatabaseName(); log.debug("Beginning to drop database {} for request {}", databaseName, context); try (final Connection connection = this.dataSource.getConnection()) { JdbcConnectorUtils.executeUpdate(connection, "DROP DATABASE " + databaseName); log.debug("Finished dropping database {} for request {}", databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, 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) { return super.list(context, getSnowflakeName(name), prefix, sort, pageable); }
/** * {@inheritDoc} */ @Override public void rename(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName oldName, @Nonnull final QualifiedName newName) { super.rename(context, getSnowflakeName(oldName), getSnowflakeName(newName)); }
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"))); JdbcConnectorUtils.sort(names, sort, comparator); final List<QualifiedName> results = JdbcConnectorUtils.paginate(names, pageable);
/** * {@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); } }
/** * {@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(); }
); try (Connection connection = this.getConnection(oldDatabaseName)) { connection.setSchema(oldDatabaseName); JdbcConnectorUtils.executeUpdate( connection, this.getRenameTableSql(oldName, oldTableName, newTableName) ); log.debug(
/** * {@inheritDoc} */ @Override public List<DatabaseInfo> list( @Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name, @Nullable final QualifiedName prefix, @Nullable final Sort sort, @Nullable final Pageable pageable ) { final String catalogName = name.getCatalogName(); log.debug("Beginning to list database metadata for catalog {} for request {}", catalogName, context); final ImmutableList.Builder<DatabaseInfo> builder = ImmutableList.builder(); for (final QualifiedName dbName : this.listNames(context, name, prefix, sort, pageable)) { builder.add(this.get(context, dbName)); } log.debug("Finished listing database metadata for catalog {} for request {}", catalogName, context); return builder.build(); }
/** * {@inheritDoc} */ @Override public void delete(@Nonnull final ConnectorRequestContext context, @Nonnull final QualifiedName name) { final String databaseName = name.getDatabaseName(); log.debug("Beginning to drop database {} for request {}", databaseName, context); try (final Connection connection = this.dataSource.getConnection()) { JdbcConnectorUtils.executeUpdate(connection, "DROP DATABASE " + databaseName); log.debug("Finished dropping database {} for request {}", databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, name); } }
/** * {@inheritDoc} */ @Override public void create(@Nonnull final ConnectorRequestContext context, @Nonnull final DatabaseInfo resource) { final String databaseName = resource.getName().getDatabaseName(); log.debug("Beginning to create database {} for request {}", databaseName, context); try (final Connection connection = this.dataSource.getConnection()) { JdbcConnectorUtils.executeUpdate(connection, "CREATE DATABASE " + databaseName); log.debug("Finished creating database {} for request {}", databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, resource.getName()); } }
/** * {@inheritDoc} */ @Override public void create(@Nonnull final ConnectorRequestContext context, @Nonnull final DatabaseInfo resource) { final String databaseName = resource.getName().getDatabaseName(); log.debug("Beginning to create database {} for request {}", databaseName, context); try (final Connection connection = this.dataSource.getConnection()) { JdbcConnectorUtils.executeUpdate(connection, "CREATE DATABASE " + databaseName); log.debug("Finished creating database {} for request {}", databaseName, context); } catch (final SQLException se) { throw this.exceptionMapper.toConnectorException(se, resource.getName()); } }