扩展 IBM Rational Data Architect 满足数据建模和集成需求，第 1 部分: 修改 RDA 模型和定制属性

                

	private void TraverseDatabase(Database db) {
		System.out.println("Database: " + db.getName());
		System.out.println("-- Vendor: " + db.getVendor());
		System.out.println("-- Version: "+ db.getVersion());
		// get schemas
		Iterator schemaItor = db.getSchemas().iterator();
		while(schemaItor.hasNext()) {
			Schema aSchema = (Schema)schemaItor.next();
			TraverseSchema(aSchema);
		}
	}
	
	private void TraverseSchema(Schema schema) {
		System.out.println("Schema: " + schema.getName());
		// get tables
		Iterator tablesItor = schema.getTables().iterator();
		while(tablesItor.hasNext()) {
			Table aTable = (Table)tablesItor.next();
			TraverseTable(aTable);
		}
	}

 

                
 
	private void TraverseTable(Table table) {
		System.out.println("Table: " + table.getName());
		// get columns
		Iterator columnsItor = table.getColumns().iterator();
		while(columnsItor.hasNext()) {
			Column aColumn = (Column)columnsItor.next();
			TraverseColumn(aColumn);
		}
	}
	
	private void TraverseColumn(Column col) {
		System.out.println("   Column: " + col.getName());
		// get column properties
		DataType dataType = col.getDataType();
		System.out.println("   -- Data type: " + dataType.getName());
		boolean isNullable = col.isNullable();
		System.out.println("   -- Is nullable: " + Boolean.toString(isNullable));
		String defaultValue = col.getDefaultValue();
		System.out.println("   -- Default value: " + defaultValue);
	} 
			

                
 
	private void AddSSNColumn(Table table) {
		// get database from table
		Database db = table.getSchema().getDatabase();
		// get the database specific model element factory
		DatabaseDefinition dbDef = DataToolsPlugin.getDefault()
				.getDatabaseDefinitionRegistry().getDefinition(
						db.getVendor(),	db.getVersion());
		DataModelElementFactory factory = dbDef.getDataModelElementFactory();

		Column col = (Column) factory.create(SQLTablesPackage.eINSTANCE
				.getColumn());
		col.setName("SSN");
		CharacterStringDataType cType = (CharacterStringDataType) dbDef
				.getPredefinedDataType("CHARACTER");
		cType.setLength(9);
		col.setDataType(cType);
		EStructuralFeature feature = table.eClass().getEStructuralFeature(
				SQLTablesPackage.TABLE__COLUMNS);
		// using RDA CommandFactory to create a add command
		ICommand cmd = CommandFactory.INSTANCE.createAddCommand(
				"Add SSN column", table, feature, col);
		// execute the command using RDA command manager
		DataToolsPlugin.getDefault().getCommandManager().execute(cmd);
	}
	
			

                
<extension point="org.eclipse.ui.views.properties.tabbed.propertyContributor">
      <propertyContributor
            contributorId="com.ibm.datatools.properties"
            labelProvider="com.ibm.datatools.core.ui.properties.PropertyLabelProvider"
            typeMapper="com.ibm.datatools.core.ui.properties.PropertyTypeMapper">
         <propertyCategory category="Core"/> 
         <propertyCategory category="Extended"/> 
         <propertyCategory category="Other"/>
         <propertyCategory category="UserDefined"/>
         <propertyCategory category="Appearance"/>
         <propertyCategory category="rulerGrid"/>
         <propertyCategory category="Advanced"/>
      </propertyContributor>
   </extension>
 
   
			

                   
<extension point="org.eclipse.ui.views.properties.tabbed.propertyTabs">
       <propertyTabs contributorId="com.ibm.datatools.properties">
          <propertyTab
               label="Privacy"
               category="Extended"
               id="com.ibm.custome.PrivacyPropertiesTab">
          </propertyTab>    
       </propertyTabs>
    </extension>
 
    

                
 <extension point="org.eclipse.ui.views.properties.tabbed.propertySections">
      <propertySections contributorId="com.ibm.datatools.properties">
         <propertySection 
            tab="com.ibm.custome.PrivacyPropertiesTab"  
            class="com.ibm.datratools.extendProperties.column.SamplePropertySection"
            id="com.ibm.custome.PrivacyPropertiesTab">
            <!-- enable for Columns -->
            <input type="org.eclipse.wst.rdb.internal.models.sql.tables.Column"/> 
         </propertySection>
      </propertySections>
   </extension> 
    

 
			

                
	public void createControls(Composite parent, TabbedPropertySheetPage page) {
		super.createControls(parent, page);
		TabbedPropertySheetWidgetFactory factory = getWidgetFactory();
		Composite comp = factory.createFlatFormComposite(parent);
		// Privacy checkbox
		privacyCheckbox = factory.createButton(comp, "Private Data", SWT.CHECK);
		FormData data = new FormData();
		data.left = new FormAttachment(0, 0);
		data.top = new FormAttachment(0, ITabbedPropertyConstants.VSPACE);
		privacyCheckbox.setLayoutData(data);
		privacyCheckbox.addSelectionListener(new SelectionListener() {
			public void widgetSelected(SelectionEvent evt) {
				Sample1PropertySection.this.onCheckboxSelected();
			}
			public void widgetDefaultSelected(SelectionEvent evt) {
				
			}
		});
		// Masking text
		CLabel label = factory.createCLabel(comp, "Masking method:");
		data = new FormData();
		data.left = new FormAttachment(0, 0);
		data.top = new FormAttachment(privacyCheckbox, 
				ITabbedPropertyConstants.HSPACE);
		label.setLayoutData(data);
		
		maskingText = factory.createText(comp, "");
		data = new FormData();
		data.left = new FormAttachment(label, ITabbedPropertyConstants.HSPACE);
		data.right = new FormAttachment(100, 0);
		data.top = new FormAttachment(label, 0, SWT.CENTER);
		maskingText.setLayoutData(data);
		textListener = new TextChangeListener() {
			protected void changeProperty(Event e) { 
				Sample1PropertySection.this.onLeaveText(); }
		};
		maskingText.addListener(SWT.FocusOut, textListener);
		maskingText.addListener(SWT.DefaultSelection, textListener);
	}
	
	public void setInput(IWorkbenchPart part, ISelection selection) {
		super.setInput(part, selection);
		
		if(!(selection instanceof IStructuredSelection))
			return;
		Object firstObject = ((IStructuredSelection) selection).getFirstElement();
		if(firstObject instanceof Column) {
			column = (Column)firstObject;
			refresh();
		}
		else {
			column = null;
		}
	}
	
	public void refresh() 
	{
		super.refresh();	
		// read the property value
		if(column != null) {
			privacyCheckbox.setSelection(getPrivacyProperty());
			maskingText.setText(getMaskingProperty());
		}
	}
	
	private void onCheckboxSelected() {
		// save the property value
		boolean checkboxSelected = privacyCheckbox.getSelection();
		boolean propertyStatus = this.getPrivacyProperty();
		if(checkboxSelected != propertyStatus) {
			setPrivacyProperty(checkboxSelected);
		}
	}
	
	private void onLeaveText() {
		// save the property value
		String newText = this.maskingText.getText();
		String oldText = this.getMaskingProperty();
		if(!newText.equals(oldText)) {
			setMaskingProperty(newText);
		}
	}
	
	private String getMaskingProperty() {
		String maskingStr = "";
		EAnnotation ea = column.getEAnnotation(SAMPLE_EANNOTAITN_NAME);
		if(ea != null) {
			// get the details with the key SAMPLE_MASKING_PROPERTY_NAME
			Object valObj = ea.getDetails().get(SAMPLE_MASKING_PROPERTY_NAME);
			if(valObj != null) {				
				maskingStr = (String)valObj;
				if(maskingStr != null)
					return maskingStr;
			}
		}
		return "";
	}
	
	private void setMaskingProperty(String maskingStr) {
		EAnnotation ea = column.getEAnnotation(SAMPLE_EANNOTAITN_NAME);
		DataToolsCompositeCommand cmd = 
			new DataToolsCompositeCommand(COMMAND_LABEL);
		String newText = this.maskingText.getText();
		if(ea == null) {
			ea = createSampleEAnnotaiton(cmd);
		}
		EMap details = ea.getDetails();
		int entryCount = details.size();
		EStringToStringMapEntryImpl entry = null;
		for(int i=0; i < entryCount; i++) {
			EStringToStringMapEntryImpl anEntry = 
				(EStringToStringMapEntryImpl)ea.getDetails().get(i);
			if(anEntry.getKey().equals(SAMPLE_MASKING_PROPERTY_NAME)) {
				entry = anEntry;	
				break;
			}
		}
		if(entry != null) {
			EStructuralFeature feature = 
				EcorePackage.eINSTANCE.getEStringToStringMapEntry_Value();
			cmd.compose(
				new SetCommand(COMMAND_LABEL, entry, feature, newText));
			DataToolsPlugin.getDefault().getCommandManager().execute(cmd);
		}
	}