1
22
23 package com.liferay.portal.upgrade.v4_3_0;
24
25 import com.liferay.portal.upgrade.UpgradeProcess;
26 import com.liferay.portal.upgrade.util.DefaultPKMapper;
27 import com.liferay.portal.upgrade.util.DefaultUpgradeTableImpl;
28 import com.liferay.portal.upgrade.util.PKUpgradeColumnImpl;
29 import com.liferay.portal.upgrade.util.SwapUpgradeColumnImpl;
30 import com.liferay.portal.upgrade.util.UpgradeColumn;
31 import com.liferay.portal.upgrade.util.UpgradeTable;
32 import com.liferay.portal.upgrade.util.ValueMapper;
33 import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
34 import com.liferay.portal.upgrade.v4_3_0.util.BookmarksEntryTable;
35 import com.liferay.portal.upgrade.v4_3_0.util.BookmarksFolderTable;
36
37 import java.sql.Types;
38
39
45 public class UpgradeBookmarks extends UpgradeProcess {
46
47 protected void doUpgrade() throws Exception {
48
49
51 UpgradeColumn upgradeGroupIdColumn = new SwapUpgradeColumnImpl(
52 "groupId", AvailableMappersUtil.getGroupIdMapper());
53
54 UpgradeColumn upgradeUserIdColumn = new SwapUpgradeColumnImpl(
55 "userId", new Integer(Types.VARCHAR),
56 AvailableMappersUtil.getUserIdMapper());
57
58 PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
59 "folderId", true);
60
61 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
62 BookmarksFolderTable.TABLE_NAME, BookmarksFolderTable.TABLE_COLUMNS,
63 upgradePKColumn, upgradeGroupIdColumn, upgradeUserIdColumn);
64
65 upgradeTable.setCreateSQL(BookmarksFolderTable.TABLE_SQL_CREATE);
66
67 upgradeTable.updateTable();
68
69 ValueMapper folderIdMapper = new DefaultPKMapper(
70 upgradePKColumn.getValueMapper());
71
72 AvailableMappersUtil.setBookmarksFolderIdMapper(folderIdMapper);
73
74 UpgradeColumn upgradeParentFolderIdColumn = new SwapUpgradeColumnImpl(
75 "parentFolderId", folderIdMapper);
76
77 upgradeTable = new DefaultUpgradeTableImpl(
78 BookmarksFolderTable.TABLE_NAME, BookmarksFolderTable.TABLE_COLUMNS,
79 upgradeParentFolderIdColumn);
80
81 upgradeTable.updateTable();
82
83 UpgradeColumn upgradeFolderIdColumn = new SwapUpgradeColumnImpl(
84 "folderId", folderIdMapper);
85
86
88 upgradePKColumn = new PKUpgradeColumnImpl("entryId", true);
89
90 upgradeTable = new DefaultUpgradeTableImpl(
91 BookmarksEntryTable.TABLE_NAME, BookmarksEntryTable.TABLE_COLUMNS,
92 upgradePKColumn, upgradeFolderIdColumn, upgradeUserIdColumn);
93
94 upgradeTable.setCreateSQL(BookmarksEntryTable.TABLE_SQL_CREATE);
95
96 upgradeTable.updateTable();
97
98 ValueMapper entryIdMapper = upgradePKColumn.getValueMapper();
99
100 AvailableMappersUtil.setBookmarksEntryIdMapper(entryIdMapper);
101 }
102
103 }