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)