dbadb − Manage the DB-ALLe database
dbadb [command] [options] [args...]
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..
info |
Print information about the database. |
dbadb follows the usual GNU command line syntax, with long options starting with two dashes (‘-’).
Options used to connect to the database
−−dsn=url
alias of --url, used for historical compatibility
−−url=url
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)
−−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
−−disappear
just remove the DB-All.e data and tables
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
Option for command info
−?, −−help
print an help message
−−verbose
verbose output
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.
dbadb has been written by Enrico Zini <enrico AT enricozini DOT com> for ARPA Emilia Romagna, Servizio Idrometeorologico.