Package rife.database.queries

Class CreateView

java.lang.Object

rife.database.queries.CreateView

All Implemented Interfaces:

Cloneable, Query

public class CreateView
extends Object
implements Cloneable

Object representation of a SQL "CREATE VIEW" query.

This object may be used to dynamically construct a SQL statement in a database-independent fashion. After it is finished, it may be executed using DbQueryManager.executeUpdate().

You provide the view definition either as a Select query, which makes the construction of the view just as database-independent as the query builders themselves, or as a literal SQL string. A select query that has parameters can't define a view, since views don't have placeholders.

Since:

1.10

Field Summary

Fields

Modifier and Type	Field	Description
protected Datasource	datasource_
protected boolean	excludeUnsupportedCapabilities_
protected String	sql_

Constructor Summary

Constructors

Constructor	Description
CreateView(Datasource datasource)

Method Summary

Modifier and Type	Method	Description
CreateView	as(String definition)
CreateView	as(Select select)
void	clear()
protected void	clearGenerated()
CreateView	clone()
CreateView	columns(String... columns)
rife.database.capabilities.Capabilities	getCapabilities()
List<String>	getColumns()
Datasource	getDatasource()
String	getDefinition()
QueryParameters	getParameters()
Select	getSelect()
String	getSql()
String	getView()
boolean	isReplace()
CreateView	replace(boolean replace)
void	setExcludeUnsupportedCapabilities(boolean flag)
String	toString()
CreateView	view(String view)

Methods inherited from class java.lang.Object

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

Field Details

datasource_

protected Datasource datasource_

sql_

protected String sql_

excludeUnsupportedCapabilities_

protected boolean excludeUnsupportedCapabilities_

Constructor Details

CreateView

public CreateView(Datasource datasource)

Method Details

clear

public void clear()

Specified by:

clear in interface Query

getCapabilities

public rife.database.capabilities.Capabilities getCapabilities()

Specified by:

getCapabilities in interface Query

getView

public String getView()

isReplace

public boolean isReplace()

getColumns

public List<String> getColumns()

getSelect

public Select getSelect()

getDefinition

public String getDefinition()

view

public CreateView view(String view)

replace

public CreateView replace(boolean replace)

columns

public CreateView columns(String... columns)

as

public CreateView as(Select select)

as

public CreateView as(String definition)

getSql

public String getSql()
              throws DbQueryException

Specified by:

getSql in interface Query

Throws:

DbQueryException

clone

public CreateView clone()

getDatasource

public Datasource getDatasource()

getParameters

public QueryParameters getParameters()

Specified by:

getParameters in interface Query

setExcludeUnsupportedCapabilities

public void setExcludeUnsupportedCapabilities(boolean flag)

Specified by:

setExcludeUnsupportedCapabilities in interface Query

clearGenerated

protected void clearGenerated()

toString

public String toString()

Overrides:

toString in class Object