| 1 | use strict; | ||
| 2 | use 5.010; | ||
| 3 | |||
| 4 | package FusqlFS::Backend::MySQL::Table::Data; | ||
| 5 | use FusqlFS::Version; | ||
| 6 | our $VERSION = $FusqlFS::Version::VERSION; | ||
| 7 | use parent 'FusqlFS::Artifact::Table::Data'; | ||
| 8 | |||
| 9 | =head1 NAME | ||
| 10 | |||
| 11 | FusqlFS::Backend::MySQL::Table::Data - | ||
| 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->SUPER::init(); | ||
| 25 | |||
| 26 | $self->{field_quote} = '`'; | ||
| 27 | $self->{get_primary_expr} = 'SHOW INDEX FROM `%s` WHERE Key_name = "PRIMARY"'; | ||
| 28 | } | ||
| 29 | |||
| 30 | sub get_primary_key | ||
| 31 | { | ||
| 32 | my $self = shift; | ||
| 33 | my ($table) = @_; | ||
| 34 | my @result = (); | ||
| 35 | my $data = $self->all_row($self->{get_primary_expr}, [$table]); | ||
| 36 | if ($data) | ||
| 37 | { | ||
| 38 | @result = map { $_->{Column_name} } @$data; | ||
| 39 | } | ||
| 40 | return @result; | ||
| 41 | } | ||
| 42 | |||
| 43 | sub concat | ||
| 44 | { | ||
| 45 | shift @_; | ||
| 46 | my $instance = $FusqlFS::Artifact::instance; | ||
| 47 | return "CONCAT_WS('$instance->{fnsep}', `" . join('`, `', @_) . "`)"; | ||
| 48 | } | ||
| 49 | |||
| 50 | 1; |