@Override protected String getBannerTitle() { return "Save " + _table.getName() + "\nas Excel spreadsheet file"; } };
@Override public TableMetadata getTableMetadata(Table table) { if (table == null) { return null; } final String tableName = table.getName(); return getTableMetadataByName(tableName); }
@Override public String toString() { return getTable().getName(); } }
@Override public final List<String> getTableNames() { return getTables().stream() .map(table -> table.getName()) .collect(Collectors.toList()); }
private Map<String, Object> createTableMap(Table table) { final Map<String, Object> map = new HashMap<>(); map.put("name", table.getName()); map.put("columns", createColumnList(table)); return map; }
@Override public void rowProcessingProgress(final AnalysisJob job, final RowProcessingMetrics metrics, final int currentRow) { final Table table = metrics.getTable(); final ProgressCounter progressCounter = rowCounts.get(table); if (progressCounter != null) { final boolean significant = progressCounter.setIfSignificantToUser(currentRow); if (significant) { System.out.println(currentRow + " rows processed from table: " + table.getName()); } } } }
@Override protected Void doInBackground() throws Exception { final Schema schema = (Schema) _schemaNode.getUserObject(); final List<Table> tables = schema.getTables(); for (final Table table : tables) { final String name = table.getName(); logger.debug("Publishing table name: {}", name); publish(table); } return null; }
@Override protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int maxRows) { final DocumentConverter documentConverter = _schemaBuilder.getDocumentConverter(table); final List<SelectItem> selectItems = columns.stream().map(SelectItem::new).collect(Collectors.toList()); final DataSetHeader header = new CachingDataSetHeader(selectItems); final DocumentSource documentSource = getDocumentSourceForTable(table.getName()); DataSet dataSet = new DocumentSourceDataSet(header, documentSource, documentConverter); if (maxRows > 0) { dataSet = new MaxRowsDataSet(dataSet, maxRows); } return dataSet; }
private void loadRelations(Table table, DatabaseMetaData metaData) { Schema schema = table.getSchema(); try (ResultSet rs = metaData.getImportedKeys(getCatalogName(schema), getJdbcSchemaName(schema), table .getName())) { loadRelations(rs, schema); } catch (SQLException e) { throw JdbcUtils.wrapException(e, "retrieve imported keys for " + table.getName(), JdbcActionType.METADATA); } }
@Override protected Number executeCountQuery(Table table, List<FilterItem> whereItems, boolean functionApproximationAllowed) { if (whereItems.isEmpty()) { final String session = _sessionId.get(); final String moduleName = table.getName(); final GetEntriesCountResult entriesCount = _service.getEntriesCount(session, moduleName, "", 0); final int resultCount = entriesCount.getResultCount(); return resultCount; } return super.executeCountQuery(table, whereItems, functionApproximationAllowed); }
@Override protected Number executeCountQuery(Table table, List<FilterItem> whereItems, boolean functionApproximationAllowed) { if (!whereItems.isEmpty()) { // not supported - will have to be done by counting client-side logger.debug( "Not able to execute count query natively - resorting to query post-processing, which may be expensive"); return null; } final Statement statement = QueryBuilder.select().countAll().from(keySpaceName, table.getName()); final Row response = cassandraCluster.connect().execute(statement).one(); return response.getLong(0); }
private void loadRelations(Table table, DatabaseMetaData metaData) { Schema schema = table.getSchema(); try (ResultSet rs = metaData.getImportedKeys(getCatalogName(schema), getJdbcSchemaName(schema), table .getName())) { loadRelations(rs, schema); } catch (SQLException e) { throw JdbcUtils.wrapException(e, "retrieve imported keys for " + table.getName(), JdbcActionType.METADATA); } }
@Override public void execute() throws MetaModelException { final String tableName = getTable().getName(); final DeleteTableResult result = _dataContext.getDynamoDb().deleteTable(tableName); logger.debug("Dropped table {} in request ID: {}", tableName, result.getSdkResponseMetadata().getRequestId()); }
@Override public void execute() throws MetaModelException { Table table = getTable(); _updateCallback.removeCollection(table.getName()); MutableSchema schema = (MutableSchema) table.getSchema(); schema.removeTable(table); }
@Override public void execute() throws MetaModelException { final Table table = getTable(); _updateCallback.removeSheet(table.getName()); final MutableSchema schema = (MutableSchema) table.getSchema(); schema.removeTable(table); }
@Override public void rowProcessingSuccess(final AnalysisJob job, final RowProcessingMetrics metrics) { logger.info("rowProcessingSuccess: {}", job.getDatastore().getName()); _progressInformationPanel.updateProgressFinished(metrics.getTable()); _progressInformationPanel.addUserLog( "Processing of " + metrics.getTable().getName() + " is successful. Generating results..."); }
@Override public void execute() throws MetaModelException { final MongoCollection<Document> collection = _updateCallback.getCollection(getTable().getName()); final MongoDbDataContext dataContext = _updateCallback.getDataContext(); final Document query = dataContext.createMongoDbQuery(getTable(), getWhereItems(), whereItem -> { throw new UnsupportedOperationException("Unable to handle WHERE item in DELETE: " + whereItem.toSql()); }); DeleteResult result = collection.deleteMany(query); logger.info("Remove returned result: {}", result); }
@Override public void execute() { // Remove from the datastore final Table table = getTable(); ((HBaseDataContext) _updateCallback.getDataContext()).getHBaseClient().dropTable(table.getName()); // Remove from schema ((MutableSchema) table.getSchema()).removeTable(table); } }
@Override public void execute() throws MetaModelException { final DBCollection collection = _updateCallback.getCollection(getTable().getName()); final MongoDbDataContext dataContext = _updateCallback.getDataContext(); final BasicDBObject query = dataContext.createMongoDbQuery(getTable(), getWhereItems()); WriteConcern writeConcern = _updateCallback.getWriteConcernAdvisor().adviceDeleteQuery(collection, query); final WriteResult writeResult = collection.remove(query, writeConcern); logger.info("Remove returned result: {}", writeResult); }