@Override public String toSql() { return "DROP TABLE " + _table.getQualifiedLabel(); } }
@Override public String toSql() { return "DROP TABLE " + _table.getQualifiedLabel(); } }
@Override public String toString() { return "RowProcessingPublisher[table=" + _table.getQualifiedLabel() + ", consumers=" + _consumers.size() + "]"; }
@Override public final String getQualifiedLabel() { StringBuilder sb = new StringBuilder(); Table table = getTable(); if (table != null) { sb.append(table.getQualifiedLabel()); sb.append('.'); } sb.append(getName()); return sb.toString(); }
@Override public final String getQualifiedLabel() { StringBuilder sb = new StringBuilder(); Table table = getTable(); if (table != null) { sb.append(table.getQualifiedLabel()); sb.append('.'); } sb.append(getName()); return sb.toString(); }
@Override public final int compareTo(Table that) { int diff = getQualifiedLabel().compareTo(that.getQualifiedLabel()); if (diff == 0) { diff = toString().compareTo(that.toString()); } return diff; } }
@Override public final int compareTo(Table that) { int diff = getQualifiedLabel().compareTo(that.getQualifiedLabel()); if (diff == 0) { diff = toString().compareTo(that.toString()); } return diff; } }
@Override public String toSql() { return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems); } }
@Override public String toSql() { return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems); } }
StringBuilder sb = new StringBuilder(); sb.append("INSERT INTO "); sb.append(_table.getQualifiedLabel()); sb.append("("); Column[] columns = getColumns();
StringBuilder sb = new StringBuilder(); sb.append("INSERT INTO "); sb.append(_table.getQualifiedLabel()); sb.append("("); Column[] columns = getColumns();
@Override public void actionPerformed(final ActionEvent e) { final Datastore datastore = _analysisJobBuilder.getDatastore(); final StringBuilder initialQuery = new StringBuilder("SELECT "); if (_columns == null || _columns.isEmpty()) { initialQuery.append("*"); } else { boolean first = true; for (final HasName column : _columns) { if (!first) { initialQuery.append(", "); } initialQuery.append("a."); initialQuery.append(column.getName()); first = false; } } String fromClause = _table.getQualifiedLabel(); if (fromClause.contains(" ")) { fromClause = _table.getName(); } initialQuery.append("\nFROM " + fromClause + " a"); final QueryWindow window = new QueryWindow(_windowContext, datastore, initialQuery.toString()); window.open(); }
@Override public String toSql() { StringBuilder sb = new StringBuilder(); sb.append("UPDATE "); sb.append(_table.getQualifiedLabel()); sb.append(" SET "); Column[] columns = getColumns(); Object[] values = getValues(); for (int i = 0; i < columns.length; i++) { if (i != 0) { sb.append(','); } sb.append(columns[i].getName()); sb.append('='); sb.append(values[i] == null ? "NULL" : values[i].toString()); } List<FilterItem> whereItems = getWhereItems(); String whereClause = new FilterClause(null, " WHERE ").addItems(whereItems).toSql(); sb.append(whereClause); return sb.toString(); }
@Override public String toSql() { StringBuilder sb = new StringBuilder(); sb.append("UPDATE "); sb.append(_table.getQualifiedLabel()); sb.append(" SET "); Column[] columns = getColumns(); Object[] values = getValues(); for (int i = 0; i < columns.length; i++) { if (i != 0) { sb.append(','); } sb.append(columns[i].getName()); sb.append('='); sb.append(values[i] == null ? "NULL" : values[i].toString()); } List<FilterItem> whereItems = getWhereItems(); String whereClause = new FilterClause(null, " WHERE ").addItems(whereItems).toSql(); sb.append(whereClause); return sb.toString(); }
@Override public String toString(final Object o) { final String result; if (o instanceof Schema) { result = ((Schema) o).getName(); } else if (o instanceof Table) { result = ((Table) o).getQualifiedLabel(); } else if (o instanceof Column) { result = ((Column) o).getQualifiedLabel(); } else if (o instanceof Dictionary) { result = ((Dictionary) o).getName(); } else if (o instanceof SynonymCatalog) { result = ((SynonymCatalog) o).getName(); } else if (o instanceof StringPattern) { result = ((StringPattern) o).getName(); } else if (o instanceof Datastore) { result = ((Datastore) o).getName(); } else { logger.warn("Could not convert type: {}", o.getClass().getName()); result = o.toString(); } return result; }
private JButton createQueryButton(final Datastore datastore) { final JButton queryButton = WidgetFactory.createDefaultButton("Query", IconUtils.MODEL_QUERY); queryButton.setToolTipText("Query datastore"); queryButton.addActionListener(e -> { final String queryString; try (DatastoreConnection connection = datastore.openConnection()) { final List<Table> tables = connection.getSchemaNavigator().getDefaultSchema().getTables(); if (tables.size() > 0) { queryString = "SELECT *\nFROM " + tables.get(0).getQualifiedLabel(); } else { queryString = "SELECT *\nFROM ?"; } } final QueryWindow queryWindow = new QueryWindow(_windowContext, datastore, queryString); queryWindow.open(); }); return queryButton; }
@Override public String toString(Object o) { final String result; if (o instanceof Schema) { result = ((Schema) o).getName(); } else if (o instanceof Table) { result = ((Table) o).getQualifiedLabel(); } else if (o instanceof Column) { result = ((Column) o).getQualifiedLabel(); } else if (o instanceof Dictionary) { result = ((Dictionary) o).getName(); } else if (o instanceof SynonymCatalog) { result = ((SynonymCatalog) o).getName(); } else if (o instanceof StringPattern) { result = ((StringPattern) o).getName(); } else if (o instanceof Datastore) { result = ((Datastore) o).getName(); } else { logger.warn("Could not convert type: {}", o.getClass().getName()); result = o.toString(); } return result; }
if (!getQualifiedLabel().equals(other.getQualifiedLabel())) { return false;
if (!getQualifiedLabel().equals(other.getQualifiedLabel())) { return false;
final DCPanel headerPanel = new DCPanel(); headerPanel.setLayout(new FlowLayout(FlowLayout.LEFT, 0, 0)); final JLabel tableNameLabel = new JLabel(table.getQualifiedLabel(), imageManager.getImageIcon(IconUtils.MODEL_COLUMN, IconUtils.ICON_SIZE_SMALL), JLabel.LEFT); tableNameLabel.setOpaque(false);