cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: adding new columns to table
Date Mon, 26 Nov 2012 14:53:14 GMT
Using Flyway (or Liquibase), you'll have to extract the JDBC connection
from Cayenne to pass to Flyway to perform the migration when the
application initializes.  See the bottom of:

http://flywaydb.org/documentation/api.html

Also, Flyway doesn't know about Cayenne, so you'd have to update your
Cayenne model to have your new column(s) then add an SQL script (or Java
migration) for Flyway to use to upgrade the schema separately.  Not too
difficult, just something to keep in mind to be part of your process.

mrg



On Sun, Nov 25, 2012 at 10:45 AM, emeka okafor <emeka_1978@yahoo.com> wrote:

> Thank you for your suggestions; I am going to try both and see which one
> is easier.
>
>
>
> ________________________________
>  From: Juan José Gil <matero@gmail.com>
> To: user@cayenne.apache.org
> Sent: Saturday, November 24, 2012 11:08 PM
> Subject: Re: adding new columns to table
>
> wouldn't be better to use something like flyway? http://flywaydb.org/
>
>
> 2012/11/24 John Huss <johnthuss@gmail.com>
>
> > There is an experimental library in the cayenne-sandbox you could try:
> > http://svn.apache.org/viewvc/cayenne/sandbox/cayenne-migrations/
> >
> > I'm using it in production, but your mileage may vary.  The migrations
> are
> > not automatically generated (except for the initial database) but they
> are
> > easy to write.
> >
> >
> > On Sat, Nov 24, 2012 at 10:59 AM, emeka okafor <emeka_1978@yahoo.com>
> > wrote:
> >
> > > Is there a cayenne way to modifying a databse table? Like a way for
> > > cayenne to generate a migration class that can be run when when my
> schema
> > > changes.
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message