← Back to branch summary

~ubuntu-branches/ubuntu/utopic/apgdiff/utopic-proposed

« back to all changes in this revision

Viewing changes to src/main/java/cz/startnet/utils/pgdiff/PgDiff.java

  • Committer: Bazaar Package Importer
  • Author(s): Christoph Berg
  • Date: 2010-10-11 09:08:18 UTC
  • mfrom: (1.1.4 upstream)
  • Revision ID: james.westby@ubuntu.com-20101011090818-s0bzw1ieg6rmpfld
Tags: 2.2.2-1
* New upstream version.
* Using changelog included in zipfile, thanks Miroslav for providing this.
* Update manpage.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/main/java/cz/startnet/utils/pgdiff/PgDiff.java
108
108
        if (arguments.isOutputIgnoredStatements()) {
109
109
            if (!oldDatabase.getIgnoredStatements().isEmpty()) {
110
110
                writer.println();
111
 
                writer.println("/* Original database ignored statements");
 
111
                writer.print("/* ");
 
112
                writer.println(Resources.getString(
 
113
                        "OriginalDatabaseIgnoredStatements"));
112
114
 
113
115
                for (final String statement :
114
116
                        oldDatabase.getIgnoredStatements()) {
121
123
 
122
124
            if (!newDatabase.getIgnoredStatements().isEmpty()) {
123
125
                writer.println();
124
 
                writer.println("/* New database ignored statements");
 
126
                writer.print("/* ");
 
127
                writer.println(
 
128
                        Resources.getString("NewDatabaseIgnoredStatements"));
125
129
 
126
130
                for (final String statement :
127
131
                        newDatabase.getIgnoredStatements()) {
168
172
                || !newDatabase.getSchemas().get(0).getName().equals("public");
169
173
 
170
174
        for (final PgSchema newSchema : newDatabase.getSchemas()) {
 
175
            final SearchPathHelper searchPathHelper;
 
176
 
171
177
            if (setSearchPath) {
172
 
                writer.println();
173
 
                writer.println("SET search_path = "
 
178
                searchPathHelper = new SearchPathHelper("SET search_path = "
174
179
                        + PgDiffUtils.getQuotedName(newSchema.getName(), true)
175
180
                        + ", pg_catalog;");
 
181
            } else {
 
182
                searchPathHelper = new SearchPathHelper(null);
176
183
            }
177
184
 
178
185
            final PgSchema oldSchema =
179
186
                    oldDatabase.getSchema(newSchema.getName());
180
187
 
181
 
            PgDiffTriggers.dropTriggers(writer, oldSchema, newSchema);
 
188
            PgDiffTriggers.dropTriggers(
 
189
                    writer, oldSchema, newSchema, searchPathHelper);
182
190
            PgDiffFunctions.dropFunctions(
183
 
                    writer, arguments, oldSchema, newSchema);
 
191
                    writer, arguments, oldSchema, newSchema, searchPathHelper);
184
192
            PgDiffFunctions.createFunctions(
185
 
                    writer, arguments, oldSchema, newSchema);
186
 
            PgDiffViews.dropViews(writer, oldSchema, newSchema);
187
 
            PgDiffConstraints.dropConstraints(
188
 
                    writer, oldSchema, newSchema, true);
189
 
            PgDiffConstraints.dropConstraints(
190
 
                    writer, oldSchema, newSchema, false);
191
 
            PgDiffIndexes.dropIndexes(writer, oldSchema, newSchema);
192
 
            PgDiffTables.dropClusters(writer, oldSchema, newSchema);
193
 
            PgDiffTables.dropTables(writer, oldSchema, newSchema);
194
 
            PgDiffSequences.dropSequences(writer, oldSchema, newSchema);
 
193
                    writer, arguments, oldSchema, newSchema, searchPathHelper);
 
194
            PgDiffViews.dropViews(
 
195
                    writer, oldSchema, newSchema, searchPathHelper);
 
196
            PgDiffConstraints.dropConstraints(
 
197
                    writer, oldSchema, newSchema, true, searchPathHelper);
 
198
            PgDiffConstraints.dropConstraints(
 
199
                    writer, oldSchema, newSchema, false, searchPathHelper);
 
200
            PgDiffIndexes.dropIndexes(
 
201
                    writer, oldSchema, newSchema, searchPathHelper);
 
202
            PgDiffTables.dropClusters(
 
203
                    writer, oldSchema, newSchema, searchPathHelper);
 
204
            PgDiffTables.dropTables(
 
205
                    writer, oldSchema, newSchema, searchPathHelper);
 
206
            PgDiffSequences.dropSequences(
 
207
                    writer, oldSchema, newSchema, searchPathHelper);
195
208
 
196
 
            PgDiffSequences.createSequences(writer, oldSchema, newSchema);
 
209
            PgDiffSequences.createSequences(
 
210
                    writer, oldSchema, newSchema, searchPathHelper);
197
211
            PgDiffSequences.alterSequences(
198
 
                    writer, arguments, oldSchema, newSchema);
199
 
            PgDiffTables.createTables(writer, oldSchema, newSchema);
200
 
            PgDiffTables.alterTables(writer, arguments, oldSchema, newSchema);
201
 
            PgDiffConstraints.createConstraints(
202
 
                    writer, oldSchema, newSchema, true);
203
 
            PgDiffConstraints.createConstraints(
204
 
                    writer, oldSchema, newSchema, false);
205
 
            PgDiffIndexes.createIndexes(writer, oldSchema, newSchema);
206
 
            PgDiffTables.createClusters(writer, oldSchema, newSchema);
207
 
            PgDiffTriggers.createTriggers(writer, oldSchema, newSchema);
208
 
            PgDiffViews.createViews(writer, oldSchema, newSchema);
209
 
            PgDiffViews.alterViews(writer, oldSchema, newSchema);
 
212
                    writer, arguments, oldSchema, newSchema, searchPathHelper);
 
213
            PgDiffTables.createTables(
 
214
                    writer, oldSchema, newSchema, searchPathHelper);
 
215
            PgDiffTables.alterTables(
 
216
                    writer, arguments, oldSchema, newSchema, searchPathHelper);
 
217
            PgDiffConstraints.createConstraints(
 
218
                    writer, oldSchema, newSchema, true, searchPathHelper);
 
219
            PgDiffConstraints.createConstraints(
 
220
                    writer, oldSchema, newSchema, false, searchPathHelper);
 
221
            PgDiffIndexes.createIndexes(
 
222
                    writer, oldSchema, newSchema, searchPathHelper);
 
223
            PgDiffTables.createClusters(
 
224
                    writer, oldSchema, newSchema, searchPathHelper);
 
225
            PgDiffTriggers.createTriggers(
 
226
                    writer, oldSchema, newSchema, searchPathHelper);
 
227
            PgDiffViews.createViews(
 
228
                    writer, oldSchema, newSchema, searchPathHelper);
 
229
            PgDiffViews.alterViews(
 
230
                    writer, oldSchema, newSchema, searchPathHelper);
210
231
        }
211
232
    }
212
233
}