.TH DBADB 1 "jan 10, 2023 .SH NAME dbadb \- Manage the DB-ALLe database .SH SYNOPSIS .B dbadb .RI [ command ] .RI [ options ] .RI [ args ... ] .br .SH DESCRIPTION It allows to initialise the database, dump its contents and import and export data using BUFR, or CREX encoding. .P \fBdbadb\fP always requires a non-switch argument, that indicates what is the operation that should be performed: .TP \fBhelp\fP .br Print a help summary. .TP \fBhelp manpage\fP .br Print this manpage. .TP \fBdump [options] [queryparm1=val1 [queryparm2=val2 [...]]]\fP .br 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.. .TP \fBstations [options] [queryparm1=val1 [queryparm2=val2 [...]]]\fP .br 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.. .TP \fBwipe [options] [optional rep_memo description file]\fP .br 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. .TP \fBcleanup [options]\fP .br 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.. .TP \fBrepinfo [options] [filename]\fP .br 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. .TP \fBimport [options] [filter] filename [filename [ ... ] ]\fP .br Import data into the database. .TP \fBexport [options] [queryparm1=val1 [queryparm2=val2 [...]]]\fP .br 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. The database is specified with --url or with the DBA_DB environment variable. .TP \fBdelete [options] [queryparm1=val1 [queryparm2=val2 [...]]]\fP .br 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.. .TP \fBinfo\fP .br Print information about the database. .SH OPTIONS \fBdbadb\fP follows the usual GNU command line syntax, with long options starting with two dashes (`-'). .SS Options used to connect to the database .TP .B \-\-dsn=url alias of --url, used for historical compatibility .TP .B \-\-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) .TP .B \-\-wipe-first wipe database before any other action .SS Options used to filter messages .TP .B \-\-category=num match messages with the given data category .TP .B \-\-subcategory=num match BUFR messages with the given data subcategory .TP .B \-\-check-digit=num match CREX messages with check digit (if 1) or without check digit (if 0) .TP .B \-\-parsable match only messages that can be parsed .TP .B \-\-index=expr match messages with the index in the given range (ex.: 1-5,9,22-30) .SS Option for command dump .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SS Option for command stations .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SS Option for command wipe .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .TP .B \-\-disappear just remove the DB-All.e data and tables .SS Option for command cleanup .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SS Option for command repinfo .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SS Option for command import .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .TP .B \-t type, \-\-type=type format of the input data ('bufr', 'crex', 'csv', 'json') .TP .B \-\-rejected=fname write unprocessed data to this file .TP .B \-f, \-\-overwrite overwrite existing data .TP .B \-r rep, \-\-report=rep force data to be of this type of report .TP .B \-\-fast Prefer speed to transactional integrity: if the import is interrupted, the database needs to be wiped and recreated. .TP .B \-\-no-attrs do not import data attributes .TP .B \-\-full-pseudoana merge pseudoana extra values with the ones already existing in the database .TP .B \-\-precise import messages using precise contexts instead of standard ones .TP .B \-\-varlist=varlist only import variables with the given varcode(s) .TP .B \-\-domain-errors=varlist recovery strategy to use when importing values outside a variable domain. Possible values: 'unset' (ignore error and consider the value as unset), 'clamp' (ignore error and replace the value with the closest extreme of the valid domain) .SS Option for command export .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .TP .B \-r rep, \-\-report=rep force exported data to be of this type of report .TP .B \-d type, \-\-dest=type format of the data in output ('bufr', 'crex', 'json') .TP .B \-t name, \-\-template=name template of the data in output (autoselect if not specified, 'list' gives a list) .TP .B \-\-dump dump data to be encoded instead of encoding it .SS Option for command delete .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SS Option for command info .TP .B \-?, \-\-help print an help message .TP .B \-\-verbose verbose output .SH AUTHOR \fBdbadb\fP has been written by Enrico Zini for ARPA Emilia Romagna, Servizio Idrometeorologico.