| java.lang.Object
 net.sourceforge.squirrel_sql.client.session.SQLExecuterTask
| SQLExecuterTask | | public class SQLExecuterTask implements Runnable,IDataSetUpdateableTableModel(Code) | | This class can be used to execute SQL.
It implements Runnable so it can be executed as a thread
(asynchronus execution)
or standalone in the main Swing thread (synchronus execution).
|
| Method Summary | |
| public void | addListener(DataSetUpdateableTableModelListener l)
| | public void | cancel()
| | public String | deleteRows(Object[][] rowData, ColumnDisplayDefinition[] colDefs)
| | public boolean | editModeIsForced()
| | public void | forceEditMode(boolean mode)
| | public String[] | getDefaultValues(ColumnDisplayDefinition[] colDefs)
| | public int | getQueryCount()
Returns the number of queries that the tokenizer found in _sql. | | public int | getRowidCol()
| | public TableInfo | getTableName(String tableNameFromSQL)
Get the full name info for the table that is being referred to in the
SQL query.
Since we do not know the catalog, schema, or the actual name used in
this DB to refer to "table" types, we cannot filter the initial query on any of
those criteria. | | public String | getWarningOnCurrentData(Object[] values, ColumnDisplayDefinition[] colDefs, int col, Object oldValue)
| | public String | getWarningOnProjectedUpdate(Object[] values, ColumnDisplayDefinition[] colDefs, int col, Object newValue)
| | public String | insertRow(Object[] values, ColumnDisplayDefinition[] colDefs)
| | public Object | reReadDatum(Object[] values, ColumnDisplayDefinition[] colDefs, int col, StringBuffer message)
| | public void | removeListener(DataSetUpdateableTableModelListener l)
| | public void | run()
| | public void | setExecutionListeners(ISQLExecutionListener[] executionListeners)
| | public void | setSchemaCheck(boolean aBoolean)
| | public String | updateTableComponent(Object[] values, ColumnDisplayDefinition[] colDefs, int col, Object oldValue, Object newValue)
|
| cancel | | public void cancel()(Code) | | |
| editModeIsForced | | public boolean editModeIsForced()(Code) | | |
| forceEditMode | | public void forceEditMode(boolean mode)(Code) | | |
| getQueryCount | | public int getQueryCount()(Code) | | Returns the number of queries that the tokenizer found in _sql.
|
| getRowidCol | | public int getRowidCol()(Code) | | |
| getTableName | | public TableInfo getTableName(String tableNameFromSQL)(Code) | | Get the full name info for the table that is being referred to in the
SQL query.
Since we do not know the catalog, schema, or the actual name used in
this DB to refer to "table" types, we cannot filter the initial query on any of
those criteria. Thus the only thing we can do is get all of the names
of everything in the DB, then scan for things matching the name of the
table as entered by the user in the SQL query. If there are no objects
with that name or multiple objects with that name, we do not allow editing.
This method was originally copied from TableTypeExpander.createChildren
and heavilly modified.
Parameters:
tableNameInSQL - Name of the table as typed by the user in the SQL query. A TableInfo object for the only DB objectwith the given name, or null if there is none or more than one with that name. |
| setSchemaCheck | | public void setSchemaCheck(boolean aBoolean)(Code) | | |
|
|