This writes data to an external SQL based database. The specific data written as well as the database target are controlled by the profile selected.
Usage
da.output.sqldb [switches…] station… times
Switches
- --profile=STRING
-
This is the profile name to output. Multiple profiles can be defined to specify different sets of data that can be output independently. Consult the station configuration for available profiles.
Default: aerosol
- --quiet[=BOOLEAN]
-
If set then no progress output is displayed and any confirmation prompts are bypassed.
Default: Disabled
Arguments
- station
-
This argument is used to specify the station used to look up variables that do not include a station as part of an archive read specification. The station is the three letter GAW station code of the location, such as
BND
. The argument accepts multiple stations specified as regular expressions and separated by:
or;
or,
. For exampleBND,MLO
and(BND|MLO)
are two ways of selecting both the BND and MLO stations.The special value
allstations
may also be specified to select all stations. - times
-
This argument may be split into multiple actual program arguments. This full list of time arguments defines a time bounds list that sets the range of data queried. The final resulting data are clipped to the given time bounds but any values that intersect them are returned.
Examples
- Output SQL data
-
This will output data for the default "aerosol" profile.
da.output.sqldb bnd 2015-05-01 2015-05-03