1   /**
2    * Copyright (c) 2000-2008 Liferay, Inc. All rights reserved.
3    *
4    * Permission is hereby granted, free of charge, to any person obtaining a copy
5    * of this software and associated documentation files (the "Software"), to deal
6    * in the Software without restriction, including without limitation the rights
7    * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
8    * copies of the Software, and to permit persons to whom the Software is
9    * furnished to do so, subject to the following conditions:
10   *
11   * The above copyright notice and this permission notice shall be included in
12   * all copies or substantial portions of the Software.
13   *
14   * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
15   * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
16   * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
17   * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
18   * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
19   * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
20   * SOFTWARE.
21   */
22  
23  package com.liferay.portal.upgrade.v4_3_0;
24  
25  import com.liferay.portal.upgrade.UpgradeException;
26  import com.liferay.portal.upgrade.UpgradeProcess;
27  import com.liferay.portal.upgrade.util.DefaultUpgradeTableImpl;
28  import com.liferay.portal.upgrade.util.SwapUpgradeColumnImpl;
29  import com.liferay.portal.upgrade.util.UpgradeColumn;
30  import com.liferay.portal.upgrade.util.UpgradeTable;
31  import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
32  import com.liferay.portal.upgrade.v4_3_0.util.ValueMapperUtil;
33  
34  import java.sql.Types;
35  
36  import org.apache.commons.logging.Log;
37  import org.apache.commons.logging.LogFactory;
38  
39  /**
40   * <a href="UpgradeMappingTables.java.html"><b><i>View Source</i></b></a>
41   *
42   * @author Brian Wing Shun Chan
43   *
44   */
45  public class UpgradeMappingTables extends UpgradeProcess {
46  
47      public void upgrade() throws UpgradeException {
48          _log.info("Upgrading");
49  
50          try {
51              doUpgrade();
52          }
53          catch (Exception e) {
54              throw new UpgradeException(e);
55          }
56      }
57  
58      protected void doUpgrade() throws Exception {
59  
60          // Mappings
61  
62          UpgradeColumn upgradeGroupIdColumn = new SwapUpgradeColumnImpl(
63              "groupId", AvailableMappersUtil.getGroupIdMapper());
64  
65          UpgradeColumn upgradeOrganizationIdColumn = new SwapUpgradeColumnImpl(
66              "organizationId", AvailableMappersUtil.getOrganizationIdMapper());
67  
68          UpgradeColumn upgradeRoleIdColumn = new SwapUpgradeColumnImpl(
69              "roleId", AvailableMappersUtil.getRoleIdMapper());
70  
71          UpgradeColumn upgradeUserGroupIdColumn = new SwapUpgradeColumnImpl(
72              "userGroupId", AvailableMappersUtil.getUserGroupIdMapper());
73  
74          UpgradeColumn upgradeUserIdColumn = new SwapUpgradeColumnImpl(
75              "userId", new Integer(Types.VARCHAR),
76              AvailableMappersUtil.getUserIdMapper());
77  
78          // Groups_Orgs
79  
80          UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
81              _TABLE_GROUPS_ORGS, _COLUMNS_GROUPS_ORGS, upgradeGroupIdColumn,
82              upgradeOrganizationIdColumn);
83  
84          upgradeTable.setCreateSQL(_CREATE_GROUPS_ORGS);
85  
86          upgradeTable.updateTable();
87  
88          // Groups_Permissions
89  
90          upgradeTable = new DefaultUpgradeTableImpl(
91              _TABLE_GROUPS_PERMISSIONS, _COLUMNS_GROUPS_PERMISSIONS,
92              upgradeGroupIdColumn);
93  
94          upgradeTable.setCreateSQL(_CREATE_GROUPS_PERMISSIONS);
95  
96          upgradeTable.updateTable();
97  
98          // Groups_Roles
99  
100         upgradeTable = new DefaultUpgradeTableImpl(
101             _TABLE_GROUPS_ROLES, _COLUMNS_GROUPS_ROLES,
102             upgradeGroupIdColumn, upgradeRoleIdColumn);
103 
104         upgradeTable.setCreateSQL(_CREATE_GROUPS_ROLES);
105 
106         upgradeTable.updateTable();
107 
108         // Groups_UserGroups
109 
110         upgradeTable = new DefaultUpgradeTableImpl(
111             _TABLE_GROUPS_USERGROUPS, _COLUMNS_GROUPS_USERGROUPS,
112             upgradeGroupIdColumn, upgradeUserGroupIdColumn);
113 
114         upgradeTable.setCreateSQL(_CREATE_GROUPS_USERGROUPS);
115 
116         upgradeTable.updateTable();
117 
118         // Roles_Permissions
119 
120         upgradeTable = new DefaultUpgradeTableImpl(
121             _TABLE_ROLES_PERMISSIONS, _COLUMNS_ROLES_PERMISSIONS,
122             upgradeRoleIdColumn);
123 
124         upgradeTable.setCreateSQL(_CREATE_ROLES_PERMISSIONS);
125 
126         upgradeTable.updateTable();
127 
128         // Users_Groups
129 
130         upgradeTable = new DefaultUpgradeTableImpl(
131             _TABLE_USERS_GROUPS, _COLUMNS_USERS_GROUPS, upgradeUserIdColumn,
132             upgradeGroupIdColumn);
133 
134         upgradeTable.setCreateSQL(_CREATE_USERS_GROUPS);
135 
136         upgradeTable.updateTable();
137 
138         // Users_Orgs
139 
140         upgradeTable = new DefaultUpgradeTableImpl(
141             _TABLE_USERS_ORGS, _COLUMNS_USERS_ORGS, upgradeUserIdColumn,
142             upgradeOrganizationIdColumn);
143 
144         upgradeTable.setCreateSQL(_CREATE_USERS_ORGS);
145 
146         upgradeTable.updateTable();
147 
148         // Users_Permissions
149 
150         upgradeTable = new DefaultUpgradeTableImpl(
151             _TABLE_USERS_PERMISSIONS, _COLUMNS_USERS_PERMISSIONS,
152             upgradeUserIdColumn);
153 
154         upgradeTable.setCreateSQL(_CREATE_USERS_PERMISSIONS);
155 
156         upgradeTable.updateTable();
157 
158         // Users_Roles
159 
160         upgradeTable = new DefaultUpgradeTableImpl(
161             _TABLE_USERS_ROLES, _COLUMNS_USERS_ROLES, upgradeUserIdColumn,
162             upgradeRoleIdColumn);
163 
164         upgradeTable.setCreateSQL(_CREATE_USERS_ROLES);
165 
166         upgradeTable.updateTable();
167 
168         // Users_UserGroups
169 
170         upgradeTable = new DefaultUpgradeTableImpl(
171             _TABLE_USERS_USERGROUPS, _COLUMNS_USERS_USERGROUPS,
172             upgradeUserIdColumn, upgradeUserGroupIdColumn);
173 
174         upgradeTable.setCreateSQL(_CREATE_USERS_USERGROUPS);
175 
176         upgradeTable.updateTable();
177 
178         // Persist value mappers in case the portal was customized with
179         // additional tables that referenced these ids. This allows developers
180         // to retrieve the keys at a later point and build scripts to upgrade
181         // the other tables.
182 
183         ValueMapperUtil.persist(
184             AvailableMappersUtil.getBlogsEntryIdMapper(), "blogs-entry-id");
185 
186         ValueMapperUtil.persist(
187             AvailableMappersUtil.getBookmarksFolderIdMapper(),
188             "bookmarks-folder-id");
189 
190         ValueMapperUtil.persist(
191             AvailableMappersUtil.getBookmarksEntryIdMapper(),
192             "bookmarks-entry-id");
193 
194         ValueMapperUtil.persist(
195             AvailableMappersUtil.getCalEventIdMapper(), "cal-event-id");
196 
197         ValueMapperUtil.persist(
198             AvailableMappersUtil.getCompanyIdMapper(), "company-id");
199 
200         ValueMapperUtil.persist(
201             AvailableMappersUtil.getContactIdMapper(), "contact-id");
202 
203         ValueMapperUtil.persist(
204             AvailableMappersUtil.getDLFileEntryIdMapper(), "dl-file-entry-id");
205 
206         ValueMapperUtil.persist(
207             AvailableMappersUtil.getDLFileShortcutIdMapper(),
208             "dl-file-shortcut-id");
209 
210         ValueMapperUtil.persist(
211             AvailableMappersUtil.getDLFolderIdMapper(), "dl-folder-id");
212 
213         ValueMapperUtil.persist(
214             AvailableMappersUtil.getGroupIdMapper(), "group-id");
215 
216         ValueMapperUtil.persist(
217             AvailableMappersUtil.getIGFolderIdMapper(), "ig-folder-id");
218 
219         ValueMapperUtil.persist(
220             AvailableMappersUtil.getIGImageIdMapper(), "ig-image-id");
221 
222         ValueMapperUtil.persist(
223             AvailableMappersUtil.getImageIdMapper(), "image-id");
224 
225         ValueMapperUtil.persist(
226             AvailableMappersUtil.getJournalArticleIdMapper(),
227             "journal-article-id");
228 
229         ValueMapperUtil.persist(
230             AvailableMappersUtil.getJournalStructureIdMapper(),
231             "journal-structure-id");
232 
233         ValueMapperUtil.persist(
234             AvailableMappersUtil.getJournalTemplateIdMapper(),
235             "journal-template-id");
236 
237         ValueMapperUtil.persist(
238             AvailableMappersUtil.getLayoutPlidMapper(), "layout-plid");
239 
240         ValueMapperUtil.persist(
241             AvailableMappersUtil.getMBCategoryIdMapper(), "mb-category-id");
242 
243         ValueMapperUtil.persist(
244             AvailableMappersUtil.getMBMessageIdMapper(), "mb-message-id");
245 
246         ValueMapperUtil.persist(
247             AvailableMappersUtil.getMBThreadIdMapper(), "mb-thread-id");
248 
249         ValueMapperUtil.persist(
250             AvailableMappersUtil.getOrganizationIdMapper(), "organization-id");
251 
252         ValueMapperUtil.persist(
253             AvailableMappersUtil.getPollsQuestionIdMapper(),
254             "polls-question-id");
255 
256         ValueMapperUtil.persist(
257             AvailableMappersUtil.getRoleIdMapper(), "role-id");
258 
259         ValueMapperUtil.persist(
260             AvailableMappersUtil.getShoppingCategoryIdMapper(),
261             "shopping-category-id");
262 
263         ValueMapperUtil.persist(
264             AvailableMappersUtil.getShoppingItemIdMapper(), "shopping-item-id");
265 
266         ValueMapperUtil.persist(
267             AvailableMappersUtil.getUserGroupIdMapper(), "user-group-id");
268 
269         ValueMapperUtil.persist(
270             AvailableMappersUtil.getUserIdMapper(), "user-id");
271 
272         ValueMapperUtil.persist(
273             AvailableMappersUtil.getWikiNodeIdMapper(), "wiki-node-id");
274 
275         ValueMapperUtil.persist(
276             AvailableMappersUtil.getWikiPageIdMapper(), "wiki-page-id");
277     }
278 
279     private static final String _TABLE_GROUPS_ORGS = "Groups_Orgs";
280 
281     private static final String _TABLE_GROUPS_ROLES = "Groups_Roles";
282 
283     private static final String _TABLE_GROUPS_PERMISSIONS =
284         "Groups_Permissions";
285 
286     private static final String _TABLE_GROUPS_USERGROUPS = "Groups_UserGroups";
287 
288     private static final String _TABLE_ROLES_PERMISSIONS = "Roles_Permissions";
289 
290     private static final String _TABLE_USERS_GROUPS = "Users_Groups";
291 
292     private static final String _TABLE_USERS_ORGS = "Users_Orgs";
293 
294     private static final String _TABLE_USERS_PERMISSIONS = "Users_Permissions";
295 
296     private static final String _TABLE_USERS_ROLES = "Users_Roles";
297 
298     private static final String _TABLE_USERS_USERGROUPS = "Users_UserGroups";
299 
300     private static final Object[][] _COLUMNS_GROUPS_ORGS = {
301         {"groupId", new Integer(Types.BIGINT)},
302         {"organizationId", new Integer(Types.BIGINT)}
303     };
304 
305     private static final Object[][] _COLUMNS_GROUPS_PERMISSIONS = {
306         {"groupId", new Integer(Types.BIGINT)},
307         {"permissionId", new Integer(Types.BIGINT)}
308     };
309 
310     private static final Object[][] _COLUMNS_GROUPS_ROLES = {
311         {"groupId", new Integer(Types.BIGINT)},
312         {"roleId", new Integer(Types.BIGINT)}
313     };
314 
315     private static final Object[][] _COLUMNS_GROUPS_USERGROUPS = {
316         {"groupId", new Integer(Types.BIGINT)},
317         {"userGroupId", new Integer(Types.BIGINT)}
318     };
319 
320     private static final Object[][] _COLUMNS_ROLES_PERMISSIONS = {
321         {"roleId", new Integer(Types.BIGINT)},
322         {"permissionId", new Integer(Types.BIGINT)}
323     };
324 
325     private static final Object[][] _COLUMNS_USERS_GROUPS = {
326         {"userId", new Integer(Types.BIGINT)},
327         {"groupId", new Integer(Types.BIGINT)}
328     };
329 
330     private static final Object[][] _COLUMNS_USERS_ORGS = {
331         {"userId", new Integer(Types.BIGINT)},
332         {"organizationId", new Integer(Types.BIGINT)}
333     };
334 
335     private static final Object[][] _COLUMNS_USERS_PERMISSIONS = {
336         {"userId", new Integer(Types.BIGINT)},
337         {"permissionId", new Integer(Types.BIGINT)}
338     };
339 
340     private static final Object[][] _COLUMNS_USERS_ROLES = {
341         {"userId", new Integer(Types.BIGINT)},
342         {"roleId", new Integer(Types.BIGINT)}
343     };
344 
345     private static final Object[][] _COLUMNS_USERS_USERGROUPS = {
346         {"userId", new Integer(Types.BIGINT)},
347         {"userGroupId", new Integer(Types.BIGINT)}
348     };
349 
350     private static final String _CREATE_GROUPS_ORGS =
351         "create table Groups_Orgs (" +
352             "groupId LONG not null," +
353             "organizationId LONG not null," +
354             "primary key (groupId, organizationId)" +
355         ")";
356 
357     private static final String _CREATE_GROUPS_PERMISSIONS =
358         "create table Groups_Permissions (" +
359             "groupId LONG not null," +
360             "permissionId LONG not null," +
361             "primary key (groupId, permissionId)" +
362         ")";
363 
364     private static final String _CREATE_GROUPS_ROLES =
365         "create table Groups_Roles (" +
366             "groupId LONG not null," +
367             "roleId LONG not null," +
368             "primary key (groupId, roleId)" +
369         ")";
370 
371     private static final String _CREATE_GROUPS_USERGROUPS =
372         "create table Groups_UserGroups (" +
373             "groupId LONG not null," +
374             "userGroupId LONG not null," +
375             "primary key (groupId, userGroupId)" +
376         ")";
377 
378     private static final String _CREATE_ROLES_PERMISSIONS =
379         "create table Roles_Permissions (" +
380             "roleId LONG not null," +
381             "permissionId LONG not null," +
382             "primary key (roleId, permissionId)" +
383         ")";
384 
385     private static final String _CREATE_USERS_GROUPS =
386         "create table Users_Groups (" +
387             "userId LONG not null," +
388             "groupId LONG not null," +
389             "primary key (userId, groupId)" +
390         ")";
391 
392     private static final String _CREATE_USERS_ORGS =
393         "create table Users_Orgs (" +
394             "userId LONG not null," +
395             "organizationId LONG not null," +
396             "primary key (userId, organizationId)" +
397         ")";
398 
399     private static final String _CREATE_USERS_PERMISSIONS =
400         "create table Users_Permissions (" +
401             "userId LONG not null," +
402             "permissionId LONG not null," +
403             "primary key (userId, permissionId)" +
404         ")";
405 
406     private static final String _CREATE_USERS_ROLES =
407         "create table Users_Roles (" +
408             "userId LONG not null," +
409             "roleId LONG not null," +
410             "primary key (userId, roleId)" +
411         ")";
412 
413     private static final String _CREATE_USERS_USERGROUPS =
414         "create table Users_UserGroups (" +
415             "userId LONG not null," +
416             "userGroupId LONG not null," +
417             "primary key (userId, userGroupId)" +
418         ")";
419 
420     private static Log _log = LogFactory.getLog(UpgradeMappingTables.class);
421 
422 }