com.northconcepts.datapipeline.sql.postgresql

Class CreateIndex

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

com.northconcepts.datapipeline.sql.postgresql.CreateIndex

public class CreateIndex
extends PostgresSqlPart

Generates a CREATE INDEX statement for PostgreSQL.

Sample Generated SQL:

CREATE UNIQUE INDEX "idx_firstname_lastname" ON "person" ("firstname", "lastname");

Constructor Summary

Constructors

Constructor and Description
CreateIndex()
CreateIndex(String indexName, String tableName, String... columnNames)

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
List<String>	getColumnNames()
String	getIndexName()
String	getTableName()
boolean	isCheckIfNotExists() Indicates if IF NOT EXISTS clause should be included in the CREATE INDEX statement (default true).
boolean	isUnique()
CreateIndex	setCheckIfNotExists(boolean checkIfNotExists) Indicates if IF NOT EXISTS clause should be included in the CREATE INDEX statement (default true).
CreateIndex	setColumnNames(List<String> columnNames)
CreateIndex	setColumnNames(String... columnNames)
CreateIndex	setIndexName(String indexName)
CreateIndex	setPretty(boolean pretty)
CreateIndex	setTableName(String tableName)
CreateIndex	setUnique(boolean unique)

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

CreateIndex

public CreateIndex()

CreateIndex

public CreateIndex(String indexName,
                   String tableName,
                   String... columnNames)

Method Detail

setPretty

public CreateIndex setPretty(boolean pretty)

Overrides:

setPretty in class SqlPart

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

getIndexName

public String getIndexName()

setIndexName

public CreateIndex setIndexName(String indexName)

getTableName

public String getTableName()

setTableName

public CreateIndex setTableName(String tableName)

getColumnNames

public List<String> getColumnNames()

setColumnNames

public CreateIndex setColumnNames(List<String> columnNames)

setColumnNames

public CreateIndex setColumnNames(String... columnNames)

isUnique

public boolean isUnique()

setUnique

public CreateIndex setUnique(boolean unique)

isCheckIfNotExists

public boolean isCheckIfNotExists()

Indicates if IF NOT EXISTS clause should be included in the CREATE INDEX statement (default true).

setCheckIfNotExists

public CreateIndex setCheckIfNotExists(boolean checkIfNotExists)

Indicates if IF NOT EXISTS clause should be included in the CREATE INDEX statement (default true).