add more extraction types to all databases

[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / SQLMaker / MSSQL.pm

package # Hide from PAUSE
  DBIx::Class::SQLMaker::MSSQL;

use base qw( DBIx::Class::SQLMaker );

#
# MSSQL does not support ... OVER() ... RNO limits
#
sub _rno_default_order {
  return \ '(SELECT(1))';
}

{
  my %part_map = (
     year         => 'year',
     quarter      => 'quarter',
     month        => 'month',
     day_of_year  => 'dayofyear',
     day_of_month => 'day',
     week         => 'week',
     day_of_week  => 'weekday',
     hour         => 'hour',
     minute       => 'minute',
     second       => 'second',
     millisecond  => 'millisecond',
  );

  my %diff_part_map = %part_map;
  $diff_part_map{day} = delete $diff_part_map{day_of_year};
  delete $diff_part_map{day_of_month};
  delete $diff_part_map{day_of_week};

  sub _datetime_sql { "DATEPART('$part_map{$_[1]}', $_[2])" }
  sub _datetime_diff_sql { "DATEDIFF('$diff_part_map{$_[1]}', $_[2], $_[3])" }
}


1;