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

Class SQLInsertStatement.SQLInsertStatementBuilder

java.lang.Object

com.github.tadukoo.database.mysql.syntax.statement.SQLInsertStatement.SQLInsertStatementBuilder

All Implemented Interfaces:

SQLInsertStatement.Build, SQLInsertStatement.ColumnsAndValuesOrSelectStatement, SQLInsertStatement.Table

Enclosing class:

SQLInsertStatement

public static class SQLInsertStatement.SQLInsertStatementBuilder
extends Object
implements SQLInsertStatement.Table, SQLInsertStatement.ColumnsAndValuesOrSelectStatement, SQLInsertStatement.Build

A builder class used to build a SQLInsertStatement. It takes the following parameters:

SQL Insert Statement Parameters

Parameter	Description	Default or Required
table	The table to insert into	Required
columns	The columns to insert into	Defaults to empty list
values	The values to insert	Defaults to empty list - need either this or select statement
selectStmt	The select statement to use for values to insert	Defaults to null - need either this or values

Version:

Alpha v.0.3

Author:

Logan Ferree (Tadukoo)

Field Summary

Fields

Modifier and Type	Field	Description
private List<ColumnRef>	columns	The columns to insert into
private SQLSelectStatement	selectStmt	The select statement to use for values to insert
private TableRef	table	The table to insert into
private List<Object>	values	The values to insert

Constructor Summary

Constructors

Modifier	Constructor	Description
private	SQLInsertStatementBuilder()	Not allowed to instantiate outside SQLInsertStatement

Method Summary

Modifier and Type	Method	Description
SQLInsertStatement	build()	Creates a new SQLInsertStatement after checking for errors
private void	checkForErrors()	Checks for any errors and throws an IllegalArgumentException if any are found
SQLInsertStatement.ColumnsAndValuesOrSelectStatement	columns(ColumnRef... columns)
SQLInsertStatement.ColumnsAndValuesOrSelectStatement	columns(List<ColumnRef> columns)
SQLInsertStatement.Build	selectStmt(SQLSelectStatement selectStmt)
SQLInsertStatement.ColumnsAndValuesOrSelectStatement	table(TableRef table)
SQLInsertStatement.Build	values(Object... values)
SQLInsertStatement.Build	values(List<Object> values)

Methods inherited from class java.lang.Object

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

Field Details

table

private TableRef table

The table to insert into

columns

private List<ColumnRef> columns

The columns to insert into

values

private List<Object> values

The values to insert

selectStmt

private SQLSelectStatement selectStmt

The select statement to use for values to insert

Constructor Details

SQLInsertStatementBuilder

private SQLInsertStatementBuilder()

Not allowed to instantiate outside SQLInsertStatement

Method Details

table

public SQLInsertStatement.ColumnsAndValuesOrSelectStatement table(TableRef table)

Specified by:

table in interface SQLInsertStatement.Table

Parameters:

table - The table to insert into

Returns:

this, to continue building

columns

public SQLInsertStatement.ColumnsAndValuesOrSelectStatement columns(List<ColumnRef> columns)

Specified by:

columns in interface SQLInsertStatement.ColumnsAndValuesOrSelectStatement

Parameters:

columns - The columns to insert into

Returns:

this, to continue building

columns

public SQLInsertStatement.ColumnsAndValuesOrSelectStatement columns(ColumnRef... columns)

Specified by:

columns in interface SQLInsertStatement.ColumnsAndValuesOrSelectStatement

Parameters:

columns - A column to insert into

Returns:

this, to continue building

values

public SQLInsertStatement.Build values(List<Object> values)

Specified by:

values in interface SQLInsertStatement.ColumnsAndValuesOrSelectStatement

Parameters:

values - The values to insert

Returns:

this, to continue building

values

public SQLInsertStatement.Build values(Object... values)

Specified by:

values in interface SQLInsertStatement.ColumnsAndValuesOrSelectStatement

Parameters:

values - The values to insert

Returns:

this, to continue building

selectStmt

public SQLInsertStatement.Build selectStmt(SQLSelectStatement selectStmt)

Specified by:

selectStmt in interface SQLInsertStatement.ColumnsAndValuesOrSelectStatement

Parameters:

selectStmt - The select statement to use for values to insert

Returns:

this, to continue building

checkForErrors

private void checkForErrors()

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

build

public SQLInsertStatement build()

Creates a new SQLInsertStatement after checking for errors

Specified by:

build in interface SQLInsertStatement.Build

Returns:

The newly built SQLInsertStatement