Changeset 7252 for TI01-discovery-Ingest


Ignore:
Timestamp:
28/07/10 17:08:45 (9 years ago)
Author:
sdonegan
Message:

updates to allow creation of ingest tracking table and use of function for updating it

Location:
TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/IngestLoggingTable.sql

    r7245 r7252  
    55 *  
    66 */ 
    7 DROP TABLE ingestSearchLogging CASCADE; 
    8 CREATE TABLE ingestSearchLogging ( 
    9         local_ingest_id SERIAL primary key, 
    10         alt_ingest_id text, 
    11         provider_id text, 
    12         ingest_date timestamp, 
    13         total_files_processed int, 
    14         total_files_processed_successfully int, 
    15         total_files_processed_unsuccessfully int, 
    16         records_created int, 
    17         records_updated int, 
    18         records_deleted int, 
    19         number_problem_files int 
     7DROP TABLE ingest_search_logging CASCADE; 
     8CREATE TABLE ingest_search_logging ( 
     9    local_ingest_id SERIAL primary key, -- id assigned by postgres 
     10        alt_ingest_id text, -- id supplied by calling function 
     11        provider_id text, -- unique provider id 
     12        ingest_date timestamp, -- time of ingest 
     13        total_files_processed int, -- total number of files handled 
     14        total_files_processed_successfully int, -- number of files handled successfully 
     15        total_files_processed_unsuccessfully int, -- number of files handled unsuccessfully 
     16        records_created int, --number of new files inserted into DDS db 
     17        records_updated int, -- number of existing files in DDS db updated 
     18        records_deleted int, -- number of existing files in DDS db deleted 
     19        number_problem_files int -- number of successfully handled files that could not be inserted into DDS db due to content problem 
    2020); 
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/create_database.sh

    r7241 r7252  
    2424echo $dbOptions 
    2525 
     26psql -f ingestLoggingProcedures.sql $dbOptions 
    2627psql -f IngestLoggingTable.sql $dbOptions 
    27 psql -f HarvestLog.sql $dbOptions 
    28 psql -f HarvestType.sql $dbOptions 
    29 psql -f formatTable.sql $dbOptions 
    30 psql -f OAIProvider.sql $dbOptions 
    31 psql -f provider.sql $dbOptions 
    32 psql -f service_config.sql $dbOptions 
     28#psql -f HarvestLog.sql $dbOptions 
     29#psql -f HarvestType.sql $dbOptions 
     30#psql -f formatTable.sql $dbOptions 
     31#psql -f OAIProvider.sql $dbOptions 
     32#psql -f provider.sql $dbOptions 
     33#psql -f service_config.sql $dbOptions 
    3334 
Note: See TracChangeset for help on using the changeset viewer.