com.centit.support.database.ddl

Class MySqlDDLOperations

java.lang.Object

com.centit.support.database.ddl.GeneralDDLOperations

com.centit.support.database.ddl.MySqlDDLOperations

All Implemented Interfaces:

DDLOperations

Direct Known Subclasses:

H2DDLOperations

public class MySqlDDLOperations
extends GeneralDDLOperations

Field Summary

Fields inherited from class com.centit.support.database.ddl.GeneralDDLOperations

conn

Constructor Summary

Constructors

Constructor and Description
MySqlDDLOperations()
MySqlDDLOperations(Connection conn)

Method Summary

Modifier and Type	Method and Description
protected void	appendColumnSQL(TableField field, StringBuilder sbCreate)
protected void	appendPkSql(TableInfo tableInfo, StringBuilder sbCreate)
String	makeModifyColumnSql(String tableCode, TableField oldColumn, TableField column) 修改列定义 ，比如 修改 varchar 的长度
List<String>	makeReconfigurationColumnSqls(String tableCode, String columnCode, TableField column) 重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列
String	makeRenameColumnSql(String tableCode, String columnCode, TableField column) 重命名列

Methods inherited from class com.centit.support.database.ddl.GeneralDDLOperations

addColumn, appendColumnsSQL, appendColumnTypeSQL, appendPkColumnSql, checkTableWellDefined, checkViewWellDefined, createDDLOperations, createDDLOperations, createSequence, createTable, dropColumn, dropTable, makeAddColumnSql, makeCreateSequenceSql, makeCreateTableSql, makeCreateViewSql, makeDropColumnSql, makeDropTableSql, modifyColumn, parseDDL, reconfigurationColumn, renameColumn, setConnect

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.centit.support.database.ddl.DDLOperations

makeCreateTableSql

Constructor Detail

MySqlDDLOperations

public MySqlDDLOperations()

MySqlDDLOperations

public MySqlDDLOperations(Connection conn)

Method Detail

appendPkSql

protected void appendPkSql(TableInfo tableInfo,
                           StringBuilder sbCreate)

Overrides:

appendPkSql in class GeneralDDLOperations

appendColumnSQL

protected void appendColumnSQL(TableField field,
                               StringBuilder sbCreate)

Overrides:

appendColumnSQL in class GeneralDDLOperations

makeModifyColumnSql

public String makeModifyColumnSql(String tableCode,
                                  TableField oldColumn,
                                  TableField column)

Description copied from interface: DDLOperations

修改列定义 ，比如 修改 varchar 的长度

Parameters:

tableCode - 表代码

oldColumn - 老的字段

column - 字段

Returns:

sql语句

makeRenameColumnSql

public String makeRenameColumnSql(String tableCode,
                                  String columnCode,
                                  TableField column)

Description copied from interface: DDLOperations

重命名列

Specified by:

makeRenameColumnSql in interface DDLOperations

Overrides:

makeRenameColumnSql in class GeneralDDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Returns:

sql语句

makeReconfigurationColumnSqls

public List<String> makeReconfigurationColumnSqls(String tableCode,
                                                  String columnCode,
                                                  TableField column)

Description copied from interface: DDLOperations

重构列，涉及到内容格式的转换，需要新建一个列，将旧列中的数据转换到新列中，然后在删除旧列

Specified by:

makeReconfigurationColumnSqls in interface DDLOperations

Overrides:

makeReconfigurationColumnSqls in class GeneralDDLOperations

Parameters:

tableCode - 表代码

columnCode - 字段代码

column - 字段

Returns:

sql语句列表