1
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
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 }