001
014
015 package com.liferay.portal.upgrade.v4_3_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.upgrade.util.DefaultPKMapper;
019 import com.liferay.portal.kernel.upgrade.util.SwapUpgradeColumnImpl;
020 import com.liferay.portal.kernel.upgrade.util.UpgradeColumn;
021 import com.liferay.portal.kernel.upgrade.util.UpgradeTable;
022 import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
023 import com.liferay.portal.kernel.upgrade.util.ValueMapper;
024 import com.liferay.portal.upgrade.util.PKUpgradeColumnImpl;
025 import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
026 import com.liferay.portal.upgrade.v4_3_0.util.BookmarksEntryTable;
027 import com.liferay.portal.upgrade.v4_3_0.util.BookmarksFolderTable;
028
029 import java.sql.Types;
030
031
035 public class UpgradeBookmarks extends UpgradeProcess {
036
037 protected void doUpgrade() throws Exception {
038
039
040
041 UpgradeColumn upgradeGroupIdColumn = new SwapUpgradeColumnImpl(
042 "groupId", AvailableMappersUtil.getGroupIdMapper());
043
044 UpgradeColumn upgradeUserIdColumn = new SwapUpgradeColumnImpl(
045 "userId", new Integer(Types.VARCHAR),
046 AvailableMappersUtil.getUserIdMapper());
047
048 PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
049 "folderId", true);
050
051 UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
052 BookmarksFolderTable.TABLE_NAME, BookmarksFolderTable.TABLE_COLUMNS,
053 upgradePKColumn, upgradeGroupIdColumn, upgradeUserIdColumn);
054
055 upgradeTable.setCreateSQL(BookmarksFolderTable.TABLE_SQL_CREATE);
056
057 upgradeTable.updateTable();
058
059 ValueMapper folderIdMapper = new DefaultPKMapper(
060 upgradePKColumn.getValueMapper());
061
062 AvailableMappersUtil.setBookmarksFolderIdMapper(folderIdMapper);
063
064 UpgradeColumn upgradeParentFolderIdColumn = new SwapUpgradeColumnImpl(
065 "parentFolderId", folderIdMapper);
066
067 upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
068 BookmarksFolderTable.TABLE_NAME, BookmarksFolderTable.TABLE_COLUMNS,
069 upgradeParentFolderIdColumn);
070
071 upgradeTable.updateTable();
072
073 UpgradeColumn upgradeFolderIdColumn = new SwapUpgradeColumnImpl(
074 "folderId", folderIdMapper);
075
076
077
078 upgradePKColumn = new PKUpgradeColumnImpl("entryId", true);
079
080 upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
081 BookmarksEntryTable.TABLE_NAME, BookmarksEntryTable.TABLE_COLUMNS,
082 upgradePKColumn, upgradeFolderIdColumn, upgradeUserIdColumn);
083
084 upgradeTable.setCreateSQL(BookmarksEntryTable.TABLE_SQL_CREATE);
085
086 upgradeTable.updateTable();
087
088 ValueMapper entryIdMapper = upgradePKColumn.getValueMapper();
089
090 AvailableMappersUtil.setBookmarksEntryIdMapper(entryIdMapper);
091 }
092
093 }