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 parameters -- 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 values. 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 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 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')

--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 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 (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.