com.edgeti.VisibilityServer.AdvancedQueries

Class QueryInfoObject

java.lang.Object

com.edgeti.VisibilityServer.AdvancedQueries.QueryInfoObject

public class QueryInfoObject
extends java.lang.Object

Class to query a MySQL table using the google data visualization API. This allows the user to do any kind of read-only query other than joins using a reasonably simple syntax. See http://code.google.com/apis/visualization/documentation/querylanguage.html for a more detailed overview

Author:

phil.feldman

Field Summary

Fields

Modifier and Type	Field and Description
private java.util.ArrayList<FlexRowObject>	_result
private java.util.ArrayList<FlexRowObject>	discreteResult
protected org.apache.log4j.Logger	logger
private java.lang.String	message
private static java.lang.String	PROP_FILE
private java.lang.String	query
private boolean	success
private java.lang.String	tableName
private static TraceLogBuffer	trace

Constructor Summary

Constructors

Constructor and Description
QueryInfoObject()

Method Summary

Methods

Modifier and Type	Method and Description
private void	calcDiscreteResult()
private com.google.visualization.datasource.util.SqlDatabaseDescription	connect(java.lang.String table) Connect to the MySQL db we're interested in.
com.google.visualization.datasource.util.SqlDatabaseDescription	connect(java.lang.String host, java.lang.String database, java.lang.String table, java.lang.String user, java.lang.String password) Explicitly connect to the MySQL db we're interested in.
java.util.ArrayList<FlexRowObject>	getDiscreteResult() public ArrayList getResult() { return result; } public void setResult(ArrayList result) { this.result = result; }
java.lang.String	getMessage()
java.lang.String	getQuery()
java.lang.String	getTableName()
boolean	isSuccess()
void	runQuery(java.lang.String queryString, java.lang.String tableName) Run the query using the google visualization datasource syntax (see http://code.google.com/apis/visualization/documentation/querylanguage.html)
void	setDiscreteResult(java.util.ArrayList<FlexRowObject> discreteResult)
void	setMessage(java.lang.String message)
void	setQuery(java.lang.String query)
void	setSuccess(boolean success)
void	setTableName(java.lang.String tableName)
java.lang.String	toDiscreteString()
java.lang.String	toString()
java.lang.String	toXmlString() Return an xml description of the table, with unique values in the columns where possible
private java.util.ArrayList<java.lang.String>	uniqueColumnNames(java.lang.String header, int max) private function uniqueColumnValues(header:String):Dictionary{ var dict:Dictionary = new Dictionary(); var fro:FlexRowObject; var feo:FlexEntryObject; var i:int = 0; for each(fro in discreteResult){ for each(feo in fro.entries){ if(feo.name == header){ if(!dict.hasOwnProperty(header)){ if(i++ > 10){ return null; } } dict[feo.stringValue] = feo.stringValue; } } } return dict; } /

Methods inherited from class java.lang.Object

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

Field Detail

query

private java.lang.String query

tableName

private java.lang.String tableName

success

private boolean success

_result

private java.util.ArrayList<FlexRowObject> _result

discreteResult

private java.util.ArrayList<FlexRowObject> discreteResult

message

private java.lang.String message

trace

private static TraceLogBuffer trace

PROP_FILE

private static final java.lang.String PROP_FILE

See Also:

Constant Field Values

logger

protected org.apache.log4j.Logger logger

Constructor Detail

QueryInfoObject

public QueryInfoObject()

Method Detail

connect

private com.google.visualization.datasource.util.SqlDatabaseDescription connect(java.lang.String table)

Connect to the MySQL db we're interested in. Try to get the data from the properties file, but if that fails, try hard-coded settings

Parameters:

table - the name of the table we're going to query

Returns:

connect

public com.google.visualization.datasource.util.SqlDatabaseDescription connect(java.lang.String host,
                                                                      java.lang.String database,
                                                                      java.lang.String table,
                                                                      java.lang.String user,
                                                                      java.lang.String password)

Explicitly connect to the MySQL db we're interested in.

Parameters:

table - the name of the table we're going to query

Returns:

runQuery

public void runQuery(java.lang.String queryString,
            java.lang.String tableName)

Run the query using the google visualization datasource syntax (see http://code.google.com/apis/visualization/documentation/querylanguage.html)

Parameters:

queryString: - The query

tableName: - The name of the table the query will run against

calcDiscreteResult

private void calcDiscreteResult()

getQuery

public java.lang.String getQuery()

setQuery

public void setQuery(java.lang.String query)

getTableName

public java.lang.String getTableName()

setTableName

public void setTableName(java.lang.String tableName)

isSuccess

public boolean isSuccess()

setSuccess

public void setSuccess(boolean success)

getDiscreteResult

public java.util.ArrayList<FlexRowObject> getDiscreteResult()

public ArrayList getResult() { return result; } public void setResult(ArrayList result) { this.result = result; }

setDiscreteResult

public void setDiscreteResult(java.util.ArrayList<FlexRowObject> discreteResult)

getMessage

public java.lang.String getMessage()

setMessage

public void setMessage(java.lang.String message)

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

toDiscreteString

public java.lang.String toDiscreteString()

uniqueColumnNames

private java.util.ArrayList<java.lang.String> uniqueColumnNames(java.lang.String header,
                                                      int max)

private function uniqueColumnValues(header:String):Dictionary{ var dict:Dictionary = new Dictionary(); var fro:FlexRowObject; var feo:FlexEntryObject; var i:int = 0; for each(fro in discreteResult){ for each(feo in fro.entries){ if(feo.name == header){ if(!dict.hasOwnProperty(header)){ if(i++ > 10){ return null; } } dict[feo.stringValue] = feo.stringValue; } } } return dict; } /

toXmlString

public java.lang.String toXmlString()

Return an xml description of the table, with unique values in the columns where possible

Returns: