Mojolicious::Plugin::SQLiteViewerLite - Mojolicious plugin to display SQLite database information on browser
Mojolicious::Plugin::SQLiteViewerLite 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-SQLiteViewerLite
# Mojolicious::Lite # (dbh is a database handle already connected to the database) plugin 'SQLiteViewerLite', dbh => $dbh; # Mojolicious $app->plugin('SQLiteViewerLite', dbh => $dbh); # Access http://localhost:3000/sqliteviewerlite # Prefix plugin 'SQLiteViewerLite', dbh => $dbh, prefix => 'sqliteviewerlite2'; # Route my $bridge = $app->route->under(sub {...}); plugin 'SQLiteViewerLite', dbh => $dbh, route => $bridge; # Using connection manager object instead of "dbh" plugin 'SQLiteViewerLite', connector => DBIx::Connector->connect(...); # Using DBIx::Custom object instead of "dbh" plugin 'SQLiteViewerLite', dbi => DBIx::Custom->connect(...);
Mojolicious::Plugin::SQLiteViewerLite is Mojolicious plugin to display SQLite database information on browser.
Mojolicious::Plugin::SQLiteViewerLite have the following features.
Display all table names
Display show create table
show create table
Select * from TABLE
Display primary keys and null allowed columnes in all tables.
primary keys
null allowed columnes
connector
connector => $connector
Connector object such as DBIx::Connector to connect to database. You can use this instead of dbh option.
dbh
my $connector = DBIx::Connector->connect(...);
Connector has dbh method to get database handle
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 => 'sqliteviewerlite2'
Application base path, default to sqliteviewerlite.
sqliteviewerlite
route
route => $route
Router, default to $app-routes>.
$app-
It is useful when under is used.
under
my $bridge = $r->under(sub {...}); plugin 'SQLiteViewerLite', dbh => $dbh, route => $bridge;
To install Mojolicious::Plugin::SQLiteViewerLite, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Mojolicious::Plugin::SQLiteViewerLite
CPAN shell
perl -MCPAN -e shell install Mojolicious::Plugin::SQLiteViewerLite
For more information on module installation, please visit the detailed CPAN module installation guide.