1
22
23 package com.liferay.portal.upgrade.v4_3_0;
24
25 import com.liferay.portal.upgrade.UpgradeProcess;
26 import com.liferay.portal.upgrade.util.DefaultPKMapper;
27 import com.liferay.portal.upgrade.util.DefaultUpgradeTableImpl;
28 import com.liferay.portal.upgrade.util.PKUpgradeColumnImpl;
29 import com.liferay.portal.upgrade.util.UpgradeTable;
30 import com.liferay.portal.upgrade.util.ValueMapper;
31 import com.liferay.portal.upgrade.v4_3_0.util.AvailableMappersUtil;
32 import com.liferay.portal.upgrade.v4_3_0.util.ImageHeightUpgradeColumnImpl;
33 import com.liferay.portal.upgrade.v4_3_0.util.ImageSizeUpgradeColumnImpl;
34 import com.liferay.portal.upgrade.v4_3_0.util.ImageTable;
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
47 public class UpgradeImage extends UpgradeProcess {
48
49 protected void doUpgrade() throws Exception {
50
51
53 String[] webIds = WebIdUtil.getWebIds();
54
55 for (String webId : webIds) {
56 runSQL("delete from Image where imageId = '" + webId + "'");
57
58 runSQL("delete from Image where imageId = '" + webId + ".wbmp'");
59
60 runSQL(
61 "update Image set imageId = '" + webId + "' where imageId = '" +
62 webId + ".png'");
63 }
64
65
67 PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
68 "imageId", new Integer(Types.VARCHAR), true);
69
70 ImageTextUpgradeColumnImpl upgradeTextColumn =
71 new ImageTextUpgradeColumnImpl(upgradePKColumn);
72
73 ImageTypeUpgradeColumnImpl upgradeTypeColumn =
74 new ImageTypeUpgradeColumnImpl(upgradeTextColumn);
75
76 ImageHeightUpgradeColumnImpl upgradeHeightColumn =
77 new ImageHeightUpgradeColumnImpl(upgradeTextColumn);
78
79 ImageWidthUpgradeColumnImpl upgradeWidthColumn =
80 new ImageWidthUpgradeColumnImpl(upgradeTextColumn);
81
82 ImageSizeUpgradeColumnImpl upgradeSizeColumn =
83 new ImageSizeUpgradeColumnImpl(upgradeTextColumn);
84
85 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
86 ImageTable.TABLE_NAME, ImageTable.TABLE_COLUMNS,
87 upgradePKColumn, upgradeTextColumn, upgradeTypeColumn,
88 upgradeHeightColumn, upgradeWidthColumn, upgradeSizeColumn);
89
90 upgradeTable.setCreateSQL(ImageTable.TABLE_SQL_CREATE);
91
92 upgradeTable.updateTable();
93
94 ValueMapper imageIdMapper = new DefaultPKMapper(
95 upgradePKColumn.getValueMapper());
96
97 AvailableMappersUtil.setImageIdMapper(imageIdMapper);
98 }
99
100 }