blob: 7d3e4f53b5a5e90f31d921f42719b4897f109eb2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
// Copyright (C) 2010 The Android Open Source Project
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package com.google.gerrit.server.schema;
import com.google.gerrit.reviewdb.AccountProjectWatch;
import com.google.gerrit.reviewdb.ReviewDb;
import com.google.gwtorm.client.OrmException;
import com.google.gwtorm.jdbc.JdbcSchema;
import com.google.gwtorm.schema.sql.DialectH2;
import com.google.gwtorm.schema.sql.DialectMySQL;
import com.google.gwtorm.schema.sql.DialectPostgreSQL;
import com.google.gwtorm.schema.sql.SqlDialect;
import com.google.inject.Inject;
import com.google.inject.Provider;
import java.sql.SQLException;
import java.sql.Statement;
public class Schema_40 extends SchemaVersion {
@Inject
Schema_40(Provider<Schema_39> prior) {
super(prior);
}
@Override
protected void migrateData(ReviewDb db, UpdateUI ui) throws SQLException,
OrmException {
// Set to "*" the filter field of the previously watched projects
//
Statement stmt = ((JdbcSchema) db).getConnection().createStatement();
try {
stmt.execute("UPDATE account_project_watches" //
+ " SET filter = '" + AccountProjectWatch.FILTER_ALL + "'" //
+ " WHERE filter IS NULL OR filter = ''");
// Set the new primary key
//
final SqlDialect dialect = ((JdbcSchema) db).getDialect();
if (dialect instanceof DialectPostgreSQL) {
stmt.execute("ALTER TABLE account_project_watches "
+ "DROP CONSTRAINT account_project_watches_pkey");
stmt.execute("ALTER TABLE account_project_watches "
+ "ADD PRIMARY KEY (account_id, project_name, filter)");
} else if ((dialect instanceof DialectH2)
|| (dialect instanceof DialectMySQL)) {
stmt.execute("ALTER TABLE account_project_watches DROP PRIMARY KEY");
stmt.execute("ALTER TABLE account_project_watches "
+ "ADD PRIMARY KEY (account_id, project_name, filter)");
} else {
throw new OrmException("Unsupported dialect " + dialect);
}
} finally {
stmt.close();
}
}
}
|
