CreateIndex (Data Pipeline JavaDoc)

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.mysql.MySqlPart

com.northconcepts.datapipeline.sql.mysql.CreateIndex

public class CreateIndex extends MySqlPart

Generates a CREATE INDEX statement for MySQL.

Sample Generated SQL:


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

Constructor Summary

Constructors

Constructor

Description

CreateIndex()

CreateIndex(String indexName, String tableName, String... columnNames)
Method Summary

Modifier and Type

Method

Description

void

collectSqlFragment(CodeWriter writer)

Writes this part's SQL to the writer; used by SqlPart.getSqlFragment() and by enclosing parts.

List<String>

getColumnNames()

String

getIndexName()

String

getTableName()

boolean

isUnique()

CreateIndex

setColumnNames(String... columnNames)

CreateIndex

setColumnNames(List<String> columnNames)

CreateIndex

setIndexName(String indexName)

CreateIndex

setPretty(boolean pretty)

Indicates if SqlPart.getSqlFragment() adds line breaks and indentation instead of using one line (default is false).

CreateIndex

setTableName(String tableName)

CreateIndex

setUnique(boolean unique)

Methods inherited from class com.northconcepts.datapipeline.sql.mysql.MySqlPart
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 Details
- CreateIndex
  
  public CreateIndex()
- CreateIndex
  
  public CreateIndex(String indexName, String tableName, String... columnNames)
Method Details
- setPretty
  
  public CreateIndex setPretty(boolean pretty)
  
  Description copied from class: SqlPart
  
  Indicates if SqlPart.getSqlFragment() adds line breaks and indentation instead of using one line (default is false).
  
  Overrides:
  
  setPretty in class SqlPart
- collectSqlFragment
  
  public void collectSqlFragment(CodeWriter writer)
  
  Description copied from class: SqlPart
  
  Writes this part's SQL to the writer; used by SqlPart.getSqlFragment() and by enclosing parts.
  
  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)