|
||||||||||
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 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 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 |