I've made a little progress. I had my db in the ./lib directory of the app. I moved it to /tmp and used:

my $schema = My::Class->connect('dbi:SQLite:dbname=/tmp/database.db');
my $record = $schema->resultset('Report')->new(\%data);
$record->insert();
[download]

I am now getting the following error:

 DBI Exception: DBD::SQLite::st execute failed: UNIQUE constraint fail
+ed: report.id
[download]

This should be an easy fix however, it did actually do the insert into the database.