Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of mrtrick@gmail.com designates
 209.85.160.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=u0j6BrQYV+MWAiH4sZwqM2BGAOtToNhlSjleSVKnZlJIMEkFy0j3v+uBidjThRyGdO
         RNGhj234vxpIHasgsEpieN8qHAhD51uQOIW5cU1teMHR6gJXwxONeu09Tv/Wp/YsBpZe
         WIw6IXz4vZ1F/2GxxfXhZMMLQFoqb5LKYjIfg=
Message-ID: <4BFDF739.90000@gmail.com>
Date: Thu, 27 May 2010 14:38:17 +1000
From: Patrick Barnes <mrtrick@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Delete document Tree Structure
References: <COL119-W2087333D02D7B7EC2FED7CC3EA0@phx.gbl>
In-Reply-To: <COL119-W2087333D02D7B7EC2FED7CC3EA0@phx.gbl>
Content-Type: text/plain; charset=windows-874; format=flowed
Content-Transfer-Encoding: 8bit

How do you currently organise the documents into a tree and display them?

For my trees, I have a 'hierarchy' array attribute that basically holds 
a tree address, eg:
A = {"_id":"A", .... "hierarchy":["A"]};
B = {"_id":"B", .... "hierarchy":["B"]};
C = {"_id":"C", .... "hierarchy":["B","C"]};
D = {"_id":"D", .... "hierarchy":["A","D"]};
E = {"_id":"C", .... "hierarchy":["B","E"]};
F = {"_id":"C", .... "hierarchy":["B","E","F"]};

If you then create a view that emits the hierarchy attribute as the key, 
it will automatically sort them into lexicographic (tree) order.

If you want to delete B+descendants, you:
1. Query that view with:
  startkey=["B"] &
  endkey=["B",{}]
to get the B document and every descendant of B,
2. Delete them all.

On 27/05/2010 1:48 PM, Aun... ��Ǿ��� wrote:
>
>
> Hi,
>
>         I design document in couchdb to have relation something like
>
>                directory
>                      |
>                      A---------D
>                      |
>                      B---------C
>                                   |
>                                   |
>                                   E ------F
>
>           if i would like to http (DELETE B) will delete all down documents what is the possible solution to use.
>
>                  1.    can i create view and find relation and delete all of them ?
>                  2.    get  relation by higher programming api (C#,PHP) and then delete each one?
>                  3.    Do you have any solution to suggest on this.....?
>
>
> Thanks,
> A.
>
>
>   		 	   		
> _________________________________________________________________
> Hotmail: ��ԡ������ſ�� ������Ͷ���� �������ó�����
> https://signup.live.com/signup.aspx?id=60969