001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
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    }