Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cayenne-user@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <44373251.6010604@synect.com>
Date: Sat, 08 Apr 2006 13:17:29 +0930
From: Craig Turner <craig@synect.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051116)
MIME-Version: 1.0
To: cayenne-user@incubator.apache.org
CC: robert@synect.com
Subject: Re: Seeking to automate generation the cayenne schema
References: <44322D43.7090007@synect.com>
	 <9ED4E94C-D911-4F47-9613-D594DA26455D@objectstyle.org>
 <8f985b960604040647v14974a8di72a5558a9259d254@mail.gmail.com>
In-Reply-To: <8f985b960604040647v14974a8di72a5558a9259d254@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Andrus and Mike, thanks for your help with this. I've now got a simple 
implementation working. I've put a tar.gz of the work I've done up at
   http://203.15.93.19/GenerateModelTool.tar.gz
(2.6MB, including scripts, pgsql driver and cayenne1.1M12 jar)

It's far from mature:
- Project isn't using ant yet, just a simple build script
- I want to generate the XML using jdom rather than PrintWriter :)
- I want to add command-line options to have the user set the package 
for the entities
- I'd like to add support for Properties file configuration
- I'd like to write a wrapper object so that it can be launched from 
java with simple configuration to a single class rather than from the 
command-line

I wanted to get something working so that I could then ask the list 
where to go next and that's where it's at. Would there be interest to 
move this tool into the project, and if so would one of the developers 
indicate how to move forwards with this?

If not then I'd like to set this up as a distinct tool administered out 
of my firm or sourceforge. Does anyone have strong feelings about things 
I could improve about this, or what the boundaries should be for a 
well-rounded tool of this type?


Mike Kienenberger wrote:
> On 4/4/06, Andrus Adamchik <andrus@objectstyle.org> wrote:
> 
>>Everything in Cayenne can be assembled via API. So you'd go about
>>assembling Cayenne stack in the following order:
>>
>>* create DefaultConfiguration
>>* add DataDomain
>>* add DataNode
>>* add DataMap (using org.objectstyle.cayenne.access.DbLoader to
>>create it from DB on the fly)
>>
>>Also since a generic DataObject class is supported, this will even
>>work in Java:
>>
>>http://objectstyle.org/confluence/display/CAYDOC/Generic+Persistent
>>+Class
> 
> 
> Andrus, I think he's asking about how to create the xml config files. 
>  So he'd need to do everything above, and then call some kind of xml
> writer (probably a class in modeler.jar) to save it all back out as
> xml.  He'd probably also want to do the "sync to ObjEntity" stuff as
> well to create the ObjEntities.
> 
> Craig, I don't know how "straightforward" it would be, but the modeler
> project should contain everything you need.   You'd just call the java
> "work" methods directly instead of going through the swing callbacks.