NAME

Mojolicious::Plugin::MySQLViewerLite - Mojolicious plugin to display MySQL database information on browser

SYNOPSYS

  # Mojolicious::Lite
  # (dbh is a database handle already connected to the database)
  plugin 'MySQLViewerLite', dbh => $dbh;

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

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

  # Route
  my $bridge = $app->route->under(sub {...});
  plugin 'MySQLViewerLite', dbh => $dbh, route => $bridge;

  # Using connection manager object instead of "dbh"
  plugin 'MySQLViewerLite', connector => DBIx::Connector->connect(...);

  # Using DBIx::Custom object instead of "dbh"
  plugin 'MySQLViewerLite', dbi => DBIx::Custom->connect(...);

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

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

OPTIONS

connector

  connector => $connector

Connector object such as DBIx::Connector to connect to database. You can use this instead of dbh option.

  my $connector = DBIx::Connector->connect(...);

Connector has dbh method to get database handle

dbh

  dbh => $dbh

dbh is a DBI database handle already connected to the database.

  my $dbh = DBI->connect(...);

dbi

  dbi => DBIx::Custom->connect(...);

DBIx::Custom object. you can use this instead of dbh option.

prefix

  prefix => 'mysqlviewerlite2'

Application base path, default to mysqlviewerlite.

route

    route => $route

Router, default to $app-routes>.

It is useful when under is used.

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