SYNOPSIS
dbadb [command] [options] [args...]DESCRIPTION
It allows to initialise the database, dump its contents and import and export data using BUFR, CREX or AOF encoding.dbadb always requires a non-switch argument, that indicates what is the operation that should be performed:
- help
-
Print a help summary. - help manpage
-
Print this manpage. - dump [options] [queryparm1=val1 [queryparm2=val2 [...]]]
-
Dump data from the database. Query parameters are the same of the Fortran API. Please see the section "Input and output parameters -- For data related action routines" of the Fortran API documentation for a complete list.. - stations [options] [queryparm1=val1 [queryparm2=val2 [...]]]
-
List the stations present in the database. Query parameters are the same of the Fortran API. Please see the section "Input and output parameters -- For data related action routines" of the Fortran API documentation for a complete list.. - wipe [options] [optional rep_memo description file]
-
Reinitialise the database, removing all data. Reinitialisation is done using the given report code description file. If no file is provided, a default version is used. - cleanup [options]
-
Perform database cleanup operations. The only operation currently performed by this command is deleting stations that have no values. If more will be added in the future, they will be documented here.. - repinfo [options] [filename]
-
Update the report information table. Update the report information table with the data from the given report code description file. If no file is provided, a default version is used. - import [options] [filter] filename [filename [ ... ] ]
-
Import data into the database. - export [options] rep_memo [queryparm1=val1 [queryparm2=val2 [...]]]
-
Export data from the database. Query parameters are the same of the Fortran API. Please see the section "Input and output parameters -- For data related action routines" of the Fortran API documentation for a complete list.. - delete [options] [queryparm1=val1 [queryparm2=val2 [...]]]
-
Delete all the data matching the given query parameters. Query parameters are the same of the Fortran API. Please see the section "Input and output parameters -- For data related action routines" of the Fortran API documentation for a complete list..
OPTIONS
dbadb follows the usual GNU command line syntax, with long options starting with two dashes (`-').Options used to connect to the database
- --dsn=dsn
- DSN, or URL-like database definition, to use for connecting to the DB-All.e database (can also be specified in the environment as DBA_DB)
- --user=user
- username to use for connecting to the DB-All.e database
- --pass=pass
- password to use for connecting to the DB-All.e database
- --wipe-first
- wipe database before any other action
Options used to filter messages
- --category=num
- match messages with the given data category
- --subcategory=num
- match BUFR messages with the given data subcategory
- --check-digit=num
- match CREX messages with check digit (if 1) or without check digit (if 0)
- --parsable
- match only messages that can be parsed
- --index=expr
- match messages with the index in the given range (ex.: 1-5,9,22-30)
Option for command dump
- -?, --help
- print an help message
- --verbose
- verbose output
Option for command stations
- -?, --help
- print an help message
- --verbose
- verbose output
Option for command wipe
- -?, --help
- print an help message
- --verbose
- verbose output
Option for command cleanup
- -?, --help
- print an help message
- --verbose
- verbose output
Option for command repinfo
- -?, --help
- print an help message
- --verbose
- verbose output
Option for command import
- -?, --help
- print an help message
- --verbose
- verbose output
- -t type, --type=type
- format of the input data ('bufr', 'crex', 'aof', 'csv', 'json')
- --rejected=fname
- write unprocessed data to this file
- -f, --overwrite
- overwrite existing data
- -r rep, --report=rep
- force data to be of this type of report
- --fast
- Prefer speed to transactional integrity: if the import is interrupted, the database needs to be wiped and recreated.
- --no-attrs
- do not import data attributes
- --full-pseudoana
- merge pseudoana extra values with the ones already existing in the database
- --precise
- import messages using precise contexts instead of standard ones
Option for command export
- -?, --help
- print an help message
- --verbose
- verbose output
- -r rep, --report=rep
- force exported data to be of this type of report
- -d type, --dest=type
- format of the data in output ('bufr', 'crex', 'aof')
- -t name, --template=name
- template of the data in output (autoselect if not specified, 'list' gives a list)
- --dump
- dump data to be encoded instead of encoding it
Option for command delete
- -?, --help
- print an help message
- --verbose
-
verbose output
TEMPLATE NAMES
This is a list of possible template names for the --template switch:
- acars
-
ACARS (autodetect) - acars-ecmwf
-
ACARS ECMWF (4.145) - acars-wmo
-
ACARS WMO - airep
-
AIREP (autodetect) - airep-ecmwf
-
AIREP ECMWF (4.142) - amdar
-
AMDAR (autodetect) - amdar-ecmwf
-
AMDAR ECMWF (4.144) - amdar-wmo
-
AMDAR WMO - buoy
-
Buoy (1.21) - generic
-
Generic (255.0) - metar
-
Metar (0.140) - pilot
-
pilot (autodetect) - pilot-ecmwf
-
Pilot (2.91) - pilot-wmo
-
Pilot (2.1, 2.2, 2.3) - pollution
-
Pollution (8.171) - ship
-
Synop ship (autodetect) - ship-abbr
-
Synop ship (abbreviated) (1.9) - ship-auto
-
Synop ship (auto) (1.13) - ship-plain
-
Synop ship (normal) (1.11) - ship-reduced
-
Synop ship (reduced) (1.19) - ship-second
-
Synop ship (second record) (1.12) - ship-wmo
-
Ship WMO - synop
-
Synop (autodetect) - synop-ecmwf
-
Synop ECMWF (autodetect) (0.1) - synop-ecmwf-auto
-
Synop ECMWF land auto (0.3) - synop-ecmwf-land
-
Synop ECMWF land (0.1) - synop-ecmwf-land-high
-
Synop ECMWF land high level station (0.1) - synop-wmo
-
Synop WMO (0.1) - temp
-
Temp (autodetect) - temp-ecmwf
-
Temp ECMWF (autodetect) - temp-ecmwf-land
-
Temp ECMWF land (2.101) - temp-ecmwf-ship
-
Temp ECMWF ship (2.102) - temp-radar
-
Temp radar doppler wind profile (6.1) - temp-ship
-
Temp ship (autodetect) - temp-wmo
-
Temp WMO (2.101) - wmo
-
WMO style templates (autodetect)
--template=list will also print the list.
AUTHOR
dbadb has been written by Enrico Zini <[email protected]> for ARPA Emilia Romagna, Servizio Idrometeorologico.