Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of grobmeier@gmail.com
 designates 209.85.214.171 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=C8qL7eC2BkV1qABBY7ajz6KCKfD71tODALyN1Wi5BNsWSQ/Y20DFPFMyRweE47ULLK
         ez7phMolXla31rU8tTaYrJ9KMV7m0N5yo+0aQVpypEOrqTzCGh07pqpozASwwu/OdyUm
         CxPyPdI92afrdx986Rb5O/tV4n1DUuZetyq3I=
MIME-Version: 1.0
In-Reply-To: <D64F47B5-2FEB-4967-9813-7293A4B4B78D@objectstyle.org>
References: <AANLkTikv+HregEux3S7nCf1UvzgUgNqvJp8yX3mj0rY-@mail.gmail.com>
 <4D5BBC79.2020206@buk.cvut.cz>
 <AANLkTikbNF1Gq50O3nsaMGgc9pRHDnN1nGQHYOh46yKW@mail.gmail.com>
 <D64F47B5-2FEB-4967-9813-7293A4B4B78D@objectstyle.org>
From: Christian Grobmeier <grobmeier@gmail.com>
Date: Wed, 16 Feb 2011 13:20:32 +0100
Message-ID: <AANLkTin2KCVj=hR_X4AqY8Xqi46G3wEmg1MdmAGpshrS@mail.gmail.com>
Subject: Re: Unique Indexes with the modeller
To: user@cayenne.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

> Also note that the underlying argument about this feature is whether Caye=
nneModeler (and consequently map.xml) should include general DB admin funct=
ions not relevant to the ORM. Even though back in 2005 I said "I am for add=
ing more DB admin functions to the Modeler", I am still on the fence on whe=
ther it is a good idea. In this particular case I guess I won't object to a=
 working implementation.

I am very +1 on adding this feature to the modeller. Even when it may
go further to standard ORM, the modeller cannot be used alone for
working with cayenne. On the other hand there is no chance to prevent
the loss of indexes when the db schema is regenerated.

Imho I would stop when it comes to adding users to a database or
re-enter passwords or something like that.

Thanks for the explaination anyway


>
> Andrus
>
> On Feb 16, 2011, at 2:04 PM, Andrey Razumovsky wrote:
>
>> It's not supported by Cayenne, though it's a long-standing request. If
>> you're willing to watch or contribute, you can follow
>> https://issues.apache.org/jira/browse/CAY-204
>>
>> 2011/2/16 Marek =C5=A0abo <msabo@buk.cvut.cz>:
>>> Actually I would like to know whether there is any support for this in =
cm
>>> because I've been appending them manually in generated schemata.
>>>
>>> On 02/16/2011 12:40 PM, Christian Grobmeier wrote:
>>>>
>>>> Hello,
>>>>
>>>> how can I create a unique index on a column with the modeller?
>>>> Couldn't find any information even with google :-)
>>>>
>>>> I also could not find any info about indexing in Cayenne in general...
>>>> my tables are all without an index (except my primary key, which is
>>>> indexed by default).
>>>>
>>>> I am using Cay 3.1 + MySQL
>>>>
>>>> Thanks
>>>> Christian
>>>>
>>>
>>> --
>>> Marek =C5=A0abo
>>>
>>>
>>
>>
>>
>> --
>> Andrey
>>
>
>


--=20
http://www.grobmeier.de