Package com.github.eikecochu.sqlbuilder

Class From

java.lang.Object

com.github.eikecochu.sqlbuilder.QueryPartImpl<From>

com.github.eikecochu.sqlbuilder.From

All Implemented Interfaces:

BeforeGroupBy<From>, BeforeJoin<From>, BeforeOrderBy<From>, BeforeUnion<From>, BeforeWhere<From>, QueryBuilder<From>, QueryPart, QueryPartLinked<From>, QueryPartSQL<From>

public class From
extends QueryPartImpl<From>
implements QueryBuilder<From>, BeforeJoin<From>, BeforeWhere<From>, BeforeGroupBy<From>, BeforeOrderBy<From>, BeforeUnion<From>

The FROM expression. This expression defines from where the data is selected. Can be a table name or subquery.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	From(BeforeFrom<?> parent)

Method Summary

Modifier and Type	Method	Description
java.lang.String	string(QueryOptions options)	Transforms this statement into an SQL string
From	subquery(QueryBuilder<?> subquery)	Specify a subquery to select from
From	subquery(QueryBuilder<?> subquery, java.lang.String alias)	Specify a subquery to select from
From	table(Table table)	Specify the target table by Table representation
From	table(java.lang.String table)	Specify the target table by name
From	tables(Table... tables)	Specify the target table by Table representations
From	tables(java.lang.String... tables)	Specify the target tables by name

Methods inherited from class com.github.eikecochu.sqlbuilder.QueryPartImpl

parent, sql

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeGroupBy

groupBy, groupBy, groupBy, groupBySQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeJoin

crossJoin, crossJoin, crossJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, innerJoin, innerJoin, innerJoin, innerJoinOnColsEq, innerJoinOnColsEq, join, join, join, join, join, joinSQL, leftJoin, leftJoin, leftJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, outerJoin, outerJoin, outerJoin, rightJoin, rightJoin, rightJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeOrderBy

orderBy, orderBy, orderBy, orderBySQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeUnion

union, union, unionAll, unionSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeWhere

where, where, where, where, whereSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryBuilder

query, query

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart

string

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartLinked

ext, parent, parent

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartSQL

sql

Constructor Detail

From

protected From(BeforeFrom<?> parent)

Method Detail

table

public From table(java.lang.String table)

Specify the target table by name

Parameters:

table - The table name to select from

Returns:

This FROM statement

table

public From table(Table table)

Specify the target table by Table representation

Parameters:

table - The Table representation to select from

Returns:

This FROM statement

tables

public From tables(java.lang.String... tables)

Specify the target tables by name

Parameters:

tables - The table names to select from

Returns:

This FROM statement

tables

public From tables(Table... tables)

Specify the target table by Table representations

Parameters:

tables - The Table representations to select from

Returns:

This FROM statement

subquery

public From subquery(QueryBuilder<?> subquery,
                     java.lang.String alias)

Specify a subquery to select from

Parameters:

subquery - The subquery to select from

alias - The subquery alias

Returns:

This FROM statement

subquery

public From subquery(QueryBuilder<?> subquery)

Specify a subquery to select from

Parameters:

subquery - The subquery to select from

Returns:

This FROM statement

string

public java.lang.String string(QueryOptions options)

Description copied from interface: QueryPart

Transforms this statement into an SQL string

Specified by:

string in interface QueryPart

Parameters:

options - The QueryOptions to apply for transformation

Returns:

The created SQL string