org.tinygroup.database.table.impl

Class OracleSqlProcessorImpl

java.lang.Object

org.tinygroup.database.table.impl.SqlProcessorImpl

org.tinygroup.database.table.impl.OracleSqlProcessorImpl

All Implemented Interfaces:

TableSqlProcessor

public class OracleSqlProcessorImpl
extends SqlProcessorImpl

Field Summary

Fields

Modifier and Type	Field and Description
protected String	currentDbSchema
protected static String	FORMAT_FUNCTION_STR

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

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 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 String	dealDateType(String value) 处理日期类型 因为初始化数据是字符串类型,而实际是date类型,有些数据库需要进行转换。
protected void	dealDefaultValueUpdate(StringBuffer alterTypeBuffer, String fieldDefaultValue, String columnDef)
protected void	dealNotNullSql(StringBuffer alterTypeBuffer, TableField field, boolean dbNullAble)
protected void	getChangedFooterComment(Connection connection, Table table, List<String> list)
List<String>	getClearTableSql(Table table, Connection connection)
protected String	getDatabaseType()
protected String	getDropForeignSql(String dropConstraint, Table table)
protected String	getDropIndexBaseSql(String dropIndexName, String tableName)
protected String	getQueryForeignSql(Table table, String schema)
protected String	getSchema(String schema, Connection connection)
protected List<String>	getSeqTriggerSql(Table table, String packageName) 创建seq和trigger语句
protected void	getSeqTriggerUpdate(Connection connection, Table table, List<String> list)
static TableSqlProcessor	getTableSqlProcessor()

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

appendBody, appendColumnUpdate, appendDefaultValue, appendField, appendFooterComment, appendIncrease, appendPrimarySql, appendTableSpace, appendTypeAndDefault, char2DbLen, checkDefSame, checkTableColumn, checkTableExist, checkUniqueSame, dealAddFields, dealConstraintIndex, dealDropFields, dealExistFields, dealTableName, defaultChangedFooterComment, delimiter, getColumns, getComment, getCreateSql, getDbColumnColumnDef, getDbColumnRemarks, getDbColumnType, getDbForeignList, getDbIndexColumns, getDefaultValue, getDropSql, getFieldStdFieldName, getForeignKeySqls, getForeignKeySqls, getForeignUpdate, getIndexCreateSql, getIndexName, getIndexUpdate, getKeysBuffer, getOneFkSql, getOtherUpdate, getQuerySchemaName, getSchema, 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

FORMAT_FUNCTION_STR

protected static final String FORMAT_FUNCTION_STR

See Also:

Constant Field Values

currentDbSchema

protected String currentDbSchema

Constructor Detail

OracleSqlProcessorImpl

public OracleSqlProcessorImpl()

Method Detail

getTableSqlProcessor

public static TableSqlProcessor getTableSqlProcessor()

getDatabaseType

protected String getDatabaseType()

Specified by:

getDatabaseType in class SqlProcessorImpl

getQueryForeignSql

protected String getQueryForeignSql(Table table,
                                    String schema)

Overrides:

getQueryForeignSql 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)

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:

checkTypeSame

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

Description copied from class: SqlProcessorImpl

检查数据类型是否相同

Overrides:

checkTypeSame in class SqlProcessorImpl

Parameters:

dbColumnType -

tableDataType -

Returns:

getSchema

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

Overrides:

getSchema in class SqlProcessorImpl

Throws:

SQLException

getSeqTriggerSql

protected List<String> getSeqTriggerSql(Table table,
                                        String packageName)

Description copied from class: SqlProcessorImpl

创建seq和trigger语句

Overrides:

getSeqTriggerSql in class SqlProcessorImpl

Returns:

getChangedFooterComment

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

Overrides:

getChangedFooterComment in class SqlProcessorImpl

Throws:

SQLException

getSeqTriggerUpdate

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

Overrides:

getSeqTriggerUpdate in class SqlProcessorImpl

Throws:

SQLException

getDropForeignSql

protected String getDropForeignSql(String dropConstraint,
                                   Table table)

Overrides:

getDropForeignSql in class SqlProcessorImpl

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

dealDateType

protected String dealDateType(String value)

Description copied from class: SqlProcessorImpl

处理日期类型 因为初始化数据是字符串类型,而实际是date类型,有些数据库需要进行转换。

Overrides:

dealDateType in class SqlProcessorImpl

Returns: