Package cc.carm.lib.easysql.builder.impl

Class TableAlterBuilderImpl

java.lang.Object

cc.carm.lib.easysql.builder.AbstractSQLBuilder

cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl

All Implemented Interfaces:

TableAlterBuilder, SQLBuilder

public class TableAlterBuilderImpl
extends AbstractSQLBuilder
implements TableAlterBuilder

Field Summary

Fields

Modifier and Type	Field	Description
protected @NotNull java.lang.String	tableName

Constructor Summary

Constructors

Constructor	Description
TableAlterBuilderImpl(@NotNull SQLManagerImpl manager, @NotNull java.lang.String tableName)

Method Summary

Modifier and Type	Method	Description
SQLAction<java.lang.Integer>	addColumn(@NotNull java.lang.String columnName, @NotNull java.lang.String settings, @Nullable java.lang.String afterColumn)	为表添加一列
SQLAction<java.lang.Integer>	addIndex(@NotNull IndexType indexType, @NotNull java.lang.String indexName, @NotNull java.lang.String columnName, @NotNull java.lang.String... moreColumns)
SQLAction<java.lang.Integer>	changeComment(@NotNull java.lang.String newTableComment)
SQLAction<java.lang.Integer>	dropForeignKey(@NotNull java.lang.String keySymbol)	为该表移除一个外键
SQLAction<java.lang.Integer>	dropIndex(@NotNull java.lang.String indexName)	为该表移除一个索引
SQLAction<java.lang.Integer>	dropPrimaryKey()	为该表移除主键(须添加新主键)
@NotNull java.lang.String	getTableName()
SQLAction<java.lang.Integer>	modifyColumn(@NotNull java.lang.String columnName, @NotNull java.lang.String settings)
SQLAction<java.lang.Integer>	removeColumn(@NotNull java.lang.String columnName)
SQLAction<java.lang.Integer>	removeColumnDefault(@NotNull java.lang.String columnName)
SQLAction<java.lang.Integer>	renameColumn(@NotNull java.lang.String columnName, @NotNull java.lang.String newName)
SQLAction<java.lang.Integer>	renameTo(@NotNull java.lang.String newTableName)
SQLAction<java.lang.Integer>	setAutoIncrementIndex(int index)
SQLAction<java.lang.Integer>	setColumnDefault(@NotNull java.lang.String columnName, @NotNull java.lang.String defaultValue)

Methods inherited from class cc.carm.lib.easysql.builder.AbstractSQLBuilder

getManager

Methods inherited from class java.lang.Object

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

Methods inherited from interface cc.carm.lib.easysql.api.SQLBuilder

getManager

Methods inherited from interface cc.carm.lib.easysql.api.builder.TableAlterBuilder

addAutoIncrementColumn, addAutoIncrementColumn, addAutoIncrementColumn, addColumn, modifyColumn

Field Detail

tableName

@NotNull
protected final @NotNull java.lang.String tableName

Constructor Detail

TableAlterBuilderImpl

public TableAlterBuilderImpl(@NotNull
                             @NotNull SQLManagerImpl manager,
                             @NotNull
                             @NotNull java.lang.String tableName)

Method Detail

getTableName

@NotNull
public @NotNull java.lang.String getTableName()

renameTo

public SQLAction<java.lang.Integer> renameTo(@NotNull
                                             @NotNull java.lang.String newTableName)

Specified by:

renameTo in interface TableAlterBuilder

changeComment

public SQLAction<java.lang.Integer> changeComment(@NotNull
                                                  @NotNull java.lang.String newTableComment)

Specified by:

changeComment in interface TableAlterBuilder

setAutoIncrementIndex

public SQLAction<java.lang.Integer> setAutoIncrementIndex(int index)

Specified by:

setAutoIncrementIndex in interface TableAlterBuilder

addIndex

public SQLAction<java.lang.Integer> addIndex(@NotNull
                                             @NotNull IndexType indexType,
                                             @NotNull
                                             @NotNull java.lang.String indexName,
                                             @NotNull
                                             @NotNull java.lang.String columnName,
                                             @NotNull
                                             @NotNull java.lang.String... moreColumns)

Specified by:

addIndex in interface TableAlterBuilder

dropIndex

public SQLAction<java.lang.Integer> dropIndex(@NotNull
                                              @NotNull java.lang.String indexName)

Description copied from interface: TableAlterBuilder

为该表移除一个索引

Specified by:

dropIndex in interface TableAlterBuilder

Parameters:

indexName - 索引名

Returns:

SQLUpdateAction

dropForeignKey

public SQLAction<java.lang.Integer> dropForeignKey(@NotNull
                                                   @NotNull java.lang.String keySymbol)

Description copied from interface: TableAlterBuilder

为该表移除一个外键

Specified by:

dropForeignKey in interface TableAlterBuilder

Parameters:

keySymbol - 外键名

Returns:

SQLUpdateAction

dropPrimaryKey

public SQLAction<java.lang.Integer> dropPrimaryKey()

Description copied from interface: TableAlterBuilder

为该表移除主键(须添加新主键)

Specified by:

dropPrimaryKey in interface TableAlterBuilder

Returns:

SQLUpdateAction

addColumn

public SQLAction<java.lang.Integer> addColumn(@NotNull
                                              @NotNull java.lang.String columnName,
                                              @NotNull
                                              @NotNull java.lang.String settings,
                                              @Nullable
                                              @Nullable java.lang.String afterColumn)

Description copied from interface: TableAlterBuilder

为表添加一列

Specified by:

addColumn in interface TableAlterBuilder

Parameters:

columnName - 列名

settings - 列的相关设定

afterColumn - 该列增添到哪个列的后面，

该参数若省缺则放于最后一行

若为 "" 则置于首行。

Returns:

SQLUpdateAction

renameColumn

public SQLAction<java.lang.Integer> renameColumn(@NotNull
                                                 @NotNull java.lang.String columnName,
                                                 @NotNull
                                                 @NotNull java.lang.String newName)

Specified by:

renameColumn in interface TableAlterBuilder

modifyColumn

public SQLAction<java.lang.Integer> modifyColumn(@NotNull
                                                 @NotNull java.lang.String columnName,
                                                 @NotNull
                                                 @NotNull java.lang.String settings)

Specified by:

modifyColumn in interface TableAlterBuilder

removeColumn

public SQLAction<java.lang.Integer> removeColumn(@NotNull
                                                 @NotNull java.lang.String columnName)

Specified by:

removeColumn in interface TableAlterBuilder

setColumnDefault

public SQLAction<java.lang.Integer> setColumnDefault(@NotNull
                                                     @NotNull java.lang.String columnName,
                                                     @NotNull
                                                     @NotNull java.lang.String defaultValue)

Specified by:

setColumnDefault in interface TableAlterBuilder

removeColumnDefault

public SQLAction<java.lang.Integer> removeColumnDefault(@NotNull
                                                        @NotNull java.lang.String columnName)

Specified by:

removeColumnDefault in interface TableAlterBuilder