| 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; |