public final class SQLQueryEditDialog
extends java.lang.Object
implements java.util.Comparator
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
HELP_CONNECTBY_INFO |
static java.lang.String |
HELP_FROM_INFO |
static java.lang.String |
HELP_GROUPBY_INFO |
static java.lang.String |
HELP_HAVING_INFO |
static java.lang.String |
HELP_ORDERBY_INFO |
static java.lang.String |
HELP_PICKER |
static java.lang.String |
HELP_QUERY_INFO |
static java.lang.String |
HELP_SELECT_INFO |
static java.lang.String |
HELP_WHERE_INFO |
Constructor and Description |
---|
SQLQueryEditDialog()
Creates a new launcher for an edit dialog for sql queries.
|
SQLQueryEditDialog(boolean noOrderBy)
Creates a new launcher for an edit dialog for sql queries.
|
Modifier and Type | Method and Description |
---|---|
int |
compare(java.lang.Object o1,
java.lang.Object o2)
Dummy Comparator implementation that always returns equal.
|
Namespace |
createNamespace(SQLQuery query,
DBObjectProvider provider,
Schema defaultSchema)
Creates a Namespace suitable for using as the basis of the Traversable
mechanism when entering and exiting the sql query edit panels.
|
SQLQuery |
editQuery(SQLQuery query,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query.
|
SQLQuery |
editQuery(SQLQuery query,
SQLFragment defaultObject,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query.
|
java.lang.String |
editQuery(java.lang.String sqlText,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query sql text.
|
Navigable |
getMasterNavigable()
Returns a master Navigable object that has all the required child
naviagables for editing a query.
|
Navigable[] |
getNavigables()
Returns a set of Navigable objects for the pages required to edit a
SQLQuery.
|
static java.lang.String[] |
getStartPage(SQLFragment child,
boolean incMaster)
Returns the appropriate start page path for editing the given child of a
query.
|
Step[] |
getSteps()
Returns a set of Step objects for the pages required to creating a
SQLQuery.
|
static boolean |
isAvailable(DBObjectProvider pro)
Returns true if the SQLQueryEditDialog support the given provider.
|
static DBEditorConfig |
newDefaultEditorConfig(DBObjectProvider pro,
SQLQuery query)
Creates a DBEditorConfig that can be put in the Namespace to edit a
given query.
|
void |
setBindVariables(java.util.Collection<java.lang.String> bindVars)
Sets a list of the bind variables named in the query.
|
public static final java.lang.String HELP_PICKER
public static final java.lang.String HELP_SELECT_INFO
public static final java.lang.String HELP_FROM_INFO
public static final java.lang.String HELP_WHERE_INFO
public static final java.lang.String HELP_GROUPBY_INFO
public static final java.lang.String HELP_HAVING_INFO
public static final java.lang.String HELP_ORDERBY_INFO
public static final java.lang.String HELP_CONNECTBY_INFO
public static final java.lang.String HELP_QUERY_INFO
public SQLQueryEditDialog()
public SQLQueryEditDialog(boolean noOrderBy)
materializedView
- if true, the order by panel will not be
includedpublic Navigable[] getNavigables()
createNamespace(oracle.javatools.db.sql.SQLQuery, oracle.javatools.db.DBObjectProvider, oracle.javatools.db.Schema)
.public void setBindVariables(java.util.Collection<java.lang.String> bindVars)
public Navigable getMasterNavigable()
public Step[] getSteps()
createNamespace(oracle.javatools.db.sql.SQLQuery, oracle.javatools.db.DBObjectProvider, oracle.javatools.db.Schema)
.public java.lang.String editQuery(java.lang.String sqlText, DBObjectProvider provider, Schema defaultSchema)
sqlText
- the query text to editprovider
- the provider to usedefaultSchema
- the default schema for the query (can be null).public SQLQuery editQuery(SQLQuery query, DBObjectProvider provider, Schema defaultSchema)
query
- the query to editprovider
- the provider to usedefaultSchema
- the default schema for the query.public SQLQuery editQuery(SQLQuery query, SQLFragment defaultObject, DBObjectProvider provider, Schema defaultSchema)
query
- the query to editdefaultObject
- the default object within the query to start the edit
withprovider
- the provider to usedefaultSchema
- the default schema for the querypublic Namespace createNamespace(SQLQuery query, DBObjectProvider provider, Schema defaultSchema)
query
- the query being editedprovider
- the provider the query is indefaultSchema
- the default schema in the provider for the querypublic int compare(java.lang.Object o1, java.lang.Object o2)
compare
in interface java.util.Comparator
public static final DBEditorConfig newDefaultEditorConfig(DBObjectProvider pro, SQLQuery query)
public static final java.lang.String[] getStartPage(SQLFragment child, boolean incMaster)
child
- the child of the query whose page we require.incMaster
- whether the master panel is inculded in the path.public static boolean isAvailable(DBObjectProvider pro)