[Squirrel-sql-commits] sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects TimesTenDialect.java,
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Rob M. <man...@us...> - 2006-12-27 15:19:41
|
Update of /cvsroot/squirrel-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv15066/fw/src/net/sourceforge/squirrel_sql/fw/dialects Modified Files: TimesTenDialect.java Log Message: Finished implementing what few refactorings are supported natively by TImesTen ( currently only drop and add columns ). Index: TimesTenDialect.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/TimesTenDialect.java,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** TimesTenDialect.java 11 Dec 2006 02:40:24 -0000 1.7 --- TimesTenDialect.java 27 Dec 2006 15:19:32 -0000 1.8 *************** *** 175,204 **** */ public String[] getColumnAddSQL(TableColumnInfo info) throws UnsupportedOperationException { ! throw new UnsupportedOperationException("This database dialect doesn't support adding columns to tables"); ! } ! ! /** ! * Returns a boolean value indicating whether or not this dialect supports ! * adding comments to columns. ! * ! * @return true if column comments are supported; false otherwise. ! */ ! public boolean supportsColumnComment() { ! return false; ! } ! ! /** ! * Returns the SQL statement to use to add a comment to the specified ! * column of the specified table. ! * ! * @param tableName the name of the table to create the SQL for. ! * @param columnName the name of the column to create the SQL for. ! * @param comment the comment to add. ! * @return ! * @throws UnsupportedOperationException if the database doesn't support ! * annotating columns with a comment. ! */ ! public String getColumnCommentAlterSQL(String tableName, String columnName, String comment) throws UnsupportedOperationException { ! throw new UnsupportedOperationException("This database dialect doesn't support adding comments to columns"); } --- 175,181 ---- */ public String[] getColumnAddSQL(TableColumnInfo info) throws UnsupportedOperationException { ! return new String[] { ! DialectUtils.getColumnAddSQL(info, this, true, false, false) ! }; } *************** *** 210,214 **** */ public boolean supportsDropColumn() { - // TODO: need to verify this return true; } --- 187,190 ---- *************** *** 224,229 **** * dropping columns. */ ! public String getColumnDropSQL(String tableName, String columnName) { ! // TODO: Need to verify this return DialectUtils.getColumnDropSQL(tableName, columnName); } --- 200,204 ---- * dropping columns. */ ! public String getColumnDropSQL(String tableName, String columnName) { return DialectUtils.getColumnDropSQL(tableName, columnName); } *************** *** 242,246 **** */ public String getTableDropSQL(String tableName, boolean cascadeConstraints){ - // TODO: Need to verify this return DialectUtils.getTableDropSQL(tableName, true, cascadeConstraints); } --- 217,220 ---- *************** *** 257,265 **** TableColumnInfo[] columnNames) { ! // TODO: implement ! throw new UnsupportedOperationException("getAddPrimaryKeySQL not implemented"); } /** * Returns the SQL statement to use to add a comment to the specified * column of the specified table. --- 231,250 ---- TableColumnInfo[] columnNames) { ! int featureId = DialectUtils.ADD_PRIMARY_KEY_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } /** + * Returns a boolean value indicating whether or not this dialect supports + * adding comments to columns. + * + * @return true if column comments are supported; false otherwise. + */ + public boolean supportsColumnComment() { + return false; + } + + /** * Returns the SQL statement to use to add a comment to the specified * column of the specified table. *************** *** 272,280 **** throws UnsupportedOperationException { ! // TODO: implement ! throw new UnsupportedOperationException("Not yet implemented"); } /** * Returns the SQL used to alter the specified column to not allow null * values --- 257,276 ---- throws UnsupportedOperationException { ! int featureId = DialectUtils.COLUMN_COMMENT_ALTER_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } /** + * Returns a boolean value indicating whether or not this database dialect + * supports changing a column from null to not-null and vice versa. + * + * @return true if the database supports dropping columns; false otherwise. + */ + public boolean supportsAlterColumnNull() { + return false; + } + + /** * Returns the SQL used to alter the specified column to not allow null * values *************** *** 284,289 **** */ public String getColumnNullableAlterSQL(TableColumnInfo info) { ! // TODO: implement ! throw new UnsupportedOperationException("Not yet implemented"); } --- 280,286 ---- */ public String getColumnNullableAlterSQL(TableColumnInfo info) { ! int featureId = DialectUtils.COLUMN_NULL_ALTER_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } *************** *** 296,301 **** */ public boolean supportsRenameColumn() { ! // TODO: need to verify this ! return true; } --- 293,297 ---- */ public boolean supportsRenameColumn() { ! return false; } *************** *** 310,315 **** */ public String getColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to) { ! // TODO: implement ! throw new UnsupportedOperationException("Not yet implemented"); } --- 306,312 ---- */ public String getColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to) { ! int featureId = DialectUtils.COLUMN_NAME_ALTER_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } *************** *** 321,326 **** */ public boolean supportsAlterColumnType() { ! // TODO: verify this ! return true; } --- 318,322 ---- */ public boolean supportsAlterColumnType() { ! return false; } *************** *** 339,355 **** throws UnsupportedOperationException { ! // TODO: implement ! throw new UnsupportedOperationException("Not Yet Implemented"); ! } ! ! /** ! * Returns a boolean value indicating whether or not this database dialect ! * supports changing a column from null to not-null and vice versa. ! * ! * @return true if the database supports dropping columns; false otherwise. ! */ ! public boolean supportsAlterColumnNull() { ! // TODO Auto-generated method stub ! return false; } --- 335,341 ---- throws UnsupportedOperationException { ! int featureId = DialectUtils.COLUMN_TYPE_ALTER_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } *************** *** 362,367 **** */ public boolean supportsAlterColumnDefault() { ! // TODO Need to verify this ! return true; } --- 348,352 ---- */ public boolean supportsAlterColumnDefault() { ! return false; } *************** *** 373,378 **** */ public String getColumnDefaultAlterSQL(TableColumnInfo info) { ! // TODO need to implement or change the message ! throw new UnsupportedOperationException("Not yet implemented"); } --- 358,385 ---- */ public String getColumnDefaultAlterSQL(TableColumnInfo info) { ! /* ! * TimesTen reference claims this is a supported operation, but it ! * yields an exception for me: ! * ! * ALTER TABLE test MODIFY noDefaultVarcharCol DEFAULT 'Default Value' ! * ! * Exception in thread "main" ! * java.sql.SQLException: [TimesTen][TimesTen 6.0.1 ODBC Driver][TimesTen]TT1001: ! * Syntax error in SQL statement before or at: "NODEFAULTVARCHARCOL", ! * character position: 26 -- file "ptSqlY.y", lineno 1940, procedure "sbPtParseSql()" ! * ! String alterClause = DialectUtils.MODIFY_CLAUSE; ! String defaultClause = DialectUtils.DEFAULT_CLAUSE; ! return DialectUtils.getColumnDefaultAlterSQL(this, ! info, ! alterClause, ! false, ! defaultClause); ! ! So, for now, just throw an exception: ! */ ! int featureId = DialectUtils.COLUMN_DEFAULT_ALTER_TYPE; ! String msg = DialectUtils.getUnsupportedMessage(this, featureId); ! throw new UnsupportedOperationException(msg); } |