Mojolicious-Plugin-DBViewer

 view release on metacpan or  search on metacpan

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  
  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ] 
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  my $tables = $command->show_tables($database);
  
  return $self->render(
    database => $database,
    tables => $tables
  );
}

sub table {

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
    table => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  my $table = $vresult->data->{table};
  
  my $table_def = $command->show_create_table($database, $table);

  return $self->render(
    database => $database,
    table => $table, 
    table_def => $table_def,
  );

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  my $tables = $command->show_tables($database);
  
  # Get create tables
  my $create_tables = {};
  for my $table (@$tables) {
    $create_tables->{$table} = $plugin->command->show_create_table($database, $table);
  }
  
  $self->render(

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  my $tables = $command->show_tables($database);
  
  $self->render(
    database => $database,
    tables => $tables
  );
}

sub showprimarykeys {

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Get primary keys
  my $primary_keys = $command->show_primary_keys($database);
  
  $self->render(
    database => $database,
    primary_keys => $primary_keys
  );
}

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Get null allowed columns
  my $null_allowed_columns = $command->show_null_allowed_columns($database);
  
  $self->render(
    database => $database,
    null_allowed_columns => $null_allowed_columns
  );
}

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

    page => {default => 1} => [
      'uint'
    ],
    c1 => [
      'safety_name'
    ],
    v1 => [
      'not_blank'
    ]
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  my $table = $vresult->data->{table};
  
  # Where
  my $column = $vresult->data->{c1};
  my $value = $vresult->data->{v1};
  
  my $where;
  if (defined $column && defined $value) {
    $where = $plugin->dbi->where;

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Get primary keys
  my $database_engines = $command->show_database_engines($database);
  
  $self->stash->{template} = 'mysqlviewerlite/showdatabaseengines'
    unless $self->stash->{template};

  $self->render(
    database => $database,

lib/Mojolicious/Plugin/DBViewer/MySQL.pm  view on Meta::CPAN

  my $plugin = $self->stash->{plugin};
  my $command = $plugin->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Get primary keys
  my $charsets = $command->show_charsets($database);
  
  $self->stash->{template} = 'mysqlviewerlite/showcharsets'
    unless $self->stash->{template};

  $self->render(
    database => $database,

lib/Mojolicious/Plugin/DBViewer/public/js/bootstrap.js  view on Meta::CPAN

    }

  , tip: function () {
      return this.$tip = this.$tip || $(this.options.template)
    }

  , arrow: function(){
      return this.$arrow = this.$arrow || this.tip().find(".tooltip-arrow")
    }

  , validate: function () {
      if (!this.$element[0].parentNode) {
        this.hide()
        this.$element = null
        this.options = null
      }
    }

  , enable: function () {
      this.enabled = true
    }

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/charsets.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  
  # Database
  my $database = $vresult->data->{database};
  
  # Charsets
  my $charsets = $command->show_charsets($database);
%>

% layout 'dbviewer_common', title => "Charsets in $database ";
  % my $tables = [sort keys %$charsets];

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/create-tables.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  
  # Database
  my $database = $vresult->data->{database};
  
  # Table
  my $tables = $command->show_tables($database);
  
  # Create tables
  my $create_tables = {};
  for my $table (@$tables) {

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/database-engines.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;
  
  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  
  # Database
  my $database = $vresult->data->{database};
  
  # Primary keys
  my $database_engines = $command->show_database_engines($database);
%>

% layout 'dbviewer_common', title => "Database engines in $database ";
  % my $tables = [sort keys %$database_engines];

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/null-allowed-columns.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $plugin->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Null allowed columns
  my $null_allowed_columns = $command->show_null_allowed_columns($database);
%>

% layout 'dbviewer_common', title => "Null allowed columns in $database";

  % my $tables = [sort keys %$null_allowed_columns];
  %= include '/dbviewer/navi';

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/primary-keys.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  my $database = $vresult->data->{database};
  
  # Primary keys
  my $primary_keys = $command->show_primary_keys($database);
%>

% layout 'dbviewer_common', title => "Primary keys in $database";

  % my $tables = [sort keys %$primary_keys];
  %= include '/dbviewer/navi';

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/select-statements.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  
  # Database
  my $database = $vresult->data->{database};

  # Tables
  my $tables = $command->show_tables($database);
%>

% layout 'dbviewer_common', title => "Show select tables in $database";

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/select.html.ep  view on Meta::CPAN

    so2 => [
      'any'
    ],
    u => {default => 'and'} => [
      {in_array => ['and', 'or']}
    ],
    j => [
      'any'
    ]
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  my $vparams = $vresult->data;
  my $database = $vparams->{database};
  my $table = $vparams->{table};
  my $join_mode = $vparams->{j};
  
  # Paramters

  # DBI
  my $dbi = $dbviewer->dbi;
  

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/table.html.ep  view on Meta::CPAN

  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ],
    table => {default => ''} => [
      'safety_name'
    ]
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  
  # Database
  my $database = $vresult->data->{database};
  
  # Table
  my $table = $vresult->data->{table};
  my $table_def = $command->show_create_table($database, $table);
%>

% layout 'dbviewer_common';

lib/Mojolicious/Plugin/DBViewer/templates/dbviewer/auto/tables.html.ep  view on Meta::CPAN

  # Command
  my $command = $dbviewer->command;
  
  # Validation
  my $params = $command->params($self);
  my $rule = [
    database => {default => ''} => [
      'safety_name'
    ] 
  ];
  my $vresult = $dbviewer->validator->validate($params, $rule);
  
  
  # Database
  my $database = $vresult->data->{database};
  
  # Table
  my $tables = $command->show_tables($database);
%>

% layout 'dbviewer_common', title => "Tables in $database";