NAME

SqlBatch::Configuration

DESCRIPTION

The given configuration for executing the sqlbatch engine

ORIGIN OF CONFIGURATION

The values for the configuration items can either come from sqlbatch commandline arguments or from a dedicatet configuration file.

In the situation of doubble definition the commandline arguments prevail.

METHODS

database_handles

Create and return hash with two database connections. The hash contains to elements:

autocommitted

Execution on this database handle enables automatic transaction commit.

nonautocommitted :

Execution on this database handle will normally not automatically transaction commit.

In the case of a defined item force_autocommit this database handle will also be autocommit enabled.

load

Load the given configuration file

requirement_assertion($name)

Check if a configuration item requirements are met or croak/die.

item($name)

Return value for the given item or return undef.

item_hash

Return a hash of item-names and values

validate

Execute method requirement_assertion on all items.

verbosity

Return the given verbosity level

CONFIGURATION ITEMS

datasource (required)

A DBI connection string

directory (optional)

Path to directory for SQL-batch-files and default configuration file.

exclude_files (optional, default=[])

Reference to array of filepaths to exclude in execution.

force_autocommit (optional, default=undef)

No nonautocommitted database-handle will be created if defined.

from_file (optional, default=undef)

Name of the file to start execution from.

fileextension (optional, default='sb')

The fileextension of SQL-batch-files.

password (required)

Value of the password for doing the DBI connection

tags (optional, default=[])

Reference to array of tags that specify running the tagged instructions or not

to_file (optional, default=undef)

Name of the file where the execution finishes

username (required)

Value of the username for doing the DBI connection

verbosity (optional, default=1)

Level of verbosity

0 : no output
1 : overall steps
2 : detailed

AUTHOR

Sascha Dibbern (sascha at dibbern.info)

LICENCE

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.