001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * The contents of this file are subject to the terms of the Liferay Enterprise
005     * Subscription License ("License"). You may not use this file except in
006     * compliance with the License. You can obtain a copy of the License by
007     * contacting Liferay, Inc. See the License for the specific language governing
008     * permissions and limitations under the License, including but not limited to
009     * distribution rights of the Software.
010     *
011     *
012     *
013     */
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    /**
032     * @author Alexander Chow
033     * @author Brian Wing Shun Chan
034     */
035    public class UpgradeBookmarks extends UpgradeProcess {
036    
037            protected void doUpgrade() throws Exception {
038    
039                    // BookmarksFolder
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                    // BookmarksEntry
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    }