config.yml

# default configuration file for BulkMail Dancer App.
# additional and environment specific configurations should be done in YAML files
# in the "environments" directory. see the sample files:
# - environments/development.yml.sample
# - environments/production.yml.sample

appname: "BulkMail"

layout: "main"

charset: "UTF-8"

template: template_toolkit

session: "YAML"
session_dir: "/tmp/BulkMail-sessions"

server_tokens: false

# supported spreadsheet extensions
extensions:
    - csv
    - xls
    - xlsx
    - ods

saveheaders:
    - Content_Type
    - Content_Transfer_Encoding
    - Content_Language
    - MIME_Version

myurl: https://example.com
myfrom: bulkmail@example.com
myname: Bulk Mailer
bounce: bulkmail+bounce@example.com

sqlite:
    db: 'emails.db'

    insert: 'insert into mbox (key,ackkey,from_address,subject,date,Content_Type,Content_Transfer_Encoding,Content_Language,MIME_Version,body) values (?,?,?,?,?,?,?,?,?,?)'
    update_from: 'update mbox set replyto = ?, from_name = ?, remarks = ? where key = ?'
    update_rcpt: 'update mbox set recipients = ?, doubles = ?, invalid = ? where key = ?'
    update_subj: 'update mbox set subject = ? where key = ?'
    get_mail: 'select * from mbox where key = ?'
    get_mail_byack: 'select * from mbox where ackkey = ?'
    get_all: 'select id, from_address, replyto, subject, date, recipients from mbox'

    insert_mailing: 'insert into mailings (key) values (?)' 
    get_mailing: 'select * from mailings where key = ?'
    get_mailings: 'select * from mailings where status = ?'
    update_status: 'update mailings set status = ? where key = ?'
    update_delivered: 'update mailings set delivered = ? where key = ?'
    update_failed: 'update mailings set failed = ? where key = ?'
    get_delivered: 'select delivered from mailings where key = ?'
    get_failed: 'select failed from mailings where key = ?'

    tables:
    - name: mbox
      schema: >
        CREATE TABLE IF NOT EXISTS mbox (
          id integer primary key,
          key text unique,
          ackkey text unique,
          from_address text,
          from_name text,
          replyto text,
          subject text,
          date text,
          Content_Type text,
          Content_Transfer_Encoding text,
          Content_Language text,
          MIME_Version text,
          body text,
          remarks text,
          recipients text,
          doubles text,
          invalid text
        );
    - name: mailings
      schema: >
        CREATE TABLE IF NOT EXISTS mailings (
          id integer primary key,
          key text unique,
          timestamp integer(4) not null default (strftime('%s','now')),
          delivered text default "",
          failed text default "",
          status int default 0
        );