NAME

topper::database - This class handles database calls.


SYNOPSIS

  use topper::database;
  my $db = topper::database->new($config);
  $db->connect();
  $db->query('SELECT ? FROM fancy_query;',$somevar);
  $db->disconnect();


DESCRIPTION

This package handles all output (as in STDOUT, STDERR, file output, etc). It allows for verbosity levels and error reporting levels to be defined, and logging.

Methods

new(topper::config $config)

Constructor. Initialises class member variables.

Input: topper::config $config : Pass the configuration object here. Output: blessed object.

connect()

Connects to the database.

Input: n/a Output: 1 on success, 0 on failure.

disconnect()

Terminates the connection to the database.

Input: n/a Output: n/a

query($statement,$somevar,$somevar,...)

Runs a prepared statement query on the database with given variables.

Input: $statement : MySQL query. Input: $somevar : Any number of variables to fill into the query. Output: Returns DBI output.

prepare($query)

Prepares a query.

Input: $query : MySQL query. Output: prepared statement object.