Changeset 7392


Ignore:
Timestamp:
27/08/10 14:35:02 (9 years ago)
Author:
sdonegan
Message:

added ingest start and end times to relevant tables

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

Legend:

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

    r7363 r7392  
    99    local_ingest_id SERIAL primary key, -- id assigned by postgres 
    1010        id int4, -- process id supplied by calling function      
    11         ingest_date timestamp, -- time of ingest 
     11        ingest_start_time timestamp, -- time of ingest start 
     12        ingest_end_time timestamp, -- time of ingest end 
    1213        total_files_processed int, -- total number of files handled 
    1314        total_files_processed_successfully int, -- number of files handled successfully 
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/ingestLoggingProcedures.sql

    r7363 r7392  
    55 *  
    66 */ 
    7 DROP FUNCTION add_ingest_stats(ingest_id_in int4, ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) CASCADE; 
    8 CREATE FUNCTION add_ingest_stats(ingest_id_in int4,ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) RETURNS VOID AS  
     7DROP FUNCTION add_ingest_stats(ingest_id_in int4, ingest_start_date_in timestamp, ingest_end_date_in timestamp ,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) CASCADE; 
     8CREATE FUNCTION add_ingest_stats(ingest_id_in int4,ingest_start_date_in timestamp, ingest_end_date_in timestamp ,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) RETURNS VOID AS  
    99$$ 
    1010    BEGIN 
    1111     
    12         INSERT INTO ingest_search_logging (local_ingest_id, id, ingest_date, total_files_processed, total_files_processed_successfully, total_files_processed_unsuccessfully, records_created, records_updated, records_deleted, number_problem_files) VALUES (DEFAULT, ingest_id_in,ingest_date_in,total_files_processed_in ,total_files_processed_successfully_in, total_files_processed_unsuccessfully_in ,records_created_in ,records_updated_in ,records_deleted_in ,number_problem_files_in); 
     12        INSERT INTO ingest_search_logging (local_ingest_id, id, ingest_start_time, ingest_end_time, total_files_processed, total_files_processed_successfully, total_files_processed_unsuccessfully, records_created, records_updated, records_deleted, number_problem_files) VALUES (DEFAULT, ingest_id_in,ingest_start_date_in, ingest_end_date_in,total_files_processed_in ,total_files_processed_successfully_in, total_files_processed_unsuccessfully_in ,records_created_in ,records_updated_in ,records_deleted_in ,number_problem_files_in); 
    1313         
    1414     END; 
Note: See TracChangeset for help on using the changeset viewer.