|
From: Rob M. <man...@us...> - 2009-12-28 01:48:24
|
Update of /cvsroot/squirrel-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv19110/fw/src/net/sourceforge/squirrel_sql/fw/dialects Modified Files: SequencePropertyMutability.java NetezzaDialextExt.java Log Message: Finished dialect (tested against Netezza 4.6) Index: SequencePropertyMutability.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SequencePropertyMutability.java,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** SequencePropertyMutability.java 25 Feb 2008 11:44:48 -0000 1.1 --- SequencePropertyMutability.java 28 Dec 2009 01:48:10 -0000 1.2 *************** *** 21,25 **** /** * A class that represents what properties of a sequence can be modified (increment, start, cycle, ! * cache, etc.) Some databases (such as HSQLDB) restrict what properties of a sequence can be modified. * * @author manningr --- 21,26 ---- /** * A class that represents what properties of a sequence can be modified (increment, start, cycle, ! * cache, etc.) Some databases (such as HSQLDB and Netezza) restrict what properties of a sequence can be ! * modified. * * @author manningr Index: NetezzaDialextExt.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/NetezzaDialextExt.java,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** NetezzaDialextExt.java 25 Dec 2009 02:58:30 -0000 1.1 --- NetezzaDialextExt.java 28 Dec 2009 01:48:11 -0000 1.2 *************** *** 29,32 **** --- 29,33 ---- import java.sql.Types; + import java.util.Collection; import java.util.HashMap; import java.util.List; *************** *** 43,46 **** --- 44,48 ---- public class NetezzaDialextExt extends CommonHibernateDialect { + // Note that Netezza 4.6 doesn't have support for LOB data types. Under the hood, it appears to use // PostgreSQL, but with some limitations. *************** *** 593,597 **** /** ! * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getColumnNameAlterSQL(net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo, net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo, net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) */ @Override --- 595,602 ---- /** ! * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getColumnNameAlterSQL(net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo, ! * net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo, ! * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, ! * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) */ @Override *************** *** 604,606 **** --- 609,767 ---- } + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getRenameTableSQL(java.lang.String, + * java.lang.String, net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String getRenameTableSQL(String oldTableName, String newTableName, + DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + return DialectUtils.getRenameTableSQL(oldTableName, newTableName, qualifier, prefs, this); + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getCreateViewSQL(java.lang.String, + * java.lang.String, java.lang.String, + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String getCreateViewSQL(String viewName, String definition, String checkOption, + DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + return DialectUtils.getCreateViewSQL(viewName, definition, checkOption, qualifier, prefs, this); + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getRenameViewSQL(java.lang.String, + * java.lang.String, net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String[] getRenameViewSQL(String oldViewName, String newViewName, + DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + + String commandPrefix = DialectUtils.ALTER_VIEW_CLAUSE; + String renameClause = DialectUtils.RENAME_TO_CLAUSE; + return new String[] { DialectUtils.getRenameViewSQL(commandPrefix, renameClause, oldViewName, + newViewName, qualifier, prefs, this) }; + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getViewDefinitionSQL(java.lang.String, + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String getViewDefinitionSQL(String viewName, DatabaseObjectQualifier qualifier, + SqlGenerationPreferences prefs) + { + return "SELECT 'create or replace view ' || v.VIEWNAME || ' as ' || " + + "v.definition FROM _v_view v, _v_objs_owned o " + "where v.objid = o.objid " + + "and o.DATABASE = '" + qualifier.getCatalog() + "' " + "and v.VIEWNAME = '" + viewName + "'"; + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getCreateSequenceSQL(java.lang.String, + * java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, boolean, + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String getCreateSequenceSQL(String sequenceName, String increment, String minimum, String maximum, + String start, String cache, boolean cycle, DatabaseObjectQualifier qualifier, + SqlGenerationPreferences prefs) + { + final String minimumClause = DialectUtils.MINVALUE_CLAUSE; + final String maximumClause = DialectUtils.MAXVALUE_CLAUSE; + + String cycleClause = DialectUtils.CYCLE_CLAUSE; + if (!cycle) + { + cycleClause = DialectUtils.NO_CYCLE_CLAUSE; + } + + return DialectUtils.getCreateSequenceSQL(sequenceName, increment, minimumClause, minimum, + maximumClause, maximum, start, cache, cycleClause, qualifier, prefs, this); + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAlterSequenceSQL(java.lang.String, + * java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, boolean, + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String[] getAlterSequenceSQL(String sequenceName, String increment, String minimum, String maximum, + String restart, String cache, boolean cycle, DatabaseObjectQualifier qualifier, + SqlGenerationPreferences prefs) + { + String cycleClause = DialectUtils.CYCLE_CLAUSE; + if (!cycle) + { + cycleClause = DialectUtils.NO_CYCLE_CLAUSE; + } + + return new String[] { DialectUtils.getAlterSequenceSQL(sequenceName, increment, minimum, maximum, + restart, cache, cycleClause, qualifier, prefs, this) }; + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getSequencePropertyMutability() + */ + @Override + public SequencePropertyMutability getSequencePropertyMutability() + { + SequencePropertyMutability result = new SequencePropertyMutability(); + result.setCache(false); + return result; + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAddForeignKeyConstraintSQL(java.lang.String, + * java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, java.lang.Boolean, + * boolean, java.lang.String, java.util.Collection, java.lang.String, java.lang.String, + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String[] getAddForeignKeyConstraintSQL(String localTableName, String refTableName, + String constraintName, Boolean deferrable, Boolean initiallyDeferred, Boolean matchFull, + boolean autoFKIndex, String fkIndexName, Collection<String[]> localRefColumns, String onUpdateAction, + String onDeleteAction, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + return DialectUtils.getAddForeignKeyConstraintSQL(localTableName, refTableName, constraintName, + deferrable, initiallyDeferred, matchFull, autoFKIndex, fkIndexName, localRefColumns, onUpdateAction, + onDeleteAction, qualifier, prefs, this); + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getAddUniqueConstraintSQL(java.lang.String, + * java.lang.String, net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo[], + * net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String[] getAddUniqueConstraintSQL(String tableName, String constraintName, + TableColumnInfo[] columns, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + return new String[] { DialectUtils.getAddUniqueConstraintSQL(tableName, constraintName, columns, + qualifier, prefs, this) }; + } + + /** + * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getDropConstraintSQL(java.lang.String, + * java.lang.String, net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier, + * net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences) + */ + @Override + public String getDropConstraintSQL(String tableName, String constraintName, + DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) + { + return DialectUtils.getDropConstraintSQL(tableName, constraintName, qualifier, prefs, this) + + " RESTRICT"; + } + } |
