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