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