FusqlFS/Backend/MySQL/Table/Indices.pm untested

filter: Statementstmt 0.0% 0 / 72 Branchbran 0.0% 0 / 24 Conditioncond 0.0% 0 / 19 MC/DCmcdc 0.0% 0 / 11 Subroutinesub 0.0% 0 / 10 Podpod 0.0% 0 / 6 totaltotal 0.0% 0 / 142 CC 13 SCAR 34.2
CC
13
Cov
0%
store
56.0
get
42.0
list
6.0
CRAP 30.5
1 use strict;
2 use 5.010;
3  
4 package FusqlFS::Backend::MySQL::Table::Indices;
5 use FusqlFS::Version;
6 our $VERSION = $FusqlFS::Version::VERSION;
7 use parent 'FusqlFS::Artifact::Table::Lazy';
8  
9 =head1 NAME
10  
11 FusqlFS::Backend::MySQL::Table::Indices -
12  
13 =head1 SYNOPSIS
14  
15 =head1 DESCRIPTION
16  
17 =head1 EXPOSED STRUCTURE
18  
19 =cut
20  
21 sub init
22 {
23 my $self = shift;
24 $self->{template} = { '.order' => [] };
25 }
26  
27 sub list
28 {
29 my $self = shift;
30 my ($table) = @_;
31 my $data = $self->all_row('SHOW INDEX FROM `%s`', [$table]);
32 return unless $data;
33  
34 my %keys = map { $_->{Key_name} => 1 } @$data;
35 return [ keys %keys, @{$self->SUPER::list($table)} ];
36 }
37  
38 sub get
39 {
40 my $self = shift;
41 my ($table, $name) = @_;
42 unless ($self->SUPER::get($table, $name))
43 {
44 my $data = $self->all_row('SHOW INDEX FROM `%s` WHERE `Key_name` = ?', [$table], $name);
45 return unless $data && @$data;
46  
47 my $result = { '.order' => [] };
48 foreach my $item (@$data)
49 {
50 my $colname = $item->{Sub_part}? $self->ajoin($item->{Column_name}, $item->{Sub_part}): $item->{Column_name};
51 push @{$result->{'.order'}}, $item->{Column_name};
52  
53 $result->{$colname} = \"tables/$table/struct/$item->{Column_name}";
54 $result->{'.unique'} = 1 unless $item->{Non_unique};
55 $result->{'.type'} = $item->{Index_type};
56 $result->{'.primary'} = 1 if $item->{Key_name} =~ /^PRI/;
57 }
58  
59 return $result;
60 }
61 }
62  
63 sub rename
64 {
65 my $self = shift;
66 my ($table, $name, $newname) = @_;
67 my $data = $self->get($table, $name) or return;
68 $self->SUPER::rename($table, $name, $newname) or
69 $self->drop($table, $name) and $self->store($table, $newname, $data);
70 }
71  
72 sub drop
73 {
74 my $self = shift;
75 my ($table, $name) = @_;
76 $self->SUPER::drop($table, $name) or $self->do('ALTER TABLE `%s` DROP INDEX `%s`', [$table, $name]);
77 }
78  
79 sub store
80 {
81 my $self = shift;
82 my ($table, $name, $data) = @_;
83 my $struct = $self->validate($data, {
84 '-.primary' => '',
85 '-.unique' => '',
86 '-.type' => '',
87 '.order' => 'ARRAY',
88 }, sub{
89 my %columns = map { $self->asplit($_, 2) } grep !/^[.]/, keys %{$_[0]};
90 my @order = grep { exists $columns{$_} } @{$_->{'.order'}};
91  
92 my %order = map { $_ => 1 } @order;
93 foreach (keys %columns)
94 {
95 push @order, $_ unless exists $order{$_};
96 }
97 my $columns = join(',', map {
98 my $colname = "`$_`";
99 $colname .= "($columns{$_})" if $columns{$_};
100 $colname;
101 } @order);
102 $_->{'columns'} = $columns;
103 }) or return;
104  
105 $self->drop($table, $name) and $self->do('ALTER TABLE `%s` ADD %s KEY %s %s (%s)',
106 [
107 $table,
108 $struct->{'.primary'}? 'PRIMARY': ($struct->{'.unique'}? 'UNIQUE': ''),
109 $struct->{'.primary'}? '': "`$name`",
110 $struct->{'.type'}? 'USING '.$struct->{'.type'}: '',
111 $struct->{'columns'},
112 ]);
113 }
114  
115 1;
116