Package com.github.tadukoo.database.mysql.syntax.statement

Class SQLCreateStatement.SQLCreateStatementBuilder

java.lang.Object

com.github.tadukoo.database.mysql.syntax.statement.SQLCreateStatement.SQLCreateStatementBuilder

All Implemented Interfaces:

SQLCreateStatement.AsOrColumns, SQLCreateStatement.Build, SQLCreateStatement.DatabaseName, SQLCreateStatement.ExistsOrDatabaseName, SQLCreateStatement.ExistsOrTableName, SQLCreateStatement.ForeignKeysOrBuild, SQLCreateStatement.TableName, SQLCreateStatement.Type

Enclosing class:

SQLCreateStatement

public static class SQLCreateStatement.SQLCreateStatementBuilder
extends Object
implements SQLCreateStatement.Type, SQLCreateStatement.ExistsOrTableName, SQLCreateStatement.TableName, SQLCreateStatement.AsOrColumns, SQLCreateStatement.ExistsOrDatabaseName, SQLCreateStatement.DatabaseName, SQLCreateStatement.ForeignKeysOrBuild, SQLCreateStatement.Build

A builder to create a SQLCreateStatement. It takes the following parameters:

SQL Create Statement Parameters

Parameter	Description	Required or Default
type	The type to be created	Required
ifNotExists	Whether to include IF NOT EXISTS in the statement or not	Defaults to false
name	The name of the table/database to be created	Required
selectStmt	The select statement to use to grab another table	Requires either this or columns
columns	The columns to create in the table	Requires either this or selectStmt
foreignKeys	The foreign keys to add to the table	Defaults to an empty list

Version:

Alpha v.0.3

Author:

Logan Ferree (Tadukoo)

Field Summary

Fields

Modifier and Type	Field	Description
private List<ColumnDefinition>	columns	The columns to create in the table
private final List<ForeignKeyConstraint>	foreignKeys	The foreign keys to add to the table
private boolean	ifNotExists	Whether to include IF NOT EXISTS or not
private String	name	The name of the table/database to be created
private SQLSelectStatement	selectStmt	The select statement to use to grab another table
private SQLType	type	The type to be created

Constructor Summary

Constructors

Modifier	Constructor	Description
private	SQLCreateStatementBuilder()	Not allowed to instantiate outside of SQLCreateDatabaseStatement

Method Summary

Modifier and Type	Method	Description
SQLCreateStatement.ForeignKeysOrBuild	as(SQLSelectStatement selectStmt)	Create the table using another table
SQLCreateStatement	build()	Constructs a new SQLCreateStatement using the set parameters
private void	checkForErrors()	Checks for any errors and throws an IllegalArgumentException if any errors are found
SQLCreateStatement.ForeignKeysOrBuild	columns(ColumnDefinition... columns)
SQLCreateStatement.ForeignKeysOrBuild	columns(List<ColumnDefinition> columns)
SQLCreateStatement.ExistsOrDatabaseName	database()	We'll be creating a database
SQLCreateStatement.Build	databaseName(String databaseName)
SQLCreateStatement.ForeignKeysOrBuild	foreignKey(ForeignKeyConstraint foreignKey)
SQLCreateStatement.DatabaseName	ifDatabaseNotExists()	Set to add ifNotExists to the create statement
private SQLCreateStatement.SQLCreateStatementBuilder	ifNotExists()	Sets ifNotExists to true
SQLCreateStatement.TableName	ifTableNotExists()	Set to add ifNotExists to the create statement
SQLCreateStatement.ExistsOrTableName	table()	We'll be creating a table
SQLCreateStatement.AsOrColumns	tableName(String tableName)

Methods inherited from class java.lang.Object

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

Field Details

type

private SQLType type

The type to be created

ifNotExists

private boolean ifNotExists

Whether to include IF NOT EXISTS or not

name

private String name

The name of the table/database to be created

selectStmt

private SQLSelectStatement selectStmt

The select statement to use to grab another table

columns

private List<ColumnDefinition> columns

The columns to create in the table

foreignKeys

private final List<ForeignKeyConstraint> foreignKeys

The foreign keys to add to the table

Constructor Details

SQLCreateStatementBuilder

private SQLCreateStatementBuilder()

Not allowed to instantiate outside of SQLCreateDatabaseStatement

Method Details

table

public SQLCreateStatement.ExistsOrTableName table()

We'll be creating a table

Specified by:

table in interface SQLCreateStatement.Type

Returns:

this, to continue building

database

public SQLCreateStatement.ExistsOrDatabaseName database()

We'll be creating a database

Specified by:

database in interface SQLCreateStatement.Type

Returns:

this, to continue building

ifNotExists

private SQLCreateStatement.SQLCreateStatementBuilder ifNotExists()

Sets ifNotExists to true

Returns:

this, to continue building

ifTableNotExists

public SQLCreateStatement.TableName ifTableNotExists()

Set to add ifNotExists to the create statement

Specified by:

ifTableNotExists in interface SQLCreateStatement.ExistsOrTableName

Returns:

this, to continue building

ifDatabaseNotExists

public SQLCreateStatement.DatabaseName ifDatabaseNotExists()

Set to add ifNotExists to the create statement

Specified by:

ifDatabaseNotExists in interface SQLCreateStatement.ExistsOrDatabaseName

Returns:

this, to continue building

tableName

public SQLCreateStatement.AsOrColumns tableName(String tableName)

Specified by:

tableName in interface SQLCreateStatement.TableName

Parameters:

tableName - The name of the table to be created

Returns:

this, to continue building

as

public SQLCreateStatement.ForeignKeysOrBuild as(SQLSelectStatement selectStmt)

Create the table using another table

Specified by:

as in interface SQLCreateStatement.AsOrColumns

Parameters:

selectStmt - The select statement to use to grab another table

Returns:

this, to continue building

columns

public SQLCreateStatement.ForeignKeysOrBuild columns(List<ColumnDefinition> columns)

Specified by:

columns in interface SQLCreateStatement.AsOrColumns

Parameters:

columns - The columns to create in the table

Returns:

this, to continue building

columns

public SQLCreateStatement.ForeignKeysOrBuild columns(ColumnDefinition... columns)

Specified by:

columns in interface SQLCreateStatement.AsOrColumns

Parameters:

columns - The columns to create in the table

Returns:

this, to continue building

foreignKey

public SQLCreateStatement.ForeignKeysOrBuild foreignKey(ForeignKeyConstraint foreignKey)

Specified by:

foreignKey in interface SQLCreateStatement.ForeignKeysOrBuild

Parameters:

foreignKey - A foreign key to add to the table

Returns:

this, to continue building

databaseName

public SQLCreateStatement.Build databaseName(String databaseName)

Specified by:

databaseName in interface SQLCreateStatement.DatabaseName

Parameters:

databaseName - The name of the database to be created

Returns:

this, to continue building

checkForErrors

private void checkForErrors()

Checks for any errors and throws an IllegalArgumentException if any errors are found

build

public SQLCreateStatement build()

Constructs a new SQLCreateStatement using the set parameters

Specified by:

build in interface SQLCreateStatement.Build

Returns:

The newly built SQLCreateStatement