The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

 / 
Mojolicious-Plugin-MySQLViewerLite-0.17
River stage zero No dependents
/ Mojolicious::Plugin::MySQLViewerLite

NAME

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

CAUTION

Mojolicious::Plugin::MySQLViewerLite is merged into Mojolicious::Plugin::DBViewer.

This module is DEPRECATED and will be removed from CPAN in 2018/4/1.

But you get it on github.


            

              
              
https://github.com/yuki-kimoto/Mojolicious-Plugin-MySQLViewerLite

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;