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.UpgradeTable;
020    import com.liferay.portal.kernel.upgrade.util.UpgradeTableFactoryUtil;
021    import com.liferay.portal.kernel.upgrade.util.ValueMapper;
022    import com.liferay.portal.upgrade.util.PKUpgradeColumnImpl;
023    import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
024    import com.liferay.portal.upgrade.v4_3_0.util.ImageHeightUpgradeColumnImpl;
025    import com.liferay.portal.upgrade.v4_3_0.util.ImageSizeUpgradeColumnImpl;
026    import com.liferay.portal.upgrade.v4_3_0.util.ImageTable;
027    import com.liferay.portal.upgrade.v4_3_0.util.ImageTextUpgradeColumnImpl;
028    import com.liferay.portal.upgrade.v4_3_0.util.ImageTypeUpgradeColumnImpl;
029    import com.liferay.portal.upgrade.v4_3_0.util.ImageWidthUpgradeColumnImpl;
030    import com.liferay.portal.upgrade.v4_3_0.util.WebIdUtil;
031    
032    import java.sql.Types;
033    
034    /**
035     * @author Brian Wing Shun Chan
036     */
037    public class UpgradeImage extends UpgradeProcess {
038    
039            protected void doUpgrade() throws Exception {
040    
041                    // Company
042    
043                    String[] webIds = WebIdUtil.getWebIds();
044    
045                    for (String webId : webIds) {
046                            runSQL("delete from Image where imageId = '" + webId + "'");
047    
048                            runSQL("delete from Image where imageId = '" + webId + ".wbmp'");
049    
050                            runSQL(
051                                    "update Image set imageId = '" + webId + "' where imageId = '" +
052                                            webId + ".png'");
053                    }
054    
055                    // Image
056    
057                    PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
058                            "imageId", new Integer(Types.VARCHAR), true);
059    
060                    ImageTextUpgradeColumnImpl upgradeTextColumn =
061                            new ImageTextUpgradeColumnImpl(upgradePKColumn);
062    
063                    ImageTypeUpgradeColumnImpl upgradeTypeColumn =
064                            new ImageTypeUpgradeColumnImpl(upgradeTextColumn);
065    
066                    ImageHeightUpgradeColumnImpl upgradeHeightColumn =
067                            new ImageHeightUpgradeColumnImpl(upgradeTextColumn);
068    
069                    ImageWidthUpgradeColumnImpl upgradeWidthColumn =
070                            new ImageWidthUpgradeColumnImpl(upgradeTextColumn);
071    
072                    ImageSizeUpgradeColumnImpl upgradeSizeColumn =
073                            new ImageSizeUpgradeColumnImpl(upgradeTextColumn);
074    
075                    UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
076                            ImageTable.TABLE_NAME, ImageTable.TABLE_COLUMNS,
077                            upgradePKColumn, upgradeTextColumn, upgradeTypeColumn,
078                            upgradeHeightColumn, upgradeWidthColumn, upgradeSizeColumn);
079    
080                    upgradeTable.setCreateSQL(ImageTable.TABLE_SQL_CREATE);
081    
082                    upgradeTable.updateTable();
083    
084                    ValueMapper imageIdMapper = new DefaultPKMapper(
085                            upgradePKColumn.getValueMapper());
086    
087                    AvailableMappersUtil.setImageIdMapper(imageIdMapper);
088            }
089    
090    }