NAME

Mojolicious::Plugin::MySQLViewerLite - Mojolicious plugin to display mysql database information

SYNOPSYS

  # Mojolicious::Lite
  plugin 'MySQLViewerLite', dbh => $dbh;

  # Mojolicious
  $app->plugin('MySQLViewerLite', dbh => $dbh);

  # Access
  http://localhost:3000/mysqlviewerlite
  
  # Prefix
  plugin 'MySQLViewerLite', dbh => $dbh, prefix => 'mysqlviewerlite2';

DESCRIPTION

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

• Select * from TABLE limit 0, 1000

• Display primary keys, null allowed columnes, and database engines in all tables.

OPTIONS

dbh

  dbh => $dbh

Database handle object in DBI.

prefix

  prefix => 'mysqlviewerlite2'

Application base path, default to mysqlviewerlite.

    route => $route

Router, default to $app-routes>.

It is useful when under is used.

  my $b = $r->under(sub { ... });
  plugin 'MySQLViewerLite', dbh => $dbh, route => $b;