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 example BND,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