use Mojolicious::Lite;
use Mojolicious::Plugin::Database;
use Data::Dumper;

plugin 'Database' => {
        dsn      => 'dbi:MySQL:host=mysql...:dbname=d...',
        username => 'd...',
        password => '....',
        options  => { 'pg_enable_utf8' => 1, AutoCommit => 1, PrintError =>0, RaiseError => 1 },
        helper   => 'db',
        };

# Route with placeholder
get '/invtot' => sub {
  my $c   = shift;
  # my $foo = $c->param('foo');
  # $c->render(text => "Hello from $foo.");
  $c->render("invtot");

post '/invtot' => sub {
    my $c = shift;
    my $p = $c->req->body_params->to_hash;
    print Dumper $p;
    print Dumper $c->app->attr('_dbh_db')
}  
};


# Start the Mojolicious command system
app->start;
__DATA__
#as above