Reports Development Workflows - Deploying new versions in development and in production

ssmusoke · June 10, 2017, 3:42pm

How can I setup report objects not to be cached during development, as I am continuously changing the definitions. Currently I am using the following code:

AdministrationService as = Context.getAdministrationService(); log.warn("Removing all reports"); as.executeSQL("delete from reporting_report_design_resource;", false); as.executeSQL("delete from reporting_report_design;", false); as.executeSQL("delete from reporting_report_request;", false); as.executeSQL("delete from global_property WHERE property LIKE 'reporting.reportManager%';", false); as.executeSQL("delete from serialized_object WHERE type LIKE 'org.openmrs.module.reporting.report%'", false);

However when deploying my reports to a running instance, I am also not able to maintain changes, just in case I forget to change the report version numbers.

mseaton · June 12, 2017, 11:36am

@ssmusoke, not sure I understand the question. Where is the code, can I see the repository?

If you are setting reports up using ReportManagerUtil.setupReport, then you can see from this method that a report will always be updated to the latest code you have written if you add “-SNAPSHOT” to the version. While you are developing, you should always do this.

Mike

ssmusoke · February 6, 2018, 5:22am

@mseaton Here is the initialiser

github.com

METS-Programme/openmrs-module-ugandaemr-reports/blob/master/api/src/main/java/org/openmrs/module/ugandaemrreports/activator/ReportInitializer.java

/**
 * The contents of this file are subject to the OpenMRS Public License
 * Version 1.0 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://license.openmrs.org
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 *
 * Copyright (C) OpenMRS, LLC.  All Rights Reserved.
 */

package org.openmrs.module.ugandaemrreports.activator;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.openmrs.api.AdministrationService;
import org.openmrs.api.context.Context;

This file has been truncated. show original

mseaton · February 6, 2018, 1:50pm

@ssmusoke can you please clarify the question?

What determines whether a given report updates is the version number in the report manager class. If it is a higher version than previous or if it ends in -SNAPSHOT then it will update.

You should not need the removeOldReports method unless you are trying to do a one-time cleanup or something ( I assume this was pulled from my code which was serving a discreet purpose, but is not generally needed).

Mike

ssmusoke · February 6, 2018, 3:20pm

@mseaton Oh let me test out using snapshot in the version to see how it works and I will report back.