Package com.invirgance.convirgance.jdbc.sql

Class FromStatement

java.lang.Object

com.invirgance.convirgance.jdbc.sql.FromStatement

All Implemented Interfaces:

NamedSchema, SQLStatement

public class FromStatement
extends Object
implements SQLStatement, NamedSchema

Creates the FROM clause for a SQL query with the provided TabularStructure. Additionally supports table aliasing with the "AS" syntax when a name is provided.

 DatabaseSchemaLayout layout = new DatabaseSchemaLayout(driver, getHSQLDataSource());
 Table table = layout.getCurrentSchema().getTable("customer");
 
 FromStatement from = new FromStatement(layout, table);
 

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
FromStatement(DatabaseSchemaLayout layout, TabularStructure table)	Creates the from statement using the provided layout and TabularStructure.
FromStatement(DatabaseSchemaLayout layout, TabularStructure table, String name)	Creates the from statement using the provided layout and TabularStructure.

Method Summary

Modifier and Type	Method	Description
String	getName()	Get the schema name of this database object
SQLStatement	getParent()	If this statement is part of a larger statement, this returns the parent statement.
String	getQuotedName()	Get the schema name of this database object quoted for use in a SQL statement
SQLRenderer	render(SQLRenderer renderer)
void	setName(String name)
void	setParent(SQLStatement parent)
String	toString()

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.invirgance.convirgance.jdbc.sql.SQLStatement

query, query

Constructor Details

FromStatement

public FromStatement(DatabaseSchemaLayout layout,
 TabularStructure table)

Creates the from statement using the provided layout and TabularStructure.

Parameters:

layout - Database layout.

table - The table.

FromStatement

public FromStatement(DatabaseSchemaLayout layout,
 TabularStructure table,
 String name)

Creates the from statement using the provided layout and TabularStructure.

Parameters:

layout - Database layout.

table - The table.

name - The alias to use.

Method Details

getParent

public SQLStatement getParent()

Description copied from interface: SQLStatement

If this statement is part of a larger statement, this returns the parent statement.

Specified by:

getParent in interface SQLStatement

Returns:

the parent statement

setParent

public void setParent(SQLStatement parent)

Specified by:

setParent in interface SQLStatement

getName

public String getName()

Description copied from interface: NamedSchema

Get the schema name of this database object

Specified by:

getName in interface NamedSchema

Returns:

name of the object with exact database capitalization

setName

public void setName(String name)

getQuotedName

public String getQuotedName()

Description copied from interface: NamedSchema

Get the schema name of this database object quoted for use in a SQL statement

Specified by:

getQuotedName in interface NamedSchema

Returns:

name of the object quoted for use in a SQL statement

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

toString

public String toString()

Overrides:

toString in class Object