Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of matero@gmail.com designates
 209.85.160.43 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;
        b=d/hk65WjgFwSVrZUbIJ9bk67X1ptmWaBy8oDO4KxhF73Q8f9DI4DLnWyle1oa4pCrP
         n/hEkhBONSlmJeRgTnqCyzS033P0P9x6irRm+WQuZRyDrDHl2nIinyiAo9+ZcWU3f+2S
         dvI/7+N53lwrn3GvBeLV7LoC+C5PmjauL2/A8=
MIME-Version: 1.0
In-Reply-To: <AANLkTinf7nR30qYmEn-riFZBBWgnewgq3mLD_3ymnXVO@mail.gmail.com>
References: <201007062301.21865.matero@gmail.com>
	<74379189-6B62-4192-B502-6CE0C85612A0@objectstyle.org>
	<loom.20100707T154640-368@post.gmane.org>
	<AANLkTinf7nR30qYmEn-riFZBBWgnewgq3mLD_3ymnXVO@mail.gmail.com>
Date: Thu, 8 Jul 2010 08:20:51 -0300
Message-ID: <AANLkTimOSHyswiih-tZ_79_Ynedb0y8DwioCAj3PTSvS@mail.gmail.com>
Subject: Re: Re: Mapping views with modeller
From: =?UTF-8?Q?Juan_Jos=C3=A9_Gil?= <matero@gmail.com>
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=000e0cd28d389eac9b048ade7a5a

--000e0cd28d389eac9b048ade7a5a
Content-Type: text/plain; charset=UTF-8

Gary, thanks for your aclarations, they cleared mi mind...
after I let my questions out I find some of the answers (like the read-only
objects) myself...
I should learn to do less questions and more reading :(

I expect to return something to cayenne some day :)

regards
Juanjo

2010/7/7 Gary Jarrel <garyjarrel@gmail.com>

> On Wed, Jul 7, 2010 at 11:48 PM, matero <matero@gmail.com> wrote:
> > Thanks Andrus.
> >
> > So, to map a view, I need to  create it on my DB, then import it with the
> > modeler and then map it.
> > Or I should create the DbEntity as a normal one (putting all its
> attributes as
> > read-only) ?
>
> If you have a view in the database you can reverse engineer it into
> the Cayenne Modeler and the modeler will create both the DB and the
> OBJ entities for you. Alternatively you can do the whole process
> manually by creating a db entity having the same name as your view and
> then map each attribute in the modeler to the respective attribute in
> the view. Then you create your object entity and map it to the
> database entity via the Table/View option and then you can sync the
> object entity so that it picks up all the fields from the view.
>
> > Is it possible from the meta-model maintained by cayenne determine if an
> > ObjEntity maps a table or a view? this could be used to define which
> class
> > extend in the velocity template avoiding update / insert operations.
> > If it is not possible, then I should used some kind of convention on
> > tables/views names but I prefer to use the cayenne meta-model.
>
> Not all views are read only, we commonly use views to update things in
> the database (but not all database would support updating through
> views) however any object entity can me made a "Read Only" entity by
> specifying that it's "Read Only" in the modeler. And in this instance
> the class generator (which uses velocity templates) will not generate
> the setter methods.
>
> > Finally, is there a way to tell the modeler "don't try to assign a PK to
> this
> > kind of entity" (in hibernate there is a "assigned id" strategy whih does
> this).
>
> We tend to include some unique identifier in any given view that we
> use. When we take this approach we set the "PK Generation Strategy" to
> "Database Generated" (in the DB entity) and let the database handle
> the rest.
>
> Otherwise (and I could be wrong here) you can leave out specifying the
> Primary Key in the DB entity and leave the "PK Generation Strategy" at
> default hence nothing would be generated since there is no Primary
> Key. However I don't think this is such a good idea at all.
>
> Hope this helps.
>
> gary
>

--000e0cd28d389eac9b048ade7a5a--