com.viaoa.ds.jdbc.delegate

Class DDLDelegate

java.lang.Object

com.viaoa.ds.jdbc.delegate.DDLDelegate

public class DDLDelegate
extends Object

Delegate used to generate DDL for making database changes.

Author:

vvia

Constructor Summary

Constructors

Constructor and Description
DDLDelegate()

Method Summary

Modifier and Type	Method and Description
static String	getAddColumnSQL(DBMetaData dbmd, String columnName, String type, boolean bLastColumn) Used to create the sql for adding a new column within a create new table command.
static String	getAddColumnSQL(DBMetaData dbmd, String tableName, String columnName, String type)
static String	getAddColumnSQL(DBMetaData dbmd, String columnName, String type, String params, boolean bLastColumn) Used to create the sql for adding a new column within a create new table command.
static String	getAddForeignKeySQL(DBMetaData dbmd, String fromTable, String toTable, String constraintName, String fromColumns, String toColumns)
static String	getAddPkeyConstraintSQL(DBMetaData dbmd, String tableName, String constraintName, String pkeys)
static String	getAlterColumnSQL(DBMetaData dbmd, String tableName, String columnName, String newType)
static String	getBeginCreateTableSQL(DBMetaData dbmd, String tableName)
static String	getBlobType(DBMetaData dbmd, int maxLen)
static String	getBooleanType(DBMetaData dbmd)
static String	getCreateIndexSQL(DBMetaData dbmd, String tableName, String indexName, String columnNames)
static String	getCreateTableSQL(DBMetaData dbmd, String tableName)
static String	getCurrencyType(DBMetaData dbmd, int decimalLen)
static String	getDateTimeType(DBMetaData dbmd)
static String	getDateType(DBMetaData dbmd)
static String	getDoubleType(DBMetaData dbmd, int decimalLen)
static String	getDropColumnSQL(DBMetaData dbmd, String tableName, String columnName)
static String	getDropForeignKeySQL(DBMetaData dbmd, String tableName, String constraintName)
static String	getDropIndexSQL(DBMetaData dbmd, String tableName, String indexName)
static String	getDropPkeyConstraintSQL(DBMetaData dbmd, String tableName, String pkName)
static String	getDropTableSQL(DBMetaData dbmd, String tableName)
static String	getEndCreateTableSQL(DBMetaData dbmd)
static String	getFloatType(DBMetaData dbmd, int decimalLength)
static String	getInsertRecordsSQL_HOLD(DBMetaData dbmd, String fromName, String toName)
static String	getInsertRecordsSQL(DBMetaData dbmd, String fromName, String toName, String columnNames)
static String	getInsertRecordsSQL(DBMetaData dbmd, String fromName, String toName, String fromColumnNames, String toColumnNames, String where)
static String	getIntType(DBMetaData dbmd)
static String	getLongTextType(DBMetaData dbmd, int maxLen)
static String	getLongType(DBMetaData dbmd)
static String	getLongUnicodeType(DBMetaData dbmd, int maxLen)
static String	getNumberType(DBMetaData dbmd, int maxLen, int decimalLength)
static String	getSmallIntType(DBMetaData dbmd)
static String	getStringType(DBMetaData dbmd, int maxLen)
static String	getTimestampType(DBMetaData dbmd)
static String	getTimeType(DBMetaData dbmd)
static String	getUnicodeCharType(DBMetaData dbmd, int maxLen)
static String	getUnicodeType(DBMetaData dbmd, int maxLen)
static String	getUpdateColumnSQL(DBMetaData dbmd, String tableName, String fromColumnName, String toColumnName)
static String	getUpdateColumnSQL(DBMetaData dbmd, String fromTableName, String toTableName, String[] fromColumnNames, String[] toColumnNames)
static String	getUpdateColumnSQL(DBMetaData dbmd, String fromTableName, String toTableName, String[] fromColumnNames, String[] toColumnNames, String whereClause)
static String	getUpdateColumnSQL(DBMetaData dbmd, String fromTableName, String toTableName, String fromColumnName, String toColumnName)
static String	getUpdateColumnSQL(DBMetaData dbmd, String fromTableName, String toTableName, String fromColumnName, String toColumnName, String whereClause)

Methods inherited from class java.lang.Object

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

Constructor Detail

DDLDelegate

public DDLDelegate()

Method Detail

getCreateTableSQL

public static String getCreateTableSQL(DBMetaData dbmd,
                                       String tableName)

getBeginCreateTableSQL

public static String getBeginCreateTableSQL(DBMetaData dbmd,
                                            String tableName)

getEndCreateTableSQL

public static String getEndCreateTableSQL(DBMetaData dbmd)

getInsertRecordsSQL_HOLD

public static String getInsertRecordsSQL_HOLD(DBMetaData dbmd,
                                              String fromName,
                                              String toName)

getInsertRecordsSQL

public static String getInsertRecordsSQL(DBMetaData dbmd,
                                         String fromName,
                                         String toName,
                                         String columnNames)

getInsertRecordsSQL

public static String getInsertRecordsSQL(DBMetaData dbmd,
                                         String fromName,
                                         String toName,
                                         String fromColumnNames,
                                         String toColumnNames,
                                         String where)

getUpdateColumnSQL

public static String getUpdateColumnSQL(DBMetaData dbmd,
                                        String tableName,
                                        String fromColumnName,
                                        String toColumnName)

getUpdateColumnSQL

public static String getUpdateColumnSQL(DBMetaData dbmd,
                                        String fromTableName,
                                        String toTableName,
                                        String fromColumnName,
                                        String toColumnName)

getUpdateColumnSQL

public static String getUpdateColumnSQL(DBMetaData dbmd,
                                        String fromTableName,
                                        String toTableName,
                                        String fromColumnName,
                                        String toColumnName,
                                        String whereClause)

getUpdateColumnSQL

public static String getUpdateColumnSQL(DBMetaData dbmd,
                                        String fromTableName,
                                        String toTableName,
                                        String[] fromColumnNames,
                                        String[] toColumnNames)

getUpdateColumnSQL

public static String getUpdateColumnSQL(DBMetaData dbmd,
                                        String fromTableName,
                                        String toTableName,
                                        String[] fromColumnNames,
                                        String[] toColumnNames,
                                        String whereClause)

getDropPkeyConstraintSQL

public static String getDropPkeyConstraintSQL(DBMetaData dbmd,
                                              String tableName,
                                              String pkName)

getAddPkeyConstraintSQL

public static String getAddPkeyConstraintSQL(DBMetaData dbmd,
                                             String tableName,
                                             String constraintName,
                                             String pkeys)

getDropIndexSQL

public static String getDropIndexSQL(DBMetaData dbmd,
                                     String tableName,
                                     String indexName)

getDropTableSQL

public static String getDropTableSQL(DBMetaData dbmd,
                                     String tableName)

getCreateIndexSQL

public static String getCreateIndexSQL(DBMetaData dbmd,
                                       String tableName,
                                       String indexName,
                                       String columnNames)

getAddColumnSQL

public static String getAddColumnSQL(DBMetaData dbmd,
                                     String tableName,
                                     String columnName,
                                     String type)

getAddColumnSQL

public static String getAddColumnSQL(DBMetaData dbmd,
                                     String columnName,
                                     String type,
                                     boolean bLastColumn)

Used to create the sql for adding a new column within a create new table command.

Parameters:

bLastColumn - true if this is the last column being added for table.

getAddColumnSQL

public static String getAddColumnSQL(DBMetaData dbmd,
                                     String columnName,
                                     String type,
                                     String params,
                                     boolean bLastColumn)

Used to create the sql for adding a new column within a create new table command.

Parameters:

params - example: "NOT NULL"

bLastColumn - true if this is the last column being added for table.

getDropColumnSQL

public static String getDropColumnSQL(DBMetaData dbmd,
                                      String tableName,
                                      String columnName)

getAlterColumnSQL

public static String getAlterColumnSQL(DBMetaData dbmd,
                                       String tableName,
                                       String columnName,
                                       String newType)

getBlobType

public static String getBlobType(DBMetaData dbmd,
                                 int maxLen)

getUnicodeType

public static String getUnicodeType(DBMetaData dbmd,
                                    int maxLen)

getUnicodeCharType

public static String getUnicodeCharType(DBMetaData dbmd,
                                        int maxLen)

getLongUnicodeType

public static String getLongUnicodeType(DBMetaData dbmd,
                                        int maxLen)

getStringType

public static String getStringType(DBMetaData dbmd,
                                   int maxLen)

getLongTextType

public static String getLongTextType(DBMetaData dbmd,
                                     int maxLen)

getBooleanType

public static String getBooleanType(DBMetaData dbmd)

getIntType

public static String getIntType(DBMetaData dbmd)

getSmallIntType

public static String getSmallIntType(DBMetaData dbmd)

getLongType

public static String getLongType(DBMetaData dbmd)

getFloatType

public static String getFloatType(DBMetaData dbmd,
                                  int decimalLength)

getDoubleType

public static String getDoubleType(DBMetaData dbmd,
                                   int decimalLen)

getDateType

public static String getDateType(DBMetaData dbmd)

getDateTimeType

public static String getDateTimeType(DBMetaData dbmd)

getTimestampType

public static String getTimestampType(DBMetaData dbmd)

getCurrencyType

public static String getCurrencyType(DBMetaData dbmd,
                                     int decimalLen)

getTimeType

public static String getTimeType(DBMetaData dbmd)

getNumberType

public static String getNumberType(DBMetaData dbmd,
                                   int maxLen,
                                   int decimalLength)

getAddForeignKeySQL

public static String getAddForeignKeySQL(DBMetaData dbmd,
                                         String fromTable,
                                         String toTable,
                                         String constraintName,
                                         String fromColumns,
                                         String toColumns)

getDropForeignKeySQL

public static String getDropForeignKeySQL(DBMetaData dbmd,
                                          String tableName,
                                          String constraintName)