org.tinygroup.database.table.impl

Class Db2SqlProcessorImpl

java.lang.Object

org.tinygroup.database.table.impl.SqlProcessorImpl

org.tinygroup.database.table.impl.Db2SqlProcessorImpl

All Implemented Interfaces:

TableSqlProcessor

public class Db2SqlProcessorImpl
extends SqlProcessorImpl

Field Summary

Fields

Modifier and Type	Field and Description
protected String	currentDbSchema

Fields inherited from interface org.tinygroup.database.table.TableSqlProcessor

COLUMN_DEF, COLUMN_NAME, COLUMN_SIZE, DATA_TYPE, DECIMAL_DIGITS, INDEX_NON_UNIQUE, NULLABLE, REMARKS, TYPE_NAME

Constructor Summary

Constructors

Constructor and Description
Db2SqlProcessorImpl()

Method Summary

Modifier and Type	Method and Description
protected void	appendComment(String comment, StringBuffer ddlBuffer)
protected void	appendComment(String comment, StringBuffer ddlBuffer, List<String> list) 添加oracle的字段备注信息
protected void	appendFooter(StringBuffer ddlBuffer, Table table, List<String> list)
protected String	appendIncrease()
protected void	appendIndexReverse(StringBuffer ddlBuffer, Index index)
protected boolean	checkCommentSame(String standardComment, String remarks) oracle注释在foot上 不需要在字段中体现变化
protected boolean	checkIndexBaseSame(Index tableIndex, Map<String,String> dbIndexMap, Connection con) index基本信息是否一致
protected boolean	checkTypeSame(String dbColumnType, String tableDataType, String dbDataType) 检查数据类型是否相同
protected String	createAlterTypeSql(String tableName, String fieldName, String tableDataType)
protected void	dealDefaultValueUpdate(StringBuffer alterTypeBuffer, String fieldDefaultValue, String columnDef)
protected void	dealNotNullSql(StringBuffer alterTypeBuffer, TableField field, boolean dbNullAble)
protected String	dealTableName(String tableName)
protected void	getChangedFooterComment(Connection connection, Table table, List<String> list)
List<String>	getClearTableSql(Table table, Connection connection)
protected String	getDatabaseType()
protected String	getDropIndexBaseSql(String dropIndexName, String tableName)
protected String	getSchema(String schema, Connection connection)
protected String	getSchema(Table table, DatabaseMetaData metadata)
static TableSqlProcessor	getTableSqlProcessor()

Methods inherited from class org.tinygroup.database.table.impl.SqlProcessorImpl

appendBody, appendColumnUpdate, appendDefaultValue, appendField, appendFooterComment, appendPrimarySql, appendTableSpace, appendTypeAndDefault, char2DbLen, checkDefSame, checkTableColumn, checkTableExist, checkUniqueSame, dealAddFields, dealConstraintIndex, dealDateType, dealDropFields, dealExistFields, defaultChangedFooterComment, delimiter, getColumns, getComment, getCreateSql, getDbColumnColumnDef, getDbColumnRemarks, getDbColumnType, getDbForeignList, getDbIndexColumns, getDefaultValue, getDropForeignSql, getDropSql, getFieldStdFieldName, getForeignKeySqls, getForeignKeySqls, getForeignUpdate, getIndexCreateSql, getIndexName, getIndexUpdate, getKeysBuffer, getOneFkSql, getOtherUpdate, getQueryForeignSql, getQuerySchemaName, getSeqTriggerSql, getSeqTriggerUpdate, getTableColumnUpdate, getTableCreateSql, getTableName, getTableProcessor, getUpdateSql, initChar2Byte, notNeedDropIndex, setTableProcessor

Methods inherited from class java.lang.Object

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

Field Detail

currentDbSchema

protected String currentDbSchema

Constructor Detail

Db2SqlProcessorImpl

public Db2SqlProcessorImpl()

Method Detail

getTableSqlProcessor

public static TableSqlProcessor getTableSqlProcessor()

getDatabaseType

protected String getDatabaseType()

Specified by:

getDatabaseType in class SqlProcessorImpl

appendIncrease

protected String appendIncrease()

Overrides:

appendIncrease in class SqlProcessorImpl

createAlterTypeSql

protected String createAlterTypeSql(String tableName,
                                    String fieldName,
                                    String tableDataType)

Specified by:

createAlterTypeSql in class SqlProcessorImpl

getSchema

protected String getSchema(String schema,
                           Connection connection)
                    throws SQLException

Overrides:

getSchema in class SqlProcessorImpl

Throws:

SQLException

getChangedFooterComment

protected void getChangedFooterComment(Connection connection,
                                       Table table,
                                       List<String> list)
                                throws SQLException

Overrides:

getChangedFooterComment in class SqlProcessorImpl

Throws:

SQLException

dealTableName

protected String dealTableName(String tableName)

Overrides:

dealTableName in class SqlProcessorImpl

checkTypeSame

protected boolean checkTypeSame(String dbColumnType,
                                String tableDataType,
                                String dbDataType)

检查数据类型是否相同

Overrides:

checkTypeSame in class SqlProcessorImpl

Parameters:

dbColumnType -

tableDataType -

Returns:

getSchema

protected String getSchema(Table table,
                           DatabaseMetaData metadata)
                    throws SQLException

Overrides:

getSchema in class SqlProcessorImpl

Throws:

SQLException

appendComment

protected void appendComment(String comment,
                             StringBuffer ddlBuffer)

appendFooter

protected void appendFooter(StringBuffer ddlBuffer,
                            Table table,
                            List<String> list)

Overrides:

appendFooter in class SqlProcessorImpl

appendComment

protected void appendComment(String comment,
                             StringBuffer ddlBuffer,
                             List<String> list)

添加oracle的字段备注信息

Overrides:

appendComment in class SqlProcessorImpl

Parameters:

comment -

ddlBuffer -

list -

checkCommentSame

protected boolean checkCommentSame(String standardComment,
                                   String remarks)

oracle注释在foot上 不需要在字段中体现变化

Overrides:

checkCommentSame in class SqlProcessorImpl

Parameters:

standardComment -

remarks -

Returns:

getDropIndexBaseSql

protected String getDropIndexBaseSql(String dropIndexName,
                                     String tableName)

Overrides:

getDropIndexBaseSql in class SqlProcessorImpl

getClearTableSql

public List<String> getClearTableSql(Table table,
                                     Connection connection)
                              throws SQLException

Specified by:

getClearTableSql in interface TableSqlProcessor

Overrides:

getClearTableSql in class SqlProcessorImpl

Throws:

SQLException

dealDefaultValueUpdate

protected void dealDefaultValueUpdate(StringBuffer alterTypeBuffer,
                                      String fieldDefaultValue,
                                      String columnDef)

Overrides:

dealDefaultValueUpdate in class SqlProcessorImpl

dealNotNullSql

protected void dealNotNullSql(StringBuffer alterTypeBuffer,
                              TableField field,
                              boolean dbNullAble)

Overrides:

dealNotNullSql in class SqlProcessorImpl

checkIndexBaseSame

protected boolean checkIndexBaseSame(Index tableIndex,
                                     Map<String,String> dbIndexMap,
                                     Connection con)

Description copied from class: SqlProcessorImpl

index基本信息是否一致

Overrides:

checkIndexBaseSame in class SqlProcessorImpl

Returns:

appendIndexReverse

protected void appendIndexReverse(StringBuffer ddlBuffer,
                                  Index index)

Overrides:

appendIndexReverse in class SqlProcessorImpl