1
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
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
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
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
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
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
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
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
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
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
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
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
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
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 }