MySQL-Warmer

 view release on metacpan or  search on metacpan

lib/MySQL/Warmer/CLI.pm  view on Meta::CPAN

    my $user =
        exists $opt{user} ? delete $opt{user} :
        exists $ENV{USER} ? $ENV{USER}        : '';
    my $password = exists $opt{password} ? delete $opt{password} : '';
    my $dsn = $class->_build_dsn(%opt);
    my @dsn = ($dsn, $user, $password, {
        RaiseError          => 1,
        PrintError          => 0,
        ShowErrorStatement  => 1,
        AutoInactiveDestroy => 1,
        mysql_enable_utf8   => 1,
    });

    (+{
        dsn => \@dsn,
        $dry_run ? (dry_run => 1) : (),
    }, \@ARGV);
}

sub _build_dsn {
    my ($self, %args) = @_;

xt/01_basic.t  view on Meta::CPAN

      'skip-networking' => '',
    }
) or plan skip_all => $Test::mysqld::errstr;

my @connect_info = ($mysqld->dsn(dbname => 'test'));
$connect_info[3] = {
    RaiseError          => 1,
    PrintError          => 0,
    ShowErrorStatement  => 1,
    AutoInactiveDestroy => 1,
    mysql_enable_utf8   => 1,
};
my $dbh = DBI->connect(@connect_info);

$dbh->do(q[CREATE TABLE `test1` (
  `id` BIGINT unsigned NOT NULL auto_increment,
  `event_id` INTEGER NOT NULL,
  PRIMARY KEY (`id`, `event_id`)
)]);

$dbh->do(q[CREATE TABLE `test2` (



( run in 0.242 second using v1.01-cache-2.11-cpan-1dc43b0fbd2 )