sequel-tstzrange-fields

Easily work with Postgres tstzrange fields by setting the entire range, the start and end separately, using ranges, strings, {:begin, :end} hashes, objects that respond to #begin and #end, etc.

Range fields (tstzrange_fields plugin)

Defining a model class with a timestamptz range:

class ACME::Lease < Sequel::Model(:leases)
    plugin :tstzrange_fields, :active_during
end

And in the schema:

create_table(:leases) do
    primary_key :id
    tstzrange :active_during
end

You can use it as follows:

lease = ACME::Lease.new
lease.active_during_begin = Time.now
lease.active_during_end = 1.year.from_now
lease.active_during = 1.year.ago..1.year.from_now
lease.active_during_end = nil # Unbounded end set
lease.active_during = nil # Empty set

Multirange fields (tstzmultirange_fields plugin)

Defining a model class with a timestamptz multirange:

class Reminder < Sequel::Model(:reminders)
    plugin :tstzmultirange_fields, :active_during
end

And in the schema:

create_table(:reminders) do
    primary_key :id
    tstzmultirange :active_during
end

You can use it as follows:

r = Reminder.new
reminder.active_during = [{begin: Time.now, end: 1.year.from_now}]
reminder.active_during = [1.year.ago..1.year.from_now]
reminder.active_during = [Time.now..]
reminder.active_during = []