blib/lib/Qudo/Driver/Skinny.pm untested

filter: Statementstmt 0.0% 0 / 109 Branchbran 0.0% 0 / 8 Conditioncond 0.0% 0 / 2 MC/DCmcdc 0.0% 0 / 1 Subroutinesub 0.0% 0 / 21 Podpod 0.0% 0 / 18 totaltotal 0.0% 0 / 159 CC 5 SCAR 11.9
CC
5
Cov
0%
enqueue
6.0
exception_list
6.0
job_status_list
6.0
CRAP 3.3
1 package Qudo::Driver::Skinny;
2  
3 use strict;
4 use warnings;
5  
6 use DBIx::Skinny;
7  
8 sub init_driver {
9 my ($class, $master) = @_;
10  
11 for my $database (@{$master->{databases}}) {
12 my $connection = $class->new($database);
13 $master->set_connection($database->{dsn}, $connection);
14 }
15 }
16  
17 sub lookup_job {
18 my ($self, $job_id) = @_;
19  
20 my $rs = $self->_search_job_rs(limit => 1);
21  
22 $rs->add_where('job.id' => $job_id);
23  
24 my $itr = $rs->retrieve('job');
25  
26 return $self->_get_job_data($itr);
27 }
28  
29 sub find_job {
30 my ($self, $limit, $func_ids) = @_;
31  
32 my $rs = $self->_search_job_rs(limit => $limit);
33  
34 $rs->add_where('job.func_id' => $func_ids);
35  
36 my $servertime = $self->get_server_time;
37 $rs->add_where('job.grabbed_until' => { '<=', => $servertime});
38 $rs->add_where('job.run_after' => { '<=', => $servertime});
39  
40 my $itr = $rs->retrieve('job');
41  
42 return $self->_get_job_data($itr);
43 }
44  
45 sub _search_job_rs {
46 my ($self, %args) = @_;
47  
48 my $rs = $self->resultset(
49 {
50 select => [qw/job.id job.arg job.uniqkey job.func_id job.grabbed_until job.retry_cnt job.priority/],
51 from => 'job',
52 limit => $args{limit},
53 }
54 );
55 $rs->order({column => 'job.priority', desc => 'DESC'});
56  
57 return $rs;
58 }
59  
60 sub _get_job_data {
61 my ($self, $itr) = @_;
62 sub {
63 my $job = $itr->next or return;
64 return +{
65 job_id => $job->id,
66 job_arg => $job->arg,
67 job_uniqkey => $job->uniqkey,
68 job_grabbed_until => $job->grabbed_until,
69 job_retry_cnt => $job->retry_cnt,
70 job_priority => $job->priority,
71 func_id => $job->func_id,
72 };
73 };
74 }
75  
76 sub grab_a_job {
77 my ($self, %args) = @_;
78  
79 return $self->update('job',
80 {
81 grabbed_until => $args{grabbed_until},
82 },
83 {
84 id => $args{job_id},
85 grabbed_until => $args{old_grabbed_until},
86 }
87 );
88  
89 }
90  
91 sub logging_exception {
92 my ($self, $args) = @_;
93 $self->insert('exception_log', $args);
94 return;
95 }
96  
97 sub set_job_status {
98 my ($self, $args) = @_;
99 $self->insert('job_status', $args);
100 return;
101 }
102  
103 sub get_server_time {
104 my $self = shift;
105 my $unixtime_sql = $self->dbd->sql_for_unixtime;
106 return $self->dbh->selectrow_array("SELECT $unixtime_sql");
107 }
108  
109 sub enqueue {
110 my ($self, $args) = @_;
111 my $job = $self->insert('job', $args);
112 return $job ? $job->id : undef;
113 }
114  
115 sub reenqueue {
116 my ($self, $job_id, $args) = @_;
117 $self->update('job', $args, {id => $job_id});
118 }
119  
120 sub dequeue {
121 my ($self, $args) = @_;
122 $self->delete('job', $args);
123 }
124  
125 sub func_from_name {
126 my ($self, $funcname) = @_;
127 my $row = $self->find_or_create('func',{ name => $funcname });
128 return { id => $row->id, name => $row->name };
129 }
130  
131 sub func_from_id {
132 my ($self, $funcid) = @_;
133 my $row = $self->single('func',{ id => $funcid });
134 return { id => $row->id, name => $row->name };
135 }
136  
137 sub retry_from_exception_log {
138 my ($self, $exception_log_id) = @_;
139  
140 $self->update('exception_log',
141 {
142 retried => 1,
143 },
144 {
145 id => $exception_log_id,
146 },
147 );
148 }
149  
150 sub exception_list {
151 my ($self, $args) = @_;
152  
153 my $rs = $self->resultset(
154 {
155 select => [qw/exception_log.id
156 exception_log.func_id
157 exception_log.exception_time
158 exception_log.message
159 exception_log.uniqkey
160 exception_log.arg
161 exception_log.retried
162 /],
163 from => [qw/exception_log/],
164 limit => $args->{limit},
165 offset => $args->{offset},
166 }
167 );
168  
169 if ($args->{funcs}) {
170 $rs->from([]);
171 $rs->add_join(
172 exception_log => {
173 type => 'inner',
174 table => 'func',
175 condition => 'exception_log.func_id = func.id',
176 }
177 );
178 $rs->add_where('func.name' => $args->{funcs});
179 }
180 my $itr = $rs->retrieve;
181  
182 my @exception_list;
183 while (my $row = $itr->next) {
184 push @exception_list, $row->get_columns;
185 }
186 return \@exception_list;
187 }
188  
189 sub job_status_list {
190 my ($self, $args) = @_;
191  
192 my $rs = $self->resultset(
193 {
194 select => [qw/job_status.id
195 job_status.func_id
196 job_status.arg
197 job_status.uniqkey
198 job_status.status
199 job_status.job_start_time
200 job_status.job_end_time
201 /],
202 from => [qw/job_status/],
203 limit => $args->{limit},
204 offset => $args->{offset},
205 }
206 );
207  
208 if ($args->{funcs}) {
209 $rs->from([]);
210 $rs->add_join(
211 job_status => {
212 type => 'inner',
213 table => 'func',
214 condition => 'job_status.func_id = func.id',
215 }
216 );
217 $rs->add_where('func.name' => $args->{funcs});
218 }
219 my $itr = $rs->retrieve;
220  
221 my @job_status_list;
222 while (my $row = $itr->next) {
223 push @job_status_list, $row->get_columns;
224 }
225 return \@job_status_list;
226 }
227  
228 sub job_count {
229 my ($self, $funcs) = @_;
230  
231 my $rs = $self->resultset(
232 {
233 from => [qw/job/],
234 }
235 );
236 $rs->add_select('COUNT(job.id)' => 'count');
237  
238 if ($funcs) {
239 $rs->from([]);
240 $rs->add_join(
241 job => {
242 type => 'inner',
243 table => 'func',
244 condition => 'job.func_id = func.id',
245 }
246 );
247 $rs->add_where('func.name' => $funcs);
248 }
249  
250 return $rs->retrieve->first->count;
251 }
252  
253 1;
254