Esempio n. 1
0
 private void transferObjectsOfType(
     int mssqlType, DatabaseObjectInfoTableModel fromModel, DatabaseObjectInfoTableModel toModel) {
   int i = 0;
   while (i < fromModel.getRowCount()) {
     IDatabaseObjectInfo oi = (IDatabaseObjectInfo) fromModel.getValueAt(i, 0);
     if (mssqlType == 0 || MssqlIntrospector.getObjectInfoType(oi) == mssqlType) {
       if (fromModel.removeElement(oi)) toModel.addElement(oi);
       // don't increment i if you're removing something; otherwise, you'd skip the next item.
     } else i++;
   }
 }
Esempio n. 2
0
  public void preselectObjects(IDatabaseObjectInfo[] objs) {
    /* this works because all the IDatabaseObjectInfo objects come from the same source, so
     * their references are equal. */

    DatabaseObjectInfoTableModel fromModel =
        (DatabaseObjectInfoTableModel) _availableTable.getModel();
    DatabaseObjectInfoTableModel toModel = (DatabaseObjectInfoTableModel) _selectedTable.getModel();

    for (int i = 0; i < objs.length; i++) {
      if (fromModel.removeElement(objs[i])) toModel.addElement(objs[i]);
    }
  }
Esempio n. 3
0
  private void transferSelectedItems(JTable fromTable, JTable toTable) {
    DatabaseObjectInfoTableModel fromModel = (DatabaseObjectInfoTableModel) fromTable.getModel();
    DatabaseObjectInfoTableModel toModel = (DatabaseObjectInfoTableModel) toTable.getModel();
    int[] selectedRows = fromTable.getSelectedRows();

    /* we must iterate through this in descending order to avoid removing, say, item #2, making
     * item #4 into item #3, inadvertently removing item #5. */
    for (int i = selectedRows.length - 1; i >= 0; i--) {
      IDatabaseObjectInfo oi = (IDatabaseObjectInfo) fromModel.getValueAt(selectedRows[i], 0);
      if (fromModel.removeElement(oi)) toModel.addElement(oi);
    }

    /* TODO: sort the list. */
  }
Esempio n. 4
0
  private void populateAvailableTable(JTable table) {
    DatabaseObjectInfoTableModel model = (DatabaseObjectInfoTableModel) table.getModel();

    try {
      String catalog = _session.getSQLConnection().getCatalog();
      SQLDatabaseMetaData metaData = _session.getSQLConnection().getSQLMetaData();

      int i;

      /* add the tables. */
      ITableInfo[] tables =
          _session
              .getSchemaInfo()
              .getITableInfos(catalog, null, new ObjFilterMatcher(), new String[] {"TABLE"});
      for (i = 0; i < tables.length; i++) model.addElement(tables[i]);

      /* add the views. */
      ITableInfo[] views =
          _session
              .getSchemaInfo()
              .getITableInfos(catalog, null, new ObjFilterMatcher(), new String[] {"VIEW"});
      for (i = 0; i < views.length; i++) model.addElement(views[i]);

      /* add the procedures. */
      // IProcedureInfo[] procs = metaData.getProcedures(catalog,null,null);
      IProcedureInfo[] procs =
          _session.getSchemaInfo().getStoredProceduresInfos(catalog, null, new ObjFilterMatcher());
      for (i = 0; i < procs.length; i++)
        if (!procs[i].getSimpleName().startsWith("dt_")) model.addElement(procs[i]);

      /* add the UDTs. */
      IUDTInfo[] udts = metaData.getUDTs(catalog, null, null, null);
      for (i = 0; i < udts.length; i++) model.addElement(udts[i]);
    } catch (SQLException ex) {
      _session.getApplication().showErrorDialog(ex.getMessage(), ex);
    }
  }