001
014
015 package com.liferay.portal.upgrade.v6_0_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.util.LoggingTimer;
019 import com.liferay.portal.kernel.util.StringBundler;
020 import com.liferay.portal.upgrade.v6_0_0.util.ShoppingItemTable;
021
022
025 public class UpgradeShopping extends UpgradeProcess {
026
027 @Override
028 protected void doUpgrade() throws Exception {
029 updateShoppingItem();
030
031 alter(
032 ShoppingItemTable.class,
033 new AlterColumnType("smallImageURL", "STRING null"),
034 new AlterColumnType("mediumImageURL", "STRING null"),
035 new AlterColumnType("largeImageURL", "STRING null"));
036 }
037
038 protected void updateShoppingItem() throws Exception {
039 try (LoggingTimer loggingTimer = new LoggingTimer()) {
040 StringBundler sb = new StringBundler(3);
041
042 sb.append("update ShoppingItem set groupId = (select groupId ");
043 sb.append("from ShoppingCategory where ");
044 sb.append("ShoppingCategory.categoryId = ShoppingItem.categoryId)");
045
046 runSQL(sb.toString());
047 }
048 }
049
050 }