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