Re: [hibernate-dev] hibernate-delta

The main difference is that hibernate-delta does NOT run against a live database. I do load the previous version of a mapping from a custom XML file. This enables some scenarios that are not possible with the hibernate build in schemaupdate, such as 1. add a non-null column 2. change the datatype of a column 3. rename a column So the workflow is as follows: 1. Create an entity Customer 2. Run UpdateSqlGenerator (which updates the schema.xml file) 3. Copy the output to a liquibase or Flyway 4. commit and push schema.xml Note that you do not need any database connection for the entire workflow. I do like to test it on a scratch dump from the live database when I add a non-null column and fill it with a qeury for example. In addition, we have an automated test that executes changesets and compares the final schema with expected one from the annotations - using hibernate-delta - which in return uses liquibase to read the schema of the updated database. Gregor Am 24.06.2013 11:24, schrieb Max Rydahl Andersen: > Looks interesting - what is the big difference between this and > what the built in schemaupdate does ? > > If you don't look at previous versions of the mapping I would not > expect you to do much better (but if you do that would be the natural > place to contribute it to) > > Do you got an example on how to use this ? > > /max > > On Thu, Jun 20, 2013 at 11:59:51AM +0200, Gregor Zeitlinger wrote: >> Hi, >> >> I've created https://github.com/txtr/hibernate-delta because I couldn't >> find a solution that would generate SQL update statements based on the >> fields that I added to my @Entity. >> The trick is that it stores the schema in an XML file that is commited >> to git. That way, you only get the differences you introduced. >> It can also find the differences between your XML schema and the actual >> database (using liquibase). >> >> Now the questions >> >> 1. Is this something that already exists? >> 2. Is somebody interested in growing this from the current setup >> (tested with Oracle only)? >> 3. Would this maybe even a candidate to include in hibernate tools? >> >> -- >> Gregor Zeitlinger >> gregor.zeitlinger(a)txtr.com >> _______________________________________________ >> hibernate-dev mailing list >> hibernate-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/hibernate-dev