已经过了几个小时了。
我试图将模型start_time (存储在UTC中)的查询模型与PG按日组分离。
我尝试过scope方法、实例方法的查询以及整体类方法。所有这些都按UTC返回日组(,而不是预定事件的本地时区)
# event.rb
def self.morning
startday = 0
midday = 12
Event.where("extract(hour from start_time) >= ? AND extract(hour from start_time) < ?", startday, midday)
end也试过了,
def self.afternoon
midday = "12:00:00"
eveday = "17:00:00"
Event.where("start_time::time >= ? AND start_time::time < ?", midday, eveday)
end当控制台提示(通常在整个应用程序中)调用event.start_time时,在本地时区(设置在application.rb文件中)中成功返回
但是,除非在模型之外调用,否则start_time继续以UTC的身份进行查询。
我不想预置DB时区(因为这是错误的做法,而且应用程序是全球使用的)
编辑
作为视图中的一个例子,我正在调用
<% events.morning.order("start_time ASC").each do |fit_class| %>
...哪里,
events = @events = Event.all # passed through a partial发布于 2018-02-28 10:14:39
只需添加带有时区检查的事件模型的作用域即可。
class Event < ApplicationRecord
scope :morning, -> { where(
"start_time >= ? AND start_time < ?",
formatted_time(0), formatted_time(12))
}
scope :afternoon, -> { where(
"start_time >= ? AND start_time < ?",
formatted_time(12), formatted_time(17))
}
scope :evening, -> { where(
"start_time >= ? AND start_time < ?",
formatted_time(17), formatted_time(24))
}
private
def formatted_time(hour = 0)
Time.zone.parse(Date.current.to_s).change(hour: hour)
end
end您不必修改此查询的任何其他时区设置。希望能帮上忙!
发布于 2018-02-27 17:20:01
对于旁观者来说,我的临时解决方案如下(对PostgreSQL文档的大量研究):
def self.morning
startday = 0
midday = 12
Event.where("extract(hour from start_time - interval '6 hours') >= ? AND extract(hour from start_time - interval '6 hours') < ?", startday, midday)
end
def self.afternoon
midday = 12
eveday = 17
Event.where("extract(hour from start_time - interval '6 hours') >= ? AND extract(hour from start_time - interval '6 hours') < ?", midday, eveday)
end
def self.evening
eveday = 17
endday = 24
Event.where("extract(hour from start_time - interval '6 hours') >= ? AND extract(hour from start_time - interval '6 hours') < ?", eveday, endday)
end这要求我预置应用程序时区。
# application.rb
config.time_zone = "Central Time (US & Canada)"我会更改后,全面解决方案的更新,当发现!
https://stackoverflow.com/questions/48997246
复制相似问题