Sdsquery
From SRB
Contents |
NAME
Sdsquery - Provides utilities to make queries against Antelope Datascope database, registered as SRB objects.
SYNOPSIS
Sdsquery [-h] [-o output_file_path] query_string result_size srbObj(datascope_descriptor)
Sdsquery -f query_string srbObj(datascope_descriptor)
DESCRIPTION
provides utilities to make queries against an Antelope Datascope database descriptor. srbObj(datascope_descriptor), which is registered as a SRB object. Antelope Datascope database is a proprietary real-time database used by many sensor networks. Here is the offical manual: http://ament.brtt.com/docs/datascope.pdf
OPTIONS
- -h
- displays command options
- -o
- output_file_path save the query results to a local file.
- -f
- query_string This option triggers the function mode. Which provide a easier query interface for Datascope queries. Please read the support function section for details.
SUPPORTED FUNCTIONS
- "dbsubset|tableName|conditions|wanted_fields_seperated_by_'|'"
subset a table by conditions, and get wanted field values.
- "dbgetvall|start_row|end_row|tableName|wanted_fields_seperated_by_'|'"
get all rows from starting row to ending row. If ending row is '-1', it will return all rows.
- "trloadchan|sta|chan|t1|t2"
get the real time data from starting time 't1' to ending time 't2' for a particular station 'sta' and channel 'chan'.
- "dbfind_by_time_range|tableName|conditions|t1|t2"
subset table with condition and time range, and get the dbPtr (integer) for the subset view.
EXAMPLES
"Sdsquery -f 'dbsubset|site|imagename=~ \/.*Gorge.*\/|imagename' smer-image.ds"
subset table 'site' in Antelope Datascope database 'smer-image.ds', where imagename contains substring 'Gorge'.
