| Package | Description | 
|---|---|
| org.apache.ambari.server.orm | |
| org.apache.ambari.server.orm.helpers.dbms | 
| Modifier and Type | Method and Description | 
|---|---|
DBAccessor.DBColumnInfo | 
DBAccessor.getColumnInfo(String tableName,
             String columnName)
Obtain column metadata information by given table and column name 
 | 
DBAccessor.DBColumnInfo | 
DBAccessorImpl.getColumnInfo(String tableName,
             String columnName)
Obtain column metadata information by given table and column name. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
DBAccessor.addColumn(String tableName,
         DBAccessor.DBColumnInfo columnInfo)
Adds a column to an existing table. 
 | 
void | 
DBAccessorImpl.addColumn(String tableName,
         DBAccessor.DBColumnInfo columnInfo)
Adds a column to an existing table. 
 | 
void | 
DBAccessor.addDefaultConstraint(String tableName,
                    DBAccessor.DBColumnInfo column)
Adds a default constraint to an existing column. 
 | 
void | 
DBAccessorImpl.addDefaultConstraint(String tableName,
                    DBAccessor.DBColumnInfo column)
Adds a default constraint to an existing column. 
 | 
void | 
DBAccessor.alterColumn(String tableName,
           DBAccessor.DBColumnInfo columnInfo)
Alter column from existing table, only supports varchar extension  
Use following sequence for more complex stuff: DBAccessor.addColumn(String, org.apache.ambari.server.orm.DBAccessor.DBColumnInfo)
 DBAccessor.updateTable(String, String, Object, String)
 DBAccessor.dropColumn(String, String)
 DBAccessor.renameColumn(String, String, org.apache.ambari.server.orm.DBAccessor.DBColumnInfo) | 
void | 
DBAccessorImpl.alterColumn(String tableName,
           DBAccessor.DBColumnInfo columnInfo)  | 
void | 
DBAccessor.copyColumnToAnotherTable(String sourceTableName,
                        DBAccessor.DBColumnInfo sourceColumn,
                        String sourceIDFieldName1,
                        String sourceIDFieldName2,
                        String sourceIDFieldName3,
                        String targetTableName,
                        DBAccessor.DBColumnInfo targetColumn,
                        String targetIDFieldName1,
                        String targetIDFieldName2,
                        String targetIDFieldName3,
                        String sourceConditionFieldName,
                        String condition,
                        Object initialValue)
Copy column from  
targetTable by matching
 table keys sourceIDColumnName and targetIDColumnName
 and condition sourceConditionFieldName = condition | 
void | 
DBAccessorImpl.copyColumnToAnotherTable(String sourceTableName,
                        DBAccessor.DBColumnInfo sourceColumn,
                        String sourceIDFieldName1,
                        String sourceIDFieldName2,
                        String sourceIDFieldName3,
                        String targetTableName,
                        DBAccessor.DBColumnInfo targetColumn,
                        String targetIDFieldName1,
                        String targetIDFieldName2,
                        String targetIDFieldName3,
                        String sourceConditionFieldName,
                        String condition,
                        Object initialValue)
Copy column from  
targetTable by matching
 table keys sourceIDColumnName and targetIDColumnName
 and condition sourceConditionFieldName = condition | 
void | 
DBAccessor.moveColumnToAnotherTable(String sourceTableName,
                        DBAccessor.DBColumnInfo sourceColumn,
                        String sourceIDFieldName,
                        String targetTableName,
                        DBAccessor.DBColumnInfo targetColumn,
                        String targetIDFieldName,
                        Object initialValue)
Move column data from  
sourceTableName to targetTableName using sourceIDFieldName and
 targetIDFieldName keys to match right rows | 
void | 
DBAccessorImpl.moveColumnToAnotherTable(String sourceTableName,
                        DBAccessor.DBColumnInfo sourceColumn,
                        String sourceIDFieldName,
                        String targetTableName,
                        DBAccessor.DBColumnInfo targetColumn,
                        String targetIDFieldName,
                        Object initialValue)
Move column data from  
sourceTableName to targetTableName using sourceIDFieldName and
 targetIDFieldName keys to match right rows | 
void | 
DBAccessor.renameColumn(String tableName,
            String oldColumnName,
            DBAccessor.DBColumnInfo columnInfo)
Rename existing column 
 | 
void | 
DBAccessorImpl.renameColumn(String tableName,
            String oldColumnName,
            DBAccessor.DBColumnInfo columnInfo)  | 
void | 
DBAccessor.setColumnNullable(String tableName,
                 DBAccessor.DBColumnInfo columnInfo,
                 boolean nullable)
Sets the specified column to either allow or prohibit  
NULL. | 
void | 
DBAccessorImpl.setColumnNullable(String tableName,
                 DBAccessor.DBColumnInfo columnInfo,
                 boolean nullable)  | 
void | 
DBAccessor.updateTable(String tableName,
           DBAccessor.DBColumnInfo columnNameSrc,
           DBAccessor.DBColumnInfo columnNameTgt)
Simple update operation on table 
 | 
void | 
DBAccessorImpl.updateTable(String tableName,
           DBAccessor.DBColumnInfo columnNameFrom,
           DBAccessor.DBColumnInfo columnNameTo)  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
DBAccessor.createTable(String tableName,
           List<DBAccessor.DBColumnInfo> columnInfo,
           String... primaryKeyColumns)
Create new table 
 | 
void | 
DBAccessorImpl.createTable(String tableName,
           List<DBAccessor.DBColumnInfo> columnInfo,
           String... primaryKeyColumns)  | 
| Modifier and Type | Method and Description | 
|---|---|
String | 
GenericDbmsHelper.getCreateTableStatement(String tableName,
                       List<DBAccessor.DBColumnInfo> columns,
                       List<String> primaryKeyColumns)
get create table statement 
 | 
String | 
DbmsHelper.getCreateTableStatement(String tableName,
                       List<DBAccessor.DBColumnInfo> columns,
                       List<String> primaryKeyColumns)  | 
Writer | 
GenericDbmsHelper.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 
 | 
Writer | 
MySqlHelper.writeCreateTableStatement(Writer writer,
                         String tableName,
                         List<DBAccessor.DBColumnInfo> columns,
                         List<String> primaryKeyColumns)  | 
Copyright © 2022 Apache Software Foundation. All rights reserved.