org.tinygroup.database.table.impl

Class SybaseSqlProcessorImpl

java.lang.Object

org.tinygroup.database.table.impl.SqlProcessorImpl

org.tinygroup.database.table.impl.SybaseSqlProcessorImpl

All Implemented Interfaces:

TableSqlProcessor

public class SybaseSqlProcessorImpl
extends SqlProcessorImpl

Created by wangwy on 2017/2/25.

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

Method Summary

Modifier and Type	Method and Description
protected void	appendColumnUpdate(List<String> existUpdateList, TableField field, StandardField standardField, ColumnContext columnContext) 列字段是否发生改变
protected void	appendComment(String comment, StringBuffer ddlBuffer, List<String> list)
protected void	appendFooterComment(Table table, List<String> list) 在footer增加comment mysql 实现为空
protected String	appendIncrease()
protected void	appendTableSpace(StringBuffer ddlBuffer, Table table) 表空间默认实现
protected void	appendTypeAndDefault(StringBuffer ddlBuffer, TableField field, StandardField standardField) 与其他数据库顺序不一样,identity必须在not null之前
protected boolean	checkTypeSame(String dbColumnType, String tableDataType, String dbDataType) 检查数据类型是否相同
protected String	createAlterTypeSql(String tableName, String fieldName, String tableDataType)
protected void	dealNotNullSql(StringBuffer alterTypeBuffer, TableField field, boolean dbNullAble)
protected String	delimiter(String name)
protected void	getChangedFooterComment(Connection connection, Table table, List<String> list) footer检查comment变化
protected String	getDatabaseType()
protected ResultSet	getDbForeignRsSql(Connection connection, Table table)
protected String	getDropIndexBaseSql(String dropIndexName, String nameWithOutSchema)
protected String	getIndexName(Index index, Table table)
static TableSqlProcessor	getTableSqlProcessor()

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

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

SybaseSqlProcessorImpl

public SybaseSqlProcessorImpl()

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

appendFooterComment

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

在footer增加comment mysql 实现为空

Overrides:

appendFooterComment in class SqlProcessorImpl

Parameters:

table -

list -

getChangedFooterComment

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

footer检查comment变化

Overrides:

getChangedFooterComment in class SqlProcessorImpl

Parameters:

connection -

table -

list -

Throws:

SQLException

delimiter

protected String delimiter(String name)

Overrides:

delimiter in class SqlProcessorImpl

Returns:

appendTableSpace

protected void appendTableSpace(StringBuffer ddlBuffer,
                                Table table)

Description copied from class: SqlProcessorImpl

表空间默认实现

Overrides:

appendTableSpace in class SqlProcessorImpl

appendComment

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

Overrides:

appendComment in class SqlProcessorImpl

appendTypeAndDefault

protected void appendTypeAndDefault(StringBuffer ddlBuffer,
                                    TableField field,
                                    StandardField standardField)

与其他数据库顺序不一样,identity必须在not null之前

Overrides:

appendTypeAndDefault in class SqlProcessorImpl

Parameters:

ddlBuffer -

field -

standardField -

appendColumnUpdate

protected void appendColumnUpdate(List<String> existUpdateList,
                                  TableField field,
                                  StandardField standardField,
                                  ColumnContext columnContext)

Description copied from class: SqlProcessorImpl

列字段是否发生改变

Overrides:

appendColumnUpdate in class SqlProcessorImpl

Parameters:

existUpdateList -

field -

standardField -

columnContext -

dealNotNullSql

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

Overrides:

dealNotNullSql in class SqlProcessorImpl

checkTypeSame

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

检查数据类型是否相同

Overrides:

checkTypeSame in class SqlProcessorImpl

Parameters:

dbColumnType -

tableDataType -

Returns:

getDropIndexBaseSql

protected String getDropIndexBaseSql(String dropIndexName,
                                     String nameWithOutSchema)

Overrides:

getDropIndexBaseSql in class SqlProcessorImpl

Parameters:

dropIndexName -

nameWithOutSchema -

Returns:

getDbForeignRsSql

protected ResultSet getDbForeignRsSql(Connection connection,
                                      Table table)
                               throws SQLException

Parameters:

connection -

table -

Returns:

Throws:

SQLException