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

Class MySqlHelper

java.lang.Object

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

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

All Implemented Interfaces:

DbmsHelper

public class MySqlHelper
extends GenericDbmsHelper

Field Summary

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

databasePlatform

Constructor Summary

Constructors

Constructor and Description
MySqlHelper(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	quoteObjectName(String name)
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)
Writer	writeCreateTableStatement(Writer writer, String tableName, List<DBAccessor.DBColumnInfo> columns, List<String> primaryKeyColumns) Write create table statement to writer TODO default Value of column not supported
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, writeAddPrimaryKeyString, writeAlterTableClause, writeColumnType, writeDropPrimaryKeyStatement, writeDropTableColumnStatement

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlHelper

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

quoteObjectName

public String quoteObjectName(String name)

Specified by:

quoteObjectName in interface DbmsHelper

Overrides:

quoteObjectName in class GenericDbmsHelper

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

writeCreateTableStatement

public Writer writeCreateTableStatement(Writer writer,
                                        String tableName,
                                        List<DBAccessor.DBColumnInfo> columns,
                                        List<String> primaryKeyColumns)

Description copied from class: GenericDbmsHelper

Write create table statement to writer TODO default Value of column not supported

Overrides:

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