UpgradeImageGallery.java |
1 /** 2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved. 3 * 4 * Permission is hereby granted, free of charge, to any person obtaining a copy 5 * of this software and associated documentation files (the "Software"), to deal 6 * in the Software without restriction, including without limitation the rights 7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 8 * copies of the Software, and to permit persons to whom the Software is 9 * furnished to do so, subject to the following conditions: 10 * 11 * The above copyright notice and this permission notice shall be included in 12 * all copies or substantial portions of the Software. 13 * 14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 20 * SOFTWARE. 21 */ 22 23 package com.liferay.portal.upgrade.v5_2_3; 24 25 import com.liferay.portal.kernel.dao.jdbc.DataAccess; 26 import com.liferay.portal.kernel.log.Log; 27 import com.liferay.portal.kernel.log.LogFactoryUtil; 28 import com.liferay.portal.upgrade.UpgradeException; 29 import com.liferay.portal.upgrade.UpgradeProcess; 30 31 import java.sql.Connection; 32 import java.sql.PreparedStatement; 33 import java.sql.ResultSet; 34 35 /** 36 * <a href="UpgradeImageGallery.java.html"><b><i>View Source</i></b></a> 37 * 38 * @author Brian Wing Shun Chan 39 * 40 */ 41 public class UpgradeImageGallery extends UpgradeProcess { 42 43 public void upgrade() throws UpgradeException { 44 _log.info("Upgrading"); 45 46 try { 47 doUpgrade(); 48 } 49 catch (Exception e) { 50 throw new UpgradeException(e); 51 } 52 } 53 54 protected void doUpgrade() throws Exception { 55 Connection con = null; 56 PreparedStatement ps = null; 57 ResultSet rs = null; 58 59 try { 60 con = DataAccess.getConnection(); 61 62 ps = con.prepareStatement("select folderId, groupId from IGFolder"); 63 64 rs = ps.executeQuery(); 65 66 while (rs.next()) { 67 long folderId = rs.getLong("folderId"); 68 long groupId = rs.getLong("groupId"); 69 70 runSQL( 71 "update IGImage set groupId = " + groupId + 72 " where folderId = " + folderId); 73 } 74 } 75 finally { 76 DataAccess.cleanUp(con, ps, rs); 77 } 78 } 79 80 private static Log _log = LogFactoryUtil.getLog(UpgradeImageGallery.class); 81 82 }