App-DoubleUp
view release on metacpan or search on metacpan
lib/App/DoubleUp.pm view on Meta::CPAN
return $self->{files};
}
sub run {
my ($self) = @_;
STDOUT->autoflush(1);
given ($self->command) {
when ('version') {
say "doubleup version $VERSION";
}
when ('listdb') {
my @db = $self->list_of_schemata();
for (@db) {
say;
}
}
when ('import') {
my @querys = $self->process_files($self->files);
for my $schema (@{ $self->database_names }) {
my $dsn = 'dbi:mysql:'.$schema;
say "DB: $schema";
my $db = $self->connect_to_db($dsn, $self->credentials);
$self->process_querys_for_one_db($db, \@querys);
say '';
}
}
when (undef) {
$self->usage;
}
default {
say "Unknown command: $_";
$self->usage;
}
}
return;
}
sub usage {
my $self = shift;
say "Usage: doubleup [command] [options]";
say "";
say "List of commands";
say "";
say " listdb list of schemata";
say " import [filename] import a file into each db";
say " import1 [db] [filename] import a file into one db";
say " version show version";
say "";
return;
}
1;
=head1 NAME
App::DoubleApp - Import SQL files into MySQL
=head1 SYNOPSIS
( run in 3.238 seconds using v1.01-cache-2.11-cpan-d7a12ab2c7f )