[CIShell-SVN] SF.net SVN: cishell:[891] trunk/core/org.cishell.utilities/src/org/cishell/ utilities/TableUtilities.java

[<pat...@us...>]

Revision: 891
          http://cishell.svn.sourceforge.net/cishell/?rev=891&view=rev
Author:   pataphil
Date:     2009-07-20 18:44:49 +0000 (Mon, 20 Jul 2009)

Log Message:
-----------
* "Merged" TableUtilities with changes made to edu.iu.scipolicy.utilities before Utilities were moved to CIShell.

Modified Paths:
--------------
    trunk/core/org.cishell.utilities/src/org/cishell/utilities/TableUtilities.java

Modified: trunk/core/org.cishell.utilities/src/org/cishell/utilities/TableUtilities.java
===================================================================
--- trunk/core/org.cishell.utilities/src/org/cishell/utilities/TableUtilities.java	2009-07-17 22:02:42 UTC (rev 890)
+++ trunk/core/org.cishell.utilities/src/org/cishell/utilities/TableUtilities.java	2009-07-20 18:44:49 UTC (rev 891)
@@ -66,6 +66,59 @@
 		}
 	}
 	
+	public static String formNonConflictingNewColumnName(
+			Schema schema, String[] suggestedColumnNames) 
+			throws ColumnNotFoundException {
+		List workingColumnNames = getAllColumnNames(schema);
+
+		boolean suggestedNameFound = false;
+		for(int suggestedNameIndex = 0; suggestedNameIndex < suggestedColumnNames.length; suggestedNameIndex++) {
+			for(int i = 0; i < workingColumnNames.size(); i++) {
+				if(workingColumnNames.get(i).toString().equalsIgnoreCase(suggestedColumnNames[suggestedNameIndex])) {
+					suggestedNameFound = true;
+					break;
+				}
+			}
+			/*
+			 * To ensure that whenever a suggested name is found in the original column schema, create a name.
+			 * */
+			if(suggestedNameFound) {
+				break;
+			}
+		}
+		
+		/*
+		 * If none of the suggested names are conflicting then return the first suggested name.
+		 * */
+		if(!suggestedNameFound) {
+			return suggestedColumnNames[0];
+		}
+
+		/*
+		 * This part of code will be executed only if the suggested names are already present in the 
+		 * column schema.
+		 * */
+			boolean newColumnNameFound = false;
+			int columnNameSuffix = 2;
+			while(true) {
+				/*
+				 * The pattern for new names will be taken from the first suggested column name.
+				 * */
+				String newColumnName =
+					suggestedColumnNames[0].concat("_" + columnNameSuffix);
+				for(int i = 0; i < workingColumnNames.size(); i++) {
+					if(workingColumnNames.get(i).toString().equalsIgnoreCase(newColumnName)) {
+						newColumnNameFound = true;
+						break;
+					}
+				}
+				if(!newColumnNameFound) {
+					return newColumnName;
+				}
+				columnNameSuffix++;
+			}
+	}
+	
 	public static String[] filterSchemaColumnNamesByClasses
 		(Schema schema, Class[] objectClasses) throws ColumnNotFoundException
 	{


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.