[Squirrel-sql-commits] sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring DBUtil.java, 1.2, 1.3

[Rob M. <man...@us...>]

Update of /cvsroot/squirrel-sql/sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv13514/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring

Modified Files:
	DBUtil.java 
Log Message:
Implemented modifying column type for MySQL and Oracle.  Fixed Oracle dialect's preference to hard-code 4000 as the length for varchar fields. Now, 
the user can decide and not be over-ruled by the dialect.

Index: DBUtil.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/DBUtil.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DBUtil.java	6 Nov 2006 02:16:27 -0000	1.2
--- DBUtil.java	6 Nov 2006 23:10:24 -0000	1.3
***************
*** 55,61 ****
--- 55,76 ----
              result.add(commentSQL);
          }
+         String typeSQL = getTypeAlterSQL(from, to, dialect);
+         if (typeSQL != null) {
+             result.add(typeSQL);
+         }
+         
          return (String[])result.toArray(new String[result.size()]);
      }
      
+     public static String getTypeAlterSQL(TableColumnInfo from, 
+                                          TableColumnInfo to,
+                                          HibernateDialect dialect)
+     {
+         if (from.getDataType() == to.getDataType()) {
+             return null;
+         }
+         return dialect.getColumnTypeAlterSQL(from, to);
+     }
+     
      public static String getColumnNameAlterSQL(TableColumnInfo from, 
                                                 TableColumnInfo to,