| 1 | package Qudo::Driver::Skinny::Schema; | ||
| 2 | |||
| 3 | use strict; | ||
| 4 | use warnings; | ||
| 5 | |||
| 6 | use DBIx::Skinny::Schema; | ||
| 7 | |||
| 8 | install_table job => schema { | ||
| 9 | pk 'id'; | ||
| 10 | columns qw/id func_id arg uniqkey enqueue_time grabbed_until run_after retry_cnt priority/; | ||
| 11 | |||
| 12 | trigger pre_insert => callback { | ||
| 13 | my ($class, $args) = @_; | ||
| 14 | $args->{enqueue_time} ||= time; | ||
| 15 | $args->{grabbed_until} ||= 0; | ||
| 16 | $args->{retry_cnt} ||= 0; | ||
| 17 | $args->{priority} ||= 0; | ||
| 18 | $args->{run_after} = time + ($args->{run_after}||0); | ||
| 19 | }; | ||
| 20 | |||
| 21 | trigger pre_update => callback { | ||
| 22 | my ($class, $args) = @_; | ||
| 23 | $args->{enqueue_time} = time; | ||
| 24 | $args->{run_after} = time + (delete $args->{retry_delay}||0); | ||
| 25 | }; | ||
| 26 | }; | ||
| 27 | |||
| 28 | install_table func => schema { | ||
| 29 | pk 'id'; | ||
| 30 | columns qw/id name/; | ||
| 31 | }; | ||
| 32 | |||
| 33 | install_table exception_log => schema { | ||
| 34 | pk 'id'; | ||
| 35 | columns qw/id func_id message arg exception_time retried/; | ||
| 36 | |||
| 37 | trigger pre_insert => callback { | ||
| 38 | my ($class, $args) = @_; | ||
| 39 | $args->{exception_time} ||= time; | ||
| 40 | $args->{retried} = 0; | ||
| 41 | }; | ||
| 42 | }; | ||
| 43 | |||
| 44 | install_table job_status => schema { | ||
| 45 | pk 'id'; | ||
| 46 | columns qw/id func_id arg uniqkey status job_start_time job_end_time/; | ||
| 47 | }; | ||
| 48 | |||
| 49 | 1; | ||
| 50 |