isql
Class ISQLQuery

java.lang.Object
  isql.ISQLQuery

public class ISQLQuery
extends java.lang.Object

The entry point to the ISQL library. To make a query on arrays, create one instance of this class and call the query method

Author:

SHZ Mar 25, 2008

Constructor Summary

ISQLQuery(ILogger log, boolean isDebug)
Constructor

Method Summary

java.util.Map<java.lang.String,ITypedValue>

query(java.lang.String sql, java.util.Map<java.lang.String,InputArray> mapArrayByName) Queries the arrays using the SQL query

Methods inherited from class java.lang.Object

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

Constructor Detail

ISQLQuery

public ISQLQuery(ILogger log,
                 boolean isDebug)

Constructor

Parameters:

isDebug - if this is true, does some fine log about what is going on during a query

Method Detail

query

public java.util.Map<java.lang.String,ITypedValue> query(java.lang.String sql,
                                                         java.util.Map<java.lang.String,InputArray> mapArrayByName)
                                                  throws ISQLException

Queries the arrays using the SQL query

Parameters:

sql - the sql query, written in the ISQL sql dialect

mapArrayByName - a map [column name -> array], with the column name identifying the array in the SQL query

Returns:

a map [result name -> value] where the result name is the one that identifies each column in the result set of the SQL query (AS ...) and value can be either an array or a single value

Throws:

ISQLException - errors during the query