LedgerSMB::Database

This module provides the APIs for database creation and management

This module is copyright (C) 2007, the LedgerSMB Core Team and subject to the GNU General Public License (GPL) version 2, or at your option, any later version. See the COPYRIGHT and LICENSE files for more information.

LedgerSMB::Database->new({dbname = $dbname, countrycode = $cc, chart_name = $name, company_name = $company, username = $username, password = $password})

This function creates a new database management object with the specified characteristics. The $dbname is the name of the database. the countrycode is the two-letter ISO code. The company name is the friendly name for dropdown boxes on the Login screen.

As some countries may have multiple available charts, you can also specify a chart name as well.

Note that the arguments can be any hashref. If it is a LedgerSMB object, however, it will attempt to copy all attributes beginning with _ into the current object (_user, _locale, etc).

base_backup

This routine connects to the database using pg_dumpall and returns a plain text, roles-only dump of the current database cluster. This is left uncompressed for readability and ease of troubleshooting. Base backups are advised to be taken frequently and in conjunction with single database backups. The single database backups will backup all data but no roles. Restoring a new database onto a new server post-crash with only the single-database backup thus means recreating all users.

The file is named roles_[date].sql by default where the date is in yyyy-mm-dd format.

It returns the full path of the resulting backup file on success, or undef on failure.

db_backup()

This routine connects to the database using pg_dump and creates a Pg-native database backup of the selected db only. There is some redundancy with the base backup but the overlap is minimal. You can restore your database and data with the db_bakup, but not the users and roles. You can restore the users and roles with the base_backup but not your database.

The resulting file is named backup_[dbname]_[date].bak with the date in yyyy-mm-dd format.

It returns the full path of the resulting backup file on success, or undef on failure.

get_info()

This routine connects to the database using DBI and attempts to determine if a related application is running in that database and if so what version. It returns a hashref with the following keys set:

$db->server_version();

Connects to the server and returns the version number in x.y.z format.

$db->list()

Lists available databases except for those named "postgres" or starting with "template"

Returns a list of strings of db names.

$db->create();

Creates a database and loads the contrib files. This is done from template0, meaning nothing added to template1 will be found in this database. This was necessary as a workaround for issues on some Debian systems.

Returns true if successful, false of not. Creates a log called dblog in the temporary directory with all the output from the psql files.

In DEBUG mode, will show all lines to STDERR. In ERROR logging mode, will display only those lines containing the word ERROR.

$db->copy('new_name')

Copies the existing database to a new name.

$db->load_modules($loadorder)

Loads or reloads sql modules from $loadorder

$db->exec_script({script => 'path/to/file', logfile => 'path/to/log'})

Executes the script. Returns 0 if successful, 1 if there are errors suggesting that types are already created, and 2 if there are other errors.

$db->create_and_load();

Creates a database and then loads it.

$db->process_roles($rolefile);

Loads database Roles templates.

$db->lsmb_info()

This routine retrieves general stats about the database and returns the output as a hashref with the following key/value pairs:

$db->db_tests()

This routine runs general db tests.

TODO