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.SwapUpgradeColumnImpl;
30 import com.liferay.portal.upgrade.util.UpgradeColumn;
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.IGFolderTable;
35 import com.liferay.portal.upgrade.v4_3_0.util.IGImageIdUpgradeColumnImpl;
36 import com.liferay.portal.upgrade.v4_3_0.util.IGImageTable;
37 import com.liferay.portal.upgrade.v4_3_0.util.IGLargeImageIdUpgradeColumnImpl;
38 import com.liferay.portal.upgrade.v4_3_0.util.IGSmallImageIdUpgradeColumnImpl;
39
40 import java.sql.Types;
41
42
47 public class UpgradeImageGallery extends UpgradeProcess {
48
49 protected void doUpgrade() throws Exception {
50
51
53 UpgradeColumn upgradeCompanyIdColumn = new SwapUpgradeColumnImpl(
54 "companyId", new Integer(Types.VARCHAR),
55 AvailableMappersUtil.getCompanyIdMapper());
56
57 UpgradeColumn upgradeGroupIdColumn = new SwapUpgradeColumnImpl(
58 "groupId", AvailableMappersUtil.getGroupIdMapper());
59
60 UpgradeColumn upgradeUserIdColumn = new SwapUpgradeColumnImpl(
61 "userId", new Integer(Types.VARCHAR),
62 AvailableMappersUtil.getUserIdMapper());
63
64 PKUpgradeColumnImpl upgradePKColumn = new PKUpgradeColumnImpl(
65 "folderId", true);
66
67 UpgradeTable upgradeTable = new DefaultUpgradeTableImpl(
68 IGFolderTable.TABLE_NAME, IGFolderTable.TABLE_COLUMNS,
69 upgradePKColumn, upgradeGroupIdColumn, upgradeUserIdColumn);
70
71 upgradeTable.setCreateSQL(IGFolderTable.TABLE_SQL_CREATE);
72
73 upgradeTable.updateTable();
74
75 ValueMapper folderIdMapper = new DefaultPKMapper(
76 upgradePKColumn.getValueMapper());
77
78 AvailableMappersUtil.setIGFolderIdMapper(folderIdMapper);
79
80 UpgradeColumn upgradeParentFolderIdColumn = new SwapUpgradeColumnImpl(
81 "parentFolderId", folderIdMapper);
82
83 upgradeTable = new DefaultUpgradeTableImpl(
84 IGFolderTable.TABLE_NAME, IGFolderTable.TABLE_COLUMNS,
85 upgradeParentFolderIdColumn);
86
87 upgradeTable.updateTable();
88
89 UpgradeColumn upgradeFolderIdColumn = new SwapUpgradeColumnImpl(
90 "folderId", folderIdMapper);
91
92
94 PKUpgradeColumnImpl upgradeImageIdColumn =
95 new IGImageIdUpgradeColumnImpl(upgradeCompanyIdColumn);
96
97 UpgradeColumn upgradeSmallImageIdColumn =
98 new IGSmallImageIdUpgradeColumnImpl(
99 upgradeCompanyIdColumn, upgradeImageIdColumn,
100 AvailableMappersUtil.getImageIdMapper());
101
102 UpgradeColumn upgradeLargeImageIdColumn =
103 new IGLargeImageIdUpgradeColumnImpl(
104 upgradeCompanyIdColumn, upgradeImageIdColumn,
105 AvailableMappersUtil.getImageIdMapper());
106
107 upgradeTable = new DefaultUpgradeTableImpl(
108 IGImageTable.TABLE_NAME, IGImageTable.TABLE_COLUMNS,
109 upgradeCompanyIdColumn, upgradeImageIdColumn, upgradeUserIdColumn,
110 upgradeFolderIdColumn, upgradeSmallImageIdColumn,
111 upgradeLargeImageIdColumn);
112
113 upgradeTable.setCreateSQL(IGImageTable.TABLE_SQL_CREATE);
114
115 upgradeTable.updateTable();
116
117 ValueMapper imageIdMapper = upgradeImageIdColumn.getValueMapper();
118
119 AvailableMappersUtil.setIGImageIdMapper(imageIdMapper);
120 }
121
122 }