org.apache.ambari.server.orm.helpers.dbms

Class OracleHelper

java.lang.Object

org.apache.ambari.server.orm.helpers.dbms.GenericDbmsHelper

org.apache.ambari.server.orm.helpers.dbms.OracleHelper

All Implemented Interfaces:

DbmsHelper

public class OracleHelper
extends GenericDbmsHelper

Field Summary

Fields inherited from class org.apache.ambari.server.orm.helpers.dbms.GenericDbmsHelper

databasePlatform

Constructor Summary

Constructors

Constructor and Description
OracleHelper(org.eclipse.persistence.platform.database.DatabasePlatform databasePlatform)

Method Summary

Modifier and Type	Method and Description
String	getCopyColumnToAnotherTableStatement(String sourceTable, String sourceColumnName, String sourceIDColumnName, String targetTable, String targetColumnName, String targetIDColumnName) Get's the UPDATE statement for sourceTable for copy column from targetTable by matching table keys sourceIDColumnName and targetIDColumnName
String	getCopyColumnToAnotherTableStatement(String sourceTable, String sourceColumnName, String sourceIDColumnName1, String sourceIDColumnName2, String sourceIDColumnName3, String targetTable, String targetColumnName, String targetIDColumnName1, String targetIDColumnName2, String targetIDColumnName3, String sourceConditionFieldName, String condition) Get's the UPDATE statement for sourceTable for copy column from targetTable by matching table keys sourceIDColumnName and targetIDColumnName and condition sourceConditionFieldName = condition
boolean	isConstraintSupportedAfterNullability() Gets whether the database platform supports adding contraints after the NULL constraint.
boolean	supportsColumnTypeChange() Check if column type can be modified directly
StringBuilder	writeColumnModifyString(StringBuilder builder, DBAccessor.DBColumnInfo columnInfo)
StringBuilder	writeColumnRenameString(StringBuilder builder, String oldName, DBAccessor.DBColumnInfo newColumnInfo)
String	writeGetTableConstraints(String databaseName, String tableName)
StringBuilder	writeSetNullableString(StringBuilder builder, String tableName, DBAccessor.DBColumnInfo columnInfo, boolean nullable)

Methods inherited from class org.apache.ambari.server.orm.helpers.dbms.GenericDbmsHelper

convertToFieldDefinition, createStubAbstractSessionFromPlatform, getAddColumnStatement, getAddForeignKeyStatement, getAddPrimaryKeyConstraintStatement, getAddUniqueConstraintStatement, getAlterColumnStatement, getColumnUpdateStatementWhereColumnIsNull, getCreateIndexStatement, getCreateIndexStatement, getCreateTableStatement, getDropFKConstraintStatement, getDropIndexStatement, getDropPrimaryKeyStatement, getDropSequenceStatement, getDropTableColumnStatement, getDropTableStatement, getDropUniqueConstraintStatement, getRenameColumnStatement, getRenameColumnStatement, getSetNullableStatement, getTableConstraintsStatement, quoteObjectName, writeAddPrimaryKeyString, writeAlterTableClause, writeColumnType, writeCreateTableStatement, writeDropPrimaryKeyStatement, writeDropTableColumnStatement

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OracleHelper

public OracleHelper(org.eclipse.persistence.platform.database.DatabasePlatform databasePlatform)

Method Detail

supportsColumnTypeChange

public boolean supportsColumnTypeChange()

Description copied from interface: DbmsHelper

Check if column type can be modified directly

Specified by:

supportsColumnTypeChange in interface DbmsHelper

Overrides:

supportsColumnTypeChange in class GenericDbmsHelper

Returns:

writeColumnRenameString

public StringBuilder writeColumnRenameString(StringBuilder builder,
                                             String oldName,
                                             DBAccessor.DBColumnInfo newColumnInfo)

Overrides:

writeColumnRenameString in class GenericDbmsHelper

writeColumnModifyString

public StringBuilder writeColumnModifyString(StringBuilder builder,
                                             DBAccessor.DBColumnInfo columnInfo)

Overrides:

writeColumnModifyString in class GenericDbmsHelper

writeSetNullableString

public StringBuilder writeSetNullableString(StringBuilder builder,
                                            String tableName,
                                            DBAccessor.DBColumnInfo columnInfo,
                                            boolean nullable)

Overrides:

writeSetNullableString in class GenericDbmsHelper

writeGetTableConstraints

public String writeGetTableConstraints(String databaseName,
                                       String tableName)

Overrides:

writeGetTableConstraints in class GenericDbmsHelper

isConstraintSupportedAfterNullability

public boolean isConstraintSupportedAfterNullability()

Gets whether the database platform supports adding contraints after the NULL constraint. Some database, such as Oracle, don't allow this. Unfortunately, EclipsLink hard codes the order of constraints.

Oracle supports the format:

 ALTER TABLE foo ADD COLUMN bar varchar2(32) DEFAULT 'baz' NOT NULL
 

This syntax doesn't allow contraints added after the NULL constraint.

Specified by:

isConstraintSupportedAfterNullability in interface DbmsHelper

Overrides:

isConstraintSupportedAfterNullability in class GenericDbmsHelper

Returns:

true if contraints can be added after the NULL constraint, false otherwise.

getCopyColumnToAnotherTableStatement

public String getCopyColumnToAnotherTableStatement(String sourceTable,
                                                   String sourceColumnName,
                                                   String sourceIDColumnName,
                                                   String targetTable,
                                                   String targetColumnName,
                                                   String targetIDColumnName)

Get's the UPDATE statement for sourceTable for copy column from targetTable by matching table keys sourceIDColumnName and targetIDColumnName

Specified by:

getCopyColumnToAnotherTableStatement in interface DbmsHelper

Overrides:

getCopyColumnToAnotherTableStatement in class GenericDbmsHelper

Parameters:

sourceTable - the source table name

sourceColumnName - the source column name

sourceIDColumnName - source key id column which would be used to math right rows for targetTable

targetTable - the destination table name

targetColumnName - the destination column name

targetIDColumnName - destination key id column name which should math sourceIDColumnName

Returns:

getCopyColumnToAnotherTableStatement

public String getCopyColumnToAnotherTableStatement(String sourceTable,
                                                   String sourceColumnName,
                                                   String sourceIDColumnName1,
                                                   String sourceIDColumnName2,
                                                   String sourceIDColumnName3,
                                                   String targetTable,
                                                   String targetColumnName,
                                                   String targetIDColumnName1,
                                                   String targetIDColumnName2,
                                                   String targetIDColumnName3,
                                                   String sourceConditionFieldName,
                                                   String condition)

Get's the UPDATE statement for sourceTable for copy column from targetTable by matching table keys sourceIDColumnName and targetIDColumnName and condition sourceConditionFieldName = condition

Specified by:

getCopyColumnToAnotherTableStatement in interface DbmsHelper

Overrides:

getCopyColumnToAnotherTableStatement in class GenericDbmsHelper

Parameters:

sourceTable - the source table name

sourceColumnName - the source column name

sourceIDColumnName1 - source key id column which would be used to math right rows for targetTable

sourceIDColumnName2 - source key id column which would be used to math right rows for targetTable

sourceIDColumnName3 - source key id column which would be used to math right rows for targetTable

targetTable - the destination table name

targetColumnName - the destination column name

targetIDColumnName1 - destination key id column name which should match sourceIDColumnName1

targetIDColumnName2 - destination key id column name which should match sourceIDColumnName1

targetIDColumnName3 - destination key id column name which should match sourceIDColumnName1

sourceConditionFieldName - source key column name which should match condition

condition - value which should match sourceConditionFieldName

Returns: