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.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
037 public class UpgradeImage extends UpgradeProcess {
038
039 protected void doUpgrade() throws Exception {
040
041
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
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 }