Sample Queries

This section gives examples of writing queries using the features discussed so far.

Sample 1: Using input mappings in a query

This sample demonstrates how to write a simple query with input mappings.

Query ID : customerAddressSQL

SQL Statement : select * from Customers where contactLastName = ? and contactFirstName = ?

The following query needs two parameters for execution. The Input Mapping section is used to specify these input parameters.

For information on adding validations to your input mappings, see Input Validators.

Sample 2: Adding output mappings to a query

Following sample shows how to query the Cassandra data source created in Cassandra and add output mappings to it.

Query ID : getUsers

Data Source : CassandraDatasource

CQL : select 'key', 'username', 'password' from USER

You can define how the output of this query looks by adding output mappings as follows:

Sample 3: Using a result row namespace

This example shows how to use a results row namespace in output mappings. See Defining Namespaces for information on namespaces.  

Sample 4: Querying a RDF data source

Following sample shows a query written for the RDF data source created in Resource Description Framework, which is based on a RDF resource hosted by NASA. This sample uses the following SPARQL query to extract aircraft information from the data source.

PREFIX space: <http://purl.org/net/schemas/space/>
PREFIX relevance: <http://a9.com/-/opensearch/extensions/relevance/1.0/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT ?homepage ?name ?alternateName ?internationalDesignator ?mass ?score ?launch ?agency ?description
WHERE {
  ?craft foaf:homepage ?homepage.
  ?craft foaf:name ?name.
  ?craft space:alternateName ?alternateName.
  ?craft space:internationalDesignator ?internationalDesignator.
  ?craft space:mass ?mass.
  ?craft relevance:score ?score.
  ?craft space:launch ?launch.
  ?craft space:agency ?agency.
  ?craft dc:description ?description.
}

The input mapping section is used to specify parameters to the query. The above query extracts aircraft information according to the agency. Therefore, we add agency as an input parameter. Next, the output mappings are used  to map the response to an output XML.  

Sample 5: Querying a Web data source

Following sample shows a query written for the Web data source created in Web Resource. When you add a query to a Web data source, you must enter a Scraper Variable. This scraper variable must be the same as the output name in the Web data source configuration, which returns the output from the configuration. In this example, the var-def name in the configuration is weatherInfo (< var-def name = 'weatherInfo' >). Therefore, the Web resource output variable name is also specified as weatherInfo as shown below:

It defines output mappings as follows to specify how the output looks like.