Reminder: Create & find trunk-related issues here. Legacy Trac tickets are still available. Problems? Workflow feedback? Need a module project? Open a support ticket.

OpenMRS Trunk

OpenMRS database auto update using Liquibase

Details

  • Type: New Feature New Feature
  • Status: Closed Closed
  • Priority: Should Should
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: OpenMRS 1.5.0
  • Component/s: None
  • Keywords:
  • Description:
    Hide

    This is a tentative patch. OpenMRS web application calls the Liquibase programatically at startup. It will read the database changes from an XML file and mark the performed database changes in a dedicated table. This works in a similar manner to how the database updates are done in the OpenMRS modules at present.

    This will eliminate the step where the user has to run the update-to-latest-db.mysqldiff.sql SQL script using the mysql client program in a shell. And it is database server type independent. Also this eliminates the dependence on mysql client program.

    Show
    This is a tentative patch. OpenMRS web application calls the Liquibase programatically at startup. It will read the database changes from an XML file and mark the performed database changes in a dedicated table. This works in a similar manner to how the database updates are done in the OpenMRS modules at present. This will eliminate the step where the user has to run the update-to-latest-db.mysqldiff.sql SQL script using the mysql client program in a shell. And it is database server type independent. Also this eliminates the dependence on mysql client program.

Attachments

  1. Text File
    openmrs-974-liquibase-1.2.patch
    (9 kB)
    Burke Mamlin
    2008-08-13 18:43:35 EDT
  2. Text File
    openmrs-974-liquibase-1.patch
    (9 kB)
    Burke Mamlin
    2008-08-13 17:42:40 EDT

Issue Links

Relation
 

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Ben Wolfe added a comment - 2008-11-26 16:15:47 EST

I've committed changes in rev:6122 to the http://dev.openmrs.org/browser/openmrs/branches/ticket974-liquibase/ branch.

This built off of what Upul did and expanded it to include a startup wizard for creating the database. Its a simpleton wizard that will need a lot of cleanup.

There are several minor TODOs within the code that we will want to implement eventually.

Show
Ben Wolfe added a comment - 2008-11-26 16:15:47 EST I've committed changes in rev:6122 to the http://dev.openmrs.org/browser/openmrs/branches/ticket974-liquibase/ branch. This built off of what Upul did and expanded it to include a startup wizard for creating the database. Its a simpleton wizard that will need a lot of cleanup. There are several minor TODOs within the code that we will want to implement eventually.
Hide
Permalink
Ben Wolfe added a comment - 2009-01-02 16:57:47 EST

It seems the changes discussed in the code review of this a few weeks back never made it to the ticket. Nevertheless, the changes were committed to the branch.

The branch has been merged to trunk. See rev:6505 and rev:6506. There are several tickets for some clean up work that need to be done before 1.5 is eventually released: TRAC-1187, TRAC-1188, TRAC-1189, TRAC-1190

Show
Ben Wolfe added a comment - 2009-01-02 16:57:47 EST It seems the changes discussed in the code review of this a few weeks back never made it to the ticket. Nevertheless, the changes were committed to the branch. The branch has been merged to trunk. See rev:6505 and rev:6506. There are several tickets for some clean up work that need to be done before 1.5 is eventually released: TRAC-1187, TRAC-1188, TRAC-1189, TRAC-1190
Hide
Permalink
Michael Downey added a comment - 2010-07-09 17:39:32 EDT

Ticket was closed/fixed without an assignee. Updating assignee for completeness.

Show
Michael Downey added a comment - 2010-07-09 17:39:32 EDT Ticket was closed/fixed without an assignee. Updating assignee for completeness.

People

Dates

  • Created:
    2008-08-13 17:41:36 EDT
    Updated:
    2010-07-09 17:39:32 EDT
    Resolved:
    2010-07-01 22:42:18 EDT
Atlassian JIRA (v4.1.1#522) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for OpenMRS. Try JIRA - bug tracking software for your team.