org.tinygroup.database.table.impl

Class InformixSqlProcessorImpl

java.lang.Object

org.tinygroup.database.table.impl.SqlProcessorImpl

org.tinygroup.database.table.impl.InformixSqlProcessorImpl

All Implemented Interfaces:

TableSqlProcessor

public class InformixSqlProcessorImpl
extends SqlProcessorImpl

Created by wangwy on 2017/2/25.

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
InformixSqlProcessorImpl()

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)
protected void	appendFooterComment(Table table, List<String> list) 在footer增加comment 实现为空
protected void	appendIndexReverse(StringBuffer ddlBuffer, Index index)
protected void	appendPrimarySql(StringBuffer ddlBuffer, Table table, List<String> list)
protected void	appendTableSpace(StringBuffer ddlBuffer, Table table) 表空间默认实现
protected boolean	checkCommentSame(String standardComment, String remarks) 注释在foot上 不需要在字段中体现变化
protected String	createAlterTypeSql(String tableName, String fieldName, String tableDataType)
protected void	dealConstraintIndex(Table table, List<String> preDropIndexes, Map<String,Map<String,String>> dbIndexes) 删除有关联的索引 informix不做处理
protected void	dealDefaultValueUpdate(StringBuffer alterTypeBuffer, String fieldDefaultValue, String columnDef)
protected List<String>	dealDropFields(List<String> dropFields, Table table)
protected void	dealNotNullSql(StringBuffer alterTypeBuffer, TableField field, boolean dbNullAble)
protected void	getChangedFooterComment(Connection connection, Table table, List<String> list)
protected String	getDatabaseType()
protected String	getDropForeignSql(String dropConstraint, Table table)
protected String	getDropIndexBaseSql(String dropIndexName, String nameWithOutSchema)
protected String	getOneFkSql(Table table, Table foreignTable, ForeignReference foreignReference)
protected String	getSchema(String schema, Connection connection)
static TableSqlProcessor	getTableSqlProcessor()
protected boolean	notNeedDropIndex(List<Index> preAddIndexes, Table table, String dbIndexName, Map<String,Map<String,String>> dbIndexMaps, Connection connection) informix不会删除索引 因为有系统索引(主键、外键、clob都会有)存在，无法辨别

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

appendBody, appendColumnUpdate, appendDefaultValue, appendField, appendFooter, appendIncrease, appendTypeAndDefault, char2DbLen, checkDefSame, checkIndexBaseSame, checkTableColumn, checkTableExist, checkTypeSame, checkUniqueSame, dealAddFields, dealDateType, dealExistFields, dealTableName, defaultChangedFooterComment, delimiter, getClearTableSql, getColumns, getComment, getCreateSql, getDbColumnColumnDef, getDbColumnRemarks, getDbColumnType, getDbForeignList, getDbIndexColumns, getDefaultValue, getDropSql, getFieldStdFieldName, getForeignKeySqls, getForeignKeySqls, getForeignUpdate, getIndexCreateSql, getIndexName, getIndexUpdate, getKeysBuffer, getOtherUpdate, getQueryForeignSql, getQuerySchemaName, getSchema, getSeqTriggerSql, getSeqTriggerUpdate, getTableColumnUpdate, getTableCreateSql, getTableName, getTableProcessor, getUpdateSql, initChar2Byte, 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

InformixSqlProcessorImpl

public InformixSqlProcessorImpl()

Method Detail

getTableSqlProcessor

public static TableSqlProcessor getTableSqlProcessor()

getDatabaseType

protected String getDatabaseType()

Specified by:

getDatabaseType in class SqlProcessorImpl

createAlterTypeSql

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

Specified by:

createAlterTypeSql in class SqlProcessorImpl

appendComment

protected void appendComment(String comment,
                             StringBuffer ddlBuffer)

checkCommentSame

protected boolean checkCommentSame(String standardComment,
                                   String remarks)

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

Overrides:

checkCommentSame in class SqlProcessorImpl

Parameters:

standardComment -

remarks -

Returns:

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

getDropForeignSql

protected String getDropForeignSql(String dropConstraint,
                                   Table table)

Overrides:

getDropForeignSql in class SqlProcessorImpl

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

appendIndexReverse

protected void appendIndexReverse(StringBuffer ddlBuffer,
                                  Index index)

Overrides:

appendIndexReverse in class SqlProcessorImpl

appendFooterComment

protected void appendFooterComment(Table table,
                                   List<String> list)

在footer增加comment 实现为空

Overrides:

appendFooterComment in class SqlProcessorImpl

Parameters:

table -

list -

appendComment

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

Overrides:

appendComment in class SqlProcessorImpl

appendPrimarySql

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

Overrides:

appendPrimarySql in class SqlProcessorImpl

getOneFkSql

protected String getOneFkSql(Table table,
                             Table foreignTable,
                             ForeignReference foreignReference)

Overrides:

getOneFkSql in class SqlProcessorImpl

getDropIndexBaseSql

protected String getDropIndexBaseSql(String dropIndexName,
                                     String nameWithOutSchema)

Overrides:

getDropIndexBaseSql in class SqlProcessorImpl

notNeedDropIndex

protected boolean notNeedDropIndex(List<Index> preAddIndexes,
                                   Table table,
                                   String dbIndexName,
                                   Map<String,Map<String,String>> dbIndexMaps,
                                   Connection connection)

informix不会删除索引 因为有系统索引(主键、外键、clob都会有)存在，无法辨别

Overrides:

notNeedDropIndex in class SqlProcessorImpl

Parameters:

table -

dbIndexName -

dbIndexMaps -

Returns:

dealConstraintIndex

protected void dealConstraintIndex(Table table,
                                   List<String> preDropIndexes,
                                   Map<String,Map<String,String>> dbIndexes)

删除有关联的索引 informix不做处理

Overrides:

dealConstraintIndex in class SqlProcessorImpl

Parameters:

table -

preDropIndexes -

dealDropFields

protected List<String> dealDropFields(List<String> dropFields,
                                      Table table)

Overrides:

dealDropFields in class SqlProcessorImpl

Parameters:

dropFields -

table -

Returns:

appendTableSpace

protected void appendTableSpace(StringBuffer ddlBuffer,
                                Table table)

Description copied from class: SqlProcessorImpl

表空间默认实现

Overrides:

appendTableSpace in class SqlProcessorImpl

Parameters:

ddlBuffer -

table -