I have an app which stores business and business hours.  The way I
store my hours in my db is: day_of_week(0-6), open_time(mysql time),
close_time(mysql time).  There may be multiple business hours for the
same day.  For example a business opens from 8:00-12:00  and from
15:00-20:00

So a simplified model is like this:

class Business < ActiveRecord::Base
  has_many :hours
  define_index ....

class Hour < ActiveRecord::Base
  belongs_to :business

So I have a index setup on my business model to be able to search for
a business name.  Anyone got any ideas for how users can search for
businesses currently open?  Could use some steps in the right
direction.  BTW, thinking_sphinx is pretty sweet!

Thanks,
Andrew

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/thinking-sphinx?hl=en.

Reply via email to