Package com.valqueries.automapper.context.schema

Class CreateTableBuilder

java.lang.Object

com.valqueries.automapper.context.schema.CreateTableBuilder

All Implemented Interfaces:

IBaseBuilder, ICreateTableBuilder

Direct Known Subclasses:

DryRunCreateTableBuilder

public class CreateTableBuilder
extends Object
implements ICreateTableBuilder

Constructor Summary

Constructors

Constructor	Description
CreateTableBuilder(org.jooq.CloseableDSLContext jooq, org.jooq.CreateTableElementListStep jooqStep, String formattedTableName, boolean doNothing)

Method Summary

Modifier and Type	Method	Description
ICreateTableBuilder	column(Token columnName, SqlType<?> dataType)	Add a column with a specific sql type.
void	execute()	Execute the create/alter table statement(s)
ICreateTableBuilder	foreignKey(String constraintName, Token[] columns, Token referencedTable, Token[] referencedColumns)	Add a foreign key
String	getSql()	Useful for debugging
ICreateTableBuilder	index(String indexName, Token firstColumn, Token... columns)	Add an index
ICreateTableBuilder	primaryKey(Token firstColumn, Token... columns)	Add a primary key
ICreateTableBuilder	unique(String constraintName, Token firstColumn, Token... columns)	Add a unique constraint

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.valqueries.automapper.context.schema.ICreateTableBuilder

column, column, column, foreignKey, foreignKey, foreignKey, index, primaryKey, unique

Constructor Details

CreateTableBuilder

public CreateTableBuilder(org.jooq.CloseableDSLContext jooq,
 org.jooq.CreateTableElementListStep jooqStep,
 String formattedTableName,
 boolean doNothing)

Method Details

column

public ICreateTableBuilder column(Token columnName,
 SqlType<?> dataType)

Description copied from interface: ICreateTableBuilder

Add a column with a specific sql type. Adding auto-increment column automatically makes it a primary key.

Specified by:

column in interface ICreateTableBuilder

Parameters:

columnName - the name of the column

dataType - the type of the column

Returns:

this builder, for chaining. Remember to call IBaseBuilder.execute()

primaryKey

public ICreateTableBuilder primaryKey(Token firstColumn,
 Token... columns)

Description copied from interface: ICreateTableBuilder

Add a primary key

Specified by:

primaryKey in interface ICreateTableBuilder

Parameters:

firstColumn - the first column of the primary key

columns - the rest of the columns of the primary key

Returns:

this builder, for chaining. Remember to call IBaseBuilder.execute()

foreignKey

public ICreateTableBuilder foreignKey(String constraintName,
 Token[] columns,
 Token referencedTable,
 Token[] referencedColumns)

Description copied from interface: ICreateTableBuilder

Add a foreign key

Specified by:

foreignKey in interface ICreateTableBuilder

Parameters:

constraintName - the name of the foreign key

columns - the columns of the foreign key

referencedTable - the table referenced by the foreign key

referencedColumns - the referenced columns of the foreign key

Returns:

this builder, for chaining. Remember to call IBaseBuilder.execute()

unique

public ICreateTableBuilder unique(String constraintName,
 Token firstColumn,
 Token... columns)

Description copied from interface: ICreateTableBuilder

Add a unique constraint

Specified by:

unique in interface ICreateTableBuilder

Parameters:

constraintName - the name of the constraint

firstColumn - the first column of the constraint

columns - the rest of the columns of the constraint

Returns:

this builder, for chaining. Remember to call IBaseBuilder.execute()

index

public ICreateTableBuilder index(String indexName,
 Token firstColumn,
 Token... columns)

Description copied from interface: ICreateTableBuilder

Add an index

Specified by:

index in interface ICreateTableBuilder

Parameters:

indexName - the name of the index

firstColumn - the first column of the index

columns - the rest of the columns of the index

Returns:

this builder, for chaining. Remember to call execute()

execute

public void execute()

Description copied from interface: IBaseBuilder

Execute the create/alter table statement(s)

Specified by:

execute in interface IBaseBuilder

getSql

public String getSql()

Description copied from interface: IBaseBuilder

Useful for debugging

Specified by:

getSql in interface IBaseBuilder

Returns:

the sql that would be executed by IBaseBuilder.execute()