Changes between Version 2 and Version 3 of refactoring_harvesters

Timestamp:

Mar 28, 2011, 2:31:45 AM (13 years ago)

Author:

jbaillagou

Comment:

--

refactoring_harvesters

@@ -34 +34 @@
 We try to think this new model as generic as it could be in order to be easily extended by any new harvester.
 
-This new model uses specifics tables in the database to store information about harvesters (HarvestingTask, HarvestingTaskResults...).
+This new model uses specifics tables in the database to store information about harvesters (HarvestingTask, HarvestingTaskResult...).
+
+A few more details on these tables:
+HarvestingTask, HarvestingTaskGroup, HarvestingTaskCategory:
+This table may store relevant information about an harvesting task. 
+The tables HarvestingTaskGroup and HarvestingTaskCategory are used to apply categories and privilieges to harvested metadata.
+
+HarvestingTaskResult:
+Each harvesting result is stored in a dedicated table and may be displayed in an history table. 
+A mechanism can also be implemented to store the last N results (relevant).
+
+HarvestingTaskConfiguration:
+Specific properties and values for a harvesting. Indeed, some harvesters have specific values for configuration. These ones will be stored in that table.
 
 For now, we did a new interface based on ExtJs only for the OAI PMH harvester and we only move this harvester to the new model, there is some work to move all harvesters and to get them working into the trunk. 
@@ -50 +62 @@
         recurrentPeriod     int,
         lastRun   varchar(24),
-        backup     varchar(32),
         status     varchar(32)    not null,
-        isSynchronization   char(1)        default 'n' not null,
         isIncremental  char(1)        default 'n' not null,
         categoryid int not null,
+        logo varchar(32), //TBD with Logo manager
         
         primary key(id),
@@ -61 +72 @@
         
         unique(uuid)
+  );
+
+CREATE TABLE HarvestingTaskGroup
+  (
+        harvestingTaskId int,
+        groupId int,
+        
+        primary key(harvestingTaskId, groupId),
+
+        foreign key(harvestingTaskId) references HarvestingTask(id),
+        foreign key(groupId) references Groups(id)
+  );
+
+CREATE TABLE HarvestingTaskCategory
+  (
+        harvestingTaskId int,
+        categoryId int,
+        
+        primary key(harvestingTaskId, categoryId),
+
+        foreign key(harvestingTaskId) references HarvestingTask(id),
+        foreign key(categoryId) references Categories(id)
   );