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