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