org.tinygroup.database.table.impl

Class SqlserverSqlProcessorImpl

java.lang.Object

org.tinygroup.database.table.impl.SqlProcessorImpl

org.tinygroup.database.table.impl.SqlserverSqlProcessorImpl

All Implemented Interfaces:

TableSqlProcessor

public class SqlserverSqlProcessorImpl
extends SqlProcessorImpl

Field Summary

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

Method Summary

Modifier and Type	Method and Description
protected void	appendComment(String comment, StringBuffer ddlBuffer, List<String> list)
protected void	appendFooter(StringBuffer ddlBuffer, Table table, List<String> list)
protected void	appendFooterComment(Table table, List<String> list) 在footer增加comment
protected String	appendIncrease()
protected boolean	checkCommentSame(String standardComment, String remarks) 检查comment是否改变
protected boolean	checkDefSame(String standardDefault, String columnDef)
protected boolean	checkTypeSame(String dbColumnType, String tableDataType, String dbDataType) 检查数据类型是否相同
protected String	createAlterTypeSql(String tableName, String fieldName, String tableDataType)
protected void	getChangedFooterComment(Connection connection, Table table, List<String> list)
protected String	getDatabaseType()
protected String	getDropIndexBaseSql(String dropIndexName, String nameWithOutSchema)
protected String	getIndexName(Index index, Table table)
protected String	getSchema(String schema, Connection connection)
static TableSqlProcessor	getTableSqlProcessor()

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

appendBody, appendColumnUpdate, appendDefaultValue, appendField, appendIndexReverse, appendPrimarySql, appendTableSpace, appendTypeAndDefault, char2DbLen, checkIndexBaseSame, checkTableColumn, checkTableExist, checkUniqueSame, dealAddFields, dealConstraintIndex, dealDateType, dealDefaultValueUpdate, dealDropFields, dealExistFields, dealNotNullSql, dealTableName, defaultChangedFooterComment, delimiter, getClearTableSql, getColumns, getComment, getCreateSql, getDbColumnColumnDef, getDbColumnRemarks, getDbColumnType, getDbForeignList, getDbIndexColumns, getDefaultValue, getDropForeignSql, getDropSql, getFieldStdFieldName, getForeignKeySqls, getForeignKeySqls, getForeignUpdate, getIndexCreateSql, getIndexUpdate, getKeysBuffer, getOneFkSql, getOtherUpdate, getQueryForeignSql, getQuerySchemaName, getSchema, 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

Constructor Detail

SqlserverSqlProcessorImpl

public SqlserverSqlProcessorImpl()

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

getIndexName

protected String getIndexName(Index index,
                              Table table)

Overrides:

getIndexName in class SqlProcessorImpl

appendComment

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

Overrides:

appendComment in class SqlProcessorImpl

appendFooter

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

Overrides:

appendFooter in class SqlProcessorImpl

appendFooterComment

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

在footer增加comment

Overrides:

appendFooterComment in class SqlProcessorImpl

Parameters:

table -

list -

checkDefSame

protected boolean checkDefSame(String standardDefault,
                               String columnDef)

Overrides:

checkDefSame in class SqlProcessorImpl

checkCommentSame

protected boolean checkCommentSame(String standardComment,
                                   String remarks)

Description copied from class: SqlProcessorImpl

检查comment是否改变

Overrides:

checkCommentSame in class SqlProcessorImpl

Returns:

getChangedFooterComment

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

Overrides:

getChangedFooterComment in class SqlProcessorImpl

Throws:

SQLException

checkTypeSame

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

Description copied from class: SqlProcessorImpl

检查数据类型是否相同

Overrides:

checkTypeSame in class SqlProcessorImpl

Returns:

getDropIndexBaseSql

protected String getDropIndexBaseSql(String dropIndexName,
                                     String nameWithOutSchema)

Overrides:

getDropIndexBaseSql in class SqlProcessorImpl

getSchema

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

Overrides:

getSchema in class SqlProcessorImpl

Throws:

SQLException