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

Class H2Helper

java.lang.Object

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

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

All Implemented Interfaces:

DbmsHelper

public class H2Helper
extends GenericDbmsHelper

Field Summary

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

databasePlatform

Constructor Summary

Constructors

Constructor and Description
H2Helper(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
String	getRenameColumnStatement(String tableName, String oldName, DBAccessor.DBColumnInfo columnInfo) Generate rename column statement
boolean	supportsColumnTypeChange() Check if column type can be modified directly
StringBuilder	writeColumnModifyString(StringBuilder builder, DBAccessor.DBColumnInfo columnInfo)
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, getSetNullableStatement, getTableConstraintsStatement, isConstraintSupportedAfterNullability, quoteObjectName, writeAddPrimaryKeyString, writeAlterTableClause, writeColumnRenameString, writeColumnType, writeCreateTableStatement, writeDropPrimaryKeyStatement, writeDropTableColumnStatement

Methods inherited from class java.lang.Object

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

Constructor Detail

H2Helper

public H2Helper(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:

getRenameColumnStatement

public String getRenameColumnStatement(String tableName,
                                       String oldName,
                                       DBAccessor.DBColumnInfo columnInfo)

Description copied from interface: DbmsHelper

Generate rename column statement

Specified by:

getRenameColumnStatement in interface DbmsHelper

Overrides:

getRenameColumnStatement in class GenericDbmsHelper

columnInfo - definition of new column

Returns:

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

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: