com.edgeti.VisibilityServer

Class DbRemoteObject

java.lang.Object

com.edgeti.VisibilityServer.DbRemoteObject

Direct Known Subclasses:

DbRemoteObjectTests

public class DbRemoteObject
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	database
private java.lang.String	driver
private java.lang.String	host
protected org.apache.log4j.Logger	logger
private java.lang.String	password
private java.lang.String	user

Constructor Summary

Constructors

Constructor and Description
DbRemoteObject()

Method Summary

Methods

Modifier and Type	Method and Description
QueryInfoObject	advancedQuery(java.lang.String query, java.lang.String table, UserInfoObject user) Query a MySQL table using the google data visualization API.
private boolean	checkHeader(java.lang.String header, java.util.List<java.lang.String> headers)
private boolean	checkHeader2(java.lang.String header, java.util.List<ColumnInfoObject> headers)
protected void	createTable()
private java.lang.String	getHeader(java.util.List<java.lang.String> headers, int i)
FlexTreeObject	getMetaEntryDetailsList(java.lang.String topLevel, UserInfoObject user)
java.util.List<java.lang.String>	getMetaEntryList(java.lang.String relationship, UserInfoObject user)
java.util.List<FlexRowObject>	getQuery(java.util.List<java.lang.String> headers, int numRows, java.lang.String relationship, java.lang.String type, boolean emptyFlag, UserInfoObject user)
java.util.List<FlexRowObject>	getQueryWhere(java.util.List<ColumnInfoObject> columns, java.lang.String namespace, java.lang.String tableName, boolean emptyFlag, UserInfoObject user)
java.util.List<java.lang.String>	getRelationshipList(UserInfoObject user)
java.lang.String	getTableQuestions(java.lang.String tableName)
java.lang.String	getTableXMLDefaultDescription(java.lang.String tableName)
java.lang.String	getTableXMLDescription(java.lang.String tableName)
java.lang.String	getVersion()
java.lang.String	ingestXML(java.lang.String tableName, java.lang.String filename)
private void	logQueries(java.lang.String query, java.lang.String table, UserInfoObject user)
static void	main(java.lang.String[] args)
java.lang.String	setTableQuestions(java.lang.String questions, java.lang.String tableName)
java.lang.String	setTableXMLDescription(java.lang.String description, java.lang.String tableName)
private java.lang.String	setXmlTable(java.lang.String xmlString, java.lang.String tableName, java.lang.String sysTable)

Methods inherited from class java.lang.Object

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

Field Detail

host

private java.lang.String host

user

private java.lang.String user

password

private java.lang.String password

database

private java.lang.String database

driver

private java.lang.String driver

logger

protected org.apache.log4j.Logger logger

Constructor Detail

DbRemoteObject

public DbRemoteObject()

Method Detail

getVersion

public java.lang.String getVersion()

createTable

protected void createTable()

ingestXML

public java.lang.String ingestXML(java.lang.String tableName,
                         java.lang.String filename)

getRelationshipList

public java.util.List<java.lang.String> getRelationshipList(UserInfoObject user)

getMetaEntryList

public java.util.List<java.lang.String> getMetaEntryList(java.lang.String relationship,
                                                UserInfoObject user)

getMetaEntryDetailsList

public FlexTreeObject getMetaEntryDetailsList(java.lang.String topLevel,
                                     UserInfoObject user)

getHeader

private java.lang.String getHeader(java.util.List<java.lang.String> headers,
                         int i)

checkHeader

private boolean checkHeader(java.lang.String header,
                  java.util.List<java.lang.String> headers)

checkHeader2

private boolean checkHeader2(java.lang.String header,
                   java.util.List<ColumnInfoObject> headers)

getQuery

public java.util.List<FlexRowObject> getQuery(java.util.List<java.lang.String> headers,
                                     int numRows,
                                     java.lang.String relationship,
                                     java.lang.String type,
                                     boolean emptyFlag,
                                     UserInfoObject user)

getQueryWhere

public java.util.List<FlexRowObject> getQueryWhere(java.util.List<ColumnInfoObject> columns,
                                          java.lang.String namespace,
                                          java.lang.String tableName,
                                          boolean emptyFlag,
                                          UserInfoObject user)

advancedQuery

public QueryInfoObject advancedQuery(java.lang.String query,
                            java.lang.String table,
                            UserInfoObject user)

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

Parameters:

query -

table -

Returns:

logQueries

private void logQueries(java.lang.String query,
              java.lang.String table,
              UserInfoObject user)

setTableQuestions

public java.lang.String setTableQuestions(java.lang.String questions,
                                 java.lang.String tableName)

setTableXMLDescription

public java.lang.String setTableXMLDescription(java.lang.String description,
                                      java.lang.String tableName)

setXmlTable

private java.lang.String setXmlTable(java.lang.String xmlString,
                           java.lang.String tableName,
                           java.lang.String sysTable)

getTableQuestions

public java.lang.String getTableQuestions(java.lang.String tableName)

getTableXMLDescription

public java.lang.String getTableXMLDescription(java.lang.String tableName)

getTableXMLDefaultDescription

public java.lang.String getTableXMLDefaultDescription(java.lang.String tableName)

main

public static void main(java.lang.String[] args)