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

Class PostgresHelper

java.lang.Object

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

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

All Implemented Interfaces:

DbmsHelper

public class PostgresHelper
extends GenericDbmsHelper

Field Summary

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

databasePlatform

Constructor Summary

Constructors

Constructor and Description
PostgresHelper(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	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)
StringBuilder	writeDropPrimaryKeyStatement(StringBuilder builder, String constraintName, boolean cascade)
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, isConstraintSupportedAfterNullability, quoteObjectName, writeAddPrimaryKeyString, writeAlterTableClause, writeColumnType, writeCreateTableStatement, writeDropTableColumnStatement

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgresHelper

public PostgresHelper(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

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:

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

writeDropPrimaryKeyStatement

public StringBuilder writeDropPrimaryKeyStatement(StringBuilder builder,
                                                  String constraintName,
                                                  boolean cascade)

Overrides:

writeDropPrimaryKeyStatement in class GenericDbmsHelper

Parameters:

builder - String Builder passed by reference

constraintName - Constraint Name used by Postgres

cascade - In postgres, can perform a CASCADE delete. In the other DB flavors, this is ignored.

Returns:

Return the String Builder