Mailing-List: contact dev-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Received-SPF: pass (nike.apache.org: domain of antonio.fornie@gmail.com
 designates 209.85.220.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <02E3616756CDC04687D08374DA63D32C4D4FDE@SBPOMB101.sbp.lan>
References: <02E3616756CDC04687D08374DA63D32C4D4FDE@SBPOMB101.sbp.lan>
Date: Wed, 19 Mar 2014 12:25:32 +0100
Message-ID: 
 <CAEJAyca=yJguhL5jn=vS-V0wgPUR6xDOBjqbXLma5NngBB0X0g@mail.gmail.com>
Subject: Re: [PROPOSAL] Use Liquibase to manage DB changes
From: =?ISO-8859-1?Q?Antonio_Forni=E9_Casarrubios?= <antonio.fornie@gmail.com>
To: cloudstack <dev@cloudstack.apache.org>
Cc: Rajani Karuturi <Rajani.Karuturi@citrix.com>
Content-Type: multipart/alternative; boundary=e89a8ff1c08c226d0704f4f3e9ea

--e89a8ff1c08c226d0704f4f3e9ea
Content-Type: text/plain; charset=ISO-8859-1

Thanks Miguel. I think this is a very useful addition that should have been
added already

Antonio


2014-03-18 11:06 GMT+01:00 Miguel Ferreira <MFerreira@schubergphilis.com>:

> All,
>
> Following from the discussion of [1], I have written a small tool [2] to
> detect potential conflicts related to ACS DB changes.
> With the input supplied by that tool, I will proceed to check every commit
> since tag 4.2 up to the head of master.
> For every commit that introduces relevant changes to the DB I will create
> a Liquibase [3] change set, apply it to a running ACS DB, run automated
> system tests and possibly refine the change set until the DB is left in a
> consistent state.
> (Liquibase is one of the tools proposed in [1] by Rajani to help managing
> the changes to the DB. See [1] for more details on that.)
>
> My goal is twofold: (1) assess how suitable Liquibase is for managing
> changes to ACS DB; and (2) how frequent are "breaking" changes to the DB
> made.
> By "breaking" changes I mean changes that otherwise would require a fresh
> DB to start with.
> With the data I will collect I expect to be able to say something about
> how feasible it is to use Liquibase, and how involved would it be to ask
> every developer to make independent and incremental changes to the DB
> related code.
>
> I will report back on my findings, but feel free to jump in and help out
> anyway you see possible.
>
> Cheers,
> Miguel
>
>
> [1] http://markmail.org/message/7qohq2sbumthjhw6
> [2] https://github.com/schubergphilis/cloudstack-db-updater
> [3] http://www.liquibase.org/
>

--e89a8ff1c08c226d0704f4f3e9ea--