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 faust451@gmail.com designates
 209.85.220.220 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=dKocA4+4Shf6kETisG8zdTcWhs0ME0i2FyUKrThxe/f2qIzNnmZRta5g7py94X9nFk
         Qm6s+Ry12y5j0ownmcCCpMZPBVn68028vShiC422uUJhqTqui1s8e1WVb/MDWcl/ldaP
         +/o0PlXvZ35yrhwcBwEnuAQA9OxOF/Gfr5q/0=
MIME-Version: 1.0
In-Reply-To: <6878DAF8-B582-4D83-AD33-2F590CB27313@apache.org>
References: <f39928a61003271656pc4dac64k8af7d06575af7b15@mail.gmail.com>
	 <91076E76-9FAB-4590-82E2-9B14563882F0@gmail.com>
	 <f39928a61003271712n4969491dkee1d3ed9543aa710@mail.gmail.com>
	 <A204A077-4405-490F-A916-62013DE64B5F@apache.org>
	 <f39928a61003272041m31be57a3ncee7e9cb696a78b8@mail.gmail.com>
	 <6878DAF8-B582-4D83-AD33-2F590CB27313@apache.org>
Date: Thu, 1 Apr 2010 22:51:54 +0400
Message-ID: <k2qf39928a61004011151t653a9504pfa606f9fb3c32fb7@mail.gmail.com>
Subject: Re: Validate uniqueness field
From: faust 1111 <faust451@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

But in bulk updates its impossible to track uniqueness.
only when i update single doc i can before save delete old
uniq_doc(with _id =3D uniq_field_value) and create new.

2010/3/28 Jan Lehnardt <jan@apache.org>:
> The only solution to enforce uniqueness on a field is using the _id field=
 of a document. If you need two fields to be unique in a database, you'll n=
eed to use two documents for that.
>
> In addition, in the distributed case, the only way to ensure uniqueness i=
s eventually, after replication, through conflicts that show up if two node=
s created the same "unique" id.
>
> Cheers
> Jan
> --
>
> On 27 Mar 2010, at 20:41, faust 1111 wrote:
>
>> Why too documents?
>> But i have one issue User
>> =A0i need only one document .
>>
>> i am interesting, how couch people do in real projects.
>> when they need =A0two unique fields in document.
>>
>>
>> 2010/3/28 Jan Lehnardt <jan@apache.org>:
>>> You need to have two documents with a unique ID each.
>>>
>>> Cheers
>>> Jan
>>> --
>>>
>>> On 27 Mar 2010, at 17:12, faust 1111 wrote:
>>>
>>>> but what if i have two unique fields
>>>> =A0login
>>>> =A0email
>>>>
>>>> 2010/3/28 J Chris Anderson <jchris@gmail.com>:
>>>>>
>>>>> On Mar 27, 2010, at 4:56 PM, faust 1111 wrote:
>>>>>
>>>>>> Hi
>>>>>>
>>>>>> In what way i cat implement validation of uniqueness?
>>>>>> User
>>>>>> =A0email: unique
>>>>>> =A0login: =A0unique
>>>>>>
>>>>>
>>>>> You can only have 1 unique field per database. you implement it by us=
ing it as a docid, like
>>>>>
>>>>> {
>>>>> "_id" : "user:unique",
>>>>> =A0 ...
>>>>> }
>>>>>
>>>>> Chris
>>>
>>>
>
>