Module net.sf.jsqlparser

Package net.sf.jsqlparser.statement.alter

Class AlterExpression

java.lang.Object

net.sf.jsqlparser.statement.alter.AlterExpression

All Implemented Interfaces:

Serializable

public class AlterExpression
extends Object
implements Serializable

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	AlterExpression.ColumnDataType
static class	AlterExpression.ColumnDropDefault
static class	AlterExpression.ColumnDropNotNull
static class	AlterExpression.ColumnSetDefault
static class	AlterExpression.ColumnSetVisibility
static class	AlterExpression.ConvertType

Constructor Summary

Constructors

Constructor	Description
AlterExpression()

Method Summary

Modifier and Type	Method	Description
void	addColDataType(String columnName, ColDataType colDataType)
void	addColDataType(AlterExpression.ColumnDataType columnDataType)
void	addColDropDefault(AlterExpression.ColumnDropDefault columnDropDefault)
void	addColDropNotNull(AlterExpression.ColumnDropNotNull columnDropNotNull)
void	addColSetDefault(AlterExpression.ColumnSetDefault columnSetDefault)
void	addColSetVisibility(AlterExpression.ColumnSetVisibility columnSetVisibility)
AlterExpression	addConstraints(Collection<? extends ConstraintState> constraints)
AlterExpression	addConstraints(ConstraintState... constraints)
AlterExpression	addFkColumns(String... fkColumns)
AlterExpression	addFkColumns(Collection<String> fkColumns)
AlterExpression	addFkSourceColumns(String... fkSourceColumns)
AlterExpression	addFkSourceColumns(Collection<String> fkSourceColumns)
void	addParameters(String... params)
AlterExpression	addPkColumns(String... pkColumns)
AlterExpression	addPkColumns(Collection<String> pkColumns)
AlterExpression	addUkColumns(String... ukColumns)
AlterExpression	addUkColumns(Collection<String> ukColumns)
String	getAlgorithmOption()
String	getCharacterSet()
int	getCoalescePartitionNumber()
List<AlterExpression.ColumnDataType>	getColDataTypeList()
String	getCollation()
String	getColOldName()	Deprecated.
List<AlterExpression.ColumnDropDefault>	getColumnDropDefaultList()
List<AlterExpression.ColumnDropNotNull>	getColumnDropNotNullList()
String	getColumnName()
String	getColumnOldName()
List<AlterExpression.ColumnSetDefault>	getColumnSetDefaultList()
List<AlterExpression.ColumnSetVisibility>	getColumnSetVisibilityList()
String	getCommentText()
String	getConstraintName()
List<ConstraintState>	getConstraints()
String	getConstraintSymbol()
String	getConstraintType()
AlterExpression.ConvertType	getConvertType()
String	getEngineOption()
String	getExchangePartitionTableName()
List<String>	getFkColumns()
List<String>	getFkSourceColumns()
String	getFkSourceSchema()
String	getFkSourceTable()
Index	getIndex()
int	getKeyBlockSize()
String	getLockOption()
String	getNewTableName()
Index	getOldIndex()
AlterOperation	getOperation()
String	getOptionalSpecifier()
List<String>	getParameters()
List<String>	getPartitionColumns()
List<PartitionDefinition>	getPartitionDefinitions()
Expression	getPartitionExpression()
List<String>	getPartitions()
String	getPartitionType()
List<String>	getPkColumns()
ReferentialAction	getReferentialAction(ReferentialAction.Type type)
String	getTableOption()
boolean	getUk()
List<String>	getUkColumns()
String	getUkName()
boolean	getUseEqual()
boolean	hasColumn()
void	hasColumn(boolean hasColumn)
boolean	hasColumns()
void	hasColumns(boolean hasColumns)
boolean	isDefaultCollateSpecified()
boolean	isEnforced()
boolean	isExchangePartitionWithoutValidation()
boolean	isExchangePartitionWithValidation()
boolean	isInvisible()
boolean	isOnDeleteCascade()	Deprecated. use getReferentialAction(ReferentialAction.Type)
boolean	isOnDeleteRestrict()	Deprecated. use getReferentialAction(ReferentialAction.Type)
boolean	isOnDeleteSetNull()	Deprecated. use getReferentialAction(ReferentialAction.Type)
boolean	isUseIfNotExists()
boolean	isUsingIfExists()
void	removeReferentialAction(ReferentialAction.Type type)
void	setAlgorithmOption(String algorithmOption)
void	setCharacterSet(String characterSet)
void	setCoalescePartitionNumber(int coalescePartitionNumber)
void	setCollation(String collation)
void	setColOldName(String columnOldName)	Deprecated.
void	setColumnName(String columnName)
void	setColumnOldName(String columnOldName)
void	setCommentText(String commentText)
void	setConstraintName(String constraintName)
void	setConstraints(List<ConstraintState> constraints)
void	setConstraintSymbol(String constraintSymbol)
void	setConstraintType(String constraintType)
void	setConvertType(AlterExpression.ConvertType convertType)
void	setDefaultCollateSpecified(boolean value)
void	setEnforced(boolean enforced)
void	setEngineOption(String engineOption)
void	setExchangePartitionTableName(String exchangePartitionTableName)
void	setExchangePartitionWithoutValidation(boolean exchangePartitionWithoutValidation)
void	setExchangePartitionWithValidation(boolean exchangePartitionWithValidation)
void	setFkColumns(List<String> fkColumns)
void	setFkSourceColumns(List<String> fkSourceColumns)
void	setFkSourceSchema(String fkSourceSchema)
void	setFkSourceTable(String fkSourceTable)
void	setHasEqualForCharacterSet(boolean hasEqualForCharacterSet)
void	setHasEqualForCollate(boolean hasEqualForCollate)
void	setIndex(Index index)
void	setInvisible(boolean invisible)
void	setKeyBlockSize(int keyBlockSize)
void	setLockOption(String lockOption)
void	setNewTableName(String newTableName)
void	setOldIndex(Index oldIndex)
void	setOnDeleteCascade(boolean onDeleteCascade)	Deprecated. use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)
void	setOnDeleteRestrict(boolean onDeleteRestrict)	Deprecated. use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)
void	setOnDeleteSetNull(boolean onDeleteSetNull)	Deprecated. use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)
void	setOperation(AlterOperation operation)
void	setOptionalSpecifier(String optionalSpecifier)
void	setPartitionColumns(List<String> partitionColumns)
void	setPartitionDefinitions(List<PartitionDefinition> partitionDefinition)
void	setPartitionExpression(Expression partitionExpression)
void	setPartitions(List<String> partitions)
void	setPartitionType(String partitionType)
void	setPkColumns(List<String> pkColumns)
void	setReferentialAction(ReferentialAction.Type type, ReferentialAction.Action action)
void	setTableOption(String tableOption)
void	setUk(boolean uk)
void	setUkColumns(List<String> ukColumns)
void	setUkName(String ukName)
void	setUseEqual(boolean useEqual)
void	setUseIfNotExists(boolean useIfNotExists)
void	setUsingIfExists(boolean usingIfExists)
String	toString()
boolean	useBrackets()
void	useBrackets(boolean useBrackets)
AlterExpression	withColumnName(String columnName)
AlterExpression	withColumnOldName(String columnOldName)
AlterExpression	withCommentText(String commentText)
AlterExpression	withConstraintName(String constraintName)
AlterExpression	withConstraints(List<ConstraintState> constraints)
AlterExpression	withFkColumns(List<String> fkColumns)
AlterExpression	withFkSourceColumns(List<String> fkSourceColumns)
AlterExpression	withFkSourceSchema(String fkSourceSchema)
AlterExpression	withFkSourceTable(String fkSourceTable)
AlterExpression	withIndex(Index index)
AlterExpression	withOnDeleteCascade(boolean onDeleteCascade)
AlterExpression	withOnDeleteRestrict(boolean onDeleteRestrict)
AlterExpression	withOnDeleteSetNull(boolean onDeleteSetNull)
AlterExpression	withOperation(AlterOperation operation)
AlterExpression	withOptionalSpecifier(String optionalSpecifier)
AlterExpression	withPkColumns(List<String> pkColumns)
AlterExpression	withReferentialAction(ReferentialAction.Type type, ReferentialAction.Action action)
AlterExpression	withUk(boolean uk)
AlterExpression	withUkColumns(List<String> ukColumns)
AlterExpression	withUkName(String ukName)
AlterExpression	withUseEqual(boolean useEqual)
AlterExpression	withUserIfNotExists(boolean userIfNotExists)
AlterExpression	withUsingIfExists(boolean usingIfExists)

Methods inherited from class java.lang.Object

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

Constructor Detail

AlterExpression

public AlterExpression()

Method Detail

getOldIndex

public Index getOldIndex()

setOldIndex

public void setOldIndex(Index oldIndex)

hasColumn

public boolean hasColumn()

hasColumns

public boolean hasColumns()

useBrackets

public boolean useBrackets()

useBrackets

public void useBrackets(boolean useBrackets)

hasColumn

public void hasColumn(boolean hasColumn)

hasColumns

public void hasColumns(boolean hasColumns)

getFkSourceSchema

public String getFkSourceSchema()

setFkSourceSchema

public void setFkSourceSchema(String fkSourceSchema)

getCommentText

public String getCommentText()

setCommentText

public void setCommentText(String commentText)

getTableOption

public String getTableOption()

setTableOption

public void setTableOption(String tableOption)

getOperation

public AlterOperation getOperation()

setOperation

public void setOperation(AlterOperation operation)

getOptionalSpecifier

public String getOptionalSpecifier()

setOptionalSpecifier

public void setOptionalSpecifier(String optionalSpecifier)

setReferentialAction

public void setReferentialAction(ReferentialAction.Type type,
                                 ReferentialAction.Action action)

Parameters:

type -

action -

withReferentialAction

public AlterExpression withReferentialAction(ReferentialAction.Type type,
                                             ReferentialAction.Action action)

removeReferentialAction

public void removeReferentialAction(ReferentialAction.Type type)

Parameters:

type -

getReferentialAction

public ReferentialAction getReferentialAction(ReferentialAction.Type type)

Parameters:

type -

Returns:

isOnDeleteCascade

@Deprecated
public boolean isOnDeleteCascade()

Deprecated.

use getReferentialAction(ReferentialAction.Type)

Returns:

setOnDeleteCascade

@Deprecated
public void setOnDeleteCascade(boolean onDeleteCascade)

Deprecated.

use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)

Parameters:

onDeleteCascade -

isOnDeleteRestrict

@Deprecated
public boolean isOnDeleteRestrict()

Deprecated.

use getReferentialAction(ReferentialAction.Type)

Returns:

setOnDeleteRestrict

@Deprecated
public void setOnDeleteRestrict(boolean onDeleteRestrict)

Deprecated.

use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)

Parameters:

onDeleteRestrict -

isOnDeleteSetNull

@Deprecated
public boolean isOnDeleteSetNull()

Deprecated.

use getReferentialAction(ReferentialAction.Type)

Returns:

setOnDeleteSetNull

@Deprecated
public void setOnDeleteSetNull(boolean onDeleteSetNull)

Deprecated.

use setReferentialAction(ReferentialAction.Type, ReferentialAction.Action, boolean)

Parameters:

onDeleteSetNull -

getFkColumns

public List<String> getFkColumns()

setFkColumns

public void setFkColumns(List<String> fkColumns)

getFkSourceTable

public String getFkSourceTable()

setFkSourceTable

public void setFkSourceTable(String fkSourceTable)

getColDataTypeList

public List<AlterExpression.ColumnDataType> getColDataTypeList()

addColDataType

public void addColDataType(String columnName,
                           ColDataType colDataType)

addColDataType

public void addColDataType(AlterExpression.ColumnDataType columnDataType)

addColDropNotNull

public void addColDropNotNull(AlterExpression.ColumnDropNotNull columnDropNotNull)

getColumnDropDefaultList

public List<AlterExpression.ColumnDropDefault> getColumnDropDefaultList()

addColDropDefault

public void addColDropDefault(AlterExpression.ColumnDropDefault columnDropDefault)

addColSetDefault

public void addColSetDefault(AlterExpression.ColumnSetDefault columnSetDefault)

getColumnSetDefaultList

public List<AlterExpression.ColumnSetDefault> getColumnSetDefaultList()

addColSetVisibility

public void addColSetVisibility(AlterExpression.ColumnSetVisibility columnSetVisibility)

getColumnSetVisibilityList

public List<AlterExpression.ColumnSetVisibility> getColumnSetVisibilityList()

getFkSourceColumns

public List<String> getFkSourceColumns()

setFkSourceColumns

public void setFkSourceColumns(List<String> fkSourceColumns)

getNewTableName

public String getNewTableName()

setNewTableName

public void setNewTableName(String newTableName)

getColumnName

public String getColumnName()

setColumnName

public void setColumnName(String columnName)

getColOldName

@Deprecated
public String getColOldName()

Deprecated.

setColOldName

@Deprecated
public void setColOldName(String columnOldName)

Deprecated.

getColumnOldName

public String getColumnOldName()

setColumnOldName

public void setColumnOldName(String columnOldName)

getConstraintName

public String getConstraintName()

setConstraintName

public void setConstraintName(String constraintName)

isUsingIfExists

public boolean isUsingIfExists()

setUsingIfExists

public void setUsingIfExists(boolean usingIfExists)

getPkColumns

public List<String> getPkColumns()

setPkColumns

public void setPkColumns(List<String> pkColumns)

getUkColumns

public List<String> getUkColumns()

setUkColumns

public void setUkColumns(List<String> ukColumns)

getUkName

public String getUkName()

setUkName

public void setUkName(String ukName)

getIndex

public Index getIndex()

setIndex

public void setIndex(Index index)

getConstraints

public List<ConstraintState> getConstraints()

setConstraints

public void setConstraints(List<ConstraintState> constraints)

getColumnDropNotNullList

public List<AlterExpression.ColumnDropNotNull> getColumnDropNotNullList()

addParameters

public void addParameters(String... params)

getParameters

public List<String> getParameters()

getConvertType

public AlterExpression.ConvertType getConvertType()

setConvertType

public void setConvertType(AlterExpression.ConvertType convertType)

getCharacterSet

public String getCharacterSet()

setCharacterSet

public void setCharacterSet(String characterSet)

getCollation

public String getCollation()

setCollation

public void setCollation(String collation)

setDefaultCollateSpecified

public void setDefaultCollateSpecified(boolean value)

isDefaultCollateSpecified

public boolean isDefaultCollateSpecified()

getLockOption

public String getLockOption()

setLockOption

public void setLockOption(String lockOption)

getAlgorithmOption

public String getAlgorithmOption()

setAlgorithmOption

public void setAlgorithmOption(String algorithmOption)

getEngineOption

public String getEngineOption()

setEngineOption

public void setEngineOption(String engineOption)

getUseEqual

public boolean getUseEqual()

setUseEqual

public void setUseEqual(boolean useEqual)

getUk

public boolean getUk()

setUk

public void setUk(boolean uk)

isUseIfNotExists

public boolean isUseIfNotExists()

setUseIfNotExists

public void setUseIfNotExists(boolean useIfNotExists)

withUserIfNotExists

public AlterExpression withUserIfNotExists(boolean userIfNotExists)

setPartitionType

public void setPartitionType(String partitionType)

getPartitionType

public String getPartitionType()

setPartitionExpression

public void setPartitionExpression(Expression partitionExpression)

getPartitionExpression

public Expression getPartitionExpression()

setPartitionColumns

public void setPartitionColumns(List<String> partitionColumns)

getPartitionColumns

public List<String> getPartitionColumns()

setExchangePartitionTableName

public void setExchangePartitionTableName(String exchangePartitionTableName)

getExchangePartitionTableName

public String getExchangePartitionTableName()

setCoalescePartitionNumber

public void setCoalescePartitionNumber(int coalescePartitionNumber)

getCoalescePartitionNumber

public int getCoalescePartitionNumber()

setExchangePartitionWithValidation

public void setExchangePartitionWithValidation(boolean exchangePartitionWithValidation)

isExchangePartitionWithValidation

public boolean isExchangePartitionWithValidation()

setExchangePartitionWithoutValidation

public void setExchangePartitionWithoutValidation(boolean exchangePartitionWithoutValidation)

isExchangePartitionWithoutValidation

public boolean isExchangePartitionWithoutValidation()

setKeyBlockSize

public void setKeyBlockSize(int keyBlockSize)

getKeyBlockSize

public int getKeyBlockSize()

getConstraintSymbol

public String getConstraintSymbol()

setConstraintSymbol

public void setConstraintSymbol(String constraintSymbol)

isEnforced

public boolean isEnforced()

setEnforced

public void setEnforced(boolean enforced)

getConstraintType

public String getConstraintType()

setConstraintType

public void setConstraintType(String constraintType)

isInvisible

public boolean isInvisible()

setInvisible

public void setInvisible(boolean invisible)

toString

public String toString()

Overrides:

toString in class Object

withOperation

public AlterExpression withOperation(AlterOperation operation)

withOptionalSpecifier

public AlterExpression withOptionalSpecifier(String optionalSpecifier)

withColumnName

public AlterExpression withColumnName(String columnName)

withPkColumns

public AlterExpression withPkColumns(List<String> pkColumns)

withUkColumns

public AlterExpression withUkColumns(List<String> ukColumns)

withUkName

public AlterExpression withUkName(String ukName)

withIndex

public AlterExpression withIndex(Index index)

withConstraintName

public AlterExpression withConstraintName(String constraintName)

withUsingIfExists

public AlterExpression withUsingIfExists(boolean usingIfExists)

withOnDeleteRestrict

public AlterExpression withOnDeleteRestrict(boolean onDeleteRestrict)

withOnDeleteSetNull

public AlterExpression withOnDeleteSetNull(boolean onDeleteSetNull)

withOnDeleteCascade

public AlterExpression withOnDeleteCascade(boolean onDeleteCascade)

withFkColumns

public AlterExpression withFkColumns(List<String> fkColumns)

withFkSourceSchema

public AlterExpression withFkSourceSchema(String fkSourceSchema)

withFkSourceTable

public AlterExpression withFkSourceTable(String fkSourceTable)

withFkSourceColumns

public AlterExpression withFkSourceColumns(List<String> fkSourceColumns)

withUk

public AlterExpression withUk(boolean uk)

withUseEqual

public AlterExpression withUseEqual(boolean useEqual)

withConstraints

public AlterExpression withConstraints(List<ConstraintState> constraints)

withCommentText

public AlterExpression withCommentText(String commentText)

withColumnOldName

public AlterExpression withColumnOldName(String columnOldName)

addPkColumns

public AlterExpression addPkColumns(String... pkColumns)

addPkColumns

public AlterExpression addPkColumns(Collection<String> pkColumns)

addUkColumns

public AlterExpression addUkColumns(String... ukColumns)

addUkColumns

public AlterExpression addUkColumns(Collection<String> ukColumns)

addFkColumns

public AlterExpression addFkColumns(String... fkColumns)

addFkColumns

public AlterExpression addFkColumns(Collection<String> fkColumns)

addFkSourceColumns

public AlterExpression addFkSourceColumns(String... fkSourceColumns)

addFkSourceColumns

public AlterExpression addFkSourceColumns(Collection<String> fkSourceColumns)

addConstraints

public AlterExpression addConstraints(ConstraintState... constraints)

addConstraints

public AlterExpression addConstraints(Collection<? extends ConstraintState> constraints)

getPartitions

public List<String> getPartitions()

setPartitions

public void setPartitions(List<String> partitions)

getPartitionDefinitions

public List<PartitionDefinition> getPartitionDefinitions()

setPartitionDefinitions

public void setPartitionDefinitions(List<PartitionDefinition> partitionDefinition)

setHasEqualForCharacterSet

public void setHasEqualForCharacterSet(boolean hasEqualForCharacterSet)

setHasEqualForCollate

public void setHasEqualForCollate(boolean hasEqualForCollate)