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

Class SQLSelectStatement.SQLSelectStatementBuilder

java.lang.Object

com.github.tadukoo.database.mysql.syntax.statement.SQLSelectStatement.SQLSelectStatementBuilder

All Implemented Interfaces:

SQLSelectStatement.Build, SQLSelectStatement.ColumnsOrTables, SQLSelectStatement.DistinctOrColumnsOrTables, SQLSelectStatement.FromTables, SQLSelectStatement.WhereStatementAndBuild

Enclosing class:

SQLSelectStatement

public static class SQLSelectStatement.SQLSelectStatementBuilder
extends Object
implements SQLSelectStatement.DistinctOrColumnsOrTables, SQLSelectStatement.ColumnsOrTables, SQLSelectStatement.FromTables, SQLSelectStatement.WhereStatementAndBuild, SQLSelectStatement.Build

A builder to build a SQLSelectStatement. It takes the following parameters:

SQL Select Statement Parameters

Parameter	Description	Required or Default
distinct	Whether to select distinct columns or not	Defaults to false
returnColumns	The columns to be selected	Defaults to an empty list (will select all then)
fromTables	The tables to grab data from	Required
whereStatement	The conditional where statement	Defaults to null

Version:

Alpha v.0.3

Author:

Logan Ferree (Tadukoo)

Field Summary

Fields

Modifier and Type	Field	Description
private boolean	distinct	Whether to select distinct columns or not
private List<TableRef>	fromTables	The tables to grab data from
private List<ColumnRef>	returnColumns	The columns to be selected
private Conditional	whereStatement	The conditional where statement

Constructor Summary

Constructors

Modifier	Constructor	Description
private	SQLSelectStatementBuilder()	Not allowed to instantiate outside SQLSelectStatement

Method Summary

Modifier and Type	Method	Description
SQLSelectStatement	build()	Builds a new SQLSelectStatement using the set parameters
private void	checkForErrors()	Checks for any errors with the set parameters
SQLSelectStatement.ColumnsOrTables	distinct()	Sets distinct to true for this select statement
SQLSelectStatement.WhereStatementAndBuild	fromTables(TableRef... fromTables)
SQLSelectStatement.WhereStatementAndBuild	fromTables(List<TableRef> fromTables)
SQLSelectStatement.FromTables	returnColumns(ColumnRef... returnColumns)
SQLSelectStatement.FromTables	returnColumns(List<ColumnRef> returnColumns)
SQLSelectStatement.Build	whereStatement(Conditional whereStatement)

Methods inherited from class java.lang.Object

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

Field Details

distinct

private boolean distinct

Whether to select distinct columns or not

returnColumns

private List<ColumnRef> returnColumns

The columns to be selected

fromTables

private List<TableRef> fromTables

The tables to grab data from

whereStatement

private Conditional whereStatement

The conditional where statement

Constructor Details

SQLSelectStatementBuilder

private SQLSelectStatementBuilder()

Not allowed to instantiate outside SQLSelectStatement

Method Details

distinct

public SQLSelectStatement.ColumnsOrTables distinct()

Sets distinct to true for this select statement

Specified by:

distinct in interface SQLSelectStatement.DistinctOrColumnsOrTables

Returns:

this, to continue building

returnColumns

public SQLSelectStatement.FromTables returnColumns(List<ColumnRef> returnColumns)

Specified by:

returnColumns in interface SQLSelectStatement.ColumnsOrTables

Parameters:

returnColumns - The columns to be selected

Returns:

this, to continue building

returnColumns

public SQLSelectStatement.FromTables returnColumns(ColumnRef... returnColumns)

Specified by:

returnColumns in interface SQLSelectStatement.ColumnsOrTables

Parameters:

returnColumns - The columns to be selected

Returns:

this, to continue building

fromTables

public SQLSelectStatement.WhereStatementAndBuild fromTables(List<TableRef> fromTables)

Specified by:

fromTables in interface SQLSelectStatement.FromTables

Parameters:

fromTables - The tables to grab data from

Returns:

this, to continue building

fromTables

public SQLSelectStatement.WhereStatementAndBuild fromTables(TableRef... fromTables)

Specified by:

fromTables in interface SQLSelectStatement.FromTables

Parameters:

fromTables - The tables to grab data from

Returns:

this, to continue building

whereStatement

public SQLSelectStatement.Build whereStatement(Conditional whereStatement)

Specified by:

whereStatement in interface SQLSelectStatement.WhereStatementAndBuild

Parameters:

whereStatement - The conditional where statement

Returns:

this, to continue building

checkForErrors

private void checkForErrors()

Checks for any errors with the set parameters

build

public SQLSelectStatement build()

Builds a new SQLSelectStatement using the set parameters

Specified by:

build in interface SQLSelectStatement.Build

Returns:

The newly built SQLSelectStatement