OnWorks favicon

dbs_updatep - Online in the Cloud

Run dbs_updatep in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command dbs_updatep that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator



dbs_update - Update SQL Databases


dbs_update is an utility to update SQL databases from text files.

dbs_update assumes that each line of the input contains a data record and that the field
within the records are separated by tabulators. You can tell dbs_update about the input
format with the --format option.

The first field of the data record is used as table specification. These consists of the
table name and optionally the index of starting column, separated by a dot.

Alternatively dbs_update can read the column names from the first line of input (see the
-h/--headline option). These can even be aliases for the real column names (see the
-m/--map option).


Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for
MySQL) and the database name. The third parameter is optionally and specifies the database
user and/or the host where the database resides ("racke", "[email protected]" or


Removes all records which remain unaffected from the update process. The same result as
deleting all records from the table first and then running dbs_update, but the table is
not empty in the meantime.

-c COLUMN,COLUMN,..., --columns=COLUMN,COLUMN,...
Update only the table columns given by the COLUMN parameters. To exclude columns from the
update prepend "!" or "^" to the parameters.

Update only the input rows given by the ROW parameters. The first row is 1 where
headlines doesn't count. To exclude rows from the update prepend "!" or "^" to the

-f FILE, --file=FILE
Reads records from file FILE instead of from standard input.

Assumes FORMAT as format for the input. Only CSV can be specified for now, default is TAB.
The default field separator for CSV is a comma, you may change this by appending the
separator to the format.

-h, --headline
Reads the column names from the first line of the input instead of dedicting them from the
database layout. Requires the -t/--table option.

-k COUNT, -k KEY,KEY,..., --keys=COUNT, --keys=KEY,KEY,...
Specifies the keys for the table(s) either as the number of columns used as keys or by
specifying them explicitly as comma separated arguments to the option. This is used for
the detection of existing records.

Maps the names found in the first line of input to the actual column names in the
database. The alias and the column name are separated with "=" signs and the different
entries are separated by ";" signs, e.g. "Art-No.=code;Short Description=shortdescr'".

Applies a filter to the column names read from the input file. Currently there is only
the "lc" filter available.

Updates only records where the value of the column FIELD is in the result set of the SQL
statement STATEMENT, e.g. "category:{select distinct name from categories}".

-o, --update-only
Updates existing database entries only, stops if it detects new ones.

-r ROUTINE, --routine=ROUTINE
Applies ROUTINE to any data record. ROUTINE must be a subroutine. dbs_update passes the
table name and a hash reference to this subroutine. The keys of the hash are the column
names and the values are the corresponding field values. If the return value of ROUTINE is
not a truth value, the data record will be skipped.

"sub {my ($table, $valref) = @_;
unless (defined $$valref{country} && $$valref{country} !~ /\S/) {
$$valref{country} = "Germany";
1; }"

Lines not matching the assumed format are ignored. Without this option, dbs_update simply

-t TABLE, --table=TABLE
Uses TABLE as table name for all records instead of the first field name.

Use dbs_updatep online using onworks.net services

Free Servers & Workstations

Download Windows & Linux apps

  • 1
    This repository is no longer maintained
    and is kept for archival purposes. See
    https://invent.kde.org/sdk/kdiff3 for
    the newest code and
    Download KDiff3
  • 2
    USBLoaderGX is a GUI for
    Waninkoko's USB Loader, based on
    libwiigui. It allows listing and
    launching Wii games, Gamecube games and
    homebrew on Wii and WiiU...
    Download USBLoaderGX
  • 3
    Firebird RDBMS offers ANSI SQL features
    & runs on Linux, Windows &
    several Unix platforms. Features
    excellent concurrency & performance
    & power...
    Download Firebird
  • 4
    KompoZer is a wysiwyg HTML editor using
    the Mozilla Composer codebase. As
    Nvu's development has been stopped
    in 2005, KompoZer fixes many bugs and
    adds a f...
    Download KompoZer
  • 5
    Free Manga Downloader
    Free Manga Downloader
    The Free Manga Downloader (FMD) is an
    open source application written in
    Object-Pascal for managing and
    downloading manga from various websites.
    This is a mirr...
    Download Free Manga Downloader
  • 6
    UNetbootin allows you to create bootable
    Live USB drives for Ubuntu, Fedora, and
    other Linux distributions without
    burning a CD. It runs on Windows, Linux,
    and ...
    Download UNetbootin
  • 7
    Dolibarr ERP - CRM
    Dolibarr ERP - CRM
    Dolibarr ERP - CRM is an easy to use
    ERP and CRM open source software package
    (run with a web php server or as
    standalone software) for businesses,
    Download Dolibarr ERP - CRM
  • More »

Linux commands