line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package Interchange6::Schema::Populate::StateLocale; |
2
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
=head1 NAME |
4
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
Interchange6::Schema::Populate::StateLocale |
6
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
=head1 DESCRIPTION |
8
|
|
|
|
|
|
|
|
9
|
|
|
|
|
|
|
This role provides population capabilities for the State class |
10
|
|
|
|
|
|
|
|
11
|
|
|
|
|
|
|
=cut |
12
|
|
|
|
|
|
|
|
13
|
4
|
|
|
4
|
|
2227
|
use Moo::Role; |
|
4
|
|
|
|
|
10
|
|
|
4
|
|
|
|
|
47
|
|
14
|
4
|
|
|
4
|
|
1662
|
use Locale::SubCountry; |
|
4
|
|
|
|
|
10
|
|
|
4
|
|
|
|
|
1191
|
|
15
|
|
|
|
|
|
|
|
16
|
|
|
|
|
|
|
=head1 METHODS |
17
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
=head2 populate_states |
19
|
|
|
|
|
|
|
|
20
|
|
|
|
|
|
|
Returns array reference containing one hash reference per state, |
21
|
|
|
|
|
|
|
ready to use with populate schema method. |
22
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
=cut |
24
|
|
|
|
|
|
|
|
25
|
|
|
|
|
|
|
sub populate_states { |
26
|
3
|
|
|
3
|
1
|
152
|
my $self = shift; |
27
|
|
|
|
|
|
|
|
28
|
3
|
|
|
|
|
23
|
my $countries = |
29
|
|
|
|
|
|
|
$self->schema->resultset('Country')->search( { -bool => 'show_states' } ); |
30
|
|
|
|
|
|
|
|
31
|
3
|
|
|
|
|
2011
|
while ( my $country_result = $countries->next ) { |
32
|
|
|
|
|
|
|
|
33
|
6
|
|
|
|
|
26541
|
my $country = |
34
|
|
|
|
|
|
|
Locale::SubCountry->new( $country_result->country_iso_code ); |
35
|
|
|
|
|
|
|
|
36
|
|
|
|
|
|
|
# should never happen so let Devel::Cover watch it for us |
37
|
|
|
|
|
|
|
# uncoverable branch true |
38
|
6
|
50
|
|
|
|
424
|
next unless $country->has_sub_countries; |
39
|
|
|
|
|
|
|
|
40
|
6
|
|
|
|
|
98
|
my %country_states_keyed_by_code = $country->code_full_name_hash; |
41
|
|
|
|
|
|
|
|
42
|
6
|
|
|
|
|
462
|
foreach my $state_code ( sort keys %country_states_keyed_by_code ) { |
43
|
|
|
|
|
|
|
|
44
|
|
|
|
|
|
|
# some US 'states' are not actually states of the US |
45
|
|
|
|
|
|
|
next |
46
|
210
|
100
|
100
|
|
|
768994
|
if ( $country_result->country_iso_code eq 'US' |
47
|
|
|
|
|
|
|
&& $state_code =~ /(AS|GU|MP|PR|UM|VI)/ ); |
48
|
|
|
|
|
|
|
|
49
|
192
|
|
|
|
|
4115
|
my $state_name = $country_states_keyed_by_code{$state_code}; |
50
|
|
|
|
|
|
|
|
51
|
|
|
|
|
|
|
# remove (Junk) from some records |
52
|
192
|
|
|
|
|
483
|
$state_name =~ s/\s*\([^)]*\)//g; |
53
|
|
|
|
|
|
|
|
54
|
192
|
|
|
|
|
906
|
$country_result->create_related( |
55
|
|
|
|
|
|
|
'states', |
56
|
|
|
|
|
|
|
{ |
57
|
|
|
|
|
|
|
'name' => $state_name, |
58
|
|
|
|
|
|
|
'state_iso_code' => $state_code, |
59
|
|
|
|
|
|
|
} |
60
|
|
|
|
|
|
|
); |
61
|
|
|
|
|
|
|
} |
62
|
|
|
|
|
|
|
} |
63
|
|
|
|
|
|
|
} |
64
|
|
|
|
|
|
|
|
65
|
|
|
|
|
|
|
1; |