Re: Re : Am I overseen ?

I think this is not the way I should go.

My application is a database prototype design tool that also is able to
run the design because the designer it self is a design.

So I did not only need a DDL to create the target application's
database, also I need to feed a model into the system database
that specifies the model at GUI level. (Data in general means)

Therefore I have choosen the XMI / XML / XSLT approach to get SQL
scripts at once.

When there is a way to optionally add columns to existing tables via
SQL I have very less development needs to get this working.
If I do read the XML model into a DOM tree or use extarnal tools I
probably have more to work on a solution.

But thanks, it may help somehow. I'll have a look.

Lothar

Am 18.10.2007 um 19:41 schrieb Laurent ROCHE:

> Hi,
>
> You might want to have a look at DdlUtils that does similar things
> that you want to do: compare databases schemas using XML files and
> synchronising the schemas.
> Interesting tool ! !
>
> http://db.apache.org/ddlutils/
>
>  
> Have fun,
> L(at)u
> The Computing Froggy
>
>
> ----- Message d'origine ----
> De : Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> À : Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
> Cc : pgsql-general(at)postgresql(dot)org
> Envoyé le : Jeudi, 18 Octobre 2007, 18h22mn 12s
> Objet : Re: [GENERAL] Am I overseen ?
>
> On 10/18/07, Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de> wrote:
> > On 18 Okt., 17:17, br(dot)(dot)(dot)(at)zijn-digital(dot)com (brian) wrote:
> > > Lothar Behrens wrote:
> > > > Hi,
> > >
> > > > Several groups I post most of them does not answer.
> > > > Did noone see my postings ?
> > >
> > > > Please at least give me one answer :-)
> > >
> > > > Thanks, Lothar
> > >
> > > ping
> > >
> > > What was your query?
> > >
> >
> > I do convert an UML XMI model to a database script to create the
> > database schema.
> > To enable multiple iterations I need conditional alter table add
> > column like syntax.
> >
> > For sample:
> >
> > if not exsist column a in table b then
> >  alter table b add a char(100);
> >
> > Is there any way to do this ?
>
> What kind of tools are you familiar with?  I'm guessing you could
> write something in perl or php to do it.  Or do you want to do it in
> sql?  I'm sure you could do it in plpgsql or some other pl/language,
> if you want it all in the db.
>
> But I'm not that familiar with UML as to say what's the best approach.
>
> Normally when you get thundering silence, you've asked a question no
> one feels real qualified to answer, and rather than answer it halfway,
> they just leave it for the next guy to get.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/
>
>
> Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers
> Yahoo! Mail
--
Lothar Behrens | Rapid Prototyping ...
Heinrich-Scheufelen-Platz 2 |
73252 Lenningen | www.lollisoft.de