Overview  Package   Class  Use  Deprecated  Index
Home >> All >> [ PointOfViewServer overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

PointOfViewServer
Class Query  

java.lang.Object
  PointOfViewServer.Query

---

public class Query

extends java.lang.Object

This class defines a SQL query object. Query objects are created from DimensionSubset objects by calling of buildQuery inherited method. The normal forme of the query is : SELECT field1,field2 FROM tableA WHERE ... Note that it is possible to use alias to build more complex queries. Query is decomposed into differents parts (SELECT..., FROM..., WHERE..., ...). The SQL keywords SELECT, FROM, WHERE,... are not included in variables. They contain only literal part of clauses. At least, the class provides the table name and the field name of the query in a list of DimensionField and DimensionTable objects.

---

Field Summary
private  DimensionFieldList	pDimensionFields
private  DimensionTableList	pDimensionTables
private  ParameterSet	pParameters
private  java.lang.String	sFieldToJoin
private  java.lang.String	sFrom
private  java.lang.String	sGroup
private  java.lang.String	sHaving
private  java.lang.String	sName
private  java.lang.String	sOrder
private  java.lang.String	sSelect
private  java.lang.String	sWhere

 

Constructor Summary

Query(ParameterSet params)           Main constructor

Query(java.lang.String name, ParameterSet params)           Constructor accepting the name of the query

 

Method Summary
DimensionFieldList	getDimensionFields()           Return the list of fields objects used in the query.
DimensionTableList	getDimensionTables()           Return the list of tables used in the query.
java.lang.String	getFieldToJoin()           Return field used to join query to another one.
java.lang.String	getFrom()           Return current "from" clause.
java.lang.String	getGroup()           Return current "Group by" clause.
java.lang.String	getHaving()           Return current "Having" clause.
java.lang.String	getName()           Return the query name.
java.lang.String	getOrder()           Return current "Order by" clause.
java.lang.String	getSelect()           Return current "select" clause.
java.lang.String	getWhere()           Return current "where" clause.
boolean	isEmpty()           Test if the query is empty or not.
void	joinTo(Query qtoadd)           Join the query to another one.
void	setFieldToJoin(java.lang.String field)           Set field used to join query to another one.
void	setFrom(java.lang.String from)           Set the "From" clause.
void	setGroup(java.lang.String group)           Set the "Group by" clause.
void	setHaving(java.lang.String having)           Set the "Having" clause.
void	setName(java.lang.String name)           Set the name of query.
void	setOrder(java.lang.String order)           Set the "Order by" clause.
void	setSelect(java.lang.String select)           Set the "Select" clause.
void	setWhere(java.lang.String where)           Set the "Where" clause.
java.lang.String	toString()           Return concatenation of differents parts of the query.

 

Methods inherited from class java.lang.Object

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

 

Field Detail

sName

private java.lang.String sName

---

sSelect

private java.lang.String sSelect

---

sFrom

private java.lang.String sFrom

---

sWhere

private java.lang.String sWhere

---

sGroup

private java.lang.String sGroup

---

sHaving

private java.lang.String sHaving

---

sOrder

private java.lang.String sOrder

---

sFieldToJoin

private java.lang.String sFieldToJoin

---

pDimensionFields

private DimensionFieldList pDimensionFields

---

pDimensionTables

private DimensionTableList pDimensionTables

---

pParameters

private ParameterSet pParameters

Constructor Detail

Query

public Query(ParameterSet params)

Main constructor

---

Query

public Query(java.lang.String name,
             ParameterSet params)

Constructor accepting the name of the query

Method Detail

getName

public java.lang.String getName()

Return the query name.

---

getSelect

public java.lang.String getSelect()

Return current "select" clause.

---

getFrom

public java.lang.String getFrom()

Return current "from" clause.

---

getWhere

public java.lang.String getWhere()

Return current "where" clause.

---

getGroup

public java.lang.String getGroup()

Return current "Group by" clause.

---

getHaving

public java.lang.String getHaving()

Return current "Having" clause.

---

getOrder

public java.lang.String getOrder()

Return current "Order by" clause.

---

setName

public void setName(java.lang.String name)

Set the name of query.

---

setSelect

public void setSelect(java.lang.String select)

Set the "Select" clause.

---

setFrom

public void setFrom(java.lang.String from)

Set the "From" clause.

---

setWhere

public void setWhere(java.lang.String where)

Set the "Where" clause.

---

setGroup

public void setGroup(java.lang.String group)

Set the "Group by" clause.

---

setHaving

public void setHaving(java.lang.String having)

Set the "Having" clause.

---

setOrder

public void setOrder(java.lang.String order)

Set the "Order by" clause.

---

getFieldToJoin

public java.lang.String getFieldToJoin()

Return field used to join query to another one.

---

setFieldToJoin

public void setFieldToJoin(java.lang.String field)

Set field used to join query to another one.

---

getDimensionFields

public DimensionFieldList getDimensionFields()

Return the list of fields objects used in the query.

---

getDimensionTables

public DimensionTableList getDimensionTables()

Return the list of tables used in the query.

---

toString

public java.lang.String toString()

Return concatenation of differents parts of the query. Note that function add SQL keywords. Use this function to obtain query string to execute.

---

isEmpty

public boolean isEmpty()

Test if the query is empty or not.

---

joinTo

public void joinTo(Query qtoadd)

Join the query to another one.

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> [ PointOfViewServer overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---