Harvesting History

Date	2011/03/28
Contact(s)	Simon Pigot, Jose Garcia
Last edited
Status	Complete
Assigned to release	2.7.0
Resources	Available

Overview

Currently not possible to see a history of the results from a harvester - only the results of the last harvest are available. This proposal will add:

• a HarvestHistory table to the database
• record results of each harvest in the HarvestHistory table
• add user interfaces to the Harvest Manager interface for review of results from individual harvesters or all harvesters

Proposal Type

• Type: Harvester Manager GUI Change, Change to Core Harvester code, database addition
• Module: Harvester, Database

Voting History

• Not proposed for voting yet

---

Motivations

Allow administrators to review the history of a harvester or all harevsters.

Proposal

Database changes: add a HarvestHistory table with the following structure:

CREATE TABLE HarvestHistory
  (
    id             int,
    harvestDate    varchar(30),
    harvesterUuid  varchar(250),
    harvesterName  varchar(128),
    harvesterType  varchar(128),
    deleted        char(1) default 'n' not null,
    info           longvarchar,
    params         longvarchar,

    primary key(id)

  );

CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(id);
CREATE INDEX HarvestHistoryNDX2 On HarvestHistory(harvesterUuid);
CREATE INDEX HarvestHistoryNDX3 ON HarvestHistory(harvestDate);

The info field is an XML string of the results of the harvest. The params field is the parameters of the harvester. The params field is present so that a harvester that has been deleted can be restored.

Backwards Compatibility Issues

New libraries added

Explain which and why new libraries are required for that proposal ...

Risks

Participants

• List of participants and role (if necessary) in current GIP