Skip to main content

range

Range is used in combination with where and and clauses in Dream.

range supports start, end, or start and end values

import { range } from '@rvoh/dream'

// search Places that sleep at least 3 people
await Place.where({ sleeps: range(3) }).count()

// search Places that sleep 2 or fewer people
await Place.where({ sleeps: range(null, 2) }).count()

// search Places that sleep between 2 and 4 people, inclusive
await Place.where({ sleeps: range(2, 4) }).count()

range supports CalendarDate, DateTime, and number values

import { range } from '@rvoh/dream'

await user
.associationQuery('pets')
.where({
adoptedOn: range(
CalendarDate.today().minus({ months: 2 }),
CalendarDate.today().minus({ month: 1 })
),
})
.order({ adoptedOn: 'desc' })
.all()

await user
.associationQuery('pets')
.where({
adoptedOn: range(
DateTime.now().minus({ months: 2 }),
DateTime.now().minus({ month: 1 })
),
})
.order({ adoptedOn: 'desc' })
.all()

range can be used in association declaration and statements

const deco = new Decorators<typeof Post>()

export default class Post extends ApplicationModel {
...

@deco.HasMany(Comment, { and: { createdAt: () => range(CalendarDate.today().minus({ weeks: 2 })) } })
public recentComments: Comment[]
}