FusqlFS/Backend/MySQL/Variables.pm untested

filter: Statementstmt 0.0% 0 / 25 Branchbran 0.0% 0 / 4 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 6 Podpod 0.0% 0 / 2 totaltotal 0.0% 0 / 37 CC 3 SCAR 13.9
CC
3
Cov
0%
get
6.0
store
6.0
BEGIN
2.0
CRAP 4.0
1 use strict;
2 use 5.010;
3  
4 package FusqlFS::Backend::MySQL::Variables;
5 use FusqlFS::Version;
6 our $VERSION = $FusqlFS::Version::VERSION;
7 use parent 'FusqlFS::Artifact';
8  
9 =head1 NAME
10  
11 FusqlFS::Backend::MySQL::Variables - expose all MySQL variables
12  
13 =head1 SYNOPSIS
14  
15 =head1 DESCRIPTION
16  
17 =head1 EXPOSED STRUCTURE
18  
19 =cut
20  
21 sub get
22 {
23 my $self = shift;
24 my $name = shift;
25 my %vars = map { $_->{Variable_name} => $_->{Value} } @{$self->all_row('SHOW VARIABLES')};
26 return $name? $vars{$name}: $self->dump(\%vars);
27 }
28  
29 sub store
30 {
31 my $self = shift;
32 my $data = $self->load(shift);
33 return unless $data;
34  
35 foreach my $varname (keys %$data) {
36 $self->do('SET `%s` = ?', [$varname], $data->{$varname});
37 }
38 }
39  
40 1;