com.liferay.portal.upgrade.util
Class Table

java.lang.Object
  extended by com.liferay.portal.upgrade.util.Table
Direct Known Subclasses:
BaseUpgradeTableImpl, PermissionView, ResourcePermissionView

public class Table
extends java.lang.Object

View Source

Author:
Alexander Chow, Brian Wing Shun Chan, Raymond Augé

Field Summary
static int BATCH_SIZE
           
static java.lang.String[][] SAFE_CHARS
           
static java.lang.String SAFE_COMMA_CHARACTER
           
static java.lang.String SAFE_NEWLINE_CHARACTER
           
static java.lang.String SAFE_RETURN_CHARACTER
           
 
Constructor Summary
Table(java.lang.String tableName)
           
Table(java.lang.String tableName, java.lang.Object[][] columns)
           
 
Method Summary
 void appendColumn(java.lang.StringBuilder sb, java.lang.Object value, boolean last)
           
 void appendColumn(java.lang.StringBuilder sb, java.sql.ResultSet rs, java.lang.String name, java.lang.Integer type, boolean last)
           
 java.lang.String generateTempFile()
           
 java.lang.Object[][] getColumns()
           
 java.lang.String getCreateSQL()
           
 java.lang.String getDeleteSQL()
           
 java.lang.String getExportedData(java.sql.ResultSet rs)
           
 java.lang.String getInsertSQL()
           
 int[] getOrder()
           
 java.lang.String getSelectSQL()
           
 java.lang.String getTableName()
           
 long getTotalRows()
           
 java.lang.Object getValue(java.sql.ResultSet rs, java.lang.String name, java.lang.Integer type)
           
 void populateTable(java.lang.String tempFileName)
           
 void populateTableRows(java.sql.PreparedStatement ps, boolean batch)
           
 void setColumn(java.sql.PreparedStatement ps, int index, java.lang.Integer type, java.lang.String value)
           
 void setColumns(java.lang.Object[][] columns)
           
 void setCreateSQL(java.lang.String createSQL)
           
 void setSelectSQL(java.lang.String selectSQL)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

BATCH_SIZE

public static final int BATCH_SIZE

SAFE_COMMA_CHARACTER

public static final java.lang.String SAFE_COMMA_CHARACTER
See Also:
Constant Field Values

SAFE_NEWLINE_CHARACTER

public static final java.lang.String SAFE_NEWLINE_CHARACTER
See Also:
Constant Field Values

SAFE_RETURN_CHARACTER

public static final java.lang.String SAFE_RETURN_CHARACTER
See Also:
Constant Field Values

SAFE_CHARS

public static final java.lang.String[][] SAFE_CHARS
Constructor Detail

Table

public Table(java.lang.String tableName)

Table

public Table(java.lang.String tableName,
             java.lang.Object[][] columns)
Method Detail

appendColumn

public void appendColumn(java.lang.StringBuilder sb,
                         java.lang.Object value,
                         boolean last)
                  throws java.lang.Exception
Throws:
java.lang.Exception

appendColumn

public void appendColumn(java.lang.StringBuilder sb,
                         java.sql.ResultSet rs,
                         java.lang.String name,
                         java.lang.Integer type,
                         boolean last)
                  throws java.lang.Exception
Throws:
java.lang.Exception

getColumns

public java.lang.Object[][] getColumns()

getCreateSQL

public java.lang.String getCreateSQL()
                              throws java.lang.Exception
Throws:
java.lang.Exception

getDeleteSQL

public java.lang.String getDeleteSQL()
                              throws java.lang.Exception
Throws:
java.lang.Exception

getExportedData

public java.lang.String getExportedData(java.sql.ResultSet rs)
                                 throws java.lang.Exception
Throws:
java.lang.Exception

getInsertSQL

public java.lang.String getInsertSQL()
                              throws java.lang.Exception
Throws:
java.lang.Exception

getOrder

public int[] getOrder()

getSelectSQL

public java.lang.String getSelectSQL()
                              throws java.lang.Exception
Throws:
java.lang.Exception

getTableName

public java.lang.String getTableName()

getTotalRows

public long getTotalRows()

getValue

public java.lang.Object getValue(java.sql.ResultSet rs,
                                 java.lang.String name,
                                 java.lang.Integer type)
                          throws java.lang.Exception
Throws:
java.lang.Exception

generateTempFile

public java.lang.String generateTempFile()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

populateTable

public void populateTable(java.lang.String tempFileName)
                   throws java.lang.Exception
Throws:
java.lang.Exception

populateTableRows

public void populateTableRows(java.sql.PreparedStatement ps,
                              boolean batch)
                       throws java.lang.Exception
Throws:
java.lang.Exception

setColumn

public void setColumn(java.sql.PreparedStatement ps,
                      int index,
                      java.lang.Integer type,
                      java.lang.String value)
               throws java.lang.Exception
Throws:
java.lang.Exception

setColumns

public void setColumns(java.lang.Object[][] columns)

setCreateSQL

public void setCreateSQL(java.lang.String createSQL)
                  throws java.lang.Exception
Throws:
java.lang.Exception

setSelectSQL

public void setSelectSQL(java.lang.String selectSQL)
                  throws java.lang.Exception
Throws:
java.lang.Exception