Deploy-sree-parameter-sheets

From PTAGISWiki

Parameter sheets reside in the stylereport.srl file which is in zip format. So the development cycle should look like this:

1. Acquire most recent stylereport.srl from production
   1. Place stylereport.srl in the directory where it will seen by designer. (My workstation looks for it in /usr/local/bin/StyleReportEE/bin/stylereport.srl)
2. Make changes to a parameter sheet with Report Designer
3. Extract the affected parameter sheet with jar or zip
4. Copy the parameter sheet to development (changes are seen immediately)
5. Install the parameter sheet into stylereport.srl with jar or zip
6. Test
7. Deploy to production with jar or zip
8. Restart SREE from Enterprise Manager (changes are not seen until webapp restarts on pitblade, restarting weblogic is necessary on production)

How to use "jar" to manipulate stylereport.srl

• view details of a file in stylereport.srl

[rday@snapper sree-classes]$ jar tvf stylereport.srl parameterSheet/SbyC_Summary_Sheet
  7750 Fri Mar 31 10:31:38 PST 2006 parameterSheet/SbyC_Summary_Sheet

• extract a file from stylereport.srl

[rday@snapper sree-classes]$ jar xvf stylereport.srl parameterSheet/SbyC_Summary_Sheet
  inflated: parameterSheet/SbyC_Summary_Sheet

• update a single file within stylereport.srl

Note: the jar -u function is not implemented in Linux. You must do it on Solaris.

First, create a corresponding directory and file structure, for instance, if stylereport.srl is in the current directory, then arrange things like this:

[rday@snapper sree-classes]$ mkdir parameterSheet
[rday@snapper sree-classes]$ mv SbyC_Summary_Sheet parameterSheet
[rday@snapper sree-classes]$ jar uvf stylereport.srl parameterSheet/SbyC_Summary_Sheet

How to use "zip" to manipulate stylereport.srl

This is the preferred method on Linux.

• view details of a file in stylereport.srl

[rday@snapper sree-classes]$ unzip -l stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
  Length     Date   Time    Name
 --------    ----   ----    ----
     7566  01-13-06 11:17   parameterSheet/SbyC_Summary_Sheet
 --------                   -------
     7566                   1 file

• extract a file from stylereport.srl

[rday@snapper sree-classes]$ unzip stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
replace parameterSheet/SbyC_Summary_Sheet? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
  inflating: parameterSheet/SbyC_Summary_Sheet

• update a file in stylereport.srl

[rday@snapper sree-classes]$ cp SbyC_Summary_Sheet parameterSheet/
[rday@snapper sree-classes]$ zip -f stylereport.srl parameterSheet/SbyC_Summary_Sheet
freshening: parameterSheet/SbyC_Summary_Sheet (deflated 79%)
[rday@snapper sree-classes]$ unzip -l stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
  Length     Date   Time    Name
 --------    ----   ----    ----
     7750  03-31-06 15:46   parameterSheet/SbyC_Summary_Sheet
 --------                   -------
     7750                   1 file
[rday@snapper sree-classes]$ date
Fri Mar 31 15:47:15 PST 2006

If the parameterSheets don't already exist in stylereport.srl, then the "freshen" will fail. In this case, you should leave off the -f option and zip will insert the given files into stylereport.srl.

A sample session

Putting all those commands together, here is a sample session. It assumes that we have just made modifications to a parameter sheet that we have in the current directory. It also assumes that a directory called parameterSheet exists in the current directory.

The session extracts the updated parameter sheet from the locally updated stylereport.srl, copies the current stylereport.srl from development, views the details of the parameter sheet we are about to change, inserts the updated parameter sheet, and verifies the change.

[rday@snapper sree-classes]$ unzip stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
replace parameterSheet/SbyC_Summary_Sheet? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
  inflating: parameterSheet/SbyC_Summary_Sheet
[rday@snapper sree-classes]$ cp /net/pitblade/dsk2/ptagis-1.0/web/sree/WEB-INF/classes/stylereport.srl .
[rday@snapper sree-classes]$ unzip -l stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
  Length     Date   Time    Name
 --------    ----   ----    ----
     7674  11-10-05 13:26   parameterSheet/SbyC_Summary_Sheet
 --------                   -------
     7674                   1 file
[rday@snapper sree-classes]$ cp SbyC_Summary_Sheet parameterSheet/
[rday@snapper sree-classes]$ zip -f stylereport.srl parameterSheet/SbyC_Summary_Sheet
freshening: parameterSheet/SbyC_Summary_Sheet (deflated 79%)
[rday@snapper sree-classes]$ unzip -l stylereport.srl parameterSheet/SbyC_Summary_Sheet
Archive:  stylereport.srl
  Length     Date   Time    Name
 --------    ----   ----    ----
     7750  03-31-06 15:56   parameterSheet/SbyC_Summary_Sheet
 --------                   -------
     7750                   1 file

The updated stylereport.srl can be deployed back to development knowing that we have only made a change to a single parameter sheet.