1 package DBIx::Class::SQLMaker::DateOps;
4 Class::Accessor::Grouped
6 __PACKAGE__->mk_group_accessors (simple => qw/datetime_parser/);
7 use Carp::Clan qw/^DBIx::Class|^SQL::Abstract|^Try::Tiny/;
8 use Sub::Name 'subname';
10 sub _where_op_CONVERT_DATETIME {
12 my ($op, $rhs) = splice @_, -2;
13 croak "-$op takes a DateTime only" unless ref $rhs && $rhs->isa('DateTime');
15 # in case we are called as a top level special op (no '=')
18 $rhs = $self->datetime_parser->format_datetime($rhs);
21 ($lhs || $self->{_nested_func_lhs} || undef),
27 $self->_convert($self->_quote($lhs)) . ' = ' . $self->_convert('?'),
37 sub _unsupported_date_extraction {
38 "date part extraction not supported for part \"$_[1]\" with database \"$_[2]\""
41 sub _unsupported_date_adding {
42 "date part adding not supported for part \"$_[1]\" with database \"$_[2]\""
45 sub _unsupported_date_diff {
46 "date diff not supported for part \"$_[1]\" with database \"$_[2]\""
49 sub _datetime_sql { die 'date part extraction not implemented for this database' }
51 sub _datetime_diff_sql { die 'date diffing not implemented for this database' }
52 sub _datetime_add_sql { die 'date adding not implemented for this database' }
54 sub _where_op_GET_DATETIME {
69 croak 'args to -dt_get must be an arrayref' unless ref $vals eq 'ARRAY';
70 croak 'first arg to -dt_get must be a scalar' unless !ref $vals->[0];
72 my $part = $vals->[0];
75 my ($sql, @bind) = $self->_SWITCH_refkind($val, {
77 return ($self->_convert('?'), $self->_bindtype($k, $val) );
83 my ($sql, @bind) = @$$val;
84 $self->_assert_bindval_matches_bindtype(@bind);
88 my $method = $self->_METHOD_FOR_refkind("_where_hashpair", $val);
89 $self->$method('', $val);
93 return $self->_datetime_sql($part, $sql), @bind;
96 for my $part (qw(month year hour minute second)) {
98 my $name = '_where_op_GET_DATETIME_' . uc($part);
99 *{$name} = subname "DBIx::Class::SQLMaker::DateOps::$name", sub {
101 my ($op, $rhs) = splice @_, -2;
105 return $self->_where_op_GET_DATETIME($op, $lhs, [$part, $rhs])
109 sub _where_op_GET_DATETIME_DAY {
111 my ($op, $rhs) = splice @_, -2;
115 return $self->_where_op_GET_DATETIME($op, $lhs, [day_of_month => $rhs])
118 sub _where_op_DATETIME_NOW {
133 croak "args to -$op must be an arrayref" unless ref $vals eq 'ARRAY';
134 if (!exists $vals->[0]) {
135 return $self->_datetime_now_sql()
136 } elsif ($vals->[0] eq 'system') {
138 return $self->_where_op_CONVERT_DATETIME('dt', DateTime->now);
140 croak "first arg to -$op must be a 'system' or non-existant"
144 sub _reorder_add_datetime_vars {
145 my ($self, $amount, $date) = @_;
147 return ($amount, $date);
150 sub _where_op_ADD_DATETIME {
165 croak "args to -$op must be an arrayref" unless ref $vals eq 'ARRAY';
166 croak "first arg to -$op must be a scalar" unless !ref $vals->[0];
167 croak "-$op must have two more arguments" unless scalar @$vals == 3;
169 my ($part, @rest) = @$vals;
171 my $placeholder = $self->_convert('?');
173 my (@all_sql, @all_bind);
174 foreach my $val ($self->_reorder_add_datetime_vars(@rest)) {
175 my ($sql, @bind) = $self->_SWITCH_refkind($val, {
177 return ($placeholder, $self->_bindtype($k, $val) );
183 my ($sql, @bind) = @$$val;
184 $self->_assert_bindval_matches_bindtype(@bind);
185 return ($sql, @bind);
188 my $method = $self->_METHOD_FOR_refkind("_where_hashpair", $val);
189 $self->$method('', $val);
193 push @all_bind, @bind;
196 return $self->_datetime_add_sql($part, $all_sql[0], $all_sql[1]), @all_bind
199 sub _where_op_DIFF_DATETIME {
214 croak 'args to -dt_diff must be an arrayref' unless ref $vals eq 'ARRAY';
215 croak 'first arg to -dt_diff must be a scalar' unless !ref $vals->[0];
216 croak '-dt_diff must have two more arguments' unless scalar @$vals == 3;
218 my ($part, @val) = @$vals;
219 my $placeholder = $self->_convert('?');
221 my (@all_sql, @all_bind);
222 foreach my $val (@val) {
223 my ($sql, @bind) = $self->_SWITCH_refkind($val, {
225 return ($placeholder, $self->_bindtype($k, $val) );
231 my ($sql, @bind) = @$$val;
232 $self->_assert_bindval_matches_bindtype(@bind);
233 return ($sql, @bind);
236 my $method = $self->_METHOD_FOR_refkind("_where_hashpair", $val);
237 $self->$method('', $val);
241 push @all_bind, @bind;
244 return $self->_datetime_diff_sql($part, $all_sql[0], $all_sql[1]), @all_bind