MongoDb opening hours Schema and query for open/closed

Question

How could I store opening hours withing, say, a Venue document so that I could query whether the Venue is currently open.

Each Venue document would contain just an opening and a closing time for each day of the week (maybe just the ones its open?).

I need the ability only to set and list the hours (trivial I guess) and to query based on the current time whether it is open or closed.

Maybe something along these lines? But not sure on the Schema to be honest nor how to query it to check if its open.

hours: {
    mon: {open: 9:30, close: 18:00 },
    tue: {open: 9:30, close: 17:30 },
    ...
}

Any advice would be much appreciated. Thanks.

Answer 1

Instead of using actual hours, rather store your time as 0 - 1440, each number being an increment of a minute. Then you'll be able to use $gte and $lte.

So you'd have:

hours: {
  mon: {open: 570, close: 1080 },
  tue: {open: 570, close: 1050 },
  ...
}

That's the strategy that I'm using in my app. Of course there are slightly more efficient ways, like storing all the hours for the week in a single array, but your approach is still good.