public Table[] convertToTables(final String[] tableNames) { final Table[] result = new Table[tableNames.length]; for (int i = 0; i < result.length; i++) { result[i] = convertToTable(tableNames[i]); } return result; }
public Column[] convertToColumns(final String schemaName, final String tableName, final String[] columnNames) { if (columnNames == null) { return null; } if (columnNames.length == 0) { return new Column[0]; } final Table table = convertToTable(schemaName, tableName); final Column[] columns = new Column[columnNames.length]; for (int i = 0; i < columns.length; i++) { columns[i] = table.getColumnByName(columnNames[i]); } return columns; }
@Override public Table getPreviewTable(final Datastore datastore) { try (DatastoreConnection con = datastore.openConnection()) { return con.getSchemaNavigator().convertToTable(_schemaName, _tableName); } }
/** * Truncates the database table if necesary. This is NOT a distributable * initializer, since it can only happen once. */ @Initialize(distributed = false) public void truncateIfNecesary() { if (truncateTable) { try (UpdateableDatastoreConnection con = datastore.openConnection()) { final SchemaNavigator schemaNavigator = con.getSchemaNavigator(); final Table table = schemaNavigator.convertToTable(schemaName, tableName); final UpdateableDataContext dc = con.getUpdateableDataContext(); dc.executeUpdate(callback -> { final RowDeletionBuilder delete = callback.deleteFrom(table); if (logger.isInfoEnabled()) { logger.info("Executing truncating DELETE operation: {}", delete.toSql()); } delete.execute(); }); } } }
/** * A main method that will display the results of a few example number * analyzers. Useful for tweaking the charts and UI. * * @param args */ public static void main(final String[] args) throws Exception { LookAndFeelManager.get().init(); final Injector injector = Guice.createInjector(new DCModuleImpl(VFSUtils.getFileSystemManager().resolveFile("."), null)); // run a small job final AnalysisJobBuilder ajb = injector.getInstance(AnalysisJobBuilder.class); final Datastore ds = injector.getInstance(DatastoreCatalog.class).getDatastore("orderdb"); final DatastoreConnection con = ds.openConnection(); final Table table = con.getSchemaNavigator().convertToTable("PUBLIC.CUSTOMERS"); ajb.setDatastore(ds); ajb.addSourceColumns(table.getNumberColumns()); ajb.addAnalyzer(NumberAnalyzer.class).addInputColumns(ajb.getSourceColumns()); final ResultWindow resultWindow = injector.getInstance(ResultWindow.class); resultWindow.setVisible(true); resultWindow.startAnalysis(); } }
final Table table = connection.getSchemaNavigator().convertToTable(str); if (table == null) { throw new IllegalArgumentException("Table not found: " + str);
final SchemaNavigator sn = con.getSchemaNavigator(); ajb.setDatastore(ds); ajb.addSourceColumns(sn.convertToTable("PUBLIC.CUSTOMERS").getColumns());
final Datastore ds = injector.getInstance(DatastoreCatalog.class).getDatastore("orderdb"); final DatastoreConnection con = ds.openConnection(); final Table table = con.getSchemaNavigator().convertToTable("PUBLIC.CUSTOMERS"); ajb.setDatastore(ds); ajb.addSourceColumns(table.getLiteralColumns());
final Table table = con.getSchemaNavigator().convertToTable("PUBLIC.ORDERS");