1   /**
2    * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved.
3    *
4    * The contents of this file are subject to the terms of the Liferay Enterprise
5    * Subscription License ("License"). You may not use this file except in
6    * compliance with the License. You can obtain a copy of the License by
7    * contacting Liferay, Inc. See the License for the specific language governing
8    * permissions and limitations under the License, including but not limited to
9    * distribution rights of the Software.
10   *
11   * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
12   * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
13   * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
14   * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
15   * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
16   * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
17   * SOFTWARE.
18   */
19  
20  package com.liferay.portal.upgrade.util;
21  
22  import com.liferay.portal.kernel.log.Log;
23  import com.liferay.portal.kernel.log.LogFactoryUtil;
24  import com.liferay.portal.kernel.util.FileUtil;
25  import com.liferay.portal.kernel.util.Validator;
26  import com.liferay.portal.tools.sql.DBUtil;
27  import com.liferay.portal.upgrade.UpgradeException;
28  
29  /**
30   * <a href="BaseUpgradeTableImpl.java.html"><b><i>View Source</i></b></a>
31   *
32   * @author Alexander Chow
33   * @author Brian Wing Shun Chan
34   *
35   */
36  public abstract class BaseUpgradeTableImpl extends Table {
37  
38      public BaseUpgradeTableImpl(String tableName) {
39          super(tableName);
40      }
41  
42      public BaseUpgradeTableImpl(String tableName, Object[][] columns) {
43          super(tableName, columns);
44      }
45  
46      public void setCreateSQL(String createSQL) throws Exception {
47          if (_calledUpdateTable) {
48              throw new UpgradeException(
49                  "setCreateSQL is called after updateTable");
50          }
51  
52          super.setCreateSQL(createSQL);
53      }
54  
55      public void updateTable() throws Exception {
56          _calledUpdateTable = true;
57  
58          String tempFileName = generateTempFile();
59  
60          try {
61              DBUtil dbUtil = DBUtil.getInstance();
62  
63              String createSQL = getCreateSQL();
64  
65              if (Validator.isNotNull(createSQL)) {
66                  dbUtil.runSQL("drop table " + getTableName());
67  
68                  dbUtil.runSQL(createSQL);
69              }
70  
71              if (Validator.isNotNull(tempFileName)) {
72                  String deleteSQL = getDeleteSQL();
73  
74                  dbUtil.runSQL(deleteSQL);
75  
76                  populateTable(tempFileName);
77              }
78          }
79          finally {
80              if (Validator.isNotNull(tempFileName)) {
81                  FileUtil.delete(tempFileName);
82              }
83          }
84      }
85  
86      static Log _log = LogFactoryUtil.getLog(BaseUpgradeTableImpl.class);
87  
88      private boolean _calledUpdateTable;
89  
90  }