Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: unknown ~alla (athena.apache.org: encountered unrecognized
 mechanism during SPF processing of domain of jdreux@justlexit.com)
MIME-Version: 1.0
In-Reply-To: 
 <CAMiZLn0Y8Pcf+7Zp7gpss-sEUWVMAjsCARfgY00Hvka5UoywzQ@mail.gmail.com>
References: 
 <CACo=XsYf59M_Sybh3aos3n+jpy8b=1v1oyaFCtBArtDrzuC85A@mail.gmail.com>
	<F79E8F9E-0709-47BC-AFB8-FBEE7193B559@utt.fr>
	<CACo=Xsa+FY8wGb73hoBk68cLSzOqBNC3yR-7bDHeEFYenS6yZA@mail.gmail.com>
	<4A256A62-EC51-4FBB-98B3-1638BBEA674D@utt.fr>
	<CABvT1DHEA427tTnQukv9Rt7stOBWbFqbf_oDngkKo46Xn4zeRA@mail.gmail.com>
	<CACo=XsZh8fNFCEVVhEnw1E9rob3DEHraqiJcSz3iFdGbHuekoQ@mail.gmail.com>
	<CAMiZLn0Y8Pcf+7Zp7gpss-sEUWVMAjsCARfgY00Hvka5UoywzQ@mail.gmail.com>
Date: Wed, 11 Apr 2012 16:46:30 -0400
Message-ID: 
 <CACo=Xsa0srBgyMyvz3S5LpCMk-UFsV5NdqwqFvEcNehUnmEaWA@mail.gmail.com>
Subject: Re: View cache invalidation
From: Julien Dreux <jdreux@justlexit.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=bcaec51b1b6786ede804bd6d5573

--bcaec51b1b6786ede804bd6d5573
Content-Type: text/plain; charset=ISO-8859-1

Matthieu, Robert,

These answers already help a lot, however what we are trying to do is not
to retrieve the list of opening hours for  a given business for today, but
rather retrieve the list of businesses that are open at a given time
(e.g. Wednesday at 2:05 PM).
Even though I have an idea on how this could be done I would like to know
your take on it to make sure we are on the right track.

Thanks,
*
*
*JULIEN DREUX*
jdreux@justlexit.com
514 812-8084
www.justlexit.com


On Wed, Apr 11, 2012 at 4:11 PM, Matthieu Rakotojaona <
matthieu.rakotojaona@gmail.com> wrote:

> On Wed, Apr 11, 2012 at 9:24 PM, Julien Dreux <jdreux@justlexit.com>
> wrote:
> > function(doc) {
> >  if(doc.businessHours) {
> >    var daysArr = new Array('s','m','t','w','h','f','a');
> >    var day = daysArr[new Date().getDay()];
> >    emit(parseInt(doc.businessHours[day][0].indexOf('0') == 0 ?
> > doc.businessHours[day][0].substring(1) : doc.businessHours[day][0]),
> doc)};
> > }
> >
> > Thank you for your help.
> > *
> > *
> > *JULIEN DREUX*
> > jdreux@justlexit.com
> > 514 812-8084
> > www.justlexit.com
> >
>
> As said before, views (both map and reduce) MUST be absolutely
> context-independent. There is only ONE thing a map function can depend
> on : the document being processed. It cannot even rely on other
> documents, or the version of your couchdb, or whatever. If you need
> this information, include it in your doc.
>
> I get from your view definition that you would like to ask your
> database for the opening hours of your businesses for today, right ? I
> will suppose you do so. A correct way to implement way would be like
> that :
>
> - for each day in the 'businessHours' array of the doc, emit a pair.
> The key should be the day from the array, the value would be the
> opening hour as processed in your emit (removing the leading 0 if it
> exists)
> - You would then have multiple key/value pairs by document.
> - At query time, use 'key=<today's date as a single letter>' as an
> argument, like 'key="s"'.
> - Bonus : do not emit the doc in a map. If you need it, you can add
> 'include_docs=true' to the arguments at querying time, and you will be
> able to access it along the data you emitted when defining the view.
> This will prevent you from storing the doc twice.
>
> Proposed (untested) implementation :
>
> function(doc){
>   var daysArr = new Array('s','m','t','w','h','f','a');
>   var i=0;
>  for (i = 0; i < daysArr.length; i++){
>    var day = daysArr[i];
>    var openingHour = doc.businessHours[day][0].indexOf('0') == 0 ?
> doc.businessHours[day][0].substring(1) : doc.businessHours[day][0]);
>    emit(day, openingHour);
>  }
> }
>
> Query would look like this for today (wednesday) :
>
>  GET /path/to/view?key="w"&include_docs=true
>
>
>
> --
> Matthieu RAKOTOJAONA
>

--bcaec51b1b6786ede804bd6d5573--