|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.datatools.modelbase.sql.query.helper.DatabaseHelper
public class DatabaseHelper
This class provides a set of utility methods for dealing with RDBDatabase objects and associated objects such as RDBTable and RDBColumn.
Constructor Summary | |
---|---|
DatabaseHelper()
|
Method Summary | |
---|---|
static Procedure |
findProcedure(Schema schema,
java.lang.String procName)
Finds and returns a Procedure object with the given name associated with the given Schema object. |
static Schema |
findSchema(Database database,
java.lang.String schemaName)
Finds a Schema by its name in a given Database . |
static Table |
findTable(Schema schema,
java.lang.String tableName)
Finds a Table by its name in a given Schema ,
the given tableName is not case sensitive. |
static void |
resolveTableReferenceRDBTable(TableInDatabase aTableInDB,
Database aDatabase,
java.lang.String aDefaultSchemaName)
Resolves the given table references so that it has the correct RDBTable attached to it. |
static void |
resolveTableReferenceRDBTables(java.util.List aTableRefList,
Database aDatabase,
java.lang.String aDefaultSchemaName)
Deprecated. table reference resolving is now done by post parse processer, use org.eclipse.datatools.modelbase.parsers.sql.query.postparse.TableReferenceResolver
with org.eclipse.datatools.modelbase.parsers.sql.query.SQLQueryParserManager |
static void |
resolveTableReferenceRDBTables(QueryStatement aSQLStmt,
Database aDatabase,
java.lang.String aDefaultSchemaName)
Deprecated. table reference resolving is now done by post parse processer, use org.eclipse.datatools.modelbase.parsers.sql.query.postparse.TableReferenceResolver
with org.eclipse.datatools.modelbase.parsers.sql.query.SQLQueryParserManager |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DatabaseHelper()
Method Detail |
---|
public static void resolveTableReferenceRDBTables(QueryStatement aSQLStmt, Database aDatabase, java.lang.String aDefaultSchemaName)
org.eclipse.datatools.modelbase.parsers.sql.query.postparse.TableReferenceResolver
with org.eclipse.datatools.modelbase.parsers.sql.query.SQLQueryParserManager
aSQLStmt
- a SQL statement which's table refernces are to be resolvedaDatabase
- a Database to use to get RDBTablesaDefaultSchemaName
- the name of the Schema the tables will be looked up for,
if the tables are not already qualifiedpublic static void resolveTableReferenceRDBTables(java.util.List aTableRefList, Database aDatabase, java.lang.String aDefaultSchemaName)
org.eclipse.datatools.modelbase.parsers.sql.query.postparse.TableReferenceResolver
with org.eclipse.datatools.modelbase.parsers.sql.query.SQLQueryParserManager
aTableRefList
- a list of table references to be resolvedaDatabase
- an Database to use to get RDBTablesaDefaultSchemaName
- the name of the Schema the tables will be looked up for, if the tables
are not already qualifiedpublic static void resolveTableReferenceRDBTable(TableInDatabase aTableInDB, Database aDatabase, java.lang.String aDefaultSchemaName)
aTableInDB
- a table references to be resolvedaDatabase
- a Database object to use to get RDBTablesaDefaultSchemaName
- the default schema name to use to look up
tables in the database for tables that are not already qualifiedpublic static Procedure findProcedure(Schema schema, java.lang.String procName)
schema
- the Schema object to use to find the Procedure objectprocName
- the name of the Procedure object to find
public static Schema findSchema(Database database, java.lang.String schemaName)
Schema
by its name in a given Database
.
If the given schemaName
is not delimited, the search is not case
sensitive.
database
- the Database
to find Schema
s inschemaName
- the String name of the Schema
to find
Schema
found or null
if no
corresponding Schema
was foundpublic static Table findTable(Schema schema, java.lang.String tableName)
Table
by its name in a given Schema
,
the given tableName
is not case sensitive.
Look at findSchema(Database, String)
to see how
the Schema
can be found in a Database
.
schema
- the Schema
to find a Table
intableName
- the String name of the Table
to find
Table
found or null
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |