use Dancer;
use DBI;
use Template;
use Data::Dumper;

set 'database'     => 'files.db';
set 'log'          => 'debug';
set 'logger'       => 'console';

get '/' => sub {

  my $db = connect_db();
  my $sql = 'select * from table';
  my $sth = $db->prepare($sql) or die $db->errstr;
  $sth->execute or die $sth->errstr;
  my $files = $sth->fetchall_arrayref({});
  template 'show_entries.tt', {
     'files' => $files,
     'test' => [1,2,3,4,5]

  };
};

sub connect_db {
  my $dbh = DBI->connect("dbi:SQLite:dbname=".setting('database') ) or die;

  return $dbh;
}