[](https://github.com/giterlizzi/perl-Mojolicious-Plugin-DataTables/releases) [](https://travis-ci.org/giterlizzi/perl-Mojolicious-Plugin-DataTables) [](https://github.com/giterlizzi/perl-Mojolicious-Plugin-DataTables) [](https://github.com/giterlizzi/perl-Mojolicious-Plugin-DataTables) [](https://github.com/giterlizzi/perl-Mojolicious-Plugin-DataTables) [](https://github.com/giterlizzi/perl-Mojolicious-Plugin-DataTables/issues)
# Mojolicious::Plugin::DataTables
## Usage
```.pl
# Mojolicious
$self->plugin('DataTables');
# Mojolicious::Lite
plugin 'DataTables';
helper sql => sub { state $pg = Mojo::Pg->new('postgresql://postgres@/test') };
get '/users_table' => sub {
my $c = shift;
my $sql = $c->sql;
my $dt_ssp = $c->datatable->ssp(
table => 'users',
sql => $sql,
options => [
{
label => 'UID',
db => 'uid',
dt => 0,
},
{
label => 'e-Mail',
db => 'mail',
dt => 1,
},
{
label => 'Status',
db => 'status',
dt => 2,
},
]
));
$c->render(json => $dt_ssp);
};
```
```.html
@@ template.html.ep
<%= datatables_js %>
<%= datatables_css %>
```
## Installation
To install this module type the following:
perl Makefile.PL
make
make test
make install
## Copyright
Copyright (C) 2020-2021 by Giuseppe Di Terlizzi