Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of adam.kocoloski@gmail.com
 designates 209.85.219.205 as permitted sender)
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
Mime-Version: 1.0 (Apple Message framework v1076)
Subject: Re: CouchDB equivalent dynamic SQL
From: Adam Kocoloski <kocolosk@apache.org>
In-Reply-To: <243703.63807.qm@web52207.mail.re2.yahoo.com>
Date: Fri, 30 Oct 2009 13:59:21 -0400
Content-Transfer-Encoding: 7bit
Message-Id: <415EAAEA-4699-4AA2-8368-E8FF6E305750@apache.org>
References: <243703.63807.qm@web52207.mail.re2.yahoo.com>
To: user@couchdb.apache.org

On Oct 30, 2009, at 1:36 PM, Duy Nguyen wrote:

> Hi guys,
> I have a troublesome sql query that needs to translate to couchDB  
> map/reduce
> SELECT * FROM PRODUCTSWHERE [ PRICE ] AND [TYPE]'
> Please note that Price and Type are dynamically generated depend on  
> user inputs. ( i.e TYPEcan be 100 < PRICE < 1000, or 1 < PRICE <  
> 100, or 1000 < PRICE < 10000. TYPE could be 'computer' , 'tv' etc..)
> I can not do dynamically query on the fly with CouchDB. what is the  
> best way to solve this problem ?

Hi Duy, it won't always be a perfect translation.  But CouchDB's  
compound view keys should be able to help you in this situation.  In  
your map, emit([doc.type, doc.price], null) and then query the view with

?startkey=["computer", 1000]&endkey=["computer", 10000] 
&include_docs=true

or

?startkey=["tv", 100]&endkey=["tv", 1000]&include_docs=true

Best, Adam