Summary of duplicated code

This page summarizes the code fragments that have been found to be replicated in the code. Only those fragments longer than 30 lines of code are shown.

# duplications	Total lines	Total tokens	Approx # bytes
9	353	1668	6672

You expand and collapse the code fragments using the + buttons. You can also navigate to the source code by clicking on the file names.

ID Files Lines

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/MatchEngineImpl.java	line 83
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/MergeEngineImpl.java	line 59

# lines : 47


        final MergeSettings settings = project.getMergeSettings();
        
        if ( context == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: session context must not be null");
        }
        
        if ( session.getDatabase() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: database of the session must not be null");
        }
        if ( session.getDatabase().getDataSource() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: data source of the session must not be null");
        }
        
        if (!project.doesSourceTableExist()) {
            throw new SourceTableException(
                    "PreCondition failed: Your project source table \""+
                    DDLUtils.toQualifiedName(project.getSourceTable())+
            "\" does not exist");
        }
        
        if (!project.verifySourceTableStructure()) {
			throw new SourceTableException(
					"PreCondition failed: Source table structure has changed!");
		}
        
        if (!session.canSelectTable(project.getSourceTable())) {
            throw new EngineSettingException(
            "PreCondition failed: can not select project source table");
        }
        
        if (!project.doesResultTableExist()) {
            throw new EngineSettingException(
            "PreCondition failed: project result table does not exist");
        }
        
        if (!project.verifyResultTableStructure() ) {
            throw new EngineSettingException(
            "PreCondition failed: project result table structure incorrect");
        }
        
        if (settings.getSendEmail()) {
        	// First checks if the email settings are correct
        	if (!validateEmailSetting(context)) {
        		throw new EngineSettingException(

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/BuildExampleTableDialog.java	line 354
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/action/CreateRepositoryAction.java	line 170

# lines : 45


                StringBuilder buf = new StringBuilder();
                for (JTextArea sqlText : sqlTextFields) {
                    buf.append(sqlText.getText());
                    buf.append(";\n");
                }
                StringSelection selection = new StringSelection(buf.toString());
                Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
                clipboard.setContents(selection, selection);
            }
        };
        Action executeAction = new AbstractAction("Execute") {
            public void actionPerformed(ActionEvent e) {
                // Builds the gui part of the error pane that will be used
                // if a sql statement fails
                JPanel errorPanel = new JPanel(new FormLayout("4dlu,300dlu,4dlu",
                    "4dlu,pref,4dlu,pref,4dlu,200dlu,4dlu,pref,4dlu"));
                CellConstraints cc = new CellConstraints();
                
                JLabel topLabel = new JLabel();
                JTextArea errorMsgLabel = new JTextArea();
                errorMsgLabel.setLineWrap(true);
                errorMsgLabel.setWrapStyleWord(true);
                errorMsgLabel.setPreferredSize(new Dimension(300, 40));
                
                JLabel bottomLabel = new JLabel();
                JTextArea errorStmtLabel = new JTextArea();
                JScrollPane errorStmtPane = new JScrollPane(errorStmtLabel);
                errorStmtPane.setPreferredSize(new Dimension(300, 300));
                errorStmtPane.scrollRectToVisible(new Rectangle(0,0));
                
                int row = 2;
                errorPanel.add(topLabel, cc.xy(2, row));
                row += 2;
                errorPanel.add(errorMsgLabel, cc.xy(2, row));
                row += 2;
                errorPanel.add(errorStmtPane, cc.xy(2,row));
                row += 2;
                errorPanel.add(bottomLabel, cc.xy(2,row, "f,f"));
                
                // Does the actual work of executing the sql statments
                Connection con = null;
                Statement stmt = null;
                String sql = null;
                try {
                    con = targetDB.getConnection();

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/TypeMap.java	line 44
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/munge/AbstractMungeStep.java	line 776

# lines : 42


    protected Class<?> typeClass(int type) {
        switch (type) {
        case Types.VARCHAR:
        case Types.VARBINARY:
        case Types.STRUCT:
        case Types.REF:
        case Types.OTHER:
        case Types.NULL:
        case Types.LONGVARCHAR:
        case Types.LONGVARBINARY:
        case Types.JAVA_OBJECT:
        case Types.DISTINCT:
        case Types.DATALINK:
        case Types.CLOB:
        case Types.CHAR:
        case Types.BLOB:
        case Types.BINARY:
        case Types.ARRAY:
        default:
            return String.class;

        case Types.TINYINT:
        case Types.SMALLINT:
        case Types.REAL:
        case Types.NUMERIC:
        case Types.INTEGER:
        case Types.FLOAT:
        case Types.DOUBLE:
        case Types.DECIMAL:
        case Types.BIGINT:
            return BigDecimal.class;

        case Types.BIT:
        case Types.BOOLEAN:
            return Boolean.class;
        
        case Types.TIMESTAMP:
        case Types.TIME:
        case Types.DATE:
            return Date.class;
        }
    }

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/CleanseEngineImpl.java	line 70
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/MatchEngineImpl.java	line 75

# lines : 42


		this.setSession(session);
		this.setProject(project);
	}

	public void checkPreconditions() throws EngineSettingException, SQLObjectException, SourceTableException {
		MatchMakerSession session = getSession();
        Project project = getProject();
        final MatchMakerSessionContext context = session.getContext();
        final MungeSettings settings = project.getMungeSettings();
        
        if ( context == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: session context must not be null");
        }
        
        if ( session.getDatabase() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: database of the session must not be null");
        }
        if ( session.getDatabase().getDataSource() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: data source of the session must not be null");
        }
        
        if (!project.doesSourceTableExist()) {
            throw new SourceTableException(
                    "PreCondition failed: Your project source table \""+
                    DDLUtils.toQualifiedName(project.getSourceTable())+
            		"\" does not exist");
        }
        
        if (!project.verifySourceTableStructure()) {
			throw new SourceTableException(
					"PreCondition failed: Source table structure has changed!");
		}
        
        if (!session.canSelectTable(project.getSourceTable())) {
			throw new EngineSettingException(
					"PreCondition failed: can not select project source table");
		}
        
        if (!project.doesResultTableExist()) {

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/BuildExampleTableDialog.java	line 440
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/MMSUtils.java	line 333

# lines : 41


					SPSUtils.showExceptionDialogNoReport(editor, "Create Script Failure", ex);
				} finally {
					try {
						if (stmt != null) {
							stmt.close();
						}
					} catch (SQLException ex) {
						logger.warn("Couldn't close statement", ex);
					}
					try {
						if (con != null) {
							con.close();
						}
					} catch (SQLException ex) {
						logger.warn("Couldn't close connection", ex);
					}
				}
			}
		};
		Action cancelAction = new AbstractAction("Close") {
			public void actionPerformed(ActionEvent e) {
				editor.dispose();
			}
		};

		// the gui layout part
		cp.setLayout(new BorderLayout(10,10));
		cp.setBorder(BorderFactory.createEmptyBorder(10, 10, 10, 10));

		cp.add(new JScrollPane(statementsBox), BorderLayout.CENTER);

		ButtonBarBuilder bbb = ButtonBarBuilder.createLeftToRightBuilder();
		bbb.addGridded(new JButton(saveAction));
		bbb.addGridded(new JButton(copyAction));
		bbb.addGridded(new JButton(executeAction));
		bbb.addGridded(new JButton(cancelAction));

		cp.add(bbb.getPanel(), BorderLayout.SOUTH);

		editor.pack();
		editor.setLocationRelativeTo(null);

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/munge/SubstringByWordMungeStep.java	line 78
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/munge/SubstringMungeStep.java	line 42

# lines : 36


		super("Substring",false);
		setParameter(BEGIN_PARAMETER_NAME, 0);
		setParameter(END_PARAMETER_NAME, 0);
		MungeStepOutput<String> out = new MungeStepOutput<String>("substringOutput", String.class);
		addChild(out);
		InputDescriptor desc = new InputDescriptor("substring", String.class);
		super.addInput(desc);
	}
	
	@Override
	public int addInput(InputDescriptor desc) {
		throw new UnsupportedOperationException("Substring munge step does not support addInput()");
	}
	
	@Override
	public void removeInput(int index) {
		throw new UnsupportedOperationException("Substring munge step does not support removeInput()");
	}
	
	public void connectInput(int index, MungeStepOutput o) {
		if (o.getType() != getInputDescriptor(index).getType()) {
			throw new UnexpectedDataTypeException(
				"Substring munge step does not accept non-String inputs");
		} else {
			super.connectInput(index, o);
		}
	}
	
	/**
	 * This call() throws an {@link IndexOutOfBoundsException} if the given
	 * indices were not in the range of the input
	 */
	public Boolean doCall() throws Exception {

		int beginIndex = getIntegerParameter(BEGIN_PARAMETER_NAME);
		int endIndex = getIntegerParameter(END_PARAMETER_NAME);

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/util/AutoValidateSettingUserType.java	line 33
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/util/PoolFilterSettingUserType.java	line 33

# lines : 34


public class PoolFilterSettingUserType implements UserType {

	private static final int[] SQL_TYPES = {Types.VARCHAR};
	
	public Object assemble(Serializable cached, Object owner)
			throws HibernateException {
		return cached;
	}

	public Object deepCopy(Object value) throws HibernateException {
		return value;
	}

	public Serializable disassemble(Object value) throws HibernateException {
		return (Serializable)value;
	}

	public boolean equals(Object x, Object y) throws HibernateException {
		return x == y;
	}

	public int hashCode(Object x) throws HibernateException {
		if (x == null) return 0;
		return x.hashCode();
	}

	public boolean isMutable() {
		return false;
	}

	public Object nullSafeGet(ResultSet rs, String[] names, Object owner)
			throws HibernateException, SQLException {
		String name = rs.getString(names[0]);
		return rs.wasNull() ? null : PoolFilterSetting.valueOf(name);

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/CleanseEngineImpl.java	line 78
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/MergeEngineImpl.java	line 59

# lines : 34


        final MergeSettings settings = project.getMergeSettings();
        
        if ( context == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: session context must not be null");
        }
        
        if ( session.getDatabase() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: database of the session must not be null");
        }
        if ( session.getDatabase().getDataSource() == null ) {
        	throw new EngineSettingException(
        			"PreCondition failed: data source of the session must not be null");
        }
        
        if (!project.doesSourceTableExist()) {
            throw new SourceTableException(
                    "PreCondition failed: Your project source table \""+
                    DDLUtils.toQualifiedName(project.getSourceTable())+
            "\" does not exist");
        }
        
        if (!project.verifySourceTableStructure()) {
			throw new SourceTableException(
					"PreCondition failed: Source table structure has changed!");
		}
        
        if (!session.canSelectTable(project.getSourceTable())) {
            throw new EngineSettingException(
            "PreCondition failed: can not select project source table");
        }
        
        if (!project.doesResultTableExist()) {

/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/LabelPane.java	line 760
/Users/jeffrey/Documents/workspace/dqguru-0.9.6/src/ca/sqlpower/matchmaker/swingui/munge/AbstractMungeComponent.java	line 1089

# lines : 32


					Insets autoScroll = pen.getAutoscrollInsets();
					//does not use the mouse point because this looks better
					autoScrollPoint = new Point(pen.getWidth()/2, pen.getHeight()/2);
					boolean asChanged = false;
					if (getX() + getWidth() > pen.getWidth() - autoScroll.right) {
						autoScrollPoint.x = getX() + getWidth();
						asChanged = true;
					}
					if (getY() + getHeight() > pen.getHeight() - autoScroll.bottom) {
						autoScrollPoint.y = getY() + getHeight();
						asChanged = true;
					}
					if (getX() < autoScroll.left) {
						autoScrollPoint.x = getX();
						asChanged = true;
					}
					if (getY() < autoScroll.top) {
						autoScrollPoint.y = getY();
						asChanged = true;
					}
					
					if (!asChanged) {
						autoScrollTimer.stop();
					} else {
						autoScrollTimer.restart();
					}
					
				}
			} else {
				parent.mouseX = e.getX() + getX();
				parent.mouseY = e.getY() + getY();
			}