com.northconcepts.datapipeline.sql.postgresql

Class CreateTable

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

com.northconcepts.datapipeline.sql.postgresql.CreateTable

public class CreateTable
extends PostgresSqlPart

Generates a CREATE TABLE statement for PostgreSQL.

Sample Generated SQL:

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

Constructor Summary

Constructors

Constructor and Description
CreateTable()
CreateTable(String tableName)

Method Summary

Modifier and Type	Method and Description
CreateTable	addColumn(CreateTableColumn column)
void	collectSqlFragment(CodeWriter writer)
List<CreateTableColumn>	getColumns()
List<CreateTableColumn>	getPrimaryKeyColumns()
String	getTableName()
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)
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" serial, "email" text PRIMARY KEY ("user_id") ) Example output (pretty = false): CREATE TABLE IF NOT EXISTS "table_name" ("user_id" serial, "email" text, PRIMARY KEY ("user_id"))
CreateTable	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

CreateTable

public CreateTable()

CreateTable

public CreateTable(String tableName)

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" serial,
"email" text
PRIMARY KEY ("user_id")
)

Example output (pretty = false):
CREATE TABLE IF NOT EXISTS "table_name" ("user_id" serial, "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()

setTableName

public CreateTable setTableName(String tableName)

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

setColumns

public CreateTable setColumns(List<CreateTableColumn> columns)

addColumn

public CreateTable addColumn(CreateTableColumn column)

getPrimaryKeyColumns

public List<CreateTableColumn> getPrimaryKeyColumns()