Mojolicious::Plugin::MySQLViewerLite - Mojolicious plugin to display mysql database information
# Mojolicious::Lite plugin 'MySQLViewerLite', dbh => $dbh; # Mojolicious $app->plugin('MySQLViewerLite', dbh => $dbh); # Access http://localhost:3000/mysqlviewerlite # Prefix plugin 'MySQLViewerLite', dbh => $dbh, prefix => 'mysqlviewerlite2';
Mojolicious::Plugin::MySQLViewerLite is Mojolicious plugin to display MySQL database information on your browser.
Mojolicious::Plugin::MySQLViewerLite have the following features.
Display all table names
Display show create table
show create table
Select * from TABLE limit 0, 1000
Display primary keys, null allowed columnes, and database engines in all tables.
primary keys
null allowed columnes
database engines
dbh
dbh => $dbh
Database handle object in DBI.
prefix
prefix => 'mysqlviewerlite2'
Application base path, default to mysqlviewerlite.
mysqlviewerlite
route => $route
Router, default to $app-routes>.
$app-
It is useful when under is used.
under
my $b = $r->under(sub { ... }); plugin 'MySQLViewerLite', dbh => $dbh, route => $b;
1 POD Error
The following errors were encountered while parsing the POD:
Unknown directive: =head
To install Mojolicious::Plugin::MySQLViewerLite, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Mojolicious::Plugin::MySQLViewerLite
CPAN shell
perl -MCPAN -e shell install Mojolicious::Plugin::MySQLViewerLite
For more information on module installation, please visit the detailed CPAN module installation guide.