com.liferay.portal.upgrade.util

Class Table

Object

com.liferay.portal.upgrade.util.Table

Direct Known Subclasses:

BaseUpgradeTableImpl

public class Table
extends Object

Author:

Alexander Chow, Brian Wing Shun Chan, Raymond Augé

Constructor Summary

Constructors

Constructor and Description
Table(String tableName)
Table(String tableName, Object[][] columns)

Method Summary

Modifier and Type	Method and Description
void	appendColumn(StringBuilder sb, Object value, boolean last)
void	appendColumn(StringBuilder sb, ResultSet rs, String name, Integer type, boolean last)
void	generateTempFile()
void	generateTempFile(Connection con)
Object[][]	getColumns()
String	getCreateSQL()
String	getDeleteSQL()
String	getExportedData(ResultSet rs)
String	getInsertSQL()
String	getInsertTableName()
int[]	getOrder()
PreparedStatement	getSelectPreparedStatement(Connection con)
String	getSelectSQL()
String	getTableName()
String	getTempFileName()
long	getTotalRows()
Object	getValue(ResultSet rs, String name, Integer type)
void	populateTable()
void	populateTable(Connection con)
void	populateTableRows(PreparedStatement ps, boolean batch)
void	setColumn(PreparedStatement ps, int index, Integer type, String value)
void	setColumns(Object[][] columns)
void	setCreateSQL(String createSQL)
void	setSelectSQL(String selectSQL)
void	updateColumnValue(String columnName, String oldValue, String newValue)

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Table

public Table(String tableName)

Table

public Table(String tableName,
             Object[][] columns)

Method Detail

appendColumn

public void appendColumn(StringBuilder sb,
                         Object value,
                         boolean last)
                  throws Exception

Throws:

Exception

appendColumn

public void appendColumn(StringBuilder sb,
                         ResultSet rs,
                         String name,
                         Integer type,
                         boolean last)
                  throws Exception

Throws:

Exception

generateTempFile

public void generateTempFile()
                      throws Exception

Throws:

Exception

generateTempFile

public void generateTempFile(Connection con)
                      throws Exception

Throws:

Exception

getColumns

public Object[][] getColumns()

getCreateSQL

public String getCreateSQL()
                    throws Exception

Throws:

Exception

getDeleteSQL

public String getDeleteSQL()
                    throws Exception

Throws:

Exception

getExportedData

public String getExportedData(ResultSet rs)
                       throws Exception

Throws:

Exception

getInsertSQL

public String getInsertSQL()
                    throws Exception

Throws:

Exception

getInsertTableName

public String getInsertTableName()
                          throws Exception

Throws:

Exception

getOrder

public int[] getOrder()

getSelectPreparedStatement

public PreparedStatement getSelectPreparedStatement(Connection con)
                                             throws Exception

Throws:

Exception

getSelectSQL

public String getSelectSQL()
                    throws Exception

Throws:

Exception

getTableName

public String getTableName()

getTempFileName

public String getTempFileName()

getTotalRows

public long getTotalRows()

getValue

public Object getValue(ResultSet rs,
                       String name,
                       Integer type)
                throws Exception

Throws:

Exception

populateTable

public void populateTable()
                   throws Exception

Throws:

Exception

populateTable

public void populateTable(Connection con)
                   throws Exception

Throws:

Exception

populateTableRows

public void populateTableRows(PreparedStatement ps,
                              boolean batch)
                       throws Exception

Throws:

Exception

setColumn

public void setColumn(PreparedStatement ps,
                      int index,
                      Integer type,
                      String value)
               throws Exception

Throws:

Exception

setColumns

public void setColumns(Object[][] columns)

setCreateSQL

public void setCreateSQL(String createSQL)
                  throws Exception

Throws:

Exception

setSelectSQL

public void setSelectSQL(String selectSQL)
                  throws Exception

Throws:

Exception

updateColumnValue

public void updateColumnValue(String columnName,
                              String oldValue,
                              String newValue)