com.northconcepts.datapipeline.sql.postgresql

Class DropTableConstraint

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

com.northconcepts.datapipeline.sql.postgresql.DropTableConstraint

public class DropTableConstraint
extends PostgresSqlPart

Generates a ALTER TABLE...DROP CONSTRAINT statement for PostgreSQL.

Sample Generated SQL:

ALTER TABLE IF EXISTS "person" DROP CONSTRAINT IF EXISTS "email_check"

Constructor Summary

Constructors

Constructor and Description
DropTableConstraint()
DropTableConstraint(String tableName, String constraintName)

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
String	getConstraintName()
String	getTableName()
boolean	isCascade()
boolean	isCheckIfConstraintExists() Indicates if IF EXISTS clause should be added to the ALTER TABLE...DROP CONSTRAINT statement before the constraint name (default true).
boolean	isCheckIfTableExists() Indicates if the IF EXISTS clause should be added to the ALTER TABLE statement before the table name (default true).
boolean	isRestrict()
DropTableConstraint	setCascade(boolean cascade)
DropTableConstraint	setCheckIfConstraintExists(boolean checkIfConstraintExists) Indicates if IF EXISTS clause should be added to the ALTER TABLE...DROP CONSTRAINT statement before the constraint name (default true).
DropTableConstraint	setCheckIfTableExists(boolean checkIfTableExists) Indicates if the IF EXISTS clause should be added to the ALTER TABLE statement before the table name (default true).
DropTableConstraint	setConstraintName(String constraintName)
DropTableConstraint	setPretty(boolean pretty)
DropTableConstraint	setTableName(String tableName)

Methods inherited from class com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

escapeKeyword

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

collectParameterValues, getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

DropTableConstraint

public DropTableConstraint()

DropTableConstraint

public DropTableConstraint(String tableName,
                           String constraintName)

Method Detail

setPretty

public DropTableConstraint setPretty(boolean pretty)

Overrides:

setPretty in class SqlPart

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

getTableName

public String getTableName()

setTableName

public DropTableConstraint setTableName(String tableName)

getConstraintName

public String getConstraintName()

setConstraintName

public DropTableConstraint setConstraintName(String constraintName)

isCheckIfTableExists

public boolean isCheckIfTableExists()

Indicates if the IF EXISTS clause should be added to the ALTER TABLE statement before the table name (default true).

setCheckIfTableExists

public DropTableConstraint setCheckIfTableExists(boolean checkIfTableExists)

Indicates if the IF EXISTS clause should be added to the ALTER TABLE statement before the table name (default true).

isCheckIfConstraintExists

public boolean isCheckIfConstraintExists()

Indicates if IF EXISTS clause should be added to the ALTER TABLE...DROP CONSTRAINT statement before the constraint name (default true).

setCheckIfConstraintExists

public DropTableConstraint setCheckIfConstraintExists(boolean checkIfConstraintExists)

Indicates if IF EXISTS clause should be added to the ALTER TABLE...DROP CONSTRAINT statement before the constraint name (default true).

isCascade

public boolean isCascade()

setCascade

public DropTableConstraint setCascade(boolean cascade)

isRestrict

public boolean isRestrict()