| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
package Google::Fusion::Result; |
|
2
|
1
|
|
|
1
|
|
31
|
use 5.006; |
|
|
1
|
|
|
|
|
4
|
|
|
|
1
|
|
|
|
|
44
|
|
|
3
|
1
|
|
|
1
|
|
8
|
use Moose; |
|
|
1
|
|
|
|
|
1
|
|
|
|
1
|
|
|
|
|
11
|
|
|
4
|
1
|
|
|
1
|
|
7752
|
use Carp; |
|
|
1
|
|
|
|
|
3
|
|
|
|
1
|
|
|
|
|
471
|
|
|
5
|
|
|
|
|
|
|
|
|
6
|
|
|
|
|
|
|
=head1 NAME |
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
Google::Fusion::Result - A Query result |
|
9
|
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
=head1 VERSION |
|
11
|
|
|
|
|
|
|
|
|
12
|
|
|
|
|
|
|
Version 0.03 |
|
13
|
|
|
|
|
|
|
|
|
14
|
|
|
|
|
|
|
=cut |
|
15
|
|
|
|
|
|
|
|
|
16
|
|
|
|
|
|
|
our $VERSION = '0.03'; |
|
17
|
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
=head1 SYNOPSIS |
|
20
|
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
my $fusion = Google::Fusion->new( %fusion_params ); |
|
22
|
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
# Get the result for a query |
|
24
|
|
|
|
|
|
|
my $result = $fusion->query( $sql ); |
|
25
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
# Print out the rows returned |
|
27
|
|
|
|
|
|
|
foreach( @{ $result->rows } ){ |
|
28
|
|
|
|
|
|
|
print join( ',', @{ $_ } ) . "\n"; |
|
29
|
|
|
|
|
|
|
} |
|
30
|
|
|
|
|
|
|
|
|
31
|
|
|
|
|
|
|
=head1 PARAMS/ACCESSORS |
|
32
|
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
=over 2 |
|
34
|
|
|
|
|
|
|
|
|
35
|
|
|
|
|
|
|
=item * query <Str> |
|
36
|
|
|
|
|
|
|
|
|
37
|
|
|
|
|
|
|
The query string |
|
38
|
|
|
|
|
|
|
|
|
39
|
|
|
|
|
|
|
=item * response <HTTP::Response> |
|
40
|
|
|
|
|
|
|
|
|
41
|
|
|
|
|
|
|
The response object associated with the query |
|
42
|
|
|
|
|
|
|
|
|
43
|
|
|
|
|
|
|
=item * error <Str> |
|
44
|
|
|
|
|
|
|
|
|
45
|
|
|
|
|
|
|
Error string, if an error occurred |
|
46
|
|
|
|
|
|
|
|
|
47
|
|
|
|
|
|
|
=item * num_columns <Int> |
|
48
|
|
|
|
|
|
|
|
|
49
|
|
|
|
|
|
|
Number of columns the result has |
|
50
|
|
|
|
|
|
|
|
|
51
|
|
|
|
|
|
|
=item * num_rows <Int> |
|
52
|
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
Number of rows this result has (excluding headers). |
|
54
|
|
|
|
|
|
|
|
|
55
|
|
|
|
|
|
|
=item * max_lengths <ArrayRef[Int]> |
|
56
|
|
|
|
|
|
|
|
|
57
|
|
|
|
|
|
|
Array of the maximum lengths of fields for each column |
|
58
|
|
|
|
|
|
|
|
|
59
|
|
|
|
|
|
|
=item * has_headers <Bool> |
|
60
|
|
|
|
|
|
|
|
|
61
|
|
|
|
|
|
|
True if this result has headers |
|
62
|
|
|
|
|
|
|
|
|
63
|
|
|
|
|
|
|
=item * query_time <Num> |
|
64
|
|
|
|
|
|
|
|
|
65
|
|
|
|
|
|
|
Seconds (using Time::HiRes) the query took |
|
66
|
|
|
|
|
|
|
|
|
67
|
|
|
|
|
|
|
=item * auth_time <Num> |
|
68
|
|
|
|
|
|
|
|
|
69
|
|
|
|
|
|
|
Seconds (using Time::HiRes) the authentication part of the query took |
|
70
|
|
|
|
|
|
|
|
|
71
|
|
|
|
|
|
|
=item * total_time <Num> |
|
72
|
|
|
|
|
|
|
|
|
73
|
|
|
|
|
|
|
Total time for the query |
|
74
|
|
|
|
|
|
|
|
|
75
|
|
|
|
|
|
|
=item * rows <ArrayRef[ArrayRef]> |
|
76
|
|
|
|
|
|
|
|
|
77
|
|
|
|
|
|
|
The actual results |
|
78
|
|
|
|
|
|
|
|
|
79
|
|
|
|
|
|
|
=item * columns <ArrayRef> |
|
80
|
|
|
|
|
|
|
|
|
81
|
|
|
|
|
|
|
The column names (if has_headers is true). |
|
82
|
|
|
|
|
|
|
|
|
83
|
|
|
|
|
|
|
=back |
|
84
|
|
|
|
|
|
|
|
|
85
|
|
|
|
|
|
|
=cut |
|
86
|
|
|
|
|
|
|
|
|
87
|
|
|
|
|
|
|
has 'query' => ( is => 'ro', isa => 'Str', required => 1 ); |
|
88
|
|
|
|
|
|
|
has 'response' => ( is => 'ro', isa => 'HTTP::Response', required => 1 ); |
|
89
|
|
|
|
|
|
|
has 'error' => ( is => 'rw', isa => 'Str', ); |
|
90
|
|
|
|
|
|
|
has 'num_columns' => ( is => 'rw', isa => 'Int', required => 1, default => 0 ); |
|
91
|
|
|
|
|
|
|
has 'num_rows' => ( is => 'rw', isa => 'Int', required => 1, default => 0 ); |
|
92
|
|
|
|
|
|
|
has 'max_lengths' => ( is => 'rw', isa => 'ArrayRef', required => 1, default => sub{ [] } ); |
|
93
|
|
|
|
|
|
|
has 'has_headers' => ( is => 'rw', isa => 'Bool', required => 1, default => 0 ); |
|
94
|
|
|
|
|
|
|
has 'query_time' => ( is => 'rw', isa => 'Num', required => 1, default => 0 ); |
|
95
|
|
|
|
|
|
|
has 'auth_time' => ( is => 'rw', isa => 'Num', required => 1, default => 0 ); |
|
96
|
|
|
|
|
|
|
has 'total_time' => ( is => 'rw', isa => 'Num', required => 1, default => 0 ); |
|
97
|
|
|
|
|
|
|
has 'rows' => ( |
|
98
|
|
|
|
|
|
|
is => 'rw', |
|
99
|
|
|
|
|
|
|
isa => 'ArrayRef[ArrayRef]', |
|
100
|
|
|
|
|
|
|
required => 1, |
|
101
|
|
|
|
|
|
|
default => sub{ [] }, |
|
102
|
|
|
|
|
|
|
trigger => sub{ $_[0]->num_rows( scalar( @{ $_[1] } ) ) }, |
|
103
|
|
|
|
|
|
|
); |
|
104
|
|
|
|
|
|
|
|
|
105
|
|
|
|
|
|
|
has 'columns' => ( |
|
106
|
|
|
|
|
|
|
is => 'rw', |
|
107
|
|
|
|
|
|
|
isa => 'ArrayRef', |
|
108
|
|
|
|
|
|
|
required => 1, |
|
109
|
|
|
|
|
|
|
default => sub{ [] }, |
|
110
|
|
|
|
|
|
|
trigger => sub{ $_[0]->num_columns( scalar( @{ $_[1] } ) ) }, |
|
111
|
|
|
|
|
|
|
); |
|
112
|
|
|
|
|
|
|
|
|
113
|
|
|
|
|
|
|
=head1 AUTHOR |
|
114
|
|
|
|
|
|
|
|
|
115
|
|
|
|
|
|
|
Robin Clarke, C<< <perl at robinclarke.net> >> |
|
116
|
|
|
|
|
|
|
|
|
117
|
|
|
|
|
|
|
=head1 LICENSE AND COPYRIGHT |
|
118
|
|
|
|
|
|
|
|
|
119
|
|
|
|
|
|
|
Copyright 2011 Robin Clarke. |
|
120
|
|
|
|
|
|
|
|
|
121
|
|
|
|
|
|
|
This program is free software; you can redistribute it and/or modify it |
|
122
|
|
|
|
|
|
|
under the terms of either: the GNU General Public License as published |
|
123
|
|
|
|
|
|
|
by the Free Software Foundation; or the Artistic License. |
|
124
|
|
|
|
|
|
|
|
|
125
|
|
|
|
|
|
|
See http://dev.perl.org/licenses/ for more information. |
|
126
|
|
|
|
|
|
|
|
|
127
|
|
|
|
|
|
|
|
|
128
|
|
|
|
|
|
|
=cut |
|
129
|
|
|
|
|
|
|
|
|
130
|
|
|
|
|
|
|
1; |