com.northconcepts.datapipeline.sql.h2

Class CreateTable

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.h2.H2SqlPart

com.northconcepts.datapipeline.sql.h2.CreateTable

public class CreateTable
extends H2SqlPart

Generates a CREATE TABLE statement for H2.

Sample Generated SQL:

CREATE TABLE IF NOT EXISTS table_name (
user_id int,
email text,
PRIMARY KEY (user_id)
);

Constructor Summary

Constructors

Constructor and Description
CreateTable()
CreateTable(String tableName) Constructs a CreateTable with the specified table name.

Method Summary

Modifier and Type	Method and Description
CreateTable	addColumn(CreateTableColumn column) Adds a column to this table.
void	collectSqlFragment(CodeWriter writer)
List<CreateTableColumn>	getColumns() Returns the list of columns.
List<CreateTableColumn>	getPrimaryKeyColumns() Returns the list of primary key columns.
String	getTableName() Returns the table name.
boolean	isCheckIfNotExists() Indicates if IF NOT EXISTS clause should be included in the CREATE TABLE statement (default true).
CreateTable	setCheckIfNotExists(boolean checkIfNotExists) Indicates if IF NOT EXISTS clause should be included in the CREATE TABLE statement (default true).
CreateTable	setColumns(List<CreateTableColumn> columns) Sets the columns.
CreateTable	setPretty(boolean pretty) Indicates if line breaks and indentations should be added to output DDL (default false). Example output (pretty = true): CREATE TABLE IF NOT EXISTS table_name ( user_id int, email text PRIMARY KEY (user_id) ) Example output (pretty = false): CREATE TABLE IF NOT EXISTS table_name (user_id int, email text, PRIMARY KEY (user_id))
CreateTable	setTableName(String tableName) Sets the table name.

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

CreateTable

public CreateTable()

CreateTable

public CreateTable(String tableName)

Constructs a CreateTable with the specified table name.

Parameters:

tableName - the table name

Method Detail

setPretty

public CreateTable setPretty(boolean pretty)

Indicates if line breaks and indentations should be added to output DDL (default false).

Example output (pretty = true):
CREATE TABLE IF NOT EXISTS table_name (
user_id int,
email text
PRIMARY KEY (user_id)
)

Example output (pretty = false):
CREATE TABLE IF NOT EXISTS table_name (user_id int, email text, PRIMARY KEY (user_id))

Overrides:

setPretty in class SqlPart

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

getTableName

public String getTableName()

Returns the table name.

Returns:

the table name

setTableName

public CreateTable setTableName(String tableName)

Sets the table name.

Parameters:

tableName - the table name

Returns:

this instance

isCheckIfNotExists

public boolean isCheckIfNotExists()

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

setCheckIfNotExists

public CreateTable setCheckIfNotExists(boolean checkIfNotExists)

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

getColumns

public List<CreateTableColumn> getColumns()

Returns the list of columns.

Returns:

the list of columns

setColumns

public CreateTable setColumns(List<CreateTableColumn> columns)

Sets the columns.

Parameters:

columns - the list of columns

Returns:

this instance

addColumn

public CreateTable addColumn(CreateTableColumn column)

Adds a column to this table.

Parameters:

column - the column to add

Returns:

this instance

getPrimaryKeyColumns

public List<CreateTableColumn> getPrimaryKeyColumns()

Returns the list of primary key columns.

Returns:

the list of primary key columns