new

my $obj = SQLite::Work::Mail->new(
database=>$database_file,
report_template=>$report_template,
default_format=>{ 'episodes' => { 'title'=>'title', 'series_title'=>'title', } },
},
);

Make a new report object.

Takes the same arguments as SQLite::Work::new().

send_email

$obj->send_email();

    $rep->send_email(
        table=>$table,
        where=>\%where,
        not_where=>\%not_where,
        subject=>'My Mail',
        email_col=>$email_col,
        email_address=>\@addresses,
        mailer=>$mailer,
        sort_by=>\@sort_by,
        sort_reversed=>\%sort_reversed,
        show=>\@show,
        limit=>$limit,
        page=>$page,
        row_template=>$row_template,
    );

Select data from a table in the database, and send each row as a separate email.

Arguments are as follows (in alphabetical order):

email_address

An array of email addresses to send the email to. If this is given, this will send an email for each matching row, to each address in the array. Useful for broadcast mailing.

Give either this option or the 'email_col' option.

email_col

The name of the column to take email addresses from. If this is given, then each row is sent to the email address value in that column for that row. Useful for individual notification.

Give either this option or the 'email_address' option.

limit

The maximum number of rows to display per page. If this is zero, then all rows are displayed in one page.

mailer

The name of the mailing program to use. Allowable values are 'mutt', sendmail, mail, and elm.

not_where

A hash containing the column names where the selection criteria in where should be negated.

page

Select which page to generate, if limit is not zero.

row_template

The template for each row. This uses the same format as for headers. If none is given, then a default row_template will be generated, depending on which columns are going to be shown (see show).

Therefore it is important that if one provides a row_template, that it matches the current layout.

The format is as follows:

show

An array of columns to select; also the order in which they should be shown when a row_template has not been given.

sort_by

An array of column names by which the result should be sorted.

sort_reversed

A hash of column names where the sorting given in sort_by should be reversed.

subject

A template for the Subject: line of the emails.

table

The table to report on. (required)

where

A hash containing selection criteria. The keys are the column names and the values are strings suitable for using in a LIKE condition; that is, '%' is a multi-character wildcard, and '_' is a single-character wildcard. All the conditions will be ANDed together.

Yes, this is limited and doesn't use the full power of SQL, but it's useful enough for most purposes.

send_one_email

send_the_actual_mail