NAME
Mojolicious::Plugin::MySQLViewerLite
SYNOPSYS
# Mojolicious::Lite
plugin 'MySQLViewerLite', dbh => $dbh;
# Mojolicious
$app->plugin('MySQLViewerLite', dbh => $dbh);
# Access
http://localhost:3000/mysqlviewerlite
DESCRIPTION
Show MySQL database information. This is Mojolicious plugin.
Mojolicious::Plugin::MySQLViewerLite have the following features.
You can see all table definition.
You can specify talbe and select top 1000 rows.
You can see primary key, null allowed column, and database engine of all tables.
INSTALL
Mojolicious::Plugin::MySQLViewerLite need the following module.
DBIx::Custom;
Validator::Custom;
And you copy Mojolicious::Plugin::MySQLViewerLite source code to the following place.
lib/Mojolicious/Plugin/MySQLViewerLite.pm