Changes between Version 16 and Version 17 of Petascope_9.5


Ignore:
Timestamp:
Jul 3, 2017 1:03:54 PM (4 weeks ago)
Author:
dmisev
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Petascope_9.5

    v16 v17  
    4343== Developer's guide on update_petascopedb.sh
    4444
    45 `update_petascopedb.sh` is a script that allows to manually apply changes to the schema of petascopedb, like add columns, tables, etc. Every change in petascopedb is marked as an update version (current version is 17). The bigest disadvantage is that it only supports postgresql and rollback to a previous schema version (e.g. 17 to 16) is not possible.
     45`update_petascopedb.sh` is a script that allows to manually apply changes to the schema of petascopedb, like add columns, tables, etc. Every change in petascopedb is marked as an update version (current version is 17). The bigest disadvantage is that it only supports postgresql.
    4646
    4747Petascope 9.5 uses Hibernate as ORM data model, and we cannot use `update_petascopedb.sh` with explicit SQL queries. To support different kinds of databases, we use the [http://www.liquibase.org/ Liquibase], which creates the changes for each update in XML and uses that to generate the SQL statements for the target database (e.g: Postgresql, MySql, HSQLDB, etc). A migration table is added in new Petascope database to lock the application when the process is running (to make sure multiple migrations are not happening at the same time).