| java.lang.Object org.netbeans.modules.sql.framework.model.utils.SQLObjectUtil
SQLObjectUtil | public class SQLObjectUtil (Code) | | author: Ritesh Adval author: Ahimanikya Satapathy |
Method Summary | |
public static void | createMissingModelTablesInDB(ETLDataObject dataObj) | public static SourceColumn | createRuntimeInput(SQLDBTable sTable, SQLDefinition sqlDefn) | public static SourceColumn | createRuntimeInputArg(SQLDBTable sTable, String ffArgName) | public static SourceColumn | createRuntimeInputArg(SQLDBTable sTable, String ffArgName, DBConnectionDefinition connDef) | public static void | createTable(SQLDBTable aTable, SQLDBModel model) | public static void | dropTable(SQLDBTable table, SQLDBModel model) | public static String | generateFFRuntimeInputName(String prefix, SQLDBTable table) | public static String | generateTemporaryTableName(String tableName) | public static String | generateTemporaryTableName(String prefix, String tableName) | public static List | getAllExpressionObjects(Collection objs) | public static SQLDefinition | getAncestralSQLDefinition(SQLObject sqlObj) Gets ancestral SQLDefinition instance for the given SQLExpresionObject. | public static List | getAutoJoins(SQLJoinTable right, Collection lookupCollection) Creates a List of automatically generated join objects (if any) between the given
and existing s in the model. | public static SQLConnectableObject | getExpressionObject(SQLObject sqlObject, Collection allObjects) | public static SourceTable | getInputSourceTable(SQLObject obj) | public static SourceTable | getInputSourceTable(SQLObject obj, Collection allObjects) | public static TargetTable | getMappedTargetTable(SQLJoinView jv, Collection targetTables) | public static TargetTable | getMappedTargetTable(SQLObject sqlObj, Collection targetTables) | public static RuntimeInput | getRuntimeInput(SQLDBTable table) Gets RuntimeInput, if any, associated with the parent SQLDefinition of the given
SQLDBTable. | public static Map<String, String> | getTableMetaData(SQLDBTable table) | public static String | getTargetTableCountRuntimeOutput(TargetTable targetTable) Generates runtime output name to be used in referencing the count of rows inserted
or updated for the given TargetTable. | public static SQLConnectableObject | getTopExpressionObject(SQLObject sqlObject, Collection allObjects) | public static SQLCanvasObject | getTopSQLCanvasObject(SQLObject sqlObj) | public static boolean | isAggregateFunctionMapped(SQLObject obj) | public static boolean | isObjectMappedToExpression(SQLObject obj, SQLConnectableObject expObj) | public static void | migrateJoinCondition(SQLPredicate predicate, SQLCondition condition) | public static SourceColumn | removeRuntimeInput(SQLDBTable sTable, CollabSQLUIModel sqlModel) | public static void | setOrgProperties(SQLDBTable sTable) |
createMissingModelTablesInDB | public static void createMissingModelTablesInDB(ETLDataObject dataObj)(Code) | | |
generateTemporaryTableName | public static String generateTemporaryTableName(String tableName)(Code) | | |
getAncestralSQLDefinition | public static SQLDefinition getAncestralSQLDefinition(SQLObject sqlObj)(Code) | | Gets ancestral SQLDefinition instance for the given SQLExpresionObject.
Parameters: sqlObj - SQLConnectableObject whose ancestor SQLDefinition is sought SQLDefinition instance |
getAutoJoins | public static List getAutoJoins(SQLJoinTable right, Collection lookupCollection) throws BaseException(Code) | | Creates a List of automatically generated join objects (if any) between the given
and existing s in the model. Any new instances will need to be added to this
SQLDefinition, as well as their contained SQLPredicate conditions.
Parameters: right - SourceTable against which we check for join relationships withexisting SourceTables List of Join objects, empty if no relationships were detected. throws: BaseException - for any internal (unspecific) error. |
getInputSourceTable | public static SourceTable getInputSourceTable(SQLObject obj)(Code) | | get source table connected to this sql object
|
getRuntimeInput | public static RuntimeInput getRuntimeInput(SQLDBTable table)(Code) | | Gets RuntimeInput, if any, associated with the parent SQLDefinition of the given
SQLDBTable.
Parameters: table - SQLDBTable whose parent's RuntimeInput is to be obtained RuntimeInput associated with the parent of table , or null if nosuch instance exists. |
getTargetTableCountRuntimeOutput | public static String getTargetTableCountRuntimeOutput(TargetTable targetTable)(Code) | | Generates runtime output name to be used in referencing the count of rows inserted
or updated for the given TargetTable.
Parameters: targetTable - TargetTable whose count of rows will be referenced by thegenerated runtime output String representing runtime output name for count of rows processed intargetTable |
isAggregateFunctionMapped | public static boolean isAggregateFunctionMapped(SQLObject obj)(Code) | | get source table connected to this sql object
|
setOrgProperties | public static void setOrgProperties(SQLDBTable sTable) throws BaseException(Code) | | |
|
|