1
22
23 package com.liferay.portal.upgrade.v4_3_0;
24
25 import com.liferay.portal.model.impl.ImageImpl;
26 import com.liferay.portal.upgrade.UpgradeException;
27 import com.liferay.portal.upgrade.UpgradeProcess;
28 import com.liferay.portal.upgrade.util.DefaultPKMapper;
29 import com.liferay.portal.upgrade.util.DefaultUpgradeTableImpl;
30 import com.liferay.portal.upgrade.util.PKUpgradeColumnImpl;
31 import com.liferay.portal.upgrade.util.UpgradeTable;
32 import com.liferay.portal.upgrade.util.ValueMapper;
33 import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
34 import com.liferay.portal.upgrade.v4_3_0.util.ImageHeightUpgradeColumnImpl;
35 import com.liferay.portal.upgrade.v4_3_0.util.ImageSizeUpgradeColumnImpl;
36 import com.liferay.portal.upgrade.v4_3_0.util.ImageTextUpgradeColumnImpl;
37 import com.liferay.portal.upgrade.v4_3_0.util.ImageTypeUpgradeColumnImpl;
38 import com.liferay.portal.upgrade.v4_3_0.util.ImageWidthUpgradeColumnImpl;
39 import com.liferay.portal.upgrade.v4_3_0.util.WebIdUtil;
40
41 import java.sql.Types;
42
43 import org.apache.commons.logging.Log;
44 import org.apache.commons.logging.LogFactory;
45
46
52 public class UpgradeImage extends UpgradeProcess {
53
54 public void upgrade() throws UpgradeException {
55 _log.info("Upgrading");
56
57 try {
58 doUpgrade();
59 }
60 catch (Exception e) {
61 throw new UpgradeException(e);
62 }
63 }
64
65 protected void doUpgrade() throws Exception {
66
67
69 String[] webIds = WebIdUtil.getWebIds();
70
71 for (int i = 0; i < webIds.length; i++) {
72 String webId = webIds[i];
73 runSQL("delete from Image where imageId = '" + webId + "'");
74
75 runSQL("delete from Image where imageId = '" + webId + ".wbmp'");
76
77 runSQL(
78 "update Image set imageId = '" + webId + "' where imageId = '" +
79 webId + ".png'");
80 }
81
82
84 PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
85 "imageId", new Integer(Types.VARCHAR), true);
86
87 ImageTextUpgradeColumnImpl upgradeTextColumn =
88 new ImageTextUpgradeColumnImpl(upgradePKColumn);
89
90 ImageTypeUpgradeColumnImpl upgradeTypeColumn =
91 new ImageTypeUpgradeColumnImpl(upgradeTextColumn);
92
93 ImageHeightUpgradeColumnImpl upgradeHeightColumn =
94 new ImageHeightUpgradeColumnImpl(upgradeTextColumn);
95
96 ImageWidthUpgradeColumnImpl upgradeWidthColumn =
97 new ImageWidthUpgradeColumnImpl(upgradeTextColumn);
98
99 ImageSizeUpgradeColumnImpl upgradeSizeColumn =
100 new ImageSizeUpgradeColumnImpl(upgradeTextColumn);
101
102 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
103 ImageImpl.TABLE_NAME, ImageImpl.TABLE_COLUMNS,
104 upgradePKColumn, upgradeTextColumn, upgradeTypeColumn,
105 upgradeHeightColumn, upgradeWidthColumn, upgradeSizeColumn);
106
107 upgradeTable.setCreateSQL(ImageImpl.TABLE_SQL_CREATE);
108
109 upgradeTable.updateTable();
110
111 ValueMapper imageIdMapper = new DefaultPKMapper(
112 upgradePKColumn.getValueMapper());
113
114 AvailableMappersUtil.setImageIdMapper(imageIdMapper);
115 }
116
117 private static Log _log = LogFactory.getLog(UpgradeImage.class);
118
119 }