Package net.sourceforge.squirrel_sql.fw.dialects

Examples of net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier

80
81
82
83
84
85
86
87
88
89
90
91
   * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements()
   */
  @Override
  protected String[] generateSQLStatements() throws UserCancelledOperationException
  {
    DatabaseObjectQualifier qualifier =
      new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());

    String[] result =
      _dialect.getAlterSequenceSQL(customDialog.getSequenceName(),
        customDialog.getIncrement(),
        customDialog.getMinimum(),
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
165
  {
    ResultSet rs = null;
    AddModifySequenceDialog result = null;

    String simpleName = _info[0].getSimpleName();
    DatabaseObjectQualifier qualifier =
      new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());
    String sql = _dialect.getSequenceInformationSQL(simpleName, qualifier, _sqlPrefs);

    try
    {
      rs = executeQuery(sql, simpleName);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    }
   
    _session = session;
    _info = info;

    _qualifier = new DatabaseObjectQualifier(info[0].getCatalogName(), info[0].getSchemaName());
   
    RefactoringPreferenceBean prefsBean = RefactoringPreferencesManager.getPreferences();
    _sqlPrefs = new SqlGenerationPreferences();
    if (prefsBean != null)
    {
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
    @Override
    protected String[] generateSQLStatements() throws UserCancelledOperationException {
        ArrayList<String> result = new ArrayList<String>();

        for (IndexInfo iInfo : _dropIndexInfo) {
            DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(iInfo.getCatalogName(), iInfo.getSchemaName());
            result.add(_dialect.getDropConstraintSQL(iInfo.getTableName(), iInfo.getSimpleName(), qualifier, _sqlPrefs));
        }

        return result.toArray(new String[]{});
    }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
  {
    String[] result = new String[0];

    if (_dialect.supportsAutoIncrement())
    {
      DatabaseObjectQualifier qualifier =
        new DatabaseObjectQualifier(columnToModify.getCatalogName(), columnToModify.getSchemaName());

      // TODO: Allow the user to specify the sequence name for dialects that don't natively support
      // auto-increment columns without using sequence/trigger combo.
      final StringBuilder sequenceName = new StringBuilder();
      sequenceName.append(columnToModify.getTableName().toUpperCase()).append("_");
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    String joinString = customDialog.getJoinString();
    String column1 = customDialog.getFirstColumn();
    String column2 = customDialog.getSecondColumn();
    String catalog = _info[0].getCatalogName();
    String schema = _info[0].getSchemaName();
    DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(catalog, schema);
    String table = _info[0].getSimpleName();
    ArrayList<String[]> data = new ArrayList<String[]>();
    String mergeInColumn = "";
    int typeLength = 0;
    Statement stmt = null;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
    if (_dialect.supportsDropSequence())
    {
      for (IDatabaseObjectInfo dbo : _info)
      {
        DatabaseObjectQualifier qualifier =
          new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName());
        result.add(_dialect.getDropSequenceSQL(dbo.getSimpleName(),
          customDialog.isCascadeSelected(),
          qualifier,
          _sqlPrefs));
      }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
    protected String[] generateSQLStatements() throws UserCancelledOperationException {
        ArrayList<String> result = new ArrayList<String>();

        if (_dialect.supportsDropIndex()) {
            for (IndexInfo iInfo : _dropIndexInfo) {
                DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(iInfo.getCatalogName(), iInfo.getSchemaName());
                result.add(_dialect.getDropIndexSQL(_tableName, iInfo.getSimpleName(),
                        customDialog.isCascadeSelected(), qualifier, _sqlPrefs));
            }
        } else {
            _session.showMessage(s_stringMgr.getString("DropIndexCommand.unsupportedOperationMsg",
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
  protected String[] generateSQLStatements() throws UserCancelledOperationException
  {
    String result = null;
    try
    {
      DatabaseObjectQualifier qualifier =
        new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());

      result =
        _dialect.getRenameTableSQL(_info[0].getSimpleName(),
          customDialog.getNewSimpleName(),
          qualifier,
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier

  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddAutoIncrementCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddColumnCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddForeignKeyCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddIndexCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddSequenceCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddUniqueConstraintCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.AddViewCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.DropIndexTableCommand
  • net.sourceforge.squirrel_sql.plugins.refactoring.commands.DropSequenceCommand
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.