com.northconcepts.datapipeline.sql.h2

Class CreateIndex

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.h2.H2SqlPart

com.northconcepts.datapipeline.sql.h2.CreateIndex

public class CreateIndex
extends H2SqlPart

Generates a CREATE INDEX statement for H2.

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) Constructs a CreateIndex with the specified index name, table name, and column names.

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
List<String>	getColumnNames() Returns the column names.
String	getIndexName() Returns the index name.
String	getTableName() Returns the table name.
boolean	isUnique() Returns whether this is a unique index.
CreateIndex	setColumnNames(List<String> columnNames) Sets the column names.
CreateIndex	setColumnNames(String... columnNames) Sets the column names.
CreateIndex	setIndexName(String indexName) Sets the index name.
CreateIndex	setPretty(boolean pretty)
CreateIndex	setTableName(String tableName) Sets the table name.
CreateIndex	setUnique(boolean unique) Sets whether this is a unique index.

Methods inherited from class com.northconcepts.datapipeline.sql.h2.H2SqlPart

escapeKeyword, placeBackTicks

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)

Constructs a CreateIndex with the specified index name, table name, and column names.

Parameters:

indexName - the index name

tableName - the table name

columnNames - the column names to index

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()

Returns the index name.

Returns:

the index name

setIndexName

public CreateIndex setIndexName(String indexName)

Sets the index name.

Parameters:

indexName - the index name

Returns:

this instance

getTableName

public String getTableName()

Returns the table name.

Returns:

the table name

setTableName

public CreateIndex setTableName(String tableName)

Sets the table name.

Parameters:

tableName - the table name

Returns:

this instance

getColumnNames

public List<String> getColumnNames()

Returns the column names.

Returns:

the column names

setColumnNames

public CreateIndex setColumnNames(List<String> columnNames)

Sets the column names.

Parameters:

columnNames - the column names

Returns:

this instance

setColumnNames

public CreateIndex setColumnNames(String... columnNames)

Sets the column names.

Parameters:

columnNames - the column names

Returns:

this instance

isUnique

public boolean isUnique()

Returns whether this is a unique index.

Returns:

true if this is a unique index

setUnique

public CreateIndex setUnique(boolean unique)

Sets whether this is a unique index.

Parameters:

unique - true for a unique index

Returns:

this instance