| java.lang.Object workbench.storage.StatementFactory
StatementFactory | public class StatementFactory (Code) | | A class to generate DELETE, INSERT or UPDATE statements based
on the data in a
workbench.storage.RowData object.
author: support@sql-workbench.net |
Method Summary | |
public DmlStatement | createDeleteStatement(RowData aRow) | public DmlStatement | createDeleteStatement(RowData aRow, boolean ignoreStatus) | public DmlStatement | createInsertStatement(RowData aRow, boolean ignoreStatus) | public DmlStatement | createInsertStatement(RowData aRow, boolean ignoreStatus, String lineEnd) | public DmlStatement | createInsertStatement(RowData aRow, boolean ignoreStatus, String lineEnd, List columns) Generate an insert statement for the given row
When creating a script for the DataStore the ignoreStatus
will be passed as true, thus ignoring the row status and
some basic formatting will be applied to the SQL Statement
Parameters: aRow - the RowData that should be used for the insert statement Parameters: ignoreStatus - if set to true all columns will be included (otherwise only modified columns) Parameters: lineEnd - the character sequence to be used as the line ending Parameters: columns - a list of columns to be included. | public DmlStatement | createUpdateStatement(RowData aRow, boolean ignoreStatus, String lineEnd) | public DmlStatement | createUpdateStatement(RowData aRow, boolean ignoreStatus, String lineEnd, List columns) Create an UPDATE Statement based on the data provided
Parameters: aRow - the RowData that should be used for the UPDATE statement Parameters: ignoreStatus - if set to true all columns will be included (otherwise only modified columns) Parameters: lineEnd - the character sequence to be used as the line ending Parameters: columns - a list of columns to be included. | public boolean | getIncludeTableOwner() | public void | setCurrentConnection(WbConnection conn) | public void | setIncludeTableOwner(boolean flag) | public void | setTableToUse(TableIdentifier tableToUse) Setter for property tableToUse. |
StatementFactory | public StatementFactory(ResultInfo metaData, WbConnection conn)(Code) | | Parameters: metaData - the description of the resultSet for which the statements are generated Parameters: conn - the database connection for which the statements are generated |
createInsertStatement | public DmlStatement createInsertStatement(RowData aRow, boolean ignoreStatus, String lineEnd, List columns)(Code) | | Generate an insert statement for the given row
When creating a script for the DataStore the ignoreStatus
will be passed as true, thus ignoring the row status and
some basic formatting will be applied to the SQL Statement
Parameters: aRow - the RowData that should be used for the insert statement Parameters: ignoreStatus - if set to true all columns will be included (otherwise only modified columns) Parameters: lineEnd - the character sequence to be used as the line ending Parameters: columns - a list of columns to be included. If this is null all columns are included |
createUpdateStatement | public DmlStatement createUpdateStatement(RowData aRow, boolean ignoreStatus, String lineEnd, List columns)(Code) | | Create an UPDATE Statement based on the data provided
Parameters: aRow - the RowData that should be used for the UPDATE statement Parameters: ignoreStatus - if set to true all columns will be included (otherwise only modified columns) Parameters: lineEnd - the character sequence to be used as the line ending Parameters: columns - a list of columns to be included. If this is null all columns are included |
getIncludeTableOwner | public boolean getIncludeTableOwner()(Code) | | |
setIncludeTableOwner | public void setIncludeTableOwner(boolean flag)(Code) | | |
setTableToUse | public void setTableToUse(TableIdentifier tableToUse)(Code) | | Setter for property tableToUse.
Parameters: tableToUse - New value of property tableToUse. |
|
|