DBADB(1) General Commands Manual DBADB(1)
NAME
dbadb - Manage the DB-ALLe database
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..
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.
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 parame-
ters -- For data related action routines" of the Fortran API documentation for a complete list..
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.
cleanup [options]
Perform database cleanup operations. The only operation currently performed by this command is deleting stations that have no val-
ues. If more will be added in the future, they will be documented here..
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 out-
put 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)
--unparsable
match only messages that cannot be parsed
--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 wipe
-?, --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')
-f, --overwrite
overwrite existing data
-r rep, --report=rep
force data to be of this type of report, specified with rep_cod or rep_memo values
--fast Ignored. This option is left here for compatibility with old versions of dbadb.
--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, specified with rep_cod or rep_memo values
-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 repinfo
-?, --help
print an help message
--verbose
verbose output
Option for command cleanup
-?, --help
print an help message
Option for command stations
-?, --help
print an help message
Option for command delete
-?, --help
print an help message
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 (2.91)
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)
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-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 <enrico@enricozini.com> for ARPA Emilia Romagna, Servizio Idrometeorologico.
may 16, 2012 DBADB(1)