[Newleda-general] [ newleda-Feature Requests-2812725 ] history

[SourceForge.net <no...@so...>]

Feature Requests item #2812725, was opened at 2009-06-26 14:27
Message generated for change (Tracker Item Submitted) made by dimakarov
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=800699&aid=2812725&group_id=156665

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: Dmitry Makarov (dimakarov)
Assigned to: prugniel (prugniel)
Summary: history

Initial Comment:
interc has to fill the history at the ingestion step. The history structure is
\d history
                       Table "public.history"
   Column    |            Type             |       Modifiers
-------------+-----------------------------+------------------------
 date        | timestamp without time zone | not null default now()
 action      | character varying           |
 description | text                        |
 level       | smallint                    | default 0

date is filled automatically
action can be one of 'add', 'correct', 'merge', 'delete', 'release', 'structure', 'homogenization', 'other'
description is any important information like ingested tables
level is some importance level. It is not defined well, but some times ago we decided to use level=0 to show for public.

So, in case of ingestion interc has to form the SQL-query like
INSERT INTO history (action,description) VALUES ('add','Table1 from BIBCODE with N objects has been added');

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=800699&aid=2812725&group_id=156665