Class: ReportsKit::Reports::Adapters::Postgresql

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

Class Method Summary collapse

Class Method Details

.truncate_to_day(column) ⇒ Object 



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

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

.truncate_to_week(column) ⇒ Object 



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

def self.truncate_to_week(column)
  case ReportsKit.configuration.first_day_of_week
  when :sunday
    "DATE_TRUNC('week', #{column}::timestamp + '1 day'::interval) - '1 day'::interval"
  when :monday
    "DATE_TRUNC('week', #{column}::timestamp)"
  else
    raise ArgumentError.new("Unsupported first_day_of_week: #{ReportsKit.configuration.first_day_of_week}")
  end
end