com.centit.support.database.ddl

Class PostgreSqlDDLOperations

java.lang.Object

com.centit.support.database.ddl.GeneralDDLOperations

com.centit.support.database.ddl.PostgreSqlDDLOperations

All Implemented Interfaces:

DDLOperations

public class PostgreSqlDDLOperations
extends GeneralDDLOperations

Field Summary

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

conn

Constructor Summary

Constructors

Constructor and Description
PostgreSqlDDLOperations()
PostgreSqlDDLOperations(Connection conn)

Method Summary

Modifier and Type	Method and Description
String	makeCreateSequenceSql(String sequenceName) 创建序列 用表来模拟sequence create table simulate_sequence (seqname varchar(100) not null primary key, currvalue integer, increment integer);
String	makeModifyColumnSql(String tableCode, TableField oldColumn, TableField column) 修改列定义 ，比如 修改 varchar 的长度

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

addColumn, appendColumnSQL, appendColumnsSQL, appendColumnTypeSQL, appendPkColumnSql, appendPkSql, checkTableWellDefined, checkViewWellDefined, createDDLOperations, createDDLOperations, createSequence, createTable, dropColumn, dropTable, makeAddColumnSql, makeCreateTableSql, makeCreateViewSql, makeDropColumnSql, makeDropTableSql, makeReconfigurationColumnSqls, makeRenameColumnSql, 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

PostgreSqlDDLOperations

public PostgreSqlDDLOperations()

PostgreSqlDDLOperations

public PostgreSqlDDLOperations(Connection conn)

Method Detail

makeCreateSequenceSql

public String makeCreateSequenceSql(String sequenceName)

Description copied from class: GeneralDDLOperations

创建序列 用表来模拟sequence create table simulate_sequence (seqname varchar(100) not null primary key, currvalue integer, increment integer);

Specified by:

makeCreateSequenceSql in interface DDLOperations

Overrides:

makeCreateSequenceSql in class GeneralDDLOperations

Parameters:

sequenceName - 序列

Returns:

sql语句

makeModifyColumnSql

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

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

Parameters:

tableCode - 表代码

oldColumn - 老的字段

column - 字段

Returns:

sql语句