Class: ReportsKit::Reports::Adapters::Mysql

Inherits:
Object
  • Object
show all
Defined in:
lib/reports_kit/reports/adapters/mysql.rb

Class Method Summary collapse

Class Method Details

.truncate_to_day(column) ⇒ Object 



5
6
7
 
# File 'lib/reports_kit/reports/adapters/mysql.rb', line 5

def self.truncate_to_day(column)
  "DATE(#{column})"
end

.truncate_to_week(column) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
 
# File 'lib/reports_kit/reports/adapters/mysql.rb', line 9

def self.truncate_to_week(column)
  case ReportsKit.configuration.first_day_of_week
  when :sunday
    "DATE_SUB(DATE(#{column}), INTERVAL DAYOFWEEK(#{column}) - 1 DAY)"
  when :monday
    "DATE_SUB(DATE(#{column}), INTERVAL DAYOFWEEK(#{column}) - 2 DAY)"
  else
    raise ArgumentError.new("Unsupported first_day_of_week: #{ReportsKit.configuration.first_day_of_week}")
  end
end